в капилку :)

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.191.210.65' AND status=1 ORDER BY id ASC LIMIT 1

SELECT * FROM xt_photo_albums WHERE NSLevel = 0 AND NSDiffer = '' ORDER BY id ASC LIMIT 1

SELECT f.*, a.user_id as auser_id, a.title cat_title, a.NSLeft, a.NSRight, a.NSDiffer, a.nav album_nav, a.public, a.showtags a_tags, a.bbcode a_bbcode, a.orderby, a.orderto, u.nickname, u.login, p.gender, p.imageurl
FROM xt_photo_files f
INNER JOIN xt_photo_albums a ON a.id = f.album_id
LEFT JOIN xt_users u ON u.id = f.user_id
LEFT JOIN xt_user_profiles p ON p.user_id = u.id
WHERE f.id = '217' LIMIT 1

SELECT id, title, NSLevel FROM xt_photo_albums WHERE NSLeft <= 4 AND NSRight >= 5 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft

UPDATE xt_photo_files SET hits = '617' WHERE id='217'

SELECT id, file FROM xt_photo_files WHERE id<217 AND album_id = 1038 AND published=1 ORDER BY id DESC LIMIT 1

SELECT id, file FROM xt_photo_files WHERE id>217 AND album_id = 1038 AND published=1 ORDER BY id ASC LIMIT 1

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

SELECT c.*,
IFNULL(u.nickname, 0) as nickname,
IFNULL(u.login, 0) as login,
IFNULL(u.is_deleted, 0) as is_deleted,
IFNULL(p.imageurl, 0) as imageurl,
IFNULL(p.gender, 0) as gender
FROM xt_comments c
LEFT JOIN xt_users u ON u.id = c.user_id
LEFT JOIN xt_user_profiles p ON p.user_id = u.id
WHERE c.published = 1
AND (c.target='photo' AND c.target_id = '217')




ORDER BY c.pubdate ASC
LIMIT 1000

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 (47, 0)
WHERE m.published = 1 AND (m.is_strict_bind = 0)
ORDER BY m.ordering ASC

GET_INDEX

GET_GUEST

GET_ROUTE_PHOTOS

GET_PHOTOS_ACTION_VIEWPHOTO

GET_PHOTO

BEFORE_SHOW_COMMENTS

AFTER_COMPONENT_PHOTOS

PRINT_PAGE_HEAD

PRINT_PAGE_BODY