Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Aggiunto il forum per discutere tra di noi! Clicca sulla destra su Forum!!    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 Ultime notizie 20° RAPID LIDO AMERICA CONCLUSO IL 26° FESTIVAL AMATORI CT 26° FESTIVAL AMATORI CT 2024 Bando Campionato Provinciale di Catania 2024 L'Amatori Scacchi Catania entra a a far parte di "Catania al Vertice" Rapid Scacchi in Val di Noto Home CIS 2013 ad Acicastello: ed è subito record! mercoledì 20 marzo 2013 CIS 2013 ad Acicastello: ed è subito record! La terza edizione del CIS Sicilia 2013, organizzata dall'Amatori Scacchi Catania, stabilisce il nuovo record di presenze. Grande risposta dello scacchismo siciliano all'evento clou del 2013. Quasi tutte le province si sono schierate, con i propri circoli, nella "tre giorni" di Acicastello (15/17 marzo c.a.) che ha visto "concentrate", in unica sede, le serie A2, B, C e Promozione, del Campionato Italiano a squadre. Il President Park Hotel di Acicastello (CT) ha ospitato in maniera consona l'evento, garantendo un trattamento "4 stelle" a giocatori ed accompagnatori. Al resto hanno pensato gli stessi scacchisti, dando vita a gare emozionanti, cariche di agonismo e di grandissimo spessore tecnico.  Naturalmente a rendere combattutissimo l'evento ha contribuito, in maniera evidente, anche la nuova regolamentazione del CIS che prevedeva  le variazioni elo applicate a tutte le serie, Promozione inclusa, ma va anche detto che le manifestazioni a squadre, li dove i giocatori difendono i colori della propria associazione, hanno sempre un qualcosa in più delle gare individuali e lo spirito di appartenenza che si respira in sala gara in queste occasioni, è realmente palpabile. Passando alle note tecniche, sono stati circa 250 i giocatori presenti nelle varie serie, con la categoria Promozione che ha giganteggiato per numeri e entusiasmo. Vittoria finale, a punteggio pieno, del fortissimo team di casa che schierava il Maestro Giuseppe Fabiano in prima scacchiera. Tantissime new entry in Promozione, da citare il Cielo D'Alcamo Scacchi, nuova associazione del trapanese, ma soprattutto la Chessmate Academy di Bagheria, associazione sorta anch'essa nel 2013, ispirata principalmente al settore giovanile, che ha presentato ben tre formazioni di Baby  (dagli 8 ai 12 anni) che hanno ben figurato per impegno ed entusiasmo. Anche la Leonardo Favara ha presentato un team di ragazzi con la formazione "Pedoncino" che accompagnava la formazione senior "Pedoncio", in chiaro omaggio all'indimenticato Filippo Vetro, creatore della rivista omonima. Nel girone unico siciliano di Promozione c'è stata grande battaglia, con vittoria finale del favorito d'obbligo, ovvero la squadra di casa del Centro Scacchi Acicastello che vinceva a punteggio pieno con un fortissimo team che avrebbe ben figurato anche nelle serie superiori (Giuseppe Fabiano, Riccardo Marzaduri, Marco Marzaduri e Antonio Paladino. Promosse in serie C anche la Scacchistica Etnea, le due Alcantara 3 e 4, l'asd Pippo Fasino (RG) e la squadra dell'Amatori CT 3, composta solo da giovani, che l'anno prossimo affiancherà  in serie C la squadra maggiore. La serie C ha visto nel girone 29 l'affermazione della squadra Amici della scacchiera di Erice (TP) sulla Sigel di Marsala (TP). Retrocedono Centro Scacchi Palermo e Arcobaleno (PA). Nel girone 30 prevale quasi a punteggio pieno, con 4 vittorie ed un pareggio, la Kodokan A (ME) sull' Amatori Scacchi Catania 1. Retrocedono Acireale e Alcantara 2. Nel girone 31, molto combattuto, si è imposta la CPS Palermitano sulla Leonardo di Favara (AG), retrocede il Centro Studi Test PAB. In serie B girone 16, l' Alcantara 1 della P. Carrera di Viagrande (CT), impone il superiore tasso tecnico prevalendo sulla Tedea Cavallaro di Giarre (CT), retrocedono Monrealese e Bagheria A Schlechter. Infine la Serie A2 ha registrato il livello tecnico più alto, con formazioni composte anche interamente da Maestri. Si è trattato di una corsa a due tra il Paolo Boi di Siracusa ed il Circolo Palermitano Scacchi, nettamente superiori per organico alle altre formazioni che, equilibratissime, hanno lottato per non retrocedere. Alla fine il team di Guido Inglese, giungendo ex equo con la squadra di Salvo Tondo, conquistava la promozione in A1 per i maggiori punti individuali. Al terzo ed al quarto posto il Centro Scacchi Arcobaleno ed il Centro Scacchi Palermo raggiungevano una sofferta salvezza a spese dei team Gioiosano Scacchi e Cavalli Rapaci di Grammichele. Nella serata del sabato si è svolto il Campionato Regionale Lampo che, per consuetudine, accompagna da sempre l'evento principale. 54 i partecipanti con vittoria del Maestro Internazionale Liubljsavlievic. A solo mezzo punto il Maestro siracusano  Gabriele Sardo che prevale per spareggio tecnico sul giovane giarrese Pietro Pisacane. I primi posti delle fasce elo 1600-2000 e < 1600 sono state appannaggio del CM Giacomo Bertino e del giovane Antonio De Rosa. Un edizione brillante, questa di Acicastello, che rilancia prepotentemente la provincia di Catania tra gli organizzatori degli eventi più importanti della Sicilia. Da sottolineare l'impegno organizzativo di Carlo Vella e dell'Amatori Scacchi Catania, l'arbitraggio di Piero Arnetta e della Alexandra Voitenko ed il supporto del Comitato Scacchistico, che ha visto in questi tre anni crescere esponenzialmente, in successo e numeri, questo evento. Ultimo aggiornamento ( domenica 31 marzo 2013 )   < Prec.   Pros. > [Indietro] Sondaggi Ti piace il nuovo sito del circolo? E' un ottimo sito! Bello Cos? cos Potevate fare di meglio E' davvero orribile   Se giochi a scacchi , ti interessa essere aggiornato sui Tornei e attività Amatori CT ? Si sono interessato . Invio un messaggio con il mio recapito al 335-6509575   Preferisci i Tornei Open ( unico ) oppure diviso per fasce elo ? Unico Torneo Diviso per fasce elo ( vari Open )   Syndication ExtCalendar Settembre 2018 Do Lu Ma Me Gi Ve Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Home Chi siamo Dove siamo Links Cerca Articoli News Foto & Immagini FAQ Contattaci download Immagine casuale Menu utente Login Form Username Password Ricordami Password dimenticata? Nessun account? Registrati Statistiche OS: Linux h PHP: 5.2.17 MySQL: 5.0.96-community-log Ora: 09:35 Caching: Disabled GZIP: Disabled Utenti: 88506 Notizie: 294 Collegamenti web: 17 Visitatori: 16542758 Chi è online Abbiamo 3 visitatori e 1 utente online

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 = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1713514826' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713514826' )
 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 = 1
