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 FESTIVAL WE : MF Santagati domina , era già tutto previsto...... domenica 26 febbraio 2017 Si è concluso il 21° Festival WE Amatori CT , sponsorizzato da “ COSENTINO ELETTRODOMESTICI “  Via Moderi – Biancavilla (CT)  , diventato ormai un’ appuntamento storico dello scacchismo siciliano . Devo dire però che ogni edizione è diversa dalle precedenti e si trovano sempre ogni anno delle caratteristiche uniche . Gli 80 partecipanti testimoniano che oltre la storicità , gli ingredienti usati dagli organizzatori sono quelli giusti per ottenere risultati sempre più positivi . Da 3 anni l’evento si svolge , nell’ormai conosciutissimo dagli scacchisti ,  Hotel Garden di San Giovanni la Punta (CT) , struttura ed ambiente ideale per queste tipologie di manifestazioni . Nell’Open A non ci sono state sorprese . Il MF Alessandro Santagati , asso piglia tutto degli ultimi Tornei , conclude con l’en plein 6 su 6 . Piazza d’onore per il CM Pietro Pisacane che vanta una bella vittoria sul MI Ljubisavljevic . Completa il podio il bravo neo Maestro Gaetano Grasso che si gioca il tutto per tutto nell’ultimo turno con il vincitore, conducendo una partita d’assalto per poter puntare alla vittoria finale . Ma l’esperienza e la freddezza di Santagati prevalgono sull’esuberanza di Grasso e l’epilogo è quello prevedibile della vittoria del MF .  Da segnalare le buone prestazioni del CM Salvatore Gangemi (4°) , del ritrovato 1N Francesco Pafumi (5°) , dell’alcamese 1N Antonino Lo Piccolo (7°) , dei giovani 1N Franco Furnari (9°) , Angelo Caponnetto (10°) , Simone Cannella (11°) e Paolo Di Mauro (12°) . Inoltre sempre nell’Open A la bella e coraggiosa 2N Daniela Verde conclude con un buon 14° posto . Come da tradizione di questo Festival , l’Open B riserva sempre sorprese ed infatti la vittoria arride al 2N Andrea Annaloro , numero 11 del tabellone , che con un 5,5 su 6 domina l’Open e cede solo ½ punto all’ ottimo 2N Sebastiano La Rosa , che conquista il secondo posto nonostante anche lui non faceva parte del lotto dei favoriti . Completa il podio il 1N Antonello Napoli Costa di Gioiosa Marea(ME) . I 1N Francesco Furnari (padre di Franco ) e Giuseppe Rosolia si accontentano del 4° e 5° posto ed al 6° l’ ottimo 1N Calogero Savitteri di Agrigento . Premiato come Under 16 Giovanni Mendola che ormai affronta alla pari qualsiasi avversario .Per l’ Over 60 premiato Salvatore Zuccarotto , che dopo aver vinto l’anno scorso , stavolta precipita al 13 ° . Primo delle terze Nazionali Salvatore Mangiagli Presidente del Galatea Scacchi Acireale . Grande battaglia nell’ affollato Open C (24 giocatori)  , con partite che tecnicamente non avevano nulla da invidiare all’Open superiore . Vince , per spareggio tecnico , il simpatico Giuseppe Di Mauro su Fabio Manciagli . Ma la vera sorpresa , scusandomi per il gioco di parole , è il piccolo Marco Lo Piccolo che , caso più unico che raro , arriva al terzo posto pur essendo l’ultimo del Tabellone . Premiato come 1° dell’Under 16 il genio matematico Valerio Stancanelli . La Premiazione , condotta dall’arbitro principale Carlo Vella , si è svolta In un’atmosfera simpatica e cordiale , ed è stata molto movimentata , soprattutto a causa del sorteggio finale di una Stiratrice Verticale SINGER , offerta dalla stessa Multinazionale americana , vinta da Giuseppe Verde , padre di Daniela  . La partecipazione alla Premiazione del Presidente del Comitato Regionale Dante Finocchiaro è stata molto gradita , come lo sono stati gli interventi dell’arbitro Francesco Grasso e dei Consiglieri del Comitato Regionale Giuseppe Battaglia , Simonpietro Spina e Gaetano Grasso .  Carlo Vella   21° Festival Amatori CT Risultati e Classifiche             Ultimo aggiornamento ( domenica 26 febbraio 2017 )   Grande partecipazione al 21° Festival Amatori CT giovedì 16 febbraio 2017  21° Festival Amatori CT  . Partiti !!  80 partecipanti , 10 in più dell'anno scorso.    Open A e B   Open C Ultimo aggiornamento ( domenica 26 febbraio 2017 )   GLOBUS TELEVISION INTERVISTA A CARLO VELLA LUNEDI' 30 GEN.ORE 19,00 sabato 28 gennaio 2017 You Tube : l'intervista completa a Carlo Vella su Globus Television  30/01/17 Carlo Vella   GLOBUS TELEVISION "SPORT E... NON SOLO" Lunedì 30.1.2017 h.19.00 Album GLOBUS TELEVISION "SPORT E... NON SOLO" Lunedì 30.1.2017 h.19.00 4 foto · Updated 4 ore fa GLOBUS Television canale 819 digitale terrestre e GLOBUS RADIO STATION Lunedì 30 gennaio 2017 alle ore 19:00 presentano "Sport e...non solo" conduce Santi Armando Garufi. Ospite in studio CARLO VELLA arbitro federale e fondatore AMATORI SCACCHI CATANIA. Tutti sintonizzati su GLOBUS TELEVISION #canale819 #digitaleterrestre e ► Tutti online e in streaming video su: ► http://www.globusmagazine.it/video ► http://www.globusmagazine.it/radio #OnAir su #GlobusRadioStation Seguiteci anche su #Twitter : @GlobusRadio #TuneIn: http://tunein.com/radio/GLOBUS-RADIO-STATION-s24123 Seguiteci anche su #Twitter : @GlobusRadio #TuneIn: http://tunein.com/radio/GLOBUS-RADIO-STATION-s241235/             Ultimo aggiornamento ( martedì 31 gennaio 2017 )   18° Campionato Provinciale di SIRACUSA 2017 , “Memorial Edoardo Loschi” giovedì 19 gennaio 2017 L’evento ottimamente organizzato dall’ A.S.D. Scacchistica “Paolo Boi” di Siracusa , in collaborazione con la Circoscrizione Grottasanta , ha visto la partecipazione di 28 scacchisti provenienti non solo dalla città aretusea ma anche da Catania e Palermo. Il numero dei giocatori poteva essere più interessante , se il maltempo , con la sorpresa anche di un po’ di neve , non fosse stato penalizzante . Da parte dei giocatori catanesi ci sono stati i migliori piazzamenti . Il podio infatti è stato appannaggio tutto loro .Il torneo è stato vinto dal Maestro Fide Alessandro Santagati , che concede la patta soltanto all’ultimo turno con la rivelazione del Torneo il 1N Vincenzo Daniele Gullotta  , che conquista il 3° posto . Al secondo posto il CM Fabio Imbraguglia , autore di un’ottima performance con 5 vittorie su 6 ed una sconfitta , ma molto combattuta , con il vincitore . Quarto posto e primo dei siracusani, e quindi Campione Provinciale di Siracusa 2017 , il Maestro Riccardo Alaimo , un po’ al di sotto dei suoi standard abituali . Per gli over 60 la vittoria è andata al CM Salvatore Tondo, Presidente del “ Paolo Boi “ . Primo della categoria <1800 si è classificato il catanese Giuseppe Rosolia , mentre per la categoria .<1600 la prima medaglia è stata consegnata a Roberto Arangio. Il premio della categoria <1441 va al piccolo Gabriele Miano, di 11 anni , palermitano con origini siracusane . A Daniela Verde di Ramacca il premio femminile . Il torneo è stato arbitrato , con la solita grande esperienza , dal ACN  Carlo Vella di Catania . Alla premiazione ha partecipato il delegato Provinciale di Siracusa Vincenzo Monica ed il presidente di Circoscrizione Pamela La Mesa che al termine ha dichiarato: “ da parte mia oltre al ringraziamento per aver scelto i saloni della biblioteca della circoscrizione e per la numerosa partecipazione di residenti che sono venuti ad assistere al campionato , posso dire che è stato piacevole vedere come questa disciplina riesca ad appassionare così tanti giocatori”. Pamela La Mesa conclude dicendo: “sono certa che oltre a quella svolta ci saranno ancora molte altre occasioni da promuovere tra i residenti giovani e meno giovani dell’interno quartiere”. In conclusione si può affermare che finalmente il Campionato Provinciale siracusano , rispetto alle ultime edizioni , progredisce in termini di partecipazione e di livello tecnico , ma ad onor del vero anche con l’aiuto dei cugini catanesi . Carlo Vella                                    Premiazione : da sin. V. Monica , C. Vella , S. Tondo , A. Santagati , P. La Mesa . Da sin. : S. Nobile , S. Baffo , R. Alaimo , D. Verde   Ultimo aggiornamento ( sabato 21 gennaio 2017 )   18° Campionato Provinciale di Siracusa , “Memorial Edoardo Loschi” venerdì 13 gennaio 2017 L’evento ottimamente organizzato dall’ A.S.D. Scacchistica “Paolo Boi” di Siracusa , in collaborazione con la Circoscrizione Grottasanta , ha visto la partecipazione di 28 scacchisti provenienti non solo dalla città aretusea ma anche da Catania e Palermo. Il numero dei giocatori poteva essere più interessante , se il maltempo , con la sorpresa anche di un po’ di neve , non fosse stato penalizzante . Da parte dei giocatori catanesi ci sono stati i migliori piazzamenti . Il podio infatti è stato appannaggio tutto loro .Il torneo è stato vinto dal Maestro Fide Alessandro Santagati , che concede la patta soltanto all’ultimo turno con la rivelazione del Torneo il 1N Vincenzo Daniele Gullotta  , che conquista il 3° posto . Al secondo posto il CM Fabio Imbraguglia , autore di un’ottima performance con 5 vittorie su 6 ed una sconfitta , ma molto combattuta , con il vincitore . Quarto posto e primo dei siracusani, e quindi Campione Provinciale di Siracusa 2017 , il Maestro Riccardo Alaimo , un po’ al di sotto dei suoi standard abituali . Per gli over 60 la vittoria è andata al CM Salvatore Tondo, Presidente del “ Paolo Boi “ . Primo della categoria <1800 si è classificato il catanese Giuseppe Rosolia , mentre per la categoria .<1600 la prima medaglia è stata consegnata a Roberto Arangio. Il premio della categoria <1441 va al piccolo Gabriele Miano, di 11 anni , palermitano con origini siracusane . A Daniela Verde di Ramacca il premio femminile . Il torneo è stato arbitrato , con la solita grande esperienza , dal ACN  Carlo Vella di Catania . Alla premiazione ha partecipato il delegato Provinciale di Siracusa Vincenzo Monica ed il presidente di Circoscrizione Pamela La Mesa che al termine ha dichiarato: “ da parte mia oltre al ringraziamento per aver scelto i saloni della biblioteca della circoscrizione e per la numerosa partecipazione di residenti che sono venuti ad assistere al campionato , posso dire che è stato piacevole vedere come questa disciplina riesca ad appassionare così tanti giocatori”. Pamela La Mesa conclude dicendo: “sono certa che oltre a quella svolta ci saranno ancora molte altre occasioni da promuovere tra i residenti giovani e meno giovani dell’interno quartiere”. In conclusione si può affermare che finalmente il Campionato Provinciale siracusano , rispetto alle ultime edizioni , progredisce in termini di partecipazione e di livello tecnico , ma ad onor del vero anche con l’aiuto dei cugini catanesi . Carlo Vella     Altri articoli... 21° FESTIVAL AMATORI SCACCHI CATANIA 2017 1° RAPID PLAY “ MIRABELLA IMBACCARI “ SUPER RAPID TORNEO del DISTRETTO SANTAGATI DOMINA IL 12° RAPID LIDO dei CICLOPI << Inizio < Prec. 1 2 3 4 5 6 7 8 9 10 Pross. > Fine >> Risultati 55 - 63 di 204 [Indietro] ExtCalendar Ottobre 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: 23:24 Caching: Disabled GZIP: Disabled Utenti: 88546 Notizie: 294 Collegamenti web: 17 Visitatori: 16547019

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 < '1713564550' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713564550' )
 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-20 00:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 00:24' )
 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-20 00:24' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 00:24' )
 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 54, 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-20 00:24' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-20 00:24' )
 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-20 00:24' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 00:24' )
 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 = 3
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') <= 20181001 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181001 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181001 ) ) 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') <= 20181001) 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') <= 20181002 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181002 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181002 ) ) 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') <= 20181002) 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') <= 20181003 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181003 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181003 ) ) 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') <= 20181003) 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') <= 20181004 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181004 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181004 ) ) 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') <= 20181004) 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') <= 20181005 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181005 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181005 ) ) 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') <= 20181005) 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') <= 20181006 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181006 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181006 ) ) 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') <= 20181006) 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') <= 20181007 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181007 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181007 ) ) 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') <= 20181007) 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') <= 20181008 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181008 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181008 ) ) 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') <= 20181008) 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') <= 20181009 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181009 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181009 ) ) 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') <= 20181009) 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') <= 20181010 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181010 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181010 ) ) 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') <= 20181010) 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') <= 20181011 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181011 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181011 ) ) 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') <= 20181011) 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') <= 20181012 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181012 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181012 ) ) 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') <= 20181012) 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') <= 20181013 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181013 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181013 ) ) 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') <= 20181013) 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') <= 20181014 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181014 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181014 ) ) 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') <= 20181014) 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') <= 20181015 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181015 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181015 ) ) 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') <= 20181015) 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') <= 20181016 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181016 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181016 ) ) 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') <= 20181016) 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') <= 20181017 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181017 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181017 ) ) 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') <= 20181017) 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') <= 20181018 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181018 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181018 ) ) 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') <= 20181018) 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') <= 20181019 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181019 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181019 ) ) 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') <= 20181019) 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') <= 20181020 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181020 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181020 ) ) 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') <= 20181020) 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') <= 20181021 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181021 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181021 ) ) 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') <= 20181021) 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') <= 20181022 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181022 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181022 ) ) 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') <= 20181022) 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') <= 20181023 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181023 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181023 ) ) 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') <= 20181023) 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') <= 20181024 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181024 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181024 ) ) 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') <= 20181024) 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') <= 20181025 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181025 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181025 ) ) 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') <= 20181025) 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') <= 20181026 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181026 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181026 ) ) 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') <= 20181026) 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') <= 20181027 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181027 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181027 ) ) 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') <= 20181027) 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') <= 20181028 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181028 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181028 ) ) 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') <= 20181028) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
89
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20181029 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181029 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181029 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20181029) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
91
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20181030 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181030 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181030 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20181030) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20181031 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20181031 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20181031 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20181031) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
95
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
96
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
97
SELECT COUNT( id ) AS count_users
 FROM chess_users
98
SELECT COUNT( id ) AS count_items
 FROM chess_content
99
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
100
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1