Fondata ed affiliata

alla FSI dal 1987

Annunci

Tutti al 16° WE Amatori CT !!

 

Archivio

Stat

powered_by.png, 1 kB
Home arrow Articoli arrow Non solo scacchi
Non solo scacchi
Filtro     Ordina per     Mostra # 
Data Titolo Visite
martedý 05 giugno 2007 Gli scacchi come gioco 17678
martedý 05 giugno 2007 Gli scacchi come modello 19556
martedý 05 giugno 2007 Gli scacchi come metafora 29682
domenica 06 maggio 2007 Le simultanee 23086
domenica 06 maggio 2007 Otto Donne 21342
giovedý 15 febbraio 2007 Gli scacchi a Catania dal 900 ai nostri giorni. 22435
martedý 30 gennaio 2007 Come eravamo nel 1992 20184
domenica 21 gennaio 2007 Aforismi Scacchistici 19397
domenica 21 gennaio 2007 10 consigli per giocare meglio 19307
sabato 20 gennaio 2007 Filosofia e Scacchi 18184
giovedý 18 gennaio 2007 La rivoluzione degli Scacchi 18264
 
<< Inizio < Prec. 1 Pross. > Fine >>
Risultati 1 - 11 di 11

ExtCalendar

Dicembre 2023 Gennaio 2024
Do Lu Ma Me Gi Ve Sa
Settimana 48 1 2
Settimana 49 3 4 5 6 7 8 9
Settimana 50 10 11 12 13 14 15 16
Settimana 51 17 18 19 20 21 22 23
Settimana 52 24 25 26 27 28 29 30
Settimana 53 31

Immagine casuale

180px-garry_kasparov.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.92-50-log
Ora: 06:25
Caching: Disabled
GZIP: Disabled
Utenti: 84657
Notizie: 291
Collegamenti web: 17
Visitatori: 15256361
© 2023 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
103 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 = 37 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM chess_session WHERE ( ( time < '1701411047' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1701411047' ) 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 = 37
12 SELECT * FROM chess_categories WHERE id = '15'
13 SELECT * FROM chess_sections WHERE id = '4'
14 SELECT c.*, COUNT( b.id ) AS numitems FROM chess_categories AS c LEFT JOIN chess_content AS b ON b.catid = c.id AND b.state = 1 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2023-12-01 07:25' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2023-12-01 07:25' ) AND b.access <= 0 WHERE c.section = '4' AND c.published = 1 AND c.access <= 0 GROUP BY c.id HAVING COUNT( b.id ) > 0 ORDER BY c.ordering
15 SELECT COUNT(a.id) as numitems FROM chess_content AS a 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.catid = 15 AND a.state = 1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-01 07:25' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-01 07:25' ) AND a.access <= 0 AND 0 <= 0 ORDER BY a.created DESC
16 SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups FROM chess_content AS a 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.catid = 15 AND a.state = 1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-12-01 07:25' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-12-01 07:25' ) AND a.access <= 0 AND 0 <= 0 ORDER BY a.created DESC LIMIT 50
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 = 37 ) 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 folder, element, published, params FROM chess_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
22 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 <= '2023-12-01 07:25' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2023-12-01 07:25' ) 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
23 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
24 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 <= '2023-12-01 07:25' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-01 07:25' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
25 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
26 SELECT COUNT( id ) FROM chess_menu WHERE type = 'content_typed' AND published = 1
27 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
28 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=12'
29 SELECT m.* FROM chess_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
30 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
31 SELECT * FROM chess_banner WHERE showBanner = 1
32 UPDATE chess_banner SET impmade = impmade + 1 WHERE bid = 3
33 SELECT id, name, link, parent, type, menutype, access FROM chess_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
34 SELECT title, id FROM chess_categories WHERE id = 15 AND access <= 0
35 SELECT * FROM chess_extcal_config
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') <= 20231201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231201 ) ) 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') <= 20231201) 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') <= 20231202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231202 ) ) 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') <= 20231202) 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') <= 20231203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231203 ) ) 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') <= 20231203) 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') <= 20231204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231204 ) ) 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') <= 20231204) 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') <= 20231205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231205 ) ) 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') <= 20231205) 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') <= 20231206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231206 ) ) 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') <= 20231206) 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') <= 20231207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231207 ) ) 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') <= 20231207) 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') <= 20231208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231208 ) ) 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') <= 20231208) 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') <= 20231209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231209 ) ) 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') <= 20231209) 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') <= 20231210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231210 ) ) 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') <= 20231210) 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') <= 20231211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231211 ) ) 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') <= 20231211) 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') <= 20231212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231212 ) ) 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') <= 20231212) 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') <= 20231213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231213 ) ) 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') <= 20231213) 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') <= 20231214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231214 ) ) 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') <= 20231214) 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') <= 20231215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231215 ) ) 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') <= 20231215) 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') <= 20231216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231216 ) ) 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') <= 20231216) 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') <= 20231217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231217 ) ) 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') <= 20231217) 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') <= 20231218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231218 ) ) 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') <= 20231218) 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') <= 20231219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231219 ) ) 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') <= 20231219) 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') <= 20231220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231220 ) ) 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') <= 20231220) 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') <= 20231221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231221 ) ) 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') <= 20231221) 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') <= 20231222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231222 ) ) 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') <= 20231222) 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') <= 20231223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231223 ) ) 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') <= 20231223) 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') <= 20231224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231224 ) ) 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') <= 20231224) 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') <= 20231225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231225 ) ) 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') <= 20231225) 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') <= 20231226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231226 ) ) 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') <= 20231226) 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') <= 20231227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231227 ) ) 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') <= 20231227) 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') <= 20231228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231228 ) ) 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') <= 20231228) 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') <= 20231229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231229 ) ) 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') <= 20231229) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
94 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') <= 20231230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231230 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
95 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') <= 20231230) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
96 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') <= 20231231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20231231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20231231 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
97 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') <= 20231231) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
98 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
99 SELECT m.* FROM chess_menu AS m WHERE menutype = 'usermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
100 SELECT COUNT( id ) AS count_users FROM chess_users
101 SELECT COUNT( id ) AS count_items FROM chess_content
102 SELECT COUNT( id ) AS count_links FROM chess_weblinks WHERE published = 1
103 SELECT SUM( hits ) AS count FROM chess_stats_agents WHERE type = 1