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   456.jpg
visite = 40
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Torneo Int.WE 2007
  3   en1_general_menu.jpg
visite = 8
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Varie
  4   100_1623.jpg
visite = 94
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Torneo Int.WE 2007
  5   2.jpg
visite = 50
  • 5.00
  • 1
  • 2
  • 3
  • 4
  • 5
5.00/ 1 voto
> Torneo Int.WE 2007

ExtCalendar

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

Immagine casuale

Susan Chess-775560.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.96-community-log
Ora: 06:48
Caching: Disabled
GZIP: Disabled
Utenti: 88493
Notizie: 294
Collegamenti web: 17
Visitatori: 16541873
© 2024 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
205 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 < '1713504791' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713504791' )
 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 < '1713505691' OR comment_time < '1713505691' OR pass_time < '1713505691'
14
SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1713505691'
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=5 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=5 LIMIT 1
40
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
41
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 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=106
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=106
44
SELECT catdir FROM chess_zoom WHERE catid=5
45
SELECT catdir FROM chess_zoom WHERE catid=5
46
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 106 ORDER BY cmtdate ASC
47
SELECT catdir FROM chess_zoom WHERE catid=5
48
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
49
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=5 LIMIT 1
50
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
51
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 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=106
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=106
54
SELECT catdir FROM chess_zoom WHERE catid=5
55
SELECT catdir FROM chess_zoom WHERE catid=5
56
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 106 ORDER BY cmtdate ASC
57
SELECT catdir FROM chess_zoom WHERE catid=5
58
SELECT catid, catname, catdescr, catdir, catimg, subcat_id, catpassword, pos, custom_order, hideMsg, shared, published, uid, catmembers FROM chess_zoom WHERE catid=1 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=1 LIMIT 1
60
SELECT catid FROM chess_zoom WHERE subcat_id=1 ORDER BY custom_order, catid ASC
61
SELECT imgid FROM chess_zoomfiles WHERE catid = 1 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=11
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=11
64
SELECT catdir FROM chess_zoom WHERE catid=1
65
SELECT catdir FROM chess_zoom WHERE catid=1
66
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 11 ORDER BY cmtdate ASC
67
SELECT catdir FROM chess_zoom WHERE catid=1
68
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
69
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
70
SELECT catid FROM chess_zoom WHERE subcat_id=1 ORDER BY custom_order, catid ASC
71
SELECT imgid FROM chess_zoomfiles WHERE catid = 1 AND published = 1 ORDER BY imgdate ASC
72
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
73
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=11
74
SELECT catdir FROM chess_zoom WHERE catid=1
75
SELECT catdir FROM chess_zoom WHERE catid=1
76
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 11 ORDER BY cmtdate ASC
77
SELECT catdir FROM chess_zoom WHERE catid=1
78
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
79
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
80
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
81
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
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=78
83
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
84
SELECT catdir FROM chess_zoom WHERE catid=5
85
SELECT catdir FROM chess_zoom WHERE catid=5
86
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
87
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
88
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
89
SELECT catdir FROM chess_zoom WHERE catid=5
90
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
91
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
92
SELECT catid FROM chess_zoom WHERE subcat_id=5 ORDER BY custom_order, catid ASC
93
SELECT imgid FROM chess_zoomfiles WHERE catid = 5 AND published = 1 ORDER BY imgdate ASC
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=78
95
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=78
96
SELECT catdir FROM chess_zoom WHERE catid=5
97
SELECT catdir FROM chess_zoom WHERE catid=5
98
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 78 ORDER BY cmtdate ASC
99
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=5
100
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=6
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=105
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=105
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 = 105 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=105
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=105
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 = 105 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-04-19 07:48' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-19 07:48' )
 WHERE a.scope = 'content'
 AND a.published = 1
 AND a.access <= 0
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 5
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-04-19 07:48' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:48' )
 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') <= 20180601 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180601 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180601 ) ) 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') <= 20180601) 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') <= 20180602 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180602 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180602 ) ) 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') <= 20180602) 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') <= 20180603 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180603 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180603 ) ) 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') <= 20180603) 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') <= 20180604 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180604 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180604 ) ) 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') <= 20180604) 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') <= 20180605 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180605 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180605 ) ) 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') <= 20180605) 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') <= 20180606 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180606 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180606 ) ) 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') <= 20180606) 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') <= 20180607 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180607 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180607 ) ) 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') <= 20180607) 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') <= 20180608 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180608 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180608 ) ) 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') <= 20180608) 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') <= 20180609 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180609 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180609 ) ) 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') <= 20180609) 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') <= 20180610 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180610 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180610 ) ) 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') <= 20180610) 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') <= 20180611 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180611 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180611 ) ) 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') <= 20180611) 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') <= 20180612 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180612 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180612 ) ) 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') <= 20180612) 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') <= 20180613 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180613 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180613 ) ) 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') <= 20180613) 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') <= 20180614 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180614 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180614 ) ) 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') <= 20180614) 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') <= 20180615 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180615 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180615 ) ) 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') <= 20180615) 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') <= 20180616 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180616 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180616 ) ) 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') <= 20180616) 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') <= 20180617 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180617 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180617 ) ) 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') <= 20180617) 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') <= 20180618 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180618 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180618 ) ) 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') <= 20180618) 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') <= 20180619 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180619 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180619 ) ) 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') <= 20180619) 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') <= 20180620 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180620 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180620 ) ) 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') <= 20180620) 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') <= 20180621 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180621 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180621 ) ) 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') <= 20180621) 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') <= 20180622 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180622 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180622 ) ) 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') <= 20180622) 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') <= 20180623 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180623 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180623 ) ) 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') <= 20180623) 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') <= 20180624 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180624 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180624 ) ) 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') <= 20180624) 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') <= 20180625 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180625 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180625 ) ) 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') <= 20180625) 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') <= 20180626 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180626 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180626 ) ) 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') <= 20180626) 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') <= 20180627 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180627 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180627 ) ) 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') <= 20180627) 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') <= 20180628 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180628 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180628 ) ) 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') <= 20180628) 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') <= 20180629 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180629 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180629 ) ) 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') <= 20180629) 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') <= 20180630 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180630 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180630 ) ) 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') <= 20180630) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
200
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
201
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
202
SELECT COUNT( id ) AS count_users
 FROM chess_users
203
SELECT COUNT( id ) AS count_items
 FROM chess_content
204
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
205
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1