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 L'AMATORI CT VINCE IL GIRONE UNICO DELLA PROMOZIONE SICILIA giovedì 31 marzo 2011 Quest'anno i gironi della Sicilia del CIS , Campionato Italiano a squadre , si sono svolti tutti in un week-end . in un Albergo di Campofelice Roccella (PA) . La serie Promozione  è stata unificata in un'unico Girone , e alla squadra vincitrice , l'Amatori Scacchi Catania , è stato assegnato il titolo di Campione Regionale di Club a squadre . La Società ringrazia i giocatori che hanno contribuito al risultato : FURNARI FRANCESCO, VELLA CARLO, BARTA ANNAMARIA, GIUFFRIDA IGNAZIO, BATTAGLIA GIUSEPPE e CARMENI GIOVANNI . Carlo Vella. Ultimo aggiornamento ( giovedì 31 marzo 2011 )   GSS Provinciale di CATANIA venerdì 04 marzo 2011 Tutto OK al GSS Provinciale di Catania. I timori della vigilia del Comitato Provinciale , per l'alto numero di squadre partecipanti , 34 con 200  giocatori circa , sono stati fugati da un'organizzazione snella e veloce , frutto dell'esperienza di più di 20 anni , dei componenti del Comitato Mario Bongiorno e Carlo Vella , che pur avendo avuto pochi giorni a disposizione hanno eseguito tutto nel migliore dei modi . Ottima si è rivelata la scelta della scuola Media " Leonardo da Vinci " di Mascalucia, che avendo grandi spazi a disposizione ,  parcheggio corridoi ecc.ecc. , si è prestata alla notevole affluenza delle squadre . Clicca di seguito per visualizzare le Classifiche ed i Tabelloni .  http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=106&Itemid=42  . Clicca per una foto del GSS : http://www.amatoriscacchicatania.com/images//img_0944.jpg    Carlo Vella . Ultimo aggiornamento ( sabato 12 marzo 2011 )   SUCCESSO DEL 15° FESTIVAL AMATORI SCACCHI CATANIA 2011 martedì 01 marzo 2011 La 15a edizione del WE Amatori CT si è svolta nella bella Villa Buscemi del Comune di Mascalucia , per il terzo anno di seguito. Il dato che risalta è l'incremento dei partecipanti nell'Open A , addirittura raddoppiati . Mentre nell'Open B si registra un numero di giocatori stabile rispetto agli altri anni , nell'Open C , dedicato agli inclassificati , c'è stato un decremento , dovuto forse alla diminuita attività nelle scuole . Molto combattuto l'Open A , che ha visto prevalere il Maestro Internazionale Serbo Zijvojn LJUBISAVLJEVIC sui catanesi CM Alessandro SANTAGATI  e Maestro Fide Giuseppe FABIANO , il primo giovane rivelazione , ed il secondo veterano dei Tornei da molti anni . Nell'Open B prevale lo svizzero-adranese Nicolò ALBERIO sul siracusano Giuseppe POCCHI e sul catanese Roberto CONDORELLI . La nota positiva è la prestazione del giovanissimo Riccardo MARZADURI che a sorpresa si piazza al 4° posto.L'Open C vede la vittoria del giovane Vittorio CIPRIA sul messicano Ricardo SANCHEZ e sul catanese Domenico PRIOLO .  Chiude il Torneo la Premiazione con il discorso dell'organizzatore - Arbitro Carlo VELLA che dando appuntamento all'anno prossimo promette un'edizione ancora più ricca e importante . Per visualizzare le Classifiche dei 3 Open clicca di seguito http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=105&Itemid=42  Ultimo aggiornamento ( giovedì 04 aprile 2013 )   4° TURNO 15° FESTIVAL W.E. AMATORI CT 2011 martedì 15 febbraio 2011 Clicca di seguito per visualizzare gli accoppiamenti del 4° Turno , con riserva di modifiche in caso di ritiri , le  Classifiche e le previsioni della variazioni Elo. http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=104&Itemid=42  .   Ultimo aggiornamento ( martedì 15 febbraio 2011 )   15° FESTIVAL AMATORI SCACCHI CATANIA 2011 domenica 16 gennaio 2011 15° FESTIVAL W.E. AMATORI CT 2011 Mascalucia (CT) 12, 13, 19 e 20 Febbraio 2011 Via del Bosco N° 19 - Villa Buscemi , Delegazione Comunale di Massannunziata - Mascalucia (CT) Arrivato alla 15 a edizione , il Festival W.E. dell' Amatori Scacchi Catania, è un' appuntamento storico degli Scacchi in Sicilia. L' appuntamento per tutti gli appassionati è quindi per Sabato 12 Febbraio , chiusura iscrizioni ore 15,00. Per chi si volesse pre-iscrivere , si può inserire il proprio nominativo in uno dei tre Tornei ( A, B, o C ) sul sito VeSuS - Benvenuto in VeSuS!!!   oppure si può inviare una mail a  Indirizzo e-mail protetto dal bots spam , deve abilitare Javascript per vederlo   . Ricordo la suddivisione dei tre Tornei :   OPEN  “ A “ : Per giocatori con ELO Italia o FIDE > 1699 al 01/01/11. Sistema Svizzero, 6 turni, tempo di riflessione 2 h  per finire. OPEN  “ B “ : Per giocatori con ELO Italia  da 1500 a 1799 al 01-01-11.Sistema Svizzero, 6 turni, tempo di riflessione 2 h  per finire. OPEN  “ C “ : Per i giocatori con ELO Italia < 1500 al 01-01-11. Sistema Svizzero, 6 Turni, tempo di riflessione 2 h per finire. N.B. : i giocatori che hanno un punteggio elo tra 1700 e 1799 possono scegliere di partecipare all’Open “A” o all’Open “B”.   L'iscrizione è valida solo se è confermata in sede di Torneo oppure con telefonata nella mattinata di Sabato 12 . Per visualizzare il bando completo clicca di seguito : http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=103&Itemid=42   Saluti,  Carlo Vella ,   Presidente A.D. Amatori Scacchi Catania . Tel. 335-6509575 ,  e-mail : Indirizzo e-mail protetto dal bots spam , deve abilitare Javascript per vederlo Ultimo aggiornamento ( giovedì 20 gennaio 2011 )   Altri articoli... CAMPIONATO PROVINCIALE di CATANIA 2011 RASSEGNA DEL GIOCO - ETNAPOLIS RAPID LIDO dei CICLOPI 2010 SUPER RAPID LEONFORTE:QUANDO VINCE LA SOLIDARIETA' << Inizio < Prec. 11 12 13 14 15 16 17 18 19 20 Pross. > Fine >> Risultati 127 - 135 di 204 [Indietro] ExtCalendar Ottobre 2017 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: 15:00 Caching: Disabled GZIP: Disabled Utenti: 88628 Notizie: 294 Collegamenti web: 17 Visitatori: 16552499

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 < '1713620748' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713620748' )
 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 16:00' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 16:00' )
 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 16:00' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 16:00' )
 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 126, 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 16:00' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-20 16:00' )
 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 16:00' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-20 16:00' )
 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 = 1
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') <= 20171001 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171001 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171001 ) ) 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') <= 20171001) 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') <= 20171002 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171002 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171002 ) ) 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') <= 20171002) 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') <= 20171003 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171003 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171003 ) ) 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') <= 20171003) 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') <= 20171004 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171004 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171004 ) ) 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') <= 20171004) 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') <= 20171005 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171005 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171005 ) ) 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') <= 20171005) 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') <= 20171006 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171006 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171006 ) ) 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') <= 20171006) 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') <= 20171007 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171007 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171007 ) ) 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') <= 20171007) 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') <= 20171008 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171008 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171008 ) ) 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') <= 20171008) 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') <= 20171009 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171009 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171009 ) ) 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') <= 20171009) 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') <= 20171010 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171010 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171010 ) ) 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') <= 20171010) 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') <= 20171011 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171011 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171011 ) ) 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') <= 20171011) 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') <= 20171012 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171012 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171012 ) ) 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') <= 20171012) 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') <= 20171013 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171013 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171013 ) ) 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') <= 20171013) 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') <= 20171014 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171014 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171014 ) ) 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') <= 20171014) 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') <= 20171015 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171015 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171015 ) ) 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') <= 20171015) 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') <= 20171016 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171016 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171016 ) ) 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') <= 20171016) 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') <= 20171017 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171017 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171017 ) ) 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') <= 20171017) 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') <= 20171018 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171018 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171018 ) ) 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') <= 20171018) 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') <= 20171019 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171019 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171019 ) ) 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') <= 20171019) 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') <= 20171020 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171020 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171020 ) ) 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') <= 20171020) 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') <= 20171021 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171021 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171021 ) ) 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') <= 20171021) 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') <= 20171022 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171022 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171022 ) ) 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') <= 20171022) 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') <= 20171023 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171023 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171023 ) ) 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') <= 20171023) 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') <= 20171024 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171024 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171024 ) ) 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') <= 20171024) 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') <= 20171025 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171025 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171025 ) ) 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') <= 20171025) 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') <= 20171026 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171026 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171026 ) ) 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') <= 20171026) 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') <= 20171027 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171027 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171027 ) ) 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') <= 20171027) 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') <= 20171028 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171028 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171028 ) ) 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') <= 20171028) 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') <= 20171029 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171029 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171029 ) ) 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') <= 20171029) 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') <= 20171030 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171030 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171030 ) ) 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') <= 20171030) 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') <= 20171031 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171031 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171031 ) ) 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') <= 20171031) 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