12
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM chess_content AS a
 LEFT JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.id = 179 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 10:35' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:35' )
 AND a.access <= 0
13
SELECT a.id
 FROM chess_content AS a
 WHERE a.catid = 28
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 10:35' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:35' )
 ORDER BY a.ordering
14
UPDATE chess_content
 SET hits = ( hits + 1 )
 WHERE id = '179'
15
SELECT hits
 FROM chess_core_log_items
 WHERE time_stamp = '2024-04-19'
 AND item_table = '#__content'
 AND item_id = '179'
16
UPDATE chess_core_log_items
 SET hits = ( hits + 1 )
 WHERE time_stamp = '2024-04-19'
 AND item_table = '#__content'
 AND item_id = '179'
17
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
18
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'
19
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 = 1 )
 ORDER BY ordering
20
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
21
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
22
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 10:35' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-19 10:35' )
 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
23
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
24
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 10:35' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:35' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
25
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
27
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
28
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
29
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
30
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
31
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
32
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
33
SELECT a.id, a.title, a.sectionid, a.catid
 FROM chess_content AS a
 LEFT JOIN chess_content_frontpage AS f ON f.content_id = a.id
 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.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 10:35' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 10:35' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 6
34
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 294
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
36
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
37
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 293
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
38
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 292
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
39
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 291
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
40
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 290
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
41
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 289
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
42
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
43
SELECT p.id, p.title
 FROM chess_polls AS p
 INNER JOIN chess_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
