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 Home IL MAESTRO SARDO SI AGGIUDICA IL RAPID LIDO AMERICA venerdì 19 giugno 2009 Rispettando il pronostico , il Maestro siracusano Gabriele Sardo , con 7 punti su 8, si aggiudica il 5° Rapid Lido America 2009. La partecipazione di 43 giocatori , è stata giudicata ottima dagli organizzatori e dallo sponsor " Asimmetrico " , che ha messo a disposizione ben 16 elettrodomestici che si sono aggiunti ai premi già previsti . Ad un punto di distanza si sono classificati 4 giocatori , ma per spareggio tecnico si aggiudicano il 2° ed il  3° posto Fabio Imbraguglia ed Alessandro Santagati, reduci dalla promozione in Serie A2 con la squadra dell'Accademia Catanese. Al 4° posto la sorpresa del Torneo il giovane Franco Furnari , che pareggiando l'ultimo turno con il vincitore chiude a 6 punti insieme a Salvatore Gangemi, che a sorpresa perde al 1° turno con il Leonfortese Carmelo Falconieri, che si segnala per i forti progressi negli ultimi tornei. La delusione arriva da Fabrizio Bonaccorsi che si classifica al 13° posto, quindi molto al di sotto delle sue possibilità. Si aggiudicano i premi di fascia C e D , Francesco Furnari padre, Giuseppe Rosolia, Giuseppe Battaglia e Carmelo Falconieri. Post Premiazione molto movimentato , a causa del sorteggio di altri elettrodomestici , sempre omaggiati dallo sponsor   " Asimmetrico " , negozio d'arredamento in Via Umberto N° 209 Catania. In conclusione si può affermare che i due Tornei Estivi della costa Catanese , organizzati dall' Amatori CT, sono ormai una garanzia di successo e divertimento. Arrivederci ad Aci Trezza il 30 Agosto con il Rapid " Lido dei Ciclopi " . Ad inizio Torneo si è voluto ricordare l'amico Enzo Crea , scomparso recentemente, che ha arbitrato i primi Tornei , negli anni 90' , dell' Amatori Scacchi Catania, e che quindi ha fatto parte anche lui della storia della Società catanese. Clicca di seguito per visualizzare la Classifica http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=87&Itemid=42  . Carlo Vella. Tutti i premiati              Panoramica della sede di gioco Ultimo aggiornamento ( domenica 21 giugno 2009 )   < Prec.   Pros. > [Indietro] ExtCalendar Agosto 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: 04:51 Caching: Disabled GZIP: Disabled Utenti: 91529 Notizie: 294 Collegamenti web: 17 Visitatori: 16781571

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 = 2 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1715916959' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1715916959' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM chess_session
 WHERE session_id = '6c06c63c7ff03171ab6a1d0fa4e6bdb8'
6
UPDATE chess_session SET `time`='1715917859',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='6c06c63c7ff03171ab6a1d0fa4e6bdb8'
7
SELECT *
 FROM chess_menu
 WHERE id = 2
8
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM chess_content AS a
 LEFT JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.id = 123 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 05:50' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 05:50' )
 AND a.access <= 0
9
SELECT a.id
 FROM chess_content AS a
 WHERE a.catid = 27
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 05:50' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 05:50' )
 ORDER BY a.ordering
10
UPDATE chess_content
 SET hits = ( hits + 1 )
 WHERE id = '123'
11
SELECT hits
 FROM chess_core_log_items
 WHERE time_stamp = '2024-05-17'
 AND item_table = '#__content'
 AND item_id = '123'
12
UPDATE chess_core_log_items
 SET hits = ( hits + 1 )
 WHERE time_stamp = '2024-05-17'
 AND item_table = '#__content'
 AND item_id = '123'
13
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
14
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'
15
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 = 2 )
 ORDER BY ordering
16
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
17
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
18
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-05-17 05:50' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-17 05:50' )
 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
19
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
20
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-05-17 05:50' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 05:50' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
21
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
22
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
23
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
24
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
25
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
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
27
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
28
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
29
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
30
SELECT * FROM chess_extcal_config
31
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') <= 20170801 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170801 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170801 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
32
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') <= 20170801) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20170802 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170802 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170802 ) ) 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') <= 20170802) 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') <= 20170803 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170803 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170803 ) ) 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') <= 20170803) 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') <= 20170804 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170804 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170804 ) ) 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') <= 20170804) 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') <= 20170805 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170805 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170805 ) ) 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') <= 20170805) 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') <= 20170806 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170806 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170806 ) ) 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') <= 20170806) 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') <= 20170807 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170807 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170807 ) ) 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') <= 20170807) 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') <= 20170808 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170808 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170808 ) ) 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') <= 20170808) 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') <= 20170809 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170809 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170809 ) ) 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') <= 20170809) 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') <= 20170810 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170810 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170810 ) ) 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') <= 20170810) 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') <= 20170811 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170811 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170811 ) ) 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') <= 20170811) 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') <= 20170812 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170812 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170812 ) ) 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') <= 20170812) 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') <= 20170813 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170813 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170813 ) ) 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') <= 20170813) 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') <= 20170814 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170814 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170814 ) ) 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') <= 20170814) 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') <= 20170815 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170815 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170815 ) ) 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') <= 20170815) 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') <= 20170816 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170816 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170816 ) ) 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') <= 20170816) 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') <= 20170817 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170817 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170817 ) ) 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') <= 20170817) 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') <= 20170818 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170818 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170818 ) ) 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') <= 20170818) 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') <= 20170819 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170819 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170819 ) ) 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') <= 20170819) 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') <= 20170820 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170820 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170820 ) ) 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') <= 20170820) 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') <= 20170821 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170821 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170821 ) ) 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') <= 20170821) 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') <= 20170822 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170822 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170822 ) ) 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') <= 20170822) 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') <= 20170823 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170823 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170823 ) ) 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') <= 20170823) 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') <= 20170824 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170824 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170824 ) ) 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') <= 20170824) 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') <= 20170825 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170825 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170825 ) ) 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') <= 20170825) 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') <= 20170826 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170826 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170826 ) ) 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') <= 20170826) 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') <= 20170827 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170827 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170827 ) ) 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') <= 20170827) 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') <= 20170828 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170828 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170828 ) ) 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') <= 20170828) 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') <= 20170829 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170829 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170829 ) ) 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') <= 20170829) 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') <= 20170830 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170830 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170830 ) ) 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') <= 20170830) 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') <= 20170831 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20170831 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20170831 ) ) 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') <= 20170831) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
94
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
95
SELECT COUNT( id ) AS count_users
 FROM chess_users
96
SELECT COUNT( id ) AS count_items
 FROM chess_content
97
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
98
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1