Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Tutti al 16° WE Amatori CT !!   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 Torneo Int.WE 2007  Pagina principale > Torneo Int.WE 2007 Torneo Int.WE 2007 45 media trovati - sei alla pagina 3 di 5 100_1626.jpg 73 visite 100_1627.jpg 82 visite 100_1608.jpg 65 visite 100_1609.jpg 62 visite 100_1610.jpg 58 visite 100_1611.jpg 50 visite 100_1612.jpg 44 visite 100_1613.jpg 57 visite 100_1614.jpg 37 visite   Primo : Precedente << 1 | 2 | 3 | 4 | 5 >> Successivo : Ultimo >>Ricerca per parola chiave<<   Vedi il tuo Raccoglitore ExtCalendar Dicembre 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: 18:08 Caching: Disabled GZIP: Disabled Utenti: 88413 Notizie: 294 Collegamenti web: 17 Visitatori: 16537430

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 < '1713459207' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713459207' )
 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 = 55
12
SELECT priv_upload, priv_editmedium, priv_delmedium, priv_creategal, priv_editgal, priv_delgal  FROM chess_zoom_priv WHERE gid = '0'
13
DELETE FROM chess_zoom_editmon WHERE vote_time < '1713460107' OR comment_time < '1713460107' OR pass_time < '1713460107'
14
SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1713460107'
15
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
16
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
17
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
18
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
19
SELECT catname FROM chess_zoom WHERE catid=0 LIMIT 1
20
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=63
21
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=63
22
SELECT catdir FROM chess_zoom WHERE catid=5
23
SELECT catdir FROM chess_zoom WHERE catid=5
24
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 63 ORDER BY cmtdate ASC
25
SELECT catdir FROM chess_zoom WHERE catid=5
26
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=64
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=64
28
SELECT catdir FROM chess_zoom WHERE catid=5
29
SELECT catdir FROM chess_zoom WHERE catid=5
30
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 64 ORDER BY cmtdate ASC
31
SELECT catdir FROM chess_zoom WHERE catid=5
32
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=65
33
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=65
34
SELECT catdir FROM chess_zoom WHERE catid=5
35
SELECT catdir FROM chess_zoom WHERE catid=5
36
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 65 ORDER BY cmtdate ASC
37
SELECT catdir FROM chess_zoom WHERE catid=5
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=66
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=66
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 = 66 ORDER BY cmtdate ASC
43
SELECT catdir FROM chess_zoom WHERE catid=5
44
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=67
45
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=67
46
SELECT catdir FROM chess_zoom WHERE catid=5
47
SELECT catdir FROM chess_zoom WHERE catid=5
48
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 67 ORDER BY cmtdate ASC
49
SELECT catdir FROM chess_zoom WHERE catid=5
50
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=68
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=68
52
SELECT catdir FROM chess_zoom WHERE catid=5
53
SELECT catdir FROM chess_zoom WHERE catid=5
54
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 68 ORDER BY cmtdate ASC
55
SELECT catdir FROM chess_zoom WHERE catid=5
56
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
57
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
58
SELECT catdir FROM chess_zoom WHERE catid=5
59
SELECT catdir FROM chess_zoom WHERE catid=5
60
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 69 ORDER BY cmtdate ASC
61
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=1
62
SELECT catdir FROM chess_zoom WHERE catid=5
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=70
64
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=70
65
SELECT catdir FROM chess_zoom WHERE catid=5
66
SELECT catdir FROM chess_zoom WHERE catid=5
67
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 70 ORDER BY cmtdate ASC
68
SELECT catdir FROM chess_zoom WHERE catid=5
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=71
70
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=71
71
SELECT catdir FROM chess_zoom WHERE catid=5
72
SELECT catdir FROM chess_zoom WHERE catid=5
73
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 71 ORDER BY cmtdate ASC
74
SELECT catdir FROM chess_zoom WHERE catid=5
75
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=72
76
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=72
77
SELECT catdir FROM chess_zoom WHERE catid=5
78
SELECT catdir FROM chess_zoom WHERE catid=5
79
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 72 ORDER BY cmtdate ASC
80
SELECT catdir FROM chess_zoom WHERE catid=5
81
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=73
82
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=73
83
SELECT catdir FROM chess_zoom WHERE catid=5
84
SELECT catdir FROM chess_zoom WHERE catid=5
85
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 73 ORDER BY cmtdate ASC
86
SELECT catdir FROM chess_zoom WHERE catid=5
87
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=74
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=74
89
SELECT catdir FROM chess_zoom WHERE catid=5
90
SELECT catdir FROM chess_zoom WHERE catid=5
91
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 74 ORDER BY cmtdate ASC
92
SELECT catdir FROM chess_zoom WHERE catid=5
93
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=75
94
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=75
95
SELECT catdir FROM chess_zoom WHERE catid=5
96
SELECT catdir FROM chess_zoom WHERE catid=5
97
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 75 ORDER BY cmtdate ASC
98
SELECT catdir FROM chess_zoom WHERE catid=5
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=76
100
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=76
101
SELECT catdir FROM chess_zoom WHERE catid=5
102
SELECT catdir FROM chess_zoom WHERE catid=5
103
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 76 ORDER BY cmtdate ASC
104
SELECT catdir FROM chess_zoom WHERE catid=5
105
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=77
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=77
107
SELECT catdir FROM chess_zoom WHERE catid=5
108
SELECT catdir FROM chess_zoom WHERE catid=5
109
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 77 ORDER BY cmtdate ASC
110
SELECT catdir FROM chess_zoom WHERE catid=5
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 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
113
SELECT catdir FROM chess_zoom WHERE catid=5
114
SELECT catdir FROM chess_zoom WHERE catid=5
115
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
116
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
117
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
118
SELECT catdir FROM chess_zoom WHERE catid=5
119
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=79
120
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=79
121
SELECT catdir FROM chess_zoom WHERE catid=5
122
SELECT catdir FROM chess_zoom WHERE catid=5
123
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 79 ORDER BY cmtdate ASC
124
SELECT catdir FROM chess_zoom WHERE catid=5
125
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
126
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
127
SELECT catdir FROM chess_zoom WHERE catid=5
128
SELECT catdir FROM chess_zoom WHERE catid=5
129
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 80 ORDER BY cmtdate ASC
130
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=4
131
SELECT catdir FROM chess_zoom WHERE catid=5
132
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=81
133
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=81
134
SELECT catdir FROM chess_zoom WHERE catid=5
135
SELECT catdir FROM chess_zoom WHERE catid=5
136
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 81 ORDER BY cmtdate ASC
137
SELECT catdir FROM chess_zoom WHERE catid=5
138
SELECT imgmembers FROM chess_zoomfiles WHERE catid = 5 AND published=1
139
SELECT imgmembers FROM chess_zoomfiles WHERE catid = 5 AND published=1
140
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=81
141
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=81
142
SELECT catdir FROM chess_zoom WHERE catid=5
143
SELECT catdir FROM chess_zoom WHERE catid=5
144
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 81 ORDER BY cmtdate ASC
145
SELECT catdir FROM chess_zoom WHERE catid=5
146
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
147
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
148
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
149
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
150
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=81
151
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=81
152
SELECT catdir FROM chess_zoom WHERE catid=5
153
SELECT catdir FROM chess_zoom WHERE catid=5
154
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 81 ORDER BY cmtdate ASC
155
SELECT catdir FROM chess_zoom WHERE catid=5
156
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=82
157
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=82
158
SELECT catdir FROM chess_zoom WHERE catid=5
159
SELECT catdir FROM chess_zoom WHERE catid=5
160
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 82 ORDER BY cmtdate ASC
161
SELECT catdir FROM chess_zoom WHERE catid=5
162
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
163
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
164
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
165
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
166
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=82
167
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=82
168
SELECT catdir FROM chess_zoom WHERE catid=5
169
SELECT catdir FROM chess_zoom WHERE catid=5
170
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 82 ORDER BY cmtdate ASC
171
SELECT catdir FROM chess_zoom WHERE catid=5
172
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=83
173
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=83
174
SELECT catdir FROM chess_zoom WHERE catid=5
175
SELECT catdir FROM chess_zoom WHERE catid=5
176
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 83 ORDER BY cmtdate ASC
177
SELECT catdir FROM chess_zoom WHERE catid=5
178
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
179
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
180
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
181
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
182
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=83
183
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=83
184
SELECT catdir FROM chess_zoom WHERE catid=5
185
SELECT catdir FROM chess_zoom WHERE catid=5
186
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 83 ORDER BY cmtdate ASC
187
SELECT catdir FROM chess_zoom WHERE catid=5
188
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=84
189
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=84
190
SELECT catdir FROM chess_zoom WHERE catid=5
191
SELECT catdir FROM chess_zoom WHERE catid=5
192
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 84 ORDER BY cmtdate ASC
193
SELECT catdir FROM chess_zoom WHERE catid=5
194
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
195
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
196
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
197
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
198
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=84
199
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=84
200
SELECT catdir FROM chess_zoom WHERE catid=5
201
SELECT catdir FROM chess_zoom WHERE catid=5
202
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 84 ORDER BY cmtdate ASC
203
SELECT catdir FROM chess_zoom WHERE catid=5
204
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=85
205
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=85
206
SELECT catdir FROM chess_zoom WHERE catid=5
207
SELECT catdir FROM chess_zoom WHERE catid=5
208
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 85 ORDER BY cmtdate ASC
209
SELECT catdir FROM chess_zoom WHERE catid=5
210
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
211
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
212
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
213
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
214
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=85
215
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=85
216
SELECT catdir FROM chess_zoom WHERE catid=5
217
SELECT catdir FROM chess_zoom WHERE catid=5
218
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 85 ORDER BY cmtdate ASC
219
SELECT catdir FROM chess_zoom WHERE catid=5
220
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=86
221
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=86
222
SELECT catdir FROM chess_zoom WHERE catid=5
223
SELECT catdir FROM chess_zoom WHERE catid=5
224
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 86 ORDER BY cmtdate ASC
225
SELECT catdir FROM chess_zoom WHERE catid=5
226
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
227
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
228
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
229
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
230
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=86
231
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=86
232
SELECT catdir FROM chess_zoom WHERE catid=5
233
SELECT catdir FROM chess_zoom WHERE catid=5
234
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 86 ORDER BY cmtdate ASC
235
SELECT catdir FROM chess_zoom WHERE catid=5
236
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=87
237
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=87
238
SELECT catdir FROM chess_zoom WHERE catid=5
239
SELECT catdir FROM chess_zoom WHERE catid=5
240
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 87 ORDER BY cmtdate ASC
241
SELECT catdir FROM chess_zoom WHERE catid=5
242
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
243
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
244
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
245
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
246
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=87
247
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=87
248
SELECT catdir FROM chess_zoom WHERE catid=5
249
SELECT catdir FROM chess_zoom WHERE catid=5
250
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 87 ORDER BY cmtdate ASC
251
SELECT catdir FROM chess_zoom WHERE catid=5
252
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=88
253
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=88
254
SELECT catdir FROM chess_zoom WHERE catid=5
255
SELECT catdir FROM chess_zoom WHERE catid=5
256
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 88 ORDER BY cmtdate ASC
257
SELECT catdir FROM chess_zoom WHERE catid=5
258
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
259
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
260
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
261
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
262
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=88
263
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=88
264
SELECT catdir FROM chess_zoom WHERE catid=5
265
SELECT catdir FROM chess_zoom WHERE catid=5
266
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 88 ORDER BY cmtdate ASC
267
SELECT catdir FROM chess_zoom WHERE catid=5
268
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=89
269
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=89
270
SELECT catdir FROM chess_zoom WHERE catid=5
271
SELECT catdir FROM chess_zoom WHERE catid=5
272
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 89 ORDER BY cmtdate ASC
273
SELECT catdir FROM chess_zoom WHERE catid=5
274
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
275
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
276
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
277
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
278
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=89
279
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=89
280
SELECT catdir FROM chess_zoom WHERE catid=5
281
SELECT catdir FROM chess_zoom WHERE catid=5
282
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 89 ORDER BY cmtdate ASC
283
SELECT catdir FROM chess_zoom WHERE catid=5
284
SELECT cat.catkeywords, img.imgkeywords AS keywords   FROM chess_zoom as cat LEFT JOIN  chess_zoomfiles AS img ON cat.catid    WHERE cat.published = 1     AND cat.catkeywords <> ''     AND img.published = 1     AND img.imgkeywords <> ''
285
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'
286
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
287
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
288
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
289
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
290
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-04-18 19:08' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-18 19:08' )
 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
291
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
292
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-04-18 19:08' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 19:08' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
293
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
294
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
295
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
296
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
297
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
298
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
299
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
300
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 2
301
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
302
SELECT * FROM chess_extcal_config
303
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') <= 20181201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181201 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
304
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') <= 20181201) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
305
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') <= 20181202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181202 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
306
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') <= 20181202) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
307
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') <= 20181203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181203 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
308
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') <= 20181203) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
309
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') <= 20181204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181204 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
310
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') <= 20181204) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
311
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') <= 20181205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181205 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
312
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') <= 20181205) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
313
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') <= 20181206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181206 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
314
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') <= 20181206) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
315
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') <= 20181207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181207 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
316
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') <= 20181207) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
317
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') <= 20181208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181208 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
318
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') <= 20181208) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
319
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') <= 20181209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181209 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
320
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') <= 20181209) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
321
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') <= 20181210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181210 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
322
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') <= 20181210) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
323
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') <= 20181211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181211 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
324
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') <= 20181211) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
325
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') <= 20181212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181212 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
326
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') <= 20181212) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
327
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') <= 20181213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181213 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
328
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') <= 20181213) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
329
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') <= 20181214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181214 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
330
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') <= 20181214) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
331
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') <= 20181215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181215 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
332
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') <= 20181215) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
333
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') <= 20181216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181216 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
334
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') <= 20181216) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
335
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') <= 20181217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181217 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
336
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') <= 20181217) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
337
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') <= 20181218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181218 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
338
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') <= 20181218) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
339
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') <= 20181219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181219 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
340
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') <= 20181219) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
341
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') <= 20181220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181220 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
342
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') <= 20181220) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
343
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') <= 20181221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181221 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
344
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') <= 20181221) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
345
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') <= 20181222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181222 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
346
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') <= 20181222) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
347
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') <= 20181223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181223 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
348
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') <= 20181223) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
349
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') <= 20181224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181224 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
350
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') <= 20181224) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
351
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') <= 20181225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181225 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
352
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') <= 20181225) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
353
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') <= 20181226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181226 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
354
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') <= 20181226) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
355
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') <= 20181227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181227 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
356
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') <= 20181227) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
357
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') <= 20181228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181228 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
358
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') <= 20181228) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
359
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') <= 20181229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181229 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
360
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') <= 20181229) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
361
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') <= 20181230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181230 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
362
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') <= 20181230) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
363
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') <= 20181231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181231 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
364
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') <= 20181231) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
365
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
366
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
367
SELECT COUNT( id ) AS count_users
 FROM chess_users
368
SELECT COUNT( id ) AS count_items
 FROM chess_content
369
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
370
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1