Fondata ed affiliata

alla FSI dal 1987

Annunci

Aggiunto il forum per discutere tra di noi!

Clicca sulla destra su Forum!! 

 

Archivio

Stat

powered_by.png, 1 kB
Home
Le notizie
Seleziona un argomento dalla lista seguente, e dopo scegli un articolo da leggere.

ExtCalendar

Luglio 2024 Agosto 2024
Do Lu Ma Me Gi Ve Sa
Settimana 27 1 2 3 4 5 6
Settimana 28 7 8 9 10 11 12 13
Settimana 29 14 15 16 17 18 19 20
Settimana 30 21 22 23 24 25 26 27
Settimana 31 28 29 30 31

Immagine casuale

bobby-fischer-life-nov-12-1971.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.96-community-log
Ora: 15:35
Caching: Disabled
GZIP: Disabled
Utenti: 95373
Notizie: 294
Collegamenti web: 17
Visitatori: 17398512
© 2024 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
99 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 ordering
3 SELECT template FROM chess_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 2 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM chess_session WHERE ( ( time < '1721053217' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1721053217' ) AND guest = 1 AND userid = 0 )
5 SELECT COUNT(*) FROM chess_stats_agents WHERE agent = 'Unknown' AND type = 0
6 UPDATE chess_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 0
7 SELECT COUNT(*) FROM chess_stats_agents WHERE agent = 'Unknown' AND type = 1
8 UPDATE chess_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'Unknown' AND type = 1
9 SELECT COUNT(*) FROM chess_stats_agents WHERE agent = 'com' AND type = 2
10 UPDATE chess_stats_agents SET hits = ( hits + 1 ) WHERE agent = 'com' AND type = 2
11 SELECT * FROM chess_menu WHERE id = 2
12 SELECT * FROM chess_sections WHERE id = '1'
13 SELECT a.*, COUNT( b.id ) AS numitems FROM chess_categories AS a LEFT JOIN chess_content AS b ON b.catid = a.id AND b.state = 1 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-07-15 16:35' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-07-15 16:35' ) WHERE a.section = '1' AND a.published = 1 AND a.access <= 0 AND b.access <= 0 GROUP BY a.id HAVING numitems > 0 ORDER BY a.ordering
14 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'
15 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 = 2 ) ORDER BY ordering
16 SELECT m.* FROM chess_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
17 SELECT id FROM chess_menu WHERE link = 'index.php?option=com_search' AND published = 1
18 SELECT folder, element, published, params FROM chess_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
19 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 <= '2024-07-15 16:35' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-07-15 16:35' ) 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 5
20 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 DESC
21 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 <= '2024-07-15 16:35' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-07-15 16:35' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
22 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
23 SELECT COUNT( id ) FROM chess_menu WHERE type = 'content_typed' AND published = 1
24 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
25 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=12'
26 SELECT m.* FROM chess_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
27 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 10
28 SELECT * FROM chess_banner WHERE showBanner = 1
29 UPDATE chess_banner SET impmade = impmade + 1 WHERE bid = 3
30 SELECT id, name, link, parent, type, menutype, access FROM chess_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
31 SELECT * FROM chess_extcal_config
32 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') <= 20240701 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240701 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240701 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
33 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') <= 20240701) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
34 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') <= 20240702 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240702 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240702 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
35 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') <= 20240702) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
36 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') <= 20240703 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240703 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240703 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
37 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') <= 20240703) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
38 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') <= 20240704 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240704 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240704 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
39 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') <= 20240704) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
40 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') <= 20240705 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240705 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240705 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
41 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') <= 20240705) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
42 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') <= 20240706 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240706 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240706 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
43 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') <= 20240706) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
44 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') <= 20240707 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240707 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240707 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
45 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') <= 20240707) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
46 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') <= 20240708 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240708 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240708 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
47 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') <= 20240708) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
48 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') <= 20240709 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240709 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240709 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
49 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') <= 20240709) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
50 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') <= 20240710 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240710 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240710 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
51 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') <= 20240710) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
52 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') <= 20240711 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240711 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240711 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
53 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') <= 20240711) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
54 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') <= 20240712 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240712 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240712 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
55 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') <= 20240712) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
56 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') <= 20240713 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240713 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240713 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
57 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') <= 20240713) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
58 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') <= 20240714 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240714 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240714 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
59 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') <= 20240714) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
60 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') <= 20240715 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240715 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240715 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
61 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') <= 20240715) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
62 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') <= 20240716 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240716 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240716 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
63 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') <= 20240716) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
64 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') <= 20240717 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240717 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240717 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
65 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') <= 20240717) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
66 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') <= 20240718 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240718 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240718 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
67 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') <= 20240718) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
68 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') <= 20240719 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240719 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240719 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
69 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') <= 20240719) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
70 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') <= 20240720 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240720 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240720 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
71 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') <= 20240720) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
72 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') <= 20240721 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240721 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240721 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
73 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') <= 20240721) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
74 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') <= 20240722 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240722 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240722 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
75 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') <= 20240722) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
76 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') <= 20240723 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240723 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240723 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
77 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') <= 20240723) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
78 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') <= 20240724 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240724 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240724 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
79 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') <= 20240724) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
80 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') <= 20240725 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240725 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240725 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
81 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') <= 20240725) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
82 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') <= 20240726 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240726 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240726 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
83 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') <= 20240726) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
84 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') <= 20240727 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240727 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240727 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
85 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') <= 20240727) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
86 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') <= 20240728 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240728 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240728 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
87 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') <= 20240728) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
88 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') <= 20240729 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240729 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240729 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
89 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') <= 20240729) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
90 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') <= 20240730 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240730 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240730 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
91 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') <= 20240730) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
92 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') <= 20240731 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240731 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240731 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
93 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') <= 20240731) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
94 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
95 SELECT m.* FROM chess_menu AS m WHERE menutype = 'usermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
96 SELECT COUNT( id ) AS count_users FROM chess_users
97 SELECT COUNT( id ) AS count_items FROM chess_content
98 SELECT COUNT( id ) AS count_links FROM chess_weblinks WHERE published = 1
99 SELECT SUM( hits ) AS count FROM chess_stats_agents WHERE type = 1