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 CAMPIONATO REGIONALE RAPID : PREVALE SANTAGATI martedì 14 luglio 2015       Foto a sx = Imbraguglia , Furnari , Vella , Santagati , Pisacane e Fabiano    Foto a dx = Panoramica Stavolta iniziamo dalla fine , e cioè dal discorso della premiazione dell'Arbitro/Organizzatore Carlo Vella . In sostanza evidenziava che tutto era riuscito bene , dall' Hotel che rafforzava i giudizi positivi del WE Amatori CT del Febbraio scorso , la sala ampia e ben climatizzate , l'ottima gastronomia , la bellissima piscina ed infine la piacevole cortesia del personale , che non dispiace mai , con in testa l'ottimo Direttore Sig. Francesco Santoro , . L'atmosfera cordiale , la velocità delle procedure , agevolati dal proiettore che in tempo reale notiziava dei turni e delle classifiche ed il materiale scacchistico rinnovato sono i punti a favore del Campionato . Ma Carlo Vella affermava che un'evento di questo livello meritava sicuramente una partecipazione più numerosa . 34 giocatori che si sono sfidati nei 2 Rapid da 15 e da 30 minuti , sono in effetti un po' pochini . I due Tornei hanno avuto un'andamento diverso . Nel primo con cadenza di 15 minuti , c'è stato un testa a testa fra i Maestri Santagati e Fabiano che hanno chiuso a pari punti ( 7 su 8 ) con la vittoria del primo per spareggio tecnico . Al terzo posto il giovane CM Pietro Pisacane , fresco Campione Regionale Assoluto . Da segnalare i piazzamenti a sorpresa dei messinesi Andrea Musso ( 5° ) e Lorenzo Salvia ( 7° ) . Il secondo Rapid con cadenza di 30 minuti , è stato più movimentato ed ha visto 3 giocatori a pari punti nei primi posti . La sorpresa è stata la performance di Francesco Furnari che ha letteramente gettato al vento la vittoria nell'ultimo turno con Santagati , che gli avrebbe permesso di vincere il Rapid 30 . Il CM Fabio Imbraguglia approfittava invece della patta Santagati-Furnari per aggiudicarsi il Rapid 30 per spareggio tecnico . Nella Classifica finale dei due Rapid evidenziamo il 2° posto di Pisacane ed il 3° del Maestro FIDE Fabiano , tornato a livelli più consoni alla sua preparazione .In conclusione comunque gli organizzatori si ritengono soddisfatti , ma sperano che la prossima volta gli sforzi profusi siano ripagati da una partecipazione più numeros. Carlo Vella In leggi tutto trovi le Classifiche > Ultimo aggiornamento ( martedì 14 luglio 2015 ) Leggi tutto...   CAMPIONATO REGIONALE RAPID MIX-TIME lunedì 22 giugno 2015 Il Campionato si articola su un primo Torneo , con cadenza 15 minuti e 8 turni , che si disputerà Sabato pomeriggio 11 Luglio . Il secondo , con cadenza 30 minuti e 6 turni , Domenica 12 Luglio . Saranno stilate 3 Classifiche , i due Rapid ed una Classifica che si otterrà con la somma dei punti partita , del Buholz e degli altri punti spareggi , e che determinerà i Campioni Ragionali , assoluto, delle fascie , Under 16 ecc. ecc.. L'iscrizione è unica per il Campionato ed è previsto uno sconto per i partecipanti al di fuori della Provincia ospitante . Il " GARDEN HOTEL **** " di San Giovanni La Punta (CT) , ospiterà l'evento. Le tariffe competitive , l'ottima cucina e le sale gioco accoglienti , sono le caratteristiche di questa struttura alberghiera, già apprrezzata in occasione del Torneo WE Amatori CT del Febbraio scorso . Ma la novità sarà la possibilità di usufruire della bellissima piscina anche per gli accompagnatori . Anche se ci sono tanti elementi nuovi , gli organizzatori confidano in una partecipazione importante da tutta la Sicilia .  Iscrizione Campionato Regionale Rapid        Bando Campionato Regionale Rapid Ultimo aggiornamento ( martedì 23 giugno 2015 )   ETNA COMICS 2015 : GLI SCACCHI PROTAGONISTI domenica 07 giugno 2015 La quinta edizione della Rassegna " Etna Comics " ha superato in termini di affluenza e di immagine le precedenti edizioni . Dai 50.000 biglietti venduti nel 2014 si è passati ai 60.000 attuali , con un'incremento del 20% . La sezione Scacchi è stata fra le più visitate . Le 25 scacchiere sono state prese d'assalto e nei 4 giorni della Rassegna sono state quasi sempre tutte occupate . Come da Tradizione si è disputato il Rapid Italia nella giornata di Domenica . La partecipazione non è stata esaltante , ma ha raggiunto il numero minimo per l'omologazione del Rapid Play Sicilia ..In effetti 16 partecipanti è un numero a cui l'Amatori Catania non è abituato . E' vero che si possono aggiungere quelli dell'Open B per non tesserati , ma rimane comunque un numero esiguo . La ragione principale è da attribuire al biglietto d'ingresso ( € 10 ) che ha sicuramente frenato chi voleva partecipare al Rapid senza avere un particolare interesse a visitare la Rassegna . Il Rapid ha visto protagonista assoluto il neo Maestro Riccardo Marzaduri che come un carro armato ha fatto fuori tutti gli avversari non concedendo neanche una patta . Al secondo posto Franco Bruno di Valguarnera (EN) . Ha completato il podio il giovanissimo Andrea Barbagallo . Da segnalare il 4° posto di Giovanni Giustolisi con gli stessi punti del 2° e 3°(5,5) . Per tutti i dati clicca di seguito  5° RAPID PLAY   “ ETNA COMICS “ 2015 Complessivamente l'esperienza è stata sicuramente , anche quest'anno , più che positiva e noi dell'Amatori Catania siamo orgogliosi di tenere alta la bandiera degli Scacchi in questo evento , ormai reputato fra quelli più importanti dell'intera regione della sua categoria . Carlo Vella            Ultimo aggiornamento ( domenica 07 giugno 2015 )   11° RAPID LIDO AMERICA domenica 03 maggio 2015 AMATORI  SCACCHI  CATANIA   11° RAPID PLAY “ LIDO AMERICA “ 2015  CATANIA DOMENICA 14 GIUGNO 2015  Rapid Italia + Tappa Campionato Rapid Play Sicilia 2015   SEDE : LIDO AMERICA–Lungomare Kennedy–Playa di Catania Chiusura iscrizioni ore 10,00 . 1° turno ore 10,30 ENTRATA GRATIS PER UN’ ACCOMPAGNATORE DIREZIONE  ARBITRALE : A.C.N. CARLO VELLA Clicca di seguito per bando e preiscrizioni  =   11° RAPID PLAY “ LIDO AMERICA “ 2015  Informazioni : CARLO VELLA Cell. 335-6509575 ;  e-mail : Indirizzo e-mail protetto dal bots spam , deve abilitare Javascript per vederlo ; sito : www.amatoriscacchicatania.com Ultimo aggiornamento ( venerdì 05 giugno 2015 )   47° CIS : 280 giocatori e 56 squadre !! lunedì 30 marzo 2015 In 280 al Campionato Italiano a Squadre di Enna 30 mar, 2015 Si è svolta a Enna, presso il Federico II Palace Hotel, la quinta edizione del Campionato a Squadre di Scacchi, nella formula del concentramento, ovvero con la partecipazione di tutte le squadre dalla categoria Promozione, alla serie A1. La manifestazione, svolta dal 27 al 29 marzo, ha coinvolto ben  56 squadre, con oltre 280 giocatori partecipanti tra titolari e riserve. Record di partecipazione dunque, favorito certamente dalla presenza anche della Serie A1 che mai si era disputata negli altri concentramenti e che era stata assegnata alla Sicilia per l’alta presenza di squadre isolane nel girone, ma sicuramente questo risultato è anche frutto di un gradimento che l’evento in questione si è costruito nel corso degli anni creando un percorso di successo che, ricordiamo, iniziò a Palermo nel 2011. Ad oggi ricordiamo quindi le precedenti edizioni ed i circoli organizzatori: 25/27 marzo – Campo Felice di Roccella  (PA) – Centro Scacchi Palermo (48 squadre); 30 marzo/1 aprile – Baida (PA) – Centro Scacchi Palermo (40 squadre); 15/17 marzo – Acicastello (CT) President Park Hotel – Amatori Scacchi Catania  (48 squadre); 21/23 marzo – Marsala (TP) Baglio Petrosino – asd Lilybetana (54 squadre); 27/29 marzo – Enna – Hotel Federico II – Amatori Scacchi Catania (56 squadre).              Sala B , C e Promozione                                         Sala A1 e A2 Si è trattato sempre di eventi di eccellenza ben organizzati e partecipati e questo, insieme al fascino superiore del torneo a squadre, ne ha determinato l’attuale l’ampio consenso. Detto questo, entrando nei particolari di questa edizione, va segnalato innanzitutto il gran lavoro svolto dalle due associazioni organizzatrici, Amatori Catania e Sissa Leonforte, e se tutti conosciamo l’impegno che Carlo Vella mette nelle sue iniziative, ci ha sorpreso piacevolmente l’entusiasmo dell’associazione di Enna (un nome per tutti: Carmelo Falconieri) che dopo un assenza di qualche anno dal panorama federale si è ripresentata con il piglio da protagonista. Ottima la struttura alberghiera, quattro stelle di nome e di fatto,  che ha fatto da degna cornice al nostro evento. Particolarmente apprezzata la distribuzione dei giocatori in due diversi spazi con la sala principale che ha ospitato le serie Promozione, C e B, per un totale di 44 squadre (!) e la serie A2 e A1 in sala separata. Eccellente lo staff arbitrale con un Piero Arnetta sempre presente e consolidato nel suo ruolo di numero 1 del mondo siciliano arbitrale, ben affiancato dall’ACN Giuseppe Palazzotto e dall’A.R. Domenico Buffa. Bellissimo il clima generale con tutti i partecipanti, esordienti e Maestri, grandi e piccini, pronti a confrontarsi per difendere i colori del proprio circolo lottando per conquistare la promozione nella categoria superiore o, al peggio, evitare la retrocessione. La serata del 28 ha visto l’organizzazione del consueto Torneo Blitz, quest’anno “International Night-Blitz Sicilia 2015” in omaggio al M.I. Russo Vladimir Shumilin che ha fornito il montepremi della manifestazione. Cinquantotto i partecipanti con vittoria del G.M Maxim Dlugy, scacchista statunitense di origini russe, con 7,5 punti, davanti a quattro giocatori tutti ex aequo a 7 punti. Eccoli citati in ordine d’arrivo: il GM Milan Drasko, l’IM Andjelko Dragojlovic, il GM Nenad Ristic e il MF Andrea Amato. Premiazione vincitore Camp- Lampo GM Dlugy   Vince la categoria Promozione (19 squadre partecipanti) la Chessmate A di Bagheria che precede per spareggio tecnico la CPS Promo U20 di Palermo, giunta anch’essa a 8 punti. Al terzo e quarto posto un altra coppia di squadre ex aequo, la Cielo D’Alcamo e la Al Cantara di Viagrande. Al quinto posto la squadra di Casa Sissa, pure essa ex aequo con gli Amici della Scacchiera di Erice, che giungono sesti. Tutte le squadre citate vengono promosse in serie C. L'Amatori B non riesce ad essere promossa in C . La Serie C, girone 29 (17 squadre) vede la vittoria della squadra messinese della Kodokan A ex aequo con la seconda classificata, la Cielo D’Alcamo. Al terzo posto l’Ipercoop La Torre di Monreale. Le tre squadre conquistano la promozione in serie B. Retrocedono il Centro Scacchi Palermo C, il Centro Scacchi Acicastello, Arcadia Partanna, Ipercoop la Torre B di Monreale, Al Cantara 3 di Viagrande e Acireale. In Serie B (8 squadre) si impongono,  gli Amici della Scacchiera di Erice, unica squadra che conquista la promozione in serie A2. Retrocedono Al Cantara 2 di Viagrande, Rapax Horses di Grammichele e CPS Banca Nuova di Palermo. L'Ametori Catania A si salva agevolmente conquistando un'onorevole 3° posto . La Serie A2 vede la vittoria del team di Catanzaro, anch’esso unico a guadagnare la promozione nella serie superiore. Retrocedono Blacknighteam di Gioiosa Marea e Asd Enzo Crea di Messina. Nella Serie A1 caratterizzata dalla presenza di GM e MI e di diversi MF, il Circolo Palermitano Scacchi sorprende tutti e con un team di “semplici” candidati Maestri mette in riga formazioni sulla carta molto più blasonate, ottenendo un prestigioso successo (Claudio Mangione, Michel Bifulco, Luca Varriale e Guido Morello).  Al secondo posto si piazza la squadra di Roma  Steinitz ed al terzo il Centro Scacchi Palermo. Si salva il team di Al Cantara  al suo esordio nella serieA1, mentre retrocedono la Partenopea Senjor di Napoli ed il secondo team del Circolo Palermitano Scacchi.                 Premiazione La premiazione si è svolta nella sera di giorno 29, alla presenza del presidente del Comitato Scacchistico Siciliano. Ecco forse l’unica “magagna” dell’evento è tutta racchiusa qui….l’assoluta mancanza di rappresentanza della città di Enna. Insomma, stiamo parlando di un evento che ha raccolto fino a 400 persone tra giocatori e accompagnatori che, per tre giorni, hanno riempito gli alberghi della zona. Che nessuna autorità del luogo si sia presentata per dare un segnale di gradimento e di accoglienza ai nostri giocatori e al nostro sport, magari anche solo un saluto, beh questo ci ha lasciato un tantino amareggiati. Classifiche Finali CIS 2015 Classifica Blitz Video discorso d'apertura Campionato Italiano = https://www.youtube.com/watch?v=0AOdrzM0Vyg   Video Rosolia si difende = http://youtu.be/hooteeI2lC0  Video Panoramica della sala Promozione , B e C =  http://youtu.be/6Bd-i12LlH0 Ultimo aggiornamento ( venerdì 03 aprile 2015 )   Altri articoli... CONCENTRAMENTO CIS 2015 SICILIA, ENNA PALACE HOTEL FEDERICO II SARDO RESISTE E VINCE IL 19° FESTIVAL AMATORI CT 19° FESTIVAL AMATORI CT : SEMPRE PRESENTE !! RAPID PATERNO' : VINCE CARLO VELLA << Inizio < Prec. 1 2 3 4 5 6 7 8 9 10 Pross. > Fine >> Risultati 82 - 90 di 204 [Indietro] ExtCalendar Febbraio 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 Home Chi siamo Dove siamo Links Cerca Articoli News Foto & Immagini FAQ Contattaci download Immagine casuale Menu utente Statistiche OS: Linux h PHP: 5.2.17 MySQL: 5.0.96-community-log Ora: 05:52 Caching: Disabled GZIP: Disabled Utenti: 88330 Notizie: 294 Collegamenti web: 17 Visitatori: 16531933

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 < '1713415062' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713415062' )
 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 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-18 06:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 06:52' )
 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-18 06:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 06:52' )
 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 81, 9
14
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT params
 FROM chess_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
16
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'
17
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
18
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
19
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
20
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 06:52' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-18 06:52' )
 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
21
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
22
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 06:52' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-18 06:52' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
23
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
24
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
25
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
26
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
27
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
28
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
29
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
30
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 2
31
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
32
SELECT * FROM chess_extcal_config
33
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') <= 20190201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190201 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
34
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') <= 20190201) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
35
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') <= 20190202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190202 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
36
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') <= 20190202) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
37
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') <= 20190203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190203 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
38
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') <= 20190203) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
39
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') <= 20190204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190204 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
40
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') <= 20190204) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
41
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') <= 20190205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190205 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
42
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') <= 20190205) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
43
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') <= 20190206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190206 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
44
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') <= 20190206) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
45
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') <= 20190207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190207 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
46
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') <= 20190207) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
47
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') <= 20190208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190208 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
48
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') <= 20190208) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20190209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190209 ) ) 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') <= 20190209) 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') <= 20190210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190210 ) ) 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') <= 20190210) 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') <= 20190211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190211 ) ) 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') <= 20190211) 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') <= 20190212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190212 ) ) 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') <= 20190212) 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') <= 20190213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190213 ) ) 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') <= 20190213) 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') <= 20190214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190214 ) ) 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') <= 20190214) 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') <= 20190215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190215 ) ) 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') <= 20190215) 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') <= 20190216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190216 ) ) 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') <= 20190216) 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') <= 20190217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190217 ) ) 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') <= 20190217) 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') <= 20190218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190218 ) ) 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') <= 20190218) 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') <= 20190219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190219 ) ) 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') <= 20190219) 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') <= 20190220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190220 ) ) 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') <= 20190220) 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') <= 20190221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190221 ) ) 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') <= 20190221) 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') <= 20190222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190222 ) ) 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') <= 20190222) 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') <= 20190223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190223 ) ) 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') <= 20190223) 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') <= 20190224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190224 ) ) 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') <= 20190224) 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') <= 20190225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190225 ) ) 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') <= 20190225) 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') <= 20190226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190226 ) ) 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') <= 20190226) 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') <= 20190227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190227 ) ) 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') <= 20190227) 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') <= 20190228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20190228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20190228 ) ) 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') <= 20190228) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
89
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
90
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
91
SELECT COUNT( id ) AS count_users
 FROM chess_users
92
SELECT COUNT( id ) AS count_items
 FROM chess_content
93
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
94
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1