(mysqli): SELECT eh.tag_name, eh.module_name, e.originator, e.event_name, eh.handler_order, eh.handler_id, eh.removable FROM cms_event_handlers eh
INNER JOIN cms_events e ON e.event_id = eh.event_id
ORDER BY eh.handler_order ASC
(mysqli): SELECT picture_id, picture_name, picture_url, picture_url_nature, thumbnail_path, picture_url_target, picture_path, comment FROM cms_module_showtime WHERE active AND show_id = '3' ORDER BY picture_number
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (123,95,94,153,154,159,168,169,182,190,193,204,226,230,251,252) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (152,65,104,89,161,61,96,110,62,117,60,69,80,86,88,92,93,101,102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,239,240,241,243,244,245,246,248,249,291,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (72,75,73,112,118,138,158,172,195,236) ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (173,165,166,84,128,85,97,98,107,99,100,109,91,76,130,134,71,135,157,163,164,167,171,175,176,177,178,179,180,181,184,185,187,188,189,191,192,194,196,197,198,199,200,201,202,205,206,207,208,209,210,211,213,214,215,216,217,218,219,220,221,222,223,224,225,227,228,229,231,232,233,234,235,237,242,247,250,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,280,281,282,283,284,285,286,287,288,289,290,295) ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (103,57,63,116,58,64,137,147,148,203) ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (123,94,153,154,169,182,190,204,226,230,251,252) ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (60,80,86,88,101,102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (80,86,88,101,102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (86,88,101,102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (88,101,102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (101,102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (102,108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (108,113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (113,115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (115,119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (119,120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (120,121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (121,124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (124,125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (125,126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (126,127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (127,129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (129,131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (131,132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (132,133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (133,136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (136,139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (139,140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (140,141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (141,142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (142,143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (143,144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (144,145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (145,149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (149,151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (151,155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (155,156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (156,160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (160,162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (162,170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (170,174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (174,183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (183,243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (243,244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (244,245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (245,246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (246,248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (248,292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (292,293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (293,294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (294,296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT * FROM cms_content FORCE INDEX (cms_index_content_by_idhier) WHERE content_id IN (296,297,298,299,300) AND active = 1 ORDER BY hierarchy
(mysqli): SELECT mn.*, mnc.news_category_name FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc ON mnc.news_category_id = mn.news_category_id
WHERE status = 'published' AND news_id = 14
AND ( IFNULL(start_time, '1970-01-01 03:00:01') < NOW()) LIMIT 1
(mysqli):
SELECT count(mn.news_id) as count
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
( IFNULL(start_time, '1970-01-01 03:00:01') < '2025-05-16 05:23:40') AND (( IFNULL(end_time, '1970-01-01 03:00:01') = '1970-01-01 03:00:01') OR (end_time > '2025-05-16 05:23:40')) LIMIT 1
(mysqli):
SELECT
mn.*,
mnc.news_category_name,
mnc.long_name,
u.username,
u.first_name,
u.last_name
FROM cms_module_news mn
LEFT OUTER JOIN cms_module_news_categories mnc
ON mnc.news_category_id = mn.news_category_id
LEFT OUTER JOIN cms_users u
ON u.user_id = mn.author_id
WHERE
status = 'published'
AND
( IFNULL(start_time, '1970-01-01 03:00:01') < '2025-05-16 05:23:40') AND (( IFNULL(end_time, '1970-01-01 03:00:01') = '1970-01-01 03:00:01') OR (end_time > '2025-05-16 05:23:40')) ORDER BY news_date desc LIMIT 0, 5
(mysqli): SELECT DISTINCT A.css_id,A.css_name,A.css_text,A.modified_date,A.media_type,A.media_query,B.assoc_order
FROM cms_css A
LEFT JOIN cms_css_assoc B ON A.css_id = B.assoc_css_id WHERE B.assoc_type = 'template' AND B.assoc_to_id = '29' ORDER BY B.assoc_order
