Статьи

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

SELECT * FROM xt_category WHERE seolink = 'stati' AND NSDiffer = '' ORDER BY id ASC LIMIT 1

SELECT group_id FROM xt_content_access WHERE content_type = 'category' AND content_id = '6'

SELECT id, title, NSLevel, seolink, url FROM xt_category WHERE NSLeft <= 2 AND NSRight >= 3 AND parent_id > 0 AND NSDiffer = '' ORDER BY NSLeft

SELECT group_id FROM xt_content_access WHERE content_type = 'category' AND content_id = '6'

SELECT *
FROM xt_category
WHERE parent_id = '6' AND published = 1 ORDER BY NSLeft

SELECT 1

FROM xt_content con
INNER JOIN xt_category cat ON cat.id = con.category_id
WHERE con.is_arhive = 0
AND (con.category_id = '6')

SELECT con.*,
cat.title as cat_title, cat.seolink as catseolink,
cat.showdesc,
u.nickname as author,
u.login as user_login
FROM xt_content con
INNER JOIN xt_category cat ON cat.id = con.category_id
LEFT JOIN xt_users u ON u.id = con.user_id
WHERE con.is_arhive = 0
AND (con.category_id = '6')
AND (con.published = 1 AND con.pubdate <= '2024-04-20 15:29:29' AND (con.is_end=0 OR (con.is_end=1 AND con.enddate >= '2024-04-20 15:29:29')))




ORDER BY pubdate ASC
LIMIT 15, 15

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='54'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '54' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='58'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '58' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='59'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '59' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='61'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '61' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='62'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '62' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='63'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '63' AND published = 1

SELECT tag
FROM xt_tags
WHERE target='content' AND item_id='65'
ORDER BY tag DESC

SELECT 1 FROM xt_comments WHERE target = 'article' AND target_id = '65' AND published = 1

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

URL_WITHOUT_COM_NAME

GET_ROUTE_CONTENT

GET_CONTENT_ACTION_VIEW

GET_CONTENT_CAT

GET_ARTICLES

GET_PAGEBAR

AFTER_COMPONENT_CONTENT

PRINT_PAGE_HEAD

PRINT_PAGE_BODY