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 IL COMBATTIVO AGNELLO CAMPIONE PROVINCIALE di CATANIA domenica 29 aprile 2018 Il Campionato Provinciale di Catania , intitolato alla memoria di Sergio Tuttobene , ricordato nel corso della premiazione dal Dott. Carlo Cannella , si è svolto nei locali della Cittadella Universitaria del CUS Catania , gentilmente concessi dal Commissario dello stesso CUS .  La cronaca . A dispetto del nome , il combattivo CM Giuseppe Agnello (Scacchi Giarre) , diventa Campione Provinciale di Catania 2018 . Dopo un iniziale mezzo passo falso , 3 vittorie consecutive lo piazzano in testa alla classifica . A questo punto la patta con il forte giovane 1N Andrea Barbagallo (Don Pietro Carrera) , arrivato alla fine secondo a pari punti con il vincitore , costringeva Agnello a giocarsi tutto contro il giocatore con il più alto punteggio Elo del torneo , e cioè il Maestro FIDE Giuseppe Fabiano (Etna Scacchi) . La vittoria gli permetteva di mantenere la prima posizione e vincere così il Campionato . Bisogna spendere due parole su Fabiano , scacchista con un passato glorioso , denso di vittorie e soddisfazioni , ma ormai autore di prestazioni deludenti e di molto al di sotto del suo standard . In evidenza il terzo posto dell'ormai più che affidabile 1N Juri Quarta (Paolo Boi SR) , a pari punti con il 1N Andrea Annaloro (Amatori Catania) , giocatore molto regolare e sconfitto solo dal vincitore .Segue in Classifica il giovanissimo 2N Giovanni Mendola (Etna Scacchi) , che conferma i grandi progressi dell'ultimo periodo .I premi di fascia vanno a Giuseppe Battaglia (Amatori Catania) ed a Bruno Casella (Don Pietro Carrera) . 1° Under 16 Francesco Sapuppo  (Don Pietro Carrera) e 1° NC il simpatico e signorile  Giovanni Pampanini (Don Pietro Carrera) . 1° Over 60 Salvatore Verde (Etna Scacchi) . Discreta la partecipazione ed ottima la sede di gioco  , una palestra del CUS Catania ampia e luminosa . Da rivedere le date per i prossimi anni , perchè il 25 Aprile penalizza la partecipazione . All' organizzazione hanno collaborato il Delegato Provinciale Prof. Vincenzo Intraguglielmo , che per un problema personale non ha potuto essere presente alla Premiazione ,la Prof.ssa Agata Campisi (Etna Scacchi) e l'arbitro ACN Carlo Vella . Carlo Vella               Il vincitore Giuseppe Agnello                    Secondo class. Andrea Barbagallo   Il terzo class. Juri Quarta                  La Prof.ssa Agata Campisi e l'arbitro Carlo Vella Ultimo aggiornamento ( domenica 29 aprile 2018 )   Il FM Santagati domina il 22° Festival Amatori sabato 03 marzo 2018 Articolo e foto di CHESSLOGGER . Si è disputato nel doppio weekend del 17 e 18 e del 24 e 25 febbraio il 22° Festival Amatori oramai un vero e proprio classico del panorama scacchistico siciliano. La manifestazione aveva come sede il President Park Hotel ad Aci Castello e come sempre organizzata dall'Amatori Scacchi Catania. La direzione arbitrale era come sempre affidata all'esperto ACN Carlo Vella. Nell'Open A naturale favorito della vigilia era il Maestro Fide Alessandro Santagati oramai uno specialista di questi tornei, con il forte CM Pietro Pisacane come possibile antagonista alla vittoria finale. Altri possibili outsiders erano l'esperto FM Giuseppe Fabiano e la CM Laura Gueci. Alla fine dei sei turni di gioco previsti nessuna sorpresa per la vittoria finale con Alessandro Santagati che si imponeva con un perentorio 6 su 6 alle sue spalle con 4 su 6 Laura Gueci e terzo con 3,5 su 6 Pietro Pisacane. Altri premiati 4° posto Massimiliano Filetti e 5° posto Giuseppe Agnello. Classifica Finale Open A = http://vesus.org/results/open-a-elo-gt-1649-22deg-festival-amatori-scacchi-catania/standing/ In un Open B molto equilibrato all'ultimo turno si giocavano il torneo Francesco Furnari numero uno di tabellone e Mario Santagati testa di serie numero 3, alla fine di un incontro equilibrato la spuntava Furnari che vinceva il torneo con 5 punti su 6. Completano il podio l'espertissimo Mario Spadaro con 4,5 punti su 6 e con gli stessi punti ma dietro per buchholz il giovane Giovanni Mendola al terzo posto. Altri premiati 4° posto per Mario Santagati e 5° per Giuseppe Battaglia. Classifica Finale Open B = http://vesus.org/results/open-b-elo-lt-1800-22deg-festival-amatori-scacchi-catania/standing/ Nell'Open C vince Marco Guarnera con 5 punti su 6, al secondo posto Vittorio Fargetta con 4,5 punti su 6 e terzo Francesco D'Anna con 4 punti su 6. Classifica Finale Open C = http://vesus.org/results/open-c-elo-lt-1500-22deg-festival-amatori-scacchi-catania/standing/ Discorso Finale / Premiazione :  https://youtu.be/KUq46YJvkmw Album Fotografico : https://photos.google.com/u/1/share/AF1QipM4ZNAnEyysZAmIsTxjejwxlXlwYPF7Aal6P-PgZE7B75JyqPpFF7ON7jOq5FCuvg?hl=it&key=VG13TFFVcm9hYkUxN0tUSDR4c0otSERNeV9ENXZn     Ultimo aggiornamento ( sabato 03 marzo 2018 )   22° FESTIVAL WE AMATORI CT , 17-18 e 24-25 FEBBRAIO 2018 venerdì 29 dicembre 2017 Cambio di sede per il Festival " Amatori Scacchi Catania " . Il prestigioso ed ormai conosciutissimo PRESIDENT PARK HOTEL , ospiterà la 22a edizione dello storico torneo . L' evento è sponsorizzato dal rivenditore  " Cosentino Elettrodomestici " di Biancavilla . Per pre-iscrizioni e bando: 22° FESTIVAL WE AMATORI CT preiscrizioni e bando       Ultimo aggiornamento ( giovedì 15 febbraio 2018 )   Altri articoli... L'Amatori CT conquista il Trofeo Carnevale di Acireale << Inizio < Prec. 1 2 3 4 5 6 7 8 9 10 Pross. > Fine >> Risultati 37 - 40 di 175 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 Agosto 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 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: 03:58 Caching: Disabled GZIP: Disabled Utenti: 88320 Notizie: 294 Collegamenti web: 17 Visitatori: 16526983 Chi è online Abbiamo 1 visitatore 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 < '1713408200' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713408200' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
6
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 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 COUNT(a.id)
 FROM chess_content AS a
 INNER 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
 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.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 04:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 04:58' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
13
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM chess_content AS a
 INNER 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
 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.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-18 04:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 04:58' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 36, 4
14
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
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'
16
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
17
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
18
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
19
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-18 04:58' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-18 04:58' )
 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
20
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
21
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-18 04:58' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 04:58' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
22
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
24
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
25
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
26
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
27
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
28
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
29
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 1
30
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-18 04:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 04:58' )
 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
31
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
32
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
33
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
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 = 293
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35
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
36
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
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 = 290
 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 = 289
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
39
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
40
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
41
SELECT id
 FROM chess_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
42
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 15
 AND text != ''
 ORDER BY id
43
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 16
 AND text != ''
 ORDER BY id
44
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 20
 AND text != ''
 ORDER BY id
45
SELECT * FROM chess_extcal_config
46
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') <= 20190801 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190801 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190801 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
47
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') <= 20190801) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
48
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') <= 20190802 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190802 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190802 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
49
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') <= 20190802) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
50
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') <= 20190803 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190803 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190803 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
51
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') <= 20190803) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
52
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') <= 20190804 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190804 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190804 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
53
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') <= 20190804) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
54
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') <= 20190805 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190805 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190805 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
55
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') <= 20190805) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
56
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') <= 20190806 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190806 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190806 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
57
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') <= 20190806) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
58
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') <= 20190807 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190807 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190807 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
59
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') <= 20190807) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
60
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') <= 20190808 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190808 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190808 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
61
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') <= 20190808) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
62
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') <= 20190809 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190809 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190809 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
63
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') <= 20190809) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
64
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') <= 20190810 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190810 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190810 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
65
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') <= 20190810) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
66
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') <= 20190811 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190811 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190811 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
67
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') <= 20190811) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
68
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') <= 20190812 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190812 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190812 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
69
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') <= 20190812) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
70
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') <= 20190813 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190813 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190813 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
71
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') <= 20190813) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
72
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') <= 20190814 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190814 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190814 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
73
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') <= 20190814) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
74
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') <= 20190815 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190815 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190815 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
75
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') <= 20190815) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
76
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') <= 20190816 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190816 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190816 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
77
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') <= 20190816) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
78
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') <= 20190817 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190817 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190817 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
79
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') <= 20190817) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
80
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') <= 20190818 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190818 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190818 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
81
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') <= 20190818) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
82
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') <= 20190819 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190819 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190819 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
83
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') <= 20190819) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
84
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') <= 20190820 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190820 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190820 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
85
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') <= 20190820) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
86
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') <= 20190821 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190821 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190821 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
87
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') <= 20190821) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
88
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') <= 20190822 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190822 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190822 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
89
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') <= 20190822) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
90
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') <= 20190823 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190823 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190823 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
91
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') <= 20190823) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
92
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') <= 20190824 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190824 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190824 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
93
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') <= 20190824) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
94
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') <= 20190825 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190825 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190825 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
95
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') <= 20190825) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
96
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') <= 20190826 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190826 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190826 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
97
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') <= 20190826) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
98
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') <= 20190827 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190827 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190827 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
99
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') <= 20190827) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
100
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') <= 20190828 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190828 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190828 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
101
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') <= 20190828) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
102
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') <= 20190829 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190829 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190829 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
103
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') <= 20190829) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
104
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') <= 20190830 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190830 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190830 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
105
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') <= 20190830) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
106
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') <= 20190831 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190831 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190831 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
107
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') <= 20190831) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
108
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
109
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
110
SELECT COUNT( id ) AS count_users
 FROM chess_users
111
SELECT COUNT( id ) AS count_items
 FROM chess_content
112
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
113
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1
114
SELECT guest, usertype
 FROM chess_session