Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Anche il Rapid Lido dei Ciclopi arriva al traguardo della 15a edizione . Appuntamento al 15 Settembre nello storico e verdeggiante Lido della costa Jonica catanese . Sponsor dell'evento : COSENTINO ELETTRODOMESTICI , che metterà a disposizione tutti i premi .   Per iscrizioni e bando   :  15° Rapid Lido dei Ciclopi         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 = 112 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 Maggio 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: 20:08 Caching: Disabled GZIP: Disabled Utenti: 89457 Notizie: 294 Collegamenti web: 17 Visitatori: 16597632

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 < '1714071184' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1714071184' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
6
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 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 < '1714072084' OR comment_time < '1714072084' OR pass_time < '1714072084'
14
SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1714072084'
15
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
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, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
18
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
19
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
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=78
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=78
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 = 78 ORDER BY cmtdate ASC
25
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
26
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
27
SELECT catdir FROM chess_zoom WHERE catid=5
28
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
29
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
30
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
31
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
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=78
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=78
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 = 78 ORDER BY cmtdate ASC
37
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
38
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
39
SELECT catdir FROM chess_zoom WHERE catid=5
40
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
41
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
42
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
43
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
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=80
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=80
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 = 80 ORDER BY cmtdate ASC
49
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=4
50
SELECT catdir FROM chess_zoom WHERE catid=5
51
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
52
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
53
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
54
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
55
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
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=80
57
SELECT catdir FROM chess_zoom WHERE catid=5
58
SELECT catdir FROM chess_zoom WHERE catid=5
59
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 80 ORDER BY cmtdate ASC
60
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=4
61
SELECT catdir FROM chess_zoom WHERE catid=5
62
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
63
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
64
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
65
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
66
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
67
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
68
SELECT catdir FROM chess_zoom WHERE catid=5
69
SELECT catdir FROM chess_zoom WHERE catid=5
70
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 100 ORDER BY cmtdate ASC
71
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=3
72
SELECT catdir FROM chess_zoom WHERE catid=5
73
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
74
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
75
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
76
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
77
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
78
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=100
79
SELECT catdir FROM chess_zoom WHERE catid=5
80
SELECT catdir FROM chess_zoom WHERE catid=5
81
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 100 ORDER BY cmtdate ASC
82
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=3
83
SELECT catdir FROM chess_zoom WHERE catid=5
84
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
85
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
86
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
87
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
88
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
89
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
90
SELECT catdir FROM chess_zoom WHERE catid=3
91
SELECT catdir FROM chess_zoom WHERE catid=3
92
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
93
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
94
SELECT catdir FROM chess_zoom WHERE catid=3
95
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
96
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
97
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
98
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
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=28
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=28
101
SELECT catdir FROM chess_zoom WHERE catid=3
102
SELECT catdir FROM chess_zoom WHERE catid=3
103
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
104
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
105
SELECT catdir FROM chess_zoom WHERE catid=3
106
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
107
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
108
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
109
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
110
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=69
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=69
112
SELECT catdir FROM chess_zoom WHERE catid=5
113
SELECT catdir FROM chess_zoom WHERE catid=5
114
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 69 ORDER BY cmtdate ASC
115
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=1
116
SELECT catdir FROM chess_zoom WHERE catid=5
117
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
118
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
119
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
120
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
121
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
122
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
123
SELECT catdir FROM chess_zoom WHERE catid=5
124
SELECT catdir FROM chess_zoom WHERE catid=5
125
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 69 ORDER BY cmtdate ASC
126
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=1
127
SELECT catdir FROM chess_zoom WHERE catid=5
128
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'
129
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
130
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
131
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
132
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
133
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-25 21:08' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-25 21: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
134
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
135
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-25 21:08' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-25 21:08' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
136
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
137
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
138
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
139
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
140
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
141
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
142
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
143
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
144
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
145
SELECT * FROM chess_extcal_config
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') <= 20180501 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180501 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180501 ) ) 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') <= 20180501) 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') <= 20180502 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180502 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180502 ) ) 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') <= 20180502) 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') <= 20180503 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180503 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180503 ) ) 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') <= 20180503) 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') <= 20180504 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180504 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180504 ) ) 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') <= 20180504) 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') <= 20180505 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180505 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180505 ) ) 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') <= 20180505) 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') <= 20180506 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180506 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180506 ) ) 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') <= 20180506) 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') <= 20180507 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180507 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180507 ) ) 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') <= 20180507) 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') <= 20180508 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180508 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180508 ) ) 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') <= 20180508) 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') <= 20180509 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180509 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180509 ) ) 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') <= 20180509) 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') <= 20180510 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180510 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180510 ) ) 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') <= 20180510) 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') <= 20180511 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180511 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180511 ) ) 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') <= 20180511) 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') <= 20180512 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180512 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180512 ) ) 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') <= 20180512) 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') <= 20180513 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180513 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180513 ) ) 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') <= 20180513) 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') <= 20180514 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180514 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180514 ) ) 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') <= 20180514) 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') <= 20180515 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180515 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180515 ) ) 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') <= 20180515) 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') <= 20180516 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180516 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180516 ) ) 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') <= 20180516) 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') <= 20180517 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180517 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180517 ) ) 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') <= 20180517) 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') <= 20180518 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180518 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180518 ) ) 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') <= 20180518) 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') <= 20180519 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180519 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180519 ) ) 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') <= 20180519) 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') <= 20180520 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180520 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180520 ) ) 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') <= 20180520) 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') <= 20180521 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180521 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180521 ) ) 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') <= 20180521) 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') <= 20180522 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180522 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180522 ) ) 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') <= 20180522) 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') <= 20180523 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180523 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180523 ) ) 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') <= 20180523) 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') <= 20180524 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180524 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180524 ) ) 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') <= 20180524) 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') <= 20180525 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180525 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180525 ) ) 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') <= 20180525) 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') <= 20180526 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180526 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180526 ) ) 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') <= 20180526) 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') <= 20180527 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180527 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180527 ) ) 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') <= 20180527) 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') <= 20180528 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180528 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180528 ) ) 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') <= 20180528) 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') <= 20180529 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180529 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180529 ) ) 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') <= 20180529) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
204
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') <= 20180530 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180530 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180530 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
205
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') <= 20180530) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
206
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') <= 20180531 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180531 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180531 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
207
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') <= 20180531) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
208
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
209
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
210
SELECT COUNT( id ) AS count_users
 FROM chess_users
211
SELECT COUNT( id ) AS count_items
 FROM chess_content
212
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
213
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1