Fondata ed affiliata

alla FSI dal 1987

Annunci

Tutti al 16° WE Amatori CT !!

 

Archivio

Stat

powered_by.png, 1 kB
Home arrow Chi siamo
Chi siamo
giovedý 19 agosto 2004

L'Amatori Scacchi Catania è nato il 10-12-1987 e dal 1988 è affiliato alla Federazione Scacchistica Italiana.  Innumerevoli le attività nel corso degli anni : dal Torneo internazionale W.E.,arrivato quest'anno alla 26a  edizione, ai Tornei semilampo e Rapid Play Sicilia. Inoltre  abbiamo organizzato 4 volte il "Raggruppamento Sicilia del Campionato Italiano" (2013-2015-2017-2022) , con la partecipazione di circa 400 giocatori e 70/80 squadre . Pubblicheremo al più presto la nostra storia in maniera più dettagliata.

Il Presidente, Annamaria Barta .

Ultimo aggiornamento ( mercoledý 03 gennaio 2024 )
 

ExtCalendar

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

Immagine casuale

reti.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.92-50-log
Ora: 00:11
Caching: Disabled
GZIP: Disabled
Utenti: 85276
Notizie: 292
Collegamenti web: 17
Visitatori: 16094101
© 2024 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
97 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 = 40 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM chess_session WHERE ( ( time < '1709078160' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1709078160' ) 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 = 40
12 SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access, s.id AS sec_id, cc.id as cat_id FROM chess_content AS a LEFT JOIN chess_categories AS cc ON cc.id = a.catid LEFT JOIN chess_sections AS s ON s.id = cc.section AND s.scope = 'content' LEFT JOIN chess_users AS u ON u.id = a.created_by LEFT JOIN chess_groups AS g ON a.access = g.id WHERE a.id = 5 AND ( a.state = 1 OR a.state = -1 ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-02-28 01:11' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-02-28 01:11' ) AND a.access <= 0
13 UPDATE chess_content SET hits = ( hits + 1 ) WHERE id = '5'
14 SELECT hits FROM chess_core_log_items WHERE time_stamp = '2024-02-28' AND item_table = '#__content' AND item_id = '5'
15 UPDATE chess_core_log_items SET hits = ( hits + 1 ) WHERE time_stamp = '2024-02-28' AND item_table = '#__content' AND item_id = '5'
16 SELECT folder, element, published, params FROM chess_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
17 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'
18 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 = 40 ) ORDER BY ordering
19 SELECT m.* FROM chess_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
20 SELECT id FROM chess_menu WHERE link = 'index.php?option=com_search' AND published = 1
21 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-02-28 01:11' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-02-28 01:11' ) 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
22 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
23 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-02-28 01:11' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-02-28 01:11' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
24 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
25 SELECT COUNT( id ) FROM chess_menu WHERE type = 'content_typed' AND published = 1
26 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
27 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=12'
28 SELECT m.* FROM chess_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
29 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
30 SELECT * FROM chess_banner WHERE showBanner = 1
31 UPDATE chess_banner SET impmade = impmade + 1 WHERE bid = 3
32 SELECT id, name, link, parent, type, menutype, access FROM chess_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
33 SELECT * FROM chess_extcal_config
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') <= 20240201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240201 ) ) 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') <= 20240201) 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') <= 20240202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240202 ) ) 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') <= 20240202) 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') <= 20240203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240203 ) ) 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') <= 20240203) 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') <= 20240204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240204 ) ) 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') <= 20240204) 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') <= 20240205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240205 ) ) 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') <= 20240205) 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') <= 20240206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240206 ) ) 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') <= 20240206) 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') <= 20240207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240207 ) ) 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') <= 20240207) 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') <= 20240208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240208 ) ) 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') <= 20240208) 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') <= 20240209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240209 ) ) 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') <= 20240209) 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') <= 20240210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240210 ) ) 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') <= 20240210) 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') <= 20240211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240211 ) ) 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') <= 20240211) 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') <= 20240212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240212 ) ) 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') <= 20240212) 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') <= 20240213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240213 ) ) 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') <= 20240213) 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') <= 20240214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240214 ) ) 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') <= 20240214) 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') <= 20240215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240215 ) ) 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') <= 20240215) 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') <= 20240216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240216 ) ) 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') <= 20240216) 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') <= 20240217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240217 ) ) 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') <= 20240217) 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') <= 20240218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240218 ) ) 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') <= 20240218) 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') <= 20240219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240219 ) ) 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') <= 20240219) 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') <= 20240220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240220 ) ) 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') <= 20240220) 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') <= 20240221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240221 ) ) 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') <= 20240221) 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') <= 20240222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240222 ) ) 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') <= 20240222) 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') <= 20240223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240223 ) ) 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') <= 20240223) 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') <= 20240224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240224 ) ) 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') <= 20240224) 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') <= 20240225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240225 ) ) 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') <= 20240225) 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') <= 20240226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240226 ) ) 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') <= 20240226) 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') <= 20240227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240227 ) ) 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') <= 20240227) 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') <= 20240228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240228 ) ) 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') <= 20240228) 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') <= 20240229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240229 ) ) 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') <= 20240229) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
92 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
93 SELECT m.* FROM chess_menu AS m WHERE menutype = 'usermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
94 SELECT COUNT( id ) AS count_users FROM chess_users
95 SELECT COUNT( id ) AS count_items FROM chess_content
96 SELECT COUNT( id ) AS count_links FROM chess_weblinks WHERE published = 1
97 SELECT SUM( hits ) AS count FROM chess_stats_agents WHERE type = 1