44
SELECT id
 FROM chess_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
45
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 15
 AND text != ''
 ORDER BY id
46
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 16
 AND text != ''
 ORDER BY id
47
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 20
 AND text != ''
 ORDER BY id
48
SELECT * FROM chess_extcal_config
49
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') <= 20180901 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180901 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180901 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
50
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') <= 20180901) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
51
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') <= 20180902 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180902 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180902 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
52
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') <= 20180902) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
53
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') <= 20180903 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180903 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180903 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
54
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') <= 20180903) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
55
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') <= 20180904 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180904 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180904 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
56
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') <= 20180904) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
57
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') <= 20180905 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180905 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180905 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
58
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') <= 20180905) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
59
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') <= 20180906 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180906 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180906 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
60
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') <= 20180906) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
61
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') <= 20180907 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180907 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180907 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
62
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') <= 20180907) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
63
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') <= 20180908 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180908 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180908 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
64
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') <= 20180908) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
65
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') <= 20180909 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180909 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180909 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
66
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') <= 20180909) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
67
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') <= 20180910 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180910 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180910 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
68
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') <= 20180910) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
69
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') <= 20180911 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180911 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180911 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
70
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') <= 20180911) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20180912 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180912 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180912 ) ) 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') <= 20180912) 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') <= 20180913 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180913 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180913 ) ) 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') <= 20180913) 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') <= 20180914 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180914 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180914 ) ) 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') <= 20180914) 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') <= 20180915 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180915 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180915 ) ) 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') <= 20180915) 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') <= 20180916 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180916 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180916 ) ) 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') <= 20180916) 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') <= 20180917 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180917 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180917 ) ) 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') <= 20180917) 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') <= 20180918 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180918 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180918 ) ) 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') <= 20180918) 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') <= 20180919 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180919 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180919 ) ) 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') <= 20180919) 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') <= 20180920 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180920 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180920 ) ) 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') <= 20180920) 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') <= 20180921 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180921 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180921 ) ) 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') <= 20180921) 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') <= 20180922 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180922 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180922 ) ) 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') <= 20180922) 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') <= 20180923 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180923 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180923 ) ) 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') <= 20180923) 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') <= 20180924 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180924 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180924 ) ) 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') <= 20180924) 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') <= 20180925 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180925 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180925 ) ) 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') <= 20180925) 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') <= 20180926 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180926 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180926 ) ) 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') <= 20180926) 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') <= 20180927 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180927 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180927 ) ) 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') <= 20180927) 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') <= 20180928 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180928 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180928 ) ) 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') <= 20180928) 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') <= 20180929 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180929 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180929 ) ) 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') <= 20180929) 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') <= 20180930 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180930 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180930 ) ) 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') <= 20180930) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
110
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
111
SELECT COUNT( id ) AS count_users
 FROM chess_users
112
SELECT COUNT( id ) AS count_items
 FROM chess_content
113
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
114
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1
115
SELECT guest, usertype
 FROM chess_session