SELECT *
FROM cshgypro_session
WHERE session_id = 'coi6i4cdq3b81o2uq54qibt7e5'
DELETE
FROM cshgypro_session
WHERE ( TIME < '1749088442' )
SELECT *
FROM cshgypro_session
WHERE session_id = 'coi6i4cdq3b81o2uq54qibt7e5'
INSERT INTO `cshgypro_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( 'coi6i4cdq3b81o2uq54qibt7e5','1749089342','','0','1','0' )
SELECT *
FROM cshgypro_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM cshgypro_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT MAX(TIME)
FROM cshgypro_vvcounter_logs
SELECT m.*, c.`option` AS component
FROM cshgypro_menu AS m
LEFT JOIN cshgypro_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM cshgypro_jcomments_settings
SELECT template
FROM cshgypro_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 216)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM cshgypro_content AS a
LEFT JOIN cshgypro_categories AS cc
ON cc.id = a.catid
LEFT JOIN cshgypro_sections AS s
ON s.id = cc.SECTION
AND s.scope = "content"
LEFT JOIN cshgypro_users AS u
ON u.id = a.created_by
LEFT JOIN cshgypro_groups AS g
ON a.access = g.id
WHERE a.id = 552
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-05 02:09:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-05 02:09:02' ) ) OR ( a.state = -1 ) )
UPDATE cshgypro_content
SET hits = ( hits + 1 )
WHERE id='552'
SELECT catid, sectionid, created, modified, metakey
FROM cshgypro_content
WHERE id=552
LIMIT 0, 1
SELECT a.*, a.id AS key1, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM cshgypro_content AS a
INNER JOIN cshgypro_categories AS cc
ON cc.id = a.catid
INNER JOIN cshgypro_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-05 02:09:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-05 02:09:02' )
AND s.id > 0
AND a.id != 552
AND ( a.metakey LIKE '%du học tại nhật%' OR a.metakey LIKE '%du hoc tai nhat%' )
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
SELECT a.id AS key1, a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM cshgypro_content AS a
INNER JOIN cshgypro_categories AS cc
ON cc.id = a.catid
INNER JOIN cshgypro_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-05 02:09:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-05 02:09:02' )
AND s.id > 0
AND a.id != 552
AND a.created > '2013-12-20 09:30:25'
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND cc.id=193
AND a.id NOT IN (0,551,520,519,518,512)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created ASC
LIMIT 6
SELECT a.id AS key1, a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM cshgypro_content AS a
INNER JOIN cshgypro_categories AS cc
ON cc.id = a.catid
INNER JOIN cshgypro_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-05 02:09:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-05 02:09:02' )
AND s.id > 0
AND a.id != 552
AND a.created < '2013-12-20 09:30:25'
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND cc.id=193
AND a.id NOT IN (0,551,520,519,518,512)
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 6
SELECT id, title, module, POSITION, content, showtitle, control, params
FROM cshgypro_modules AS m
LEFT JOIN cshgypro_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 216 OR mm.menuid = 0 )
ORDER BY POSITION, ordering
SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM cshgypro_content AS a
INNER JOIN cshgypro_categories AS cc
ON cc.id = a.catid
INNER JOIN cshgypro_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-06-05 02:09:02' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-06-05 02:09:02' )
AND s.id > 0
AND a.access <= 0
AND cc.access <= 0
AND s.access <= 0
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 30
TRƯỜNG HỌC VIỆN YIEA
Chúng tôi muốn cùng các bạn bước những bước trên con đường thành công trong tương lai khi bạn du học tại Nhật Bản. Trường không chỉ dạy tiếng Nhật mà còn dạy cho các bạn du học sinh về cách sống, phong tục, tập quán, cách sinh hoạt của người Nhật. Với đội ngũ nhân viên tận tình, giàu kinh nghiệm sẽ giúp đỡ bạn trong suốt quá trình du học nhật bản.
