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 arrow Più votati

Pagina principale Pagina principale >  Più votati

  1   FOTO_ASC_1992_.jpg
visite = 110
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 3 voti
> Circolo e dintorni
  2   2.jpg
visite = 50
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Torneo Int.WE 2007
  3   456.jpg
visite = 40
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Torneo Int.WE 2007
  4   en1_general_menu.jpg
visite = 8
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Varie
  5   100_1623.jpg
visite = 94
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Torneo Int.WE 2007

ExtCalendar

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

Immagine casuale

fischer.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.96-community-log
Ora: 03:45
Caching: Disabled
GZIP: Disabled
Utenti: 91527
Notizie: 294
Collegamenti web: 17
Visitatori: 16781224
© 2024 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
201 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 = 55 ) ORDER BY menuid DESC LIMIT 1
4 DELETE FROM chess_session WHERE ( ( time < '1715913011' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1715913011' ) AND guest = 1 AND userid = 0 )
5 SELECT * FROM chess_session WHERE session_id = '4401478208a5ed409c1e85e181b106b0'
6 UPDATE chess_session SET `time`='1715913911',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='4401478208a5ed409c1e85e181b106b0'
7 SELECT * FROM chess_menu WHERE id = 55
8 SELECT priv_upload, priv_editmedium, priv_delmedium, priv_creategal, priv_editgal, priv_delgal FROM chess_zoom_priv WHERE gid = '0'
9 DELETE FROM chess_zoom_editmon WHERE vote_time < '1715913911' OR comment_time < '1715913911' OR pass_time < '1715913911'
10 SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1715913911'
11 SELECT DISTINCT img.imgid AS id, img.catid AS gallery_id, img.votenum, (img.votesum/img.votenum) AS rating FROM chess_zoomfiles AS img LEFT JOIN chess_zoom AS cats ON img.catid = cats.catid WHERE img.votesum > 0 AND img.votenum > 0 AND cats.catpassword = '' AND img.published = 1 AND cats.published = 1 AND img.imgmembers = '1' AND cats.catmembers = '1' ORDER BY rating DESC, img.votenum DESC LIMIT 10
12 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=3 LIMIT 1
13 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=3 LIMIT 1
14 SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
15 SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
16 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
17 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
18 SELECT catdir FROM chess_zoom WHERE catid=3
19 SELECT catdir FROM chess_zoom WHERE catid=3
20 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
21 SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
22 SELECT catdir FROM chess_zoom WHERE catid=3
23 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=3 LIMIT 1
24 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=3 LIMIT 1
25 SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
26 SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
27 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
28 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
29 SELECT catdir FROM chess_zoom WHERE catid=3
30 SELECT catdir FROM chess_zoom WHERE catid=3
31 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
32 SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
33 SELECT catdir FROM chess_zoom WHERE catid=3
34 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
35 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
36 SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
37 SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
38 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
39 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
40 SELECT catdir FROM chess_zoom WHERE catid=5
41 SELECT catdir FROM chess_zoom WHERE catid=5
42 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 105 ORDER BY cmtdate ASC
43 SELECT catdir FROM chess_zoom WHERE catid=5
44 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
45 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
46 SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
47 SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
48 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
49 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
50 SELECT catdir FROM chess_zoom WHERE catid=5
51 SELECT catdir FROM chess_zoom WHERE catid=5
52 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 105 ORDER BY cmtdate ASC
53 SELECT catdir FROM chess_zoom WHERE catid=5
54 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
55 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
56 SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
57 SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
58 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
59 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
60 SELECT catdir FROM chess_zoom WHERE catid=5
61 SELECT catdir FROM chess_zoom WHERE catid=5
62 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 106 ORDER BY cmtdate ASC
63 SELECT catdir FROM chess_zoom WHERE catid=5
64 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
65 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
66 SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
67 SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
68 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
69 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
70 SELECT catdir FROM chess_zoom WHERE catid=5
71 SELECT catdir FROM chess_zoom WHERE catid=5
72 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 106 ORDER BY cmtdate ASC
73 SELECT catdir FROM chess_zoom WHERE catid=5
74 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
75 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
76 SELECT catid FROM chess_zoom WHERE subcat_id=1 ORDER BY custom_order, catid ASC
77 SELECT imgid FROM chess_zoomfiles WHERE catid = 1 AND published = 1 ORDER BY imgdate ASC
78 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
79 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
80 SELECT catdir FROM chess_zoom WHERE catid=1
81 SELECT catdir FROM chess_zoom WHERE catid=1
82 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 11 ORDER BY cmtdate ASC
83 SELECT catdir FROM chess_zoom WHERE catid=1
84 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
85 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
86 SELECT catid FROM chess_zoom WHERE subcat_id=1 ORDER BY custom_order, catid ASC
87 SELECT imgid FROM chess_zoomfiles WHERE catid = 1 AND published = 1 ORDER BY imgdate ASC
88 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
89 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
90 SELECT catdir FROM chess_zoom WHERE catid=1
91 SELECT catdir FROM chess_zoom WHERE catid=1
92 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 11 ORDER BY cmtdate ASC
93 SELECT catdir FROM chess_zoom WHERE catid=1
94 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
95 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
96 SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
97 SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
98 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
99 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
100 SELECT catdir FROM chess_zoom WHERE catid=5
101 SELECT catdir FROM chess_zoom WHERE catid=5
102 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
103 SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
104 SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
105 SELECT catdir FROM chess_zoom WHERE catid=5
106 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
107 SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
108 SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
109 SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
110 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
111 SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
112 SELECT catdir FROM chess_zoom WHERE catid=5
113 SELECT catdir FROM chess_zoom WHERE catid=5
114 SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
115 SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
116 SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
117 SELECT catdir FROM chess_zoom WHERE catid=5
118 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'
119 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 = 55 ) ORDER BY ordering
120 SELECT m.* FROM chess_menu AS m WHERE menutype = 'topmenu' AND published = 1 AND access <= 0 AND parent = 0 ORDER BY ordering
121 SELECT id FROM chess_menu WHERE link = 'index.php?option=com_search' AND published = 1
122 SELECT folder, element, published, params FROM chess_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
123 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-05-17 04:45' ) AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-17 04:45' ) 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
124 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
125 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-05-17 04:45' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 04:45' ) AND a.catid = 3 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
126 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
127 SELECT COUNT( id ) FROM chess_menu WHERE type = 'content_typed' AND published = 1
128 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=5'
129 SELECT id FROM chess_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=12'
130 SELECT m.* FROM chess_menu AS m WHERE menutype = 'othermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
131 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
132 SELECT * FROM chess_banner WHERE showBanner = 1
133 UPDATE chess_banner SET impmade = impmade + 1 WHERE bid = 2
134 SELECT id, name, link, parent, type, menutype, access FROM chess_menu WHERE published = 1 AND access <= 0 ORDER BY menutype, parent, ordering
135 SELECT * FROM chess_extcal_config
136 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') <= 20180401 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180401 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180401 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
137 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') <= 20180401) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
138 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') <= 20180402 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180402 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180402 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
139 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') <= 20180402) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
140 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') <= 20180403 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180403 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180403 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
141 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') <= 20180403) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
142 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') <= 20180404 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180404 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180404 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
143 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') <= 20180404) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
144 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') <= 20180405 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180405 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180405 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
145 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') <= 20180405) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
146 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') <= 20180406 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180406 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180406 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
147 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') <= 20180406) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
148 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') <= 20180407 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180407 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180407 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
149 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') <= 20180407) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
150 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') <= 20180408 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180408 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180408 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
151 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') <= 20180408) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
152 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') <= 20180409 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180409 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180409 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
153 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') <= 20180409) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
154 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') <= 20180410 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180410 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180410 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
155 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') <= 20180410) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
156 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') <= 20180411 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180411 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180411 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
157 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') <= 20180411) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
158 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') <= 20180412 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180412 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180412 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
159 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') <= 20180412) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
160 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') <= 20180413 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180413 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180413 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
161 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') <= 20180413) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
162 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') <= 20180414 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180414 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180414 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
163 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') <= 20180414) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
164 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') <= 20180415 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180415 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180415 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
165 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') <= 20180415) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
166 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') <= 20180416 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180416 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180416 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
167 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') <= 20180416) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
168 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') <= 20180417 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180417 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180417 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
169 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') <= 20180417) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
170 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') <= 20180418 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180418 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180418 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
171 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') <= 20180418) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
172 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') <= 20180419 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180419 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180419 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
173 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') <= 20180419) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
174 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') <= 20180420 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180420 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180420 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
175 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') <= 20180420) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
176 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') <= 20180421 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180421 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180421 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
177 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') <= 20180421) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
178 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') <= 20180422 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180422 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180422 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
179 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') <= 20180422) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
180 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') <= 20180423 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180423 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180423 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
181 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') <= 20180423) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
182 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') <= 20180424 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180424 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180424 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
183 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') <= 20180424) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
184 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') <= 20180425 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180425 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180425 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
185 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') <= 20180425) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
186 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') <= 20180426 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180426 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180426 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
187 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') <= 20180426) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
188 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') <= 20180427 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180427 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180427 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
189 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') <= 20180427) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
190 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') <= 20180428 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180428 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180428 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
191 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') <= 20180428) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
192 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') <= 20180429 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180429 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180429 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
193 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') <= 20180429) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
194 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') <= 20180430 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180430 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180430 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
195 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') <= 20180430) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
196 SELECT m.* FROM chess_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
197 SELECT m.* FROM chess_menu AS m WHERE menutype = 'usermenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
198 SELECT COUNT( id ) AS count_users FROM chess_users
199 SELECT COUNT( id ) AS count_items FROM chess_content
200 SELECT COUNT( id ) AS count_links FROM chess_weblinks WHERE published = 1
201 SELECT SUM( hits ) AS count FROM chess_stats_agents WHERE type = 1