SELECT * FROM xt_menu ORDER BY id ASC

SELECT id, title, link, config, internal, published, version, system FROM xt_components ORDER BY title

SELECT p.id, p.plugin, p.config, e.event FROM xt_event_hooks e LEFT JOIN xt_plugins p ON e.plugin_id = p.id WHERE p.published = 1

SELECT id, access FROM xt_user_groups WHERE alias = 'guest' ORDER BY id ASC LIMIT 1

SELECT int_num, int_period, autodelete, id, status, bandate, user_id, cause FROM xt_banlist WHERE ip = '18.117.91.157' AND status=1 ORDER BY id ASC LIMIT 1

SELECT link, title FROM xt_components WHERE internal = 0 AND published = 1

SELECT 1 FROM xt_tags WHERE tag = 'yamaha'

SELECT *
FROM xt_tags
WHERE tag = 'yamaha' ORDER BY tag DESC LIMIT 0, 10

SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id, c.owner as owner, c.user_id user_id, i.seolink as seolink, c.seolink as bloglink
FROM xt_blog_posts i
LEFT JOIN xt_blogs c ON c.id = i.blog_id
WHERE i.id = '20601' AND i.published = 1

SELECT tag
FROM xt_tags
WHERE target='blogpost' AND item_id='20601'
ORDER BY tag DESC

SELECT i.title as title, i.id as item_id, c.title as cat, c.id as cat_id
FROM xt_photo_files i
LEFT JOIN xt_photo_albums c ON c.id = i.album_id
WHERE i.id = '203' AND i.published = 1

SELECT tag
FROM xt_tags
WHERE target='photo' AND item_id='203'
ORDER BY tag DESC

SELECT m.*, mb.position as mb_position
FROM xt_modules m
INNER JOIN xt_modules_bind mb ON mb.module_id = m.id AND mb.menu_id IN (0, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC

GET_INDEX

GET_GUEST

GET_ROUTE_SEARCH

GET_SEARCH_ACTION_TAG

GET_PAGEBAR

AFTER_COMPONENT_SEARCH

PRINT_PAGE_HEAD

PRINT_PAGE_BODY