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 RIVINCITA di SANTAGATI al 10° " RAPID LIDO dei CICLOPI " lunedì 01 settembre 2014 La decima edizione del Rapid " Lido dei Ciclopi " , organizzata dall'Amatori Scacchi Catania , con una  partecipazione più che soddisfacente , 43 giocatori fra i 2 Open ,  è stata caratterizzata da un livello qualitativo molto alto ,infatti fra i partecipanti si registravano 3 Maestri , 8 Candidati Maestri e 9 Prime Nazionali .Il torneo è stato molto combattuto e la prova è nel fatto che le prime 5 posizioni hanno chiuso a pari punti ((6) . Di seguito appunto i primi 5 classificati : il Maestro Alessandro Santagati vincitore , che si prende la rivincita sui risultati non eccezionali degli ultimi Rapid . il simpatico venticinquenne Lettone Nikolajs Kovsuns , vera sorpresa del Torneo , la giovane e bella palermitana Laura Gueci , di recente diventata un po' catanese ........., il Maestro siracusano Gabriele Sardo ed il vincitore del Rapid " Lido America " Riccardo Marzaduri ,che comunque non sfigura giocando partite molto aggressive . Da menzionare anche il CM Fabio Imbraguglia a solo mezzo punto dai primi 5 . I premi di categoria , 1N 2N 3N NC sono andati al messinese Davide Gelardi , al veterano ma ancora giovane Sebastiano La Rosa ,al socio Amatori CT Giovanni Giustolisi , al giovane ennese Filippo Mirci ed infine all' Under 16 Leonardo Bolognese . Nell' Open B ha vinto Giovanni Di Pino ed al 2° e 3° posto si sono classificati Sebastiano Bottino ed Angelo Amato .      Carlo Vella Per la classifica e i dati del Rapid clicca di seguito:  http://vesus.org/results/10deg-rapid-lido-dei-ciclopi-2014/              La sfida dei primi 2 classificati       Tutti i premiati   Ultimo aggiornamento ( martedì 02 settembre 2014 )   10° RAPID LIDO dei CICLOPI domenica 03 agosto 2014 La tradizione continua !!! Rapid Play ITALIA 2014 Campionato Rapid Sicilia 10°  RAPID PLAY  LIDO DEI CICLOPI ACI TREZZA   DOMENICA  31 AGOSTO 2014                                                                               MONTEPREMI OPEN A e B  contanti + valore premi = € 350 * OPEN A * PER TESSERATI F.S.I. = RAPID ITALIA valido x variazione elo ITALIA e Classifica Rapid Play Sicilia 2014 * OPEN B * PER NON TESSERATI  F.S.I. = Torneo Rapid FREE   Per visualizzare il bando completo e per le preiscrizioni clicca di seguito : http://vesus.org/tournaments/10deg-rapid-lido-dei-ciclopi-2014/    Saluti , Carlo Vella  , Tel. 335-6509575 Ultimo aggiornamento ( domenica 03 agosto 2014 )   10° RAPID LIDO AMERICA : BIS di RICCARDO MARZADURI martedì 17 giugno 2014 Nonostante la Nazionale in notturna , con la partita mondiale terminata alle 2 del mattino , ed il meteo che prevedeva la pioggia  , la partecipazione dei due Open , 28 in totale , è stata soddisfacente . Evidentemente la passione e la voglia di giocare supera molti ostacoli . Il torneo è stato molto avvincente con un ottimo livello qualitativo . Vince per la seconda volta consecutiva il giovane under 16 Riccardo Marzaduri , seguito dal sempre temibile Fabio Imbraguglia . Il podio è completato da Alessandro Santagati a pari punti con Gaetano Signorelli ,ormai diventato una certezza . I premi di categoria sono andati a Carlo Cannella (1N) , Daniele Leonardi (2N) , Giovanni Giustolisi (3N) e Filippo Mirci (NC). Nell'Open B , aperto anche ai non tesserati FSI , della serie " ti piace vincere facile " , si imponeva a punteggio pieno Franco Bruno , seguito da Lucio Contarino , Salvo Lombardo e  Sebastiano Bottino , tutti a 5 punti . Ah , dimenticavo . La pioggia è arrivata puntualmente , ma fortunatamente la copertura ha tenuto ed i giocatori sono rimasti quasi tutti asciutti !! Clicca di seguito per i dati dell'Open A  http://vesus.org/results/open-a-rapid-italia-10deg-rapid-lido-america/  Carlo Vella     Ultimo aggiornamento ( martedì 17 giugno 2014 )   ANTICIPATO al 15 GIUGNO il RAPID LIDO AMERICA sabato 31 maggio 2014 10° RAPID PLAY “ LIDO AMERICA “   ANTICIPATA a Domenica 15 GIUGNO la DATA Per il decimo anno consecutivo si svolgerà il Rapid Play " Lido America " , quest’anno valido come Rapid Play Italia 2014 e Classifica Rapid Sicilia . Organizzazione “ Amatori Scacchi Catania “ Appuntamento per Domenica 15 Giugno nel bellissimo Lido della Playa di Catania . Chiusura iscrizioni ore 10,00 . ENTRATA GRATIS PER UN’ ACCOMPAGNATORE + eventuali bambini . Clicca di seguito per preiscrizioni e per visualizzare il bando completo  :  Preiscrizioni =  http://vesus.org/festivals/10deg-rapid-lido-america/    Bando =  http://vesus.org/files/fliers/10deg-rapid-lido-america_15-06-2014.pdf  Ultimo aggiornamento ( sabato 31 maggio 2014 )   46° CIS : l'Amatori A promosso in serie B mercoledì 26 marzo 2014 Il Concentramento Siciliano del 46° CIS , che si èsvolto a Petrosino (TP) , si è concluso per le 2 squadre di Serie " C " dell'Amatori CT con un dolce amaro . La formazione A , composta da Ignazio Giuffrida , Giuseppe Rosolia , Franco Furnari e Salvatore Zuccarotto con un'ottima performance si è piazzata al 3°posto , conquistando la Promozione in serie " B " , per la seconda volta nella storia della Società . Purtroppo la formazione B , neo promossa , ottenendo solo 2 punti , ma sprecando molto , retrocede in serie Promozione . L'anno prossimo avrà l'occasione per tornare nella serie superiore , sfruttando l'ottimo potenziale . La Presidenza ringrazia i componenti di ambedue le squadre per l'impegno profuso .  Carlo Vella Ultimo aggiornamento ( mercoledì 26 marzo 2014 )   Altri articoli... MUSICAL " ULTIMA MOSSA " 18° WE AMATORI CT : IL FESTIVAL DELLE SORPRESE !! 18° FESTIVAL AMATORI CT : ANCORA NOVITA’ !!! RAPID PERGUSA-ENNA << Inizio < Prec. 11 12 13 14 15 16 17 18 19 20 Pross. > Fine >> Risultati 91 - 99 di 204 [Indietro] ExtCalendar Marzo 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: 06:58 Caching: Disabled GZIP: Disabled Utenti: 88494 Notizie: 294 Collegamenti web: 17 Visitatori: 16541920

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 < '1713505426' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713505426' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
6
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
7
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
8
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
9
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'com'
 AND type = 2
