Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Tutti al 16° WE Amatori CT !!   Menu principale Home Chi siamo Dove siamo Links Cerca Articoli News Foto & Immagini FAQ Contattaci download SITI IN EVIDENZA FEDERAZIONE SCACCHISTICA ITALIANA   SITO CONI ITALIA   SITO COMITATO SCACCHISTICO SICILIANO     FEDERAZIONE INTERNAZIONALE degli SCACCHI        MONDO SCACCHI        Menu Home Chi siamo Forum Dove siamo Download Notizie Articoli Links Cerca Contattaci FSI Uisp CONI Elo Sicilia Tornei in Italia FIDE Calcola ELO Archivio Stat Home Circolo e dintorni  Pagina principale > Circolo e dintorni Circolo e dintorni 2 media trovati - sei alla pagina 1 di 1     Foto 1992 1 Comments Added 110 visite Nome temporaneo, cambialo 56 visite     1 >>Ricerca per parola chiave<<   Vedi il tuo Raccoglitore ExtCalendar Gennaio 2019 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: 05:30 Caching: Disabled GZIP: Disabled Utenti: 91569 Notizie: 294 Collegamenti web: 17 Visitatori: 16788813

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 < '1716005750' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1716005750' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM chess_session
 WHERE session_id = 'a05beed66161e1d523528ae0ff4e2502'
6
UPDATE chess_session SET `time`='1716006650',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='a05beed66161e1d523528ae0ff4e2502'
7
SELECT *
 FROM chess_menu
 WHERE id = 55
8
SELECT priv_upload, priv_editmedium, priv_delmedium, priv_creategal, priv_editgal, priv_delgal  FROM chess_zoom_priv WHERE gid = '0'
9
DELETE FROM chess_zoom_editmon WHERE vote_time < '1716006650' OR comment_time < '1716006650' OR pass_time < '1716006650'
10
SELECT lightbox_file FROM chess_zoom_editmon WHERE lightbox_time < '1716006650'
11
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
12
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
13
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
14
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
15
SELECT catname FROM chess_zoom WHERE catid=0 LIMIT 1
16
SELECT imgmembers FROM chess_zoomfiles WHERE catid = 3 AND published=1
17
SELECT imgmembers FROM chess_zoomfiles WHERE catid = 3 AND published=1
18
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
19
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
20
SELECT catdir FROM chess_zoom WHERE catid=3
21
SELECT catdir FROM chess_zoom WHERE catid=3
22
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
23
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
24
SELECT catdir FROM chess_zoom WHERE catid=3
25
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
26
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
27
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
28
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
29
SELECT imgid, imgname, imgkeywords, imgfilename, imgdescr, date_format(imgdate, '%Y-%m-%d %H:%i:%s') AS date, imghits, votenum, votesum, published, catid, uid, imgmembers FROM chess_zoomfiles WHERE imgid=28
30
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
31
SELECT catdir FROM chess_zoom WHERE catid=3
32
SELECT catdir FROM chess_zoom WHERE catid=3
33
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 28 ORDER BY cmtdate ASC
34
SELECT cmtcontent, date_format(cmtdate, '%Y-%m-%d %H:%i:%s') AS date, cmtname FROM chess_zoom_comments WHERE cmtid=2
35
SELECT catdir FROM chess_zoom WHERE catid=3
36
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=59
37
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=59
38
SELECT catdir FROM chess_zoom WHERE catid=3
39
SELECT catdir FROM chess_zoom WHERE catid=3
40
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 59 ORDER BY cmtdate ASC
41
SELECT catdir FROM chess_zoom WHERE catid=3
42
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
43
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
44
SELECT catid FROM chess_zoom WHERE subcat_id=3 ORDER BY custom_order, catid ASC
45
SELECT imgid FROM chess_zoomfiles WHERE catid = 3 AND published = 1 ORDER BY imgdate ASC
46
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=59
47
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=59
48
SELECT catdir FROM chess_zoom WHERE catid=3
49
SELECT catdir FROM chess_zoom WHERE catid=3
50
SELECT cmtid FROM chess_zoom_comments WHERE imgid = 59 ORDER BY cmtdate ASC
51
SELECT catdir FROM chess_zoom WHERE catid=3
52
SELECT cat.catkeywords, img.imgkeywords AS keywords   FROM chess_zoom as cat LEFT JOIN  chess_zoomfiles AS img ON cat.catid    WHERE cat.published = 1     AND cat.catkeywords <> ''     AND img.published = 1     AND img.imgkeywords <> ''
53
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'
54
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
55
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
56
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
57
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
58
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM chess_sections as a
 LEFT JOIN chess_content as b ON a.id = b.sectionid
 AND b.access <= 0
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-05-18 06:30' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-18 06:30' )
 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
59
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
60
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-18 06:30' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 06:30' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
61
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
62
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
63
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
64
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
65
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
66
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
67
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
68
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
69
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
70
SELECT * FROM chess_extcal_config
71
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') <= 20190101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190101 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
72
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') <= 20190101) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
73
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') <= 20190102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190102 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
74
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') <= 20190102) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
75
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') <= 20190103 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190103 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190103 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
76
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') <= 20190103) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
77
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') <= 20190104 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190104 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190104 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78
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') <= 20190104) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
79
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') <= 20190105 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190105 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190105 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
80
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') <= 20190105) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
81
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') <= 20190106 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190106 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190106 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82
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') <= 20190106) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
83
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') <= 20190107 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190107 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190107 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84
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') <= 20190107) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
85
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') <= 20190108 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190108 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190108 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
86
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') <= 20190108) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
87
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') <= 20190109 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190109 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190109 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88
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') <= 20190109) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
89
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') <= 20190110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190110 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90
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') <= 20190110) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
91
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') <= 20190111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190111 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92
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') <= 20190111) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
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') <= 20190112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190112 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94
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') <= 20190112) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
95
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') <= 20190113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190113 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
96
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') <= 20190113) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
97
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') <= 20190114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190114 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98
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') <= 20190114) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
99
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') <= 20190115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190115 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100
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') <= 20190115) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
101
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') <= 20190116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190116 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102
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') <= 20190116) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
103
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') <= 20190117 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190117 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190117 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104
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') <= 20190117) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
105
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') <= 20190118 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190118 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190118 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106
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') <= 20190118) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
107
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') <= 20190119 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190119 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190119 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108
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') <= 20190119) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
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') <= 20190120 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190120 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190120 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110
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') <= 20190120) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
111
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') <= 20190121 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190121 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190121 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
112
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') <= 20190121) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
113
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') <= 20190122 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190122 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190122 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
114
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') <= 20190122) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
115
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') <= 20190123 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190123 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190123 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
116
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') <= 20190123) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
117
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') <= 20190124 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190124 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190124 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
118
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') <= 20190124) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
119
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') <= 20190125 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190125 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190125 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
120
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') <= 20190125) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
121
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') <= 20190126 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190126 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190126 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
122
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') <= 20190126) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
123
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') <= 20190127 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190127 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190127 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
124
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') <= 20190127) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
125
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') <= 20190128 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190128 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190128 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
126
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') <= 20190128) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
127
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') <= 20190129 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190129 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190129 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
128
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') <= 20190129) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
129
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') <= 20190130 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190130 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190130 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
130
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') <= 20190130) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
131
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') <= 20190131 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190131 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190131 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
132
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') <= 20190131) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
133
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
134
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
135
SELECT COUNT( id ) AS count_users
 FROM chess_users
136
SELECT COUNT( id ) AS count_items
 FROM chess_content
137
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
138
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1