Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Aggiunto il forum per discutere tra di noi! Clicca sulla destra su Forum!!    Menu principale Home Chi siamo Dove siamo Links Cerca Articoli News Foto & Immagini FAQ Contattaci download SITI IN EVIDENZA FEDERAZIONE SCACCHISTICA ITALIANA   SITO CONI ITALIA   SITO COMITATO SCACCHISTICO SICILIANO     FEDERAZIONE INTERNAZIONALE degli SCACCHI        MONDO SCACCHI        Menu Home Chi siamo Forum Dove siamo Download Notizie Articoli Links Cerca Contattaci FSI Uisp CONI Elo Sicilia Tornei in Italia FIDE Calcola ELO Archivio Stat Home Ultimi commenti  Pagina principale >  Ultimi commenti   1   100_1623.jpg visite = 94 5.00 1 2 3 4 5 5.00/ 1 voto > Torneo Int.WE 2007 ...(06.01.2011 22:49)   2   100_1625.jpg visite = 108 0.00 1 2 3 4 5 0.00/ 0 voti > Torneo Int.WE 2007 oops(30.12.2010 22:54)   3   100_1645.jpg visite = 34 0.00 1 2 3 4 5 0.00/ 0 voti > Torneo Int.WE 2007 rossi(30.12.2010 22:38) bella partita   4   FOTO_ASC_1992_.jpg visite = 110 5.00 1 2 3 4 5 5.00/ 3 voti > Circolo e dintorni Carlo Vella(02.05.2007 12:52) Sono passati 15 anni, e questa foto rimarrà storica per tanti motivi.Chi sa comprende il perchè.   5   100_1614.jpg visite = 113 0.00 1 2 3 4 5 0.00/ 0 voti > Torneo Int.WE 2007 Paparatti alla mossa fatale...(20.02.2007 07:08) Paparatti pensa (inutilmente...) prima di mangiare D:a7. Vincerà Giustolisi. Ma nelle analisi casalinghe c'era la difesa. Sullo sfondo della foto, il vincitore del Terziario: il feroce Elvin Buda. ExtCalendar Marzo 2018 Do Lu Ma Me Gi Ve Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Home Chi siamo Dove siamo Links Cerca Articoli News Foto & Immagini FAQ Contattaci download Immagine casuale Menu utente Statistiche OS: Linux h PHP: 5.2.17 MySQL: 5.0.96-community-log Ora: 22:48 Caching: Disabled GZIP: Disabled Utenti: 91606 Notizie: 294 Collegamenti web: 17 Visitatori: 16792923

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 < '1716068025' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1716068025' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM chess_session
 WHERE session_id = '4ad2667627850f484803bc971b8782d9'
6
UPDATE chess_session SET `time`='1716068925',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='4ad2667627850f484803bc971b8782d9'
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 < '1716068925' OR comment_time < '1716068925' OR pass_time < '1716068925'
10
SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1716068925'
11
SELECT DISTINCT com.imgid AS id, img.catid AS gallery_id, max(com.cmtid) as maxcmt FROM chess_zoomfiles AS img  LEFT JOIN chess_zoom AS cats ON img.catid = cats.catid  LEFT JOIN chess_zoom_comments AS com ON img.imgid = com.imgid    WHERE cats.catpassword = '' AND img.published = 1 AND cats.published = 1 AND img.imgmembers = '1' AND cats.catmembers = '1'     AND com.imgid > 0    AND com.cmtid > 0 GROUP BY id ORDER BY maxcmt 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=5 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=5 LIMIT 1
14
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
15
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 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=78
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=78
18
SELECT catdir FROM chess_zoom WHERE catid=5
19
SELECT catdir FROM chess_zoom WHERE catid=5
20
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 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=5
22
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
23
SELECT catdir FROM chess_zoom WHERE catid=5
24
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
25
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
26
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
27
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
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=78
29
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
30
SELECT catdir FROM chess_zoom WHERE catid=5
31
SELECT catdir FROM chess_zoom WHERE catid=5
32
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
33
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
34
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
35
SELECT catdir FROM chess_zoom WHERE catid=5
36
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
37
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
38
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
39
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
40
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=80
41
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=80
42
SELECT catdir FROM chess_zoom WHERE catid=5
43
SELECT catdir FROM chess_zoom WHERE catid=5
44
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 80 ORDER BY cmtdate ASC
45
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=4
46
SELECT catdir FROM chess_zoom WHERE catid=5
47
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
48
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
49
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
50
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
51
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=80
52
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=80
53
SELECT catdir FROM chess_zoom WHERE catid=5
54
SELECT catdir FROM chess_zoom WHERE catid=5
55
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 80 ORDER BY cmtdate ASC
56
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=4
57
SELECT catdir FROM chess_zoom WHERE catid=5
58
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
59
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
60
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
61
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
62
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=100
63
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=100
64
SELECT catdir FROM chess_zoom WHERE catid=5
65
SELECT catdir FROM chess_zoom WHERE catid=5
66
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 100 ORDER BY cmtdate ASC
67
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=3
68
SELECT catdir FROM chess_zoom WHERE catid=5
69
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
70
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
71
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
72
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
73
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=100
74
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=100
75
SELECT catdir FROM chess_zoom WHERE catid=5
76
SELECT catdir FROM chess_zoom WHERE catid=5
77
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 100 ORDER BY cmtdate ASC
78
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=3
79
SELECT catdir FROM chess_zoom WHERE catid=5
80
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
81
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
82
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
83
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
84
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
85
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
86
SELECT catdir FROM chess_zoom WHERE catid=3
87
SELECT catdir FROM chess_zoom WHERE catid=3
88
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
89
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
90
SELECT catdir FROM chess_zoom WHERE catid=3
91
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
92
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
93
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
94
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
95
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
96
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
97
SELECT catdir FROM chess_zoom WHERE catid=3
98
SELECT catdir FROM chess_zoom WHERE catid=3
99
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
100
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
101
SELECT catdir FROM chess_zoom WHERE catid=3
102
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
103
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
104
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
105
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
106
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=69
107
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=69
108
SELECT catdir FROM chess_zoom WHERE catid=5
109
SELECT catdir FROM chess_zoom WHERE catid=5
110
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 69 ORDER BY cmtdate ASC
111
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=1
112
SELECT catdir FROM chess_zoom WHERE catid=5
113
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
114
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
115
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
116
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
117
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=69
118
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=69
119
SELECT catdir FROM chess_zoom WHERE catid=5
120
SELECT catdir FROM chess_zoom WHERE catid=5
121
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 69 ORDER BY cmtdate ASC
122
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=1
123
SELECT catdir FROM chess_zoom WHERE catid=5
124
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'
125
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
126
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
127
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
128
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
129
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-18 23:48' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-18 23:48' )
 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
130
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
131
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-18 23:48' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 23:48' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
132
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
133
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
134
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
135
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
136
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
137
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
138
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
139
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 1
140
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
141
SELECT * FROM chess_extcal_config
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') <= 20180301 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180301 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180301 ) ) 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') <= 20180301) 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') <= 20180302 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180302 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180302 ) ) 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') <= 20180302) 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') <= 20180303 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180303 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180303 ) ) 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') <= 20180303) 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') <= 20180304 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180304 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180304 ) ) 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') <= 20180304) 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') <= 20180305 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180305 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180305 ) ) 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') <= 20180305) 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') <= 20180306 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180306 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180306 ) ) 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') <= 20180306) 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') <= 20180307 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180307 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180307 ) ) 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') <= 20180307) 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') <= 20180308 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180308 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180308 ) ) 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') <= 20180308) 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') <= 20180309 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180309 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180309 ) ) 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') <= 20180309) 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') <= 20180310 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180310 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180310 ) ) 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') <= 20180310) 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') <= 20180311 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180311 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180311 ) ) 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') <= 20180311) 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') <= 20180312 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180312 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180312 ) ) 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') <= 20180312) 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') <= 20180313 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180313 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180313 ) ) 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') <= 20180313) 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') <= 20180314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180314 ) ) 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') <= 20180314) 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') <= 20180315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180315 ) ) 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') <= 20180315) 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') <= 20180316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180316 ) ) 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') <= 20180316) 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') <= 20180317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180317 ) ) 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') <= 20180317) 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') <= 20180318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180318 ) ) 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') <= 20180318) 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') <= 20180319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180319 ) ) 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') <= 20180319) 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') <= 20180320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180320 ) ) 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') <= 20180320) 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') <= 20180321 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180321 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180321 ) ) 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') <= 20180321) 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') <= 20180322 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180322 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180322 ) ) 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') <= 20180322) 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') <= 20180323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180323 ) ) 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') <= 20180323) 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') <= 20180324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180324 ) ) 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') <= 20180324) 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') <= 20180325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180325 ) ) 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') <= 20180325) 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') <= 20180326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180326 ) ) 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') <= 20180326) 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') <= 20180327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180327 ) ) 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') <= 20180327) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
196
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') <= 20180328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180328 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
197
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') <= 20180328) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
198
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') <= 20180329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180329 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
199
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') <= 20180329) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
200
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') <= 20180330 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180330 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180330 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
201
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') <= 20180330) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
202
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') <= 20180331 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180331 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180331 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
203
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') <= 20180331) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
204
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
205
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
206
SELECT COUNT( id ) AS count_users
 FROM chess_users
207
SELECT COUNT( id ) AS count_items
 FROM chess_content
208
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
209
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1