Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Anche il Rapid Lido dei Ciclopi arriva al traguardo della 15a edizione . Appuntamento al 15 Settembre nello storico e verdeggiante Lido della costa Jonica catanese . Sponsor dell'evento : COSENTINO ELETTRODOMESTICI , che metterà a disposizione tutti i premi .   Per iscrizioni e bando   :  15° Rapid Lido dei Ciclopi         Menu principale Home Chi siamo Dove siamo Links Cerca Articoli News Foto & Immagini FAQ Contattaci download SITI IN EVIDENZA 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 CIS : L'AMATORI CT MANTIENE LA SERIE B mercoledì 16 marzo 2016 Meritati complimenti alla nostra squadra di serie B , per la permaneneza in serie B . Dopo un'inizio non proprio promettente con due sconfitte , i magnifici 4 , Franco Furnari , Angelo Caponnetto , Salvatore Zuccarotto e Gabriele Arena si sono riscattati con tre vittorie consecutive che gli hanno fatto conquistare il secondo posto dietro ai mostri del Circolo " Pedone Isolano "( Santagati ,Pisacane ecc. ecc. ) . Di seguito la Classifica Finale :                                                                    SERIE B  Classifica Finale Rk Squadra Fed Partite + = -   Pts GamPnt SB_MG 1   Pedone Isolano ITA 5 5 0 0   10 17.5 72.5 2   Amatori Scacchi Catania 1 ITA 5 3 0 2   6  9 30 3   Blacknighteam Gioiosa ITA 5 2 1 2   5 9.5 39 4   TE.DE.A. Cavallaro Giarre ITA 5 2 1 2   5 9.5 38 5   Lilybetana Marsala ITA 5 2 0 3   4 7.5 26.5 6   Ipercoop La Torre ITA 5 0 0 5   0 7 40 Ultimo aggiornamento ( domenica 27 marzo 2016 )   20° WE AMATORI CT : VINCE PISACANE , PRONOSTICO RISPETTATO venerdì 26 febbraio 2016      Foto : da sin. 1° Open C , Chiara Morello , 1° Open B Salvatore Zuccarotto , 1° Open A Pietro Pisacane, panoramica 1a sala Il Festival WE Amatori CT ha tagliato il traguardo della XX edizione nel migliore dei modi . I punti positivi sono veramente tanti : dall’ Hotel Garden che è ormai giudicata la location ideale per gli eventi scacchistici , per passare alla partecipazione ( 70 giocatori ) , fino all’organizzazione che si è andata sempre di più perfezionando negli anni. Prima di approfondire gli aspetti  agonistici vorrei sottolineare l’iniziativa che ha caratterizzato questo Torneo . E’ stata proposta una raccolta fondi per pagare le spese sanitarie , per il  ricovero e per un’ intervento molto difficile di un bambino rumeno di undici mesi , Andrei Gabriel Curceanu , nato con una gravissima malformazione all’intestino ed una grave anemia, che si può risolvere con un trapianto o con il prolungamento dello stesso intestino . Andrei , che pesa soltanto 3,5 Kg. , doveva essere operato Venerdì 20 Febbraio , ma purtroppo non è stato possibile operarlo fino al momento in cui scriviamo , perché il quadro clinico non permette ancora l’intervento . Il Policlinico di Catania è stato indicato dai Dottori dell’Ospedale di Bucarest per tentare di salvare la vita di Andrei , ma lo stato rumeno non riconosce ancora le spese e se le riconoscesse lo farebbe soltanto parzialmente . Occorrono subito € 30.000 , dalla Romania hanno donato € 20.000 , ne rimangono quindi 10.000 da trovare a tutti i costi . Gli scacchisti che leggono quest’articolo possono donare versando sul cc intestato a “ Gabriela Cristina Bucur “ (madre di Andrei ) Banca Transilvania : RO56BTRLEURCRT0331710201 . Torniamo al Festival . Nell’Open A , che vedeva il CM Pietro Pisacane N° 1 del tabellone , è stato rispettato il pronostico . Con 4 vittorie e 2 patte ha tolto tutte le possibilità agli avversari . Al posto d’onore il giovane CM palermitano Cristoforo Guccione , che dopo il passo falso del primo turno ha conseguito 4 vittorie di fila , fra cui quella decisiva con il Maestro Valguarnera , concludendo con un pareggio con il vincitore .  Al terzo posto , della serie “ toh chi si rivede !! “ si piazza il Maestro FIDE Giuseppe Fabiano che sembra stia risalendo la china per tornare agli antichi fasti . Buona la prestazione del Maestro palermitano Girolamo Valguarnera , 4° posto , che anche quest’anno ci ha onorato della partecipazione . A seguire i giovani CM  catanesi Gaetano Grasso e Fabio Imbraguglia , autori di prove onorevoli . I premi delle 1a e 2a Naz. sono andati a Giuseppe Magazzù ed a Franco Furnari . Nell’ Open B , caratterizzato da una partecipazione record di 38 giocatori , è stata rispettata la tradizione del Festival Amatori CT che vede sempre questo Torneo con molte sorprese . Ed infatti i primi 12 posti , ad eccezione del vincitore Salvatore Zuccarotto e da Stefano Nobile ( 6° )  sono occupati da giocatori con rating da 1494 a 1621 . Al secondo posto , staccato di mezzo punto troviamo un giovane rampante di Augusta Juri Quarta , con ben 5 vittorie , di cui 4 consecutive , ma  la sconfitta con il vincitore gli costa il primo posto . Completa il podio Domenico Priolo , un non più giovane come età , ma come scacchista . 4° 5° e 6° Giovanni Giustolisi , Francesco Giuffrida e Stefano Nobile . Da segnalare l’ottavo posto di Mario Spadaro , che non giocava Tornei ufficiali da circa 40 anni e che ha rivelato di essere stato Delegato Provinciale di Catania nel lontano 1965 . Ottima prestazione del giovanissimo gelese in grande ascesa Igor Migliorisi che chiude al 9° posto e si aggiudica il premio Under 16 . Salvatore Mangiagli , Presidente della Società Galatea di Acireale , si aggiudica il premio  dell’Over 60 ( Spadaro avrebbe cumulato 2 premi ) . Nell’Open C c’è stata la gradita sorpresa della vittoria della dodicenne gelese Chiara Morello , che ha “ rischiato “ di chiudere il Torneo a punteggio pieno . Solo nell’ultimo turno , ormai appagata della sicura vittoria , si è rilassata ed ha perso con Francesco Ferrarello che con questa vittoria ha agguantato il posto d’onore . Al terzo posto si piazza Salvatore Di Prato , che ritorna a giocare dopo molti anni e quindi ricomincia nel migliore dei modi .Primo degli Under 16 il giovanissimo Francesco Sapuppo . La Premiazione , condotta dall’Arbitro ed organizzatore il sotto scritto Carlo Vella , è stata caratterizzata da un clima allegro e gioviale , ed è iniziata con l’intervento del Delegato Provinciale di Catania l’Ing. Giuseppe Battaglia che ha annunciato i prossimi impegni scacchistici nel territorio catanese , fra cui i Campionati Provinciali Giovanili ed Assoluti . Un ringraziamento particolare all’Arbitro collaboratore Francesco Grasso che ha saputo essere equilibrato ed equidistante in tutte le occasioni . Un’ altro ringraziamento particolare ai componenti dell’organizzazione , Annamaria Barta Presidente dell’Amatori CT , Giuseppe Battaglia , Angelo Caponnetto , Gabriele Arena , Andras Barta ed al piccolo Robertino Vella . Clicca di seguto per il video della premiazione : https://www.youtube.com/watch?feature=player_embedded&v=lQPR0udsn3A  Carlo Vella Ultimo aggiornamento ( martedì 22 marzo 2016 )   RAPID INAUGURAZIONE NUOVA SEDE AMATORI CT : OBIETTIVO RAGGIUNTO !! domenica 24 gennaio 2016      L'obiettivo che ci eravamo prefissati era di recuperare scacchisti in letargo ed anche di acquisirne di nuovi . Ed è esattamente quello che è avvenuto , anzi addirittura il Torneo ha visto vincitore uno di questo gruppo , il CM Marcello Reitano , socio della prima ora dell'Amatori CT , che da parecchi anni si era allontanato dall'attività agonistica . Al posto d'onore , a mezzo punto di distanza , il CM Salvo Gangemi , che pur essendo il numero 1 del tabellone non è riuscito a far suo il Rapid . Completa il podio il Delegato Provinciale Giuseppe Battaglia , protagonista di un'ottima performance . I premiati delle Categorie sono  : 1N. Pierpaolo Melato , uno dei recuperati , 2N Gabriele Arena , sempre in prima linea ad adoperarsi per l'organizzazione , 3N Domenico Priolo socio recente dell'Amatori CT , NC il giovane Lucio Contarino . Primo Under 16 il sempre più promettente Valerio Stancanelli . Il premio dell'Over 60 va al Presidente del Circolo di Giarre Dante Finocchiaro , che ci ha fatto l'onore di partecipare all'evento . Ottima l'impressione avuta dai partecipanti del Rapid , dei locali della nuova sede , giudicati spaziosi e confortevoli . Grande la soddisfazione dei gestori della Ludoteca " Uffa Baruffa " , che presi dall'entusiasmo hanno espresso il desiderio di organizzare altri eventi . E grande anche quella del Presidente Annamaria Barta che si è molto prodigata per la riuscita dell'evento .Dopo la Premiazione è stato offerto un rinfresco ai partecipanti e si è brindato alla nuove sede . Ultima annotazione : sono venuti a trovarci scacchisti che non giocano da parecchi anni e pur non partecipando al Torneo hanno assistito, ripromettendosi di farlo le prossime volte . Adesso l'attenzione dell'organizzazioe è rivolta al più importante evento dell' anno del nostro Circolo : il Festival Int.le WE in programma dal 13 al 21 Febbraio . Carlo Vella Ultimo aggiornamento ( domenica 24 gennaio 2016 )   Condoglianze al nostro socio Rosario Isaia lunedì 11 gennaio 2016  L' Amatori Scacchi Catania vuole esprimere le più sentite condoglianze al nostro socio Rosario Isaia , per la prematura perdita della moglie . Ultimo aggiornamento ( lunedì 11 gennaio 2016 )   RAPID INAUGURAZIONE SEDE AMATORI CT giovedì 07 gennaio 2016        Dopo una ricerca lunga e travagliata , finalmente l’Amatori Scacchi Catania , storico circolo catanese fondato nel lontano 1987 , trova una sede consona alle sue tradizioni . I locali sono quelli della Ludoteca “ Uffa Baruffa “ di Gravina di Catania ( Via Cutore N° 75 ) , che ringraziamo per la collaborazione e la gentile disponibilità . Riprendiamo quindi le attività di Circolo , e cioè tornei sociali , corsi , Rapid e Tornei Lampo in sede ecc. ecc. , che negli ultimi anni avevano subito un rallentamento dovuto alle sedi che non si prestavano a questo tipo di eventi . L’Associazione non ha però mai indebolito l’attività esterna , anzi ha moltiplicato gli eventi e le iniziative . Citiamo le più importanti : Festival WE annuale nel mese di Febbraio arrivato quest’anno alla ventesima edizione , due Concentramenti Regionali del Campionato Italiano organizzati ad Acicastello (2013) ed Enna (2015) , tre Rapid annuali ormai diventati storici ( Etnacomics con stand degli Scacchi nella omonima Rassegna , Lido America e Lido dei Ciclopi ) e nel 2015 il Campionato Regionale Rapid 15 e 30 minuti . Nel giorno dell’inaugurazione organizziamo un Rapid con bassa quota d’iscrizione ( € 5 ) , che avrà lo scopo dichiarato di recuperare tutti gli scacchisti che abbiamo perso nel corso di questi anni e di attrarre nuovi e soprattutto giovani che si vogliono cimentare nel nostro Sport . Per questa ragione il Rapid sarà aperto a tutti , anche per non tesserati FSI , con la speranza di raccogliere i frutti di questa nostra iniziativa . Di seguito i dati del Rapid ed il link per le iscrizioni ed il Bando . SABATO 23 Gennaio ore 15,00 . Gravina di Catania , Vja Cutore , 75 . 7 turni , cadenza 15 minuti . QUOTA ISCRIZIONE. € 5,00 . OPEN FREE ANCHE A NON TESSERATI FSI .Per iscrizioni e bando clicca di seguito  : RAPID INAUGURAZIONE SEDE AMATORI CT Ultimo aggiornamento ( domenica 17 gennaio 2016 )   Altri articoli... 20° FESTIVAL INTERNAZIONALE W.E. Lutto nello scacchismo catanese : scomparso Sergio Tuttobene RAPID LIDO dei CICLOPI : SI IMPONE PISACANE 11° RAPID LIDO dei CICLOPI << Inizio < Prec. 1 2 3 4 5 6 7 8 9 10 Pross. > Fine >> Risultati 73 - 81 di 204 [Indietro] ExtCalendar Gennaio 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 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: 10:31 Caching: Disabled GZIP: Disabled Utenti: 88506 Notizie: 294 Collegamenti web: 17 Visitatori: 16543056

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 = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1713518193' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713518193' )
 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 published = 1 AND
 link LIKE 'index.php?option=com_content&task=blogsection%'
12
SELECT COUNT(a.id)
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_sections AS s ON a.sectionid = s.id
 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-19 11:31' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 11:31' )
 AND ( a.sectionid=1 )
 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,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_sections AS s ON a.sectionid = s.id
 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-19 11:31' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 11:31' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 72, 9
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 = 99999999 )
 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-19 11:31' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-19 11:31' )
 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-19 11:31' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 11:31' )
 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 = 2
30
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
31
SELECT * FROM chess_extcal_config
32
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') <= 20180101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180101 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
33
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') <= 20180101) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
34
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') <= 20180102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180102 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
35
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') <= 20180102) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
36
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') <= 20180103 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180103 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180103 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
37
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') <= 20180103) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
38
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') <= 20180104 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180104 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180104 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
39
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') <= 20180104) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
40
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') <= 20180105 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180105 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180105 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
41
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') <= 20180105) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
42
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') <= 20180106 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180106 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180106 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
43
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') <= 20180106) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
44
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') <= 20180107 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180107 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180107 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
45
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') <= 20180107) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20180108 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180108 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180108 ) ) 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') <= 20180108) 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') <= 20180109 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180109 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180109 ) ) 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') <= 20180109) 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') <= 20180110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180110 ) ) 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') <= 20180110) 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') <= 20180111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180111 ) ) 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') <= 20180111) 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') <= 20180112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180112 ) ) 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') <= 20180112) 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') <= 20180113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180113 ) ) 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') <= 20180113) 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') <= 20180114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180114 ) ) 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') <= 20180114) 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') <= 20180115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180115 ) ) 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') <= 20180115) 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') <= 20180116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180116 ) ) 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') <= 20180116) 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') <= 20180117 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180117 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180117 ) ) 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') <= 20180117) 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') <= 20180118 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180118 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180118 ) ) 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') <= 20180118) 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') <= 20180119 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180119 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180119 ) ) 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') <= 20180119) 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') <= 20180120 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180120 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180120 ) ) 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') <= 20180120) 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') <= 20180121 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180121 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180121 ) ) 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') <= 20180121) 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') <= 20180122 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180122 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180122 ) ) 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') <= 20180122) 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') <= 20180123 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180123 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180123 ) ) 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') <= 20180123) 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') <= 20180124 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180124 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180124 ) ) 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') <= 20180124) 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') <= 20180125 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180125 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180125 ) ) 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') <= 20180125) 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') <= 20180126 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180126 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180126 ) ) 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') <= 20180126) 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') <= 20180127 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180127 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180127 ) ) 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') <= 20180127) 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') <= 20180128 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180128 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180128 ) ) 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') <= 20180128) 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') <= 20180129 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180129 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180129 ) ) 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') <= 20180129) 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') <= 20180130 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180130 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180130 ) ) 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') <= 20180130) 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') <= 20180131 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180131 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180131 ) ) 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') <= 20180131) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
94
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
95
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
96
SELECT COUNT( id ) AS count_users
 FROM chess_users
97
SELECT COUNT( id ) AS count_items
 FROM chess_content
98
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
99
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1