10
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
11
SELECT *
 FROM chess_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com_content&task=blogsection%'
12
SELECT COUNT(a.id)
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_sections AS s ON a.sectionid = s.id
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 07:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:58' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
13
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_sections AS s ON a.sectionid = s.id
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 07:58' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:58' )
 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 90, 9
14
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT a.*
 FROM chess_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
16
SELECT id, title, module, position, content, showtitle, params
 FROM chess_modules AS m
 INNER JOIN chess_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 99999999 )
 ORDER BY ordering
17
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
18
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
19
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM chess_sections as a
 LEFT JOIN chess_content as b ON a.id = b.sectionid
 AND b.access <= 0
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-04-19 07:58' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-19 07:58' )
 WHERE a.scope = 'content'
 AND a.published = 1
 AND a.access <= 0
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 5
20
SELECT m.id AS Itemid, m.componentid AS sectionid
 FROM chess_menu AS m
 WHERE ( m.type = 'content_section' OR m.type = 'content_blog_section' )
 AND m.published = 1
 AND m.access <= 0
 AND ( m.componentid=1 OR m.componentid=4 OR m.componentid=2 OR m.componentid=3 OR m.componentid=0 )
 ORDER BY m.type DESC, m.id DESC
21
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 07:58' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 07:58' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
22
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
24
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
25
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
26
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
27
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
 FROM chess_content
 WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
 GROUP BY created_year DESC, created_month DESC
LIMIT 10
28
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
29
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
30
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
31
SELECT * FROM chess_extcal_config
32
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180301 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180301 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180301 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
33
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180301) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
34
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180302 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180302 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180302 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
35
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180302) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
36
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180303 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180303 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180303 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
37
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180303) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
38
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180304 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180304 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180304 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
39
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180304) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
40
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180305 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180305 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180305 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
41
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180305) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
42
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180306 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180306 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180306 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
43
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180306) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
44
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180307 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180307 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180307 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
45
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180307) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
46
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180308 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180308 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180308 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
47
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180308) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
48
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180309 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180309 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180309 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
49
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180309) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
50
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180310 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180310 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180310 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
51
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180310) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
52
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180311 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180311 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180311 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
53
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180311) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
54
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180312 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180312 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180312 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
55
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180312) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
56
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180313 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180313 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180313 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
57
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180313) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
58
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180314 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
59
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180314) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
60
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180315 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
61
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180315) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
62
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180316 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
63
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180316) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
64
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180317 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
65
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180317) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
66
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180318 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
67
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180318) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
68
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180319 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
69
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180319) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
70
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180320 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
71
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180320) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
72
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180321 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180321 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180321 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
73
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180321) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
74
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180322 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180322 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180322 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
75
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180322) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
76
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180323 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180323 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180323 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
77
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180323) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
78
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180324 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180324 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180324 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
79
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180324) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
80
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180325 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180325 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180325 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
81
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180325) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
82
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180326 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180326 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180326 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
83
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180326) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
84
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180327 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180327 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180327 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
85
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180327) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
86
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180328 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180328 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180328 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
87
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180328) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
88
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180329 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180329 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180329 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
89
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180329) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
90
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180330 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180330 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180330 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
91
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180330) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
92
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180331 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180331 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180331 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
93
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180331) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
94
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
95
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
96
SELECT COUNT( id ) AS count_users
 FROM chess_users
97
SELECT COUNT( id ) AS count_items
 FROM chess_content
98
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
99
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1