Fondata ed affiliata

alla FSI dal 1987

Sezioni

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

 
Risultati immagini per LOGO FSI
 

 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

powered_by.png, 1 kB
Home arrow Più votati

Pagina principale Pagina principale >  Più votati

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

ExtCalendar

Giugno 2018 Luglio 2018 Agosto 2018
Do Lu Ma Me Gi Ve Sa
Settimana 27 1 2 3 4 5 6 7
Settimana 28 8 9 10 11 12 13 14
Settimana 29 15 16 17 18 19 20 21
Settimana 30 22 23 24 25 26 27 28
Settimana 31 29 30 31
Home
Chi siamo
Dove siamo
Links Links
Cerca
Articoli
News
Foto & Immagini
FAQ
Contattaci
download

Immagine casuale

fischer6.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.96-community-log
Ora: 05:56
Caching: Disabled
GZIP: Disabled
Utenti: 90221
Notizie: 294
Collegamenti web: 17
Visitatori: 16661177
© 2024 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
207 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM chess_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 55 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1714624885' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1714624885' )
 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 < '1714625785' OR comment_time < '1714625785' OR pass_time < '1714625785'
14
SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1714625785'
15
SELECT DISTINCT img.imgid AS id, img.catid AS gallery_id, img.votenum, (img.votesum/img.votenum) AS rating FROM chess_zoomfiles AS img  LEFT JOIN chess_zoom AS cats ON img.catid = cats.catid    WHERE img.votesum > 0      AND img.votenum > 0      AND cats.catpassword = '' AND img.published = 1 AND cats.published = 1 AND img.imgmembers = '1' AND cats.catmembers = '1'  ORDER BY rating DESC, img.votenum DESC LIMIT 10
16
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
17
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
18
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
19
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 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=28
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=28
22
SELECT catdir FROM chess_zoom WHERE catid=3
23
SELECT catdir FROM chess_zoom WHERE catid=3
24
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 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=2
26
SELECT catdir FROM chess_zoom WHERE catid=3
27
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
28
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
29
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
30
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
31
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
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=28
33
SELECT catdir FROM chess_zoom WHERE catid=3
34
SELECT catdir FROM chess_zoom WHERE catid=3
35
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
36
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
37
SELECT catdir FROM chess_zoom WHERE catid=3
38
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
39
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
40
SELECT catid FROM chess_zoom WHERE subcat_id=1 ORDER BY custom_order, catid ASC
41
SELECT imgid FROM chess_zoomfiles WHERE catid = 1 AND published = 1 ORDER BY imgdate ASC
42
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
43
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
44
SELECT catdir FROM chess_zoom WHERE catid=1
45
SELECT catdir FROM chess_zoom WHERE catid=1
46
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 11 ORDER BY cmtdate ASC
47
SELECT catdir FROM chess_zoom WHERE catid=1
48
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
49
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 LIMIT 1
50
SELECT catid FROM chess_zoom WHERE subcat_id=1 ORDER BY custom_order, catid ASC
51
SELECT imgid FROM chess_zoomfiles WHERE catid = 1 AND published = 1 ORDER BY imgdate ASC
52
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
53
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
54
SELECT catdir FROM chess_zoom WHERE catid=1
55
SELECT catdir FROM chess_zoom WHERE catid=1
56
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 11 ORDER BY cmtdate ASC
57
SELECT catdir FROM chess_zoom WHERE catid=1
58
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
59
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
60
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
61
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
62
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
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=78
64
SELECT catdir FROM chess_zoom WHERE catid=5
65
SELECT catdir FROM chess_zoom WHERE catid=5
66
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
67
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
68
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
69
SELECT catdir FROM chess_zoom WHERE catid=5
70
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
71
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
72
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
73
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
74
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
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=78
76
SELECT catdir FROM chess_zoom WHERE catid=5
77
SELECT catdir FROM chess_zoom WHERE catid=5
78
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
79
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
80
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
81
SELECT catdir FROM chess_zoom WHERE catid=5
82
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
83
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
84
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
85
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
86
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
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=105
88
SELECT catdir FROM chess_zoom WHERE catid=5
89
SELECT catdir FROM chess_zoom WHERE catid=5
90
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 105 ORDER BY cmtdate ASC
91
SELECT catdir FROM chess_zoom WHERE catid=5
92
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
93
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
94
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
95
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
96
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
97
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=105
98
SELECT catdir FROM chess_zoom WHERE catid=5
99
SELECT catdir FROM chess_zoom WHERE catid=5
100
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 105 ORDER BY cmtdate ASC
101
SELECT catdir FROM chess_zoom WHERE catid=5
102
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
103
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
104
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
105
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
106
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
107
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
108
SELECT catdir FROM chess_zoom WHERE catid=5
109
SELECT catdir FROM chess_zoom WHERE catid=5
110
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 106 ORDER BY cmtdate ASC
111
SELECT catdir FROM chess_zoom WHERE catid=5
112
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
113
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
114
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
115
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
116
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
117
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=106
118
SELECT catdir FROM chess_zoom WHERE catid=5
119
SELECT catdir FROM chess_zoom WHERE catid=5
120
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 106 ORDER BY cmtdate ASC
121
SELECT catdir FROM chess_zoom WHERE catid=5
122
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'
123
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
124
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
125
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
126
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
127
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM chess_sections as a
 LEFT JOIN chess_content as b ON a.id = b.sectionid
 AND b.access <= 0
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-05-02 06:56' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-02 06:56' )
 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
128
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
129
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 06:56' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 06:56' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
130
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
131
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
132
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
133
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
134
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
135
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
136
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
137
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 1
138
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
139
SELECT * FROM chess_extcal_config
140
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180701 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180701 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180701 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
141
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180701) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
142
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180702 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180702 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180702 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
143
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180702) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
144
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180703 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180703 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180703 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
145
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180703) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
146
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180704 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180704 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180704 ) ) 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') <= 20180704) 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') <= 20180705 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180705 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180705 ) ) 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') <= 20180705) 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') <= 20180706 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180706 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180706 ) ) 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') <= 20180706) 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') <= 20180707 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180707 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180707 ) ) 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') <= 20180707) 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') <= 20180708 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180708 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180708 ) ) 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') <= 20180708) 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') <= 20180709 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180709 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180709 ) ) 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') <= 20180709) 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') <= 20180710 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180710 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180710 ) ) 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') <= 20180710) 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') <= 20180711 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180711 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180711 ) ) 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') <= 20180711) 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') <= 20180712 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180712 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180712 ) ) 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') <= 20180712) 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') <= 20180713 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180713 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180713 ) ) 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') <= 20180713) 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') <= 20180714 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180714 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180714 ) ) 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') <= 20180714) 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') <= 20180715 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180715 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180715 ) ) 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') <= 20180715) 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') <= 20180716 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180716 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180716 ) ) 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') <= 20180716) 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') <= 20180717 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180717 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180717 ) ) 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') <= 20180717) 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') <= 20180718 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180718 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180718 ) ) 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') <= 20180718) 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') <= 20180719 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180719 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180719 ) ) 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') <= 20180719) 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') <= 20180720 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180720 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180720 ) ) 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') <= 20180720) 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') <= 20180721 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180721 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180721 ) ) 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') <= 20180721) 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') <= 20180722 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180722 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180722 ) ) 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') <= 20180722) 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') <= 20180723 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180723 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180723 ) ) 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') <= 20180723) 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') <= 20180724 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180724 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180724 ) ) 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') <= 20180724) 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') <= 20180725 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180725 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180725 ) ) 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') <= 20180725) 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') <= 20180726 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180726 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180726 ) ) 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') <= 20180726) 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') <= 20180727 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180727 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180727 ) ) 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') <= 20180727) 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') <= 20180728 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180728 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180728 ) ) 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') <= 20180728) 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') <= 20180729 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180729 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180729 ) ) 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') <= 20180729) 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') <= 20180730 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180730 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180730 ) ) 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') <= 20180730) 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') <= 20180731 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180731 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180731 ) ) 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') <= 20180731) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
202
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
203
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
204
SELECT COUNT( id ) AS count_users
 FROM chess_users
205
SELECT COUNT( id ) AS count_items
 FROM chess_content
206
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
207
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1