Joomla! un software libero rilasciato sotto licenza GNU/GPL.
119 queries executed
1
SET sql_mode = 'MYSQL40'2
SELECT folder, element, published, params
FROM chess_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering3
SELECT template
FROM chess_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 99999999 )
ORDER BY menuid DESC
LIMIT 14
DELETE FROM chess_session
WHERE (
( time < '1735844366' )
AND guest = 0
AND gid > 0
) OR (
( time < '1735844366' )
AND guest = 1
AND userid = 0
)5
SELECT COUNT(*)
FROM chess_stats_agents
WHERE agent = 'Mozilla 5.0'
AND type = 06
UPDATE chess_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Mozilla 5.0'
AND type = 07
SELECT COUNT(*)
FROM chess_stats_agents
WHERE agent = 'Unknown'
AND type = 18
UPDATE chess_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'Unknown'
AND type = 19
SELECT COUNT(*)
FROM chess_stats_agents
WHERE agent = 'com'
AND type = 210
UPDATE chess_stats_agents
SET hits = ( hits + 1 )
WHERE agent = 'com'
AND type = 211
SELECT *
FROM chess_menu
WHERE published = 1 AND
link LIKE 'index.php?option=com_extcalendar%'12
SELECT * FROM chess_extcal_config13
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250323) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC14
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250323 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC15
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250323) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC16
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250324) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC17
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250324 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC18
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250324) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC19
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250325) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC20
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250325 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC21
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250325) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC22
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250326) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC23
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250326 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC24
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250326) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC25
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250327) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC26
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250327 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC27
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250327) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC28
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250328) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC29
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250328 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC30
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250328) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC31
SELECT extid FROM chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250329) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC32
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250329 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC33
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250329) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC34
SELECT cat_id, cat_name, description AS cat_desc, color FROM chess_extcal_categories WHERE published = 135
SELECT a.*
FROM chess_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'36
SELECT id, title, module, position, content, showtitle, params
FROM chess_modules AS m
INNER JOIN chess_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 99999999 )
ORDER BY ordering37
SELECT m.*
FROM chess_menu AS m
WHERE menutype = 'topmenu'
AND published = 1
AND access <= 0
AND parent = 0
ORDER BY ordering38
SELECT id
FROM chess_menu
WHERE link = 'index.php?option=com_search'
AND published = 139
SELECT folder, element, published, params
FROM chess_mambots
WHERE access <= 0
AND folder = 'content'
ORDER BY ordering40
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
FROM chess_sections as a
LEFT JOIN chess_content as b ON a.id = b.sectionid
AND b.access <= 0
AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2025-01-02 20:14' )
AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2025-01-02 20:14' )
WHERE a.scope = 'content'
AND a.published = 1
AND a.access <= 0
GROUP BY a.id
HAVING COUNT( b.id ) > 0
ORDER BY a.ordering
LIMIT 541
SELECT m.id AS Itemid, m.componentid AS sectionid
FROM chess_menu AS m
WHERE ( m.type = 'content_section' OR m.type = 'content_blog_section' )
AND m.published = 1
AND m.access <= 0
AND ( m.componentid=1 OR m.componentid=4 OR m.componentid=2 OR m.componentid=3 OR m.componentid=0 )
ORDER BY m.type DESC, m.id DESC42
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
FROM chess_content AS a
INNER JOIN chess_categories AS cc ON cc.id = a.catid
INNER JOIN chess_sections AS s ON s.id = a.sectionid
WHERE a.state = 1
AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-02 20:14' )
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-02 20:14' )
AND a.catid = 3
AND cc.published = 1
AND s.published = 1
ORDER BY a.ordering43
SELECT m.*
FROM chess_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering44
SELECT COUNT( id )
FROM chess_menu
WHERE type = 'content_typed'
AND published = 145
SELECT id
FROM chess_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=5'46
SELECT id
FROM chess_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=12'47
SELECT m.*
FROM chess_menu AS m
WHERE menutype = 'othermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering48
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
FROM chess_content
WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
GROUP BY created_year DESC, created_month DESC
LIMIT 1049
SELECT *
FROM chess_banner
WHERE showBanner = 150
UPDATE chess_banner
SET impmade = impmade + 1
WHERE bid = 351
SELECT id, name, link, parent, type, menutype, access
FROM chess_menu
WHERE published = 1
AND access <= 0
ORDER BY menutype, parent, ordering52
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250301 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250301 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250301 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC53
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250301) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC54
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250302 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250302 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250302 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC55
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250302) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC56
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250303 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250303 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250303 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC57
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250303) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC58
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250304 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250304 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250304 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC59
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250304) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC60
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250305 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250305 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250305 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC61
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250305) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC62
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250306 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250306 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250306 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC63
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250306) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC64
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250307 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250307 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250307 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC65
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250307) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC66
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250308 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250308 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250308 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC67
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250308) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC68
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250309 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250309 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250309 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC69
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250309) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC70
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250310 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250310 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250310 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC71
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250310) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC72
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250311 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250311 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250311 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC73
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250311) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC74
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250312 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250312 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250312 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC75
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250312) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC76
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250313 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250313 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250313 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC77
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250313) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC78
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250314 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC79
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250314) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC80
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250315 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC81
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250315) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC82
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250316 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC83
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250316) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC84
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250317 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC85
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250317) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC86
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250318 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC87
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250318) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC88
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250319 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC89
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250319) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC90
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250320 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC91
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250320) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC92
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250321 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250321 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250321 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC93
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250321) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC94
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250322 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250322 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250322 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC95
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250322) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC96
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250323 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC97
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250323) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC98
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250324 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC99
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250324) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC100
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250325 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC101
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250325) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC102
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250326 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC103
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250326) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC104
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250327 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC105
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250327) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC106
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250328 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC107
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250328) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC108
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250329 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC109
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250329) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC110
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250330 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250330 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250330 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC111
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250330) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC112
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250331 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20250331 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20250331 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC113
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20250331) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC114
SELECT m.*
FROM chess_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering115
SELECT m.*
FROM chess_menu AS m
WHERE menutype = 'usermenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering116
SELECT COUNT( id ) AS count_users
FROM chess_users117
SELECT COUNT( id ) AS count_items
FROM chess_content118
SELECT COUNT( id ) AS count_links
FROM chess_weblinks
WHERE published = 1119
SELECT SUM( hits ) AS count
FROM chess_stats_agents
WHERE type = 1