Notizie Home Collegamenti web Contattaci Libro degli ospiti Download   Fondata ed affiliata alla FSI dal 1987 Sezioni Notizie Articoli Annunci FAQ Annunci Tutti al 16° WE Amatori CT !!   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 Ultime notizie 20° RAPID LIDO AMERICA CONCLUSO IL 26° FESTIVAL AMATORI CT 26° FESTIVAL AMATORI CT 2024 Bando Campionato Provinciale di Catania 2024 L'Amatori Scacchi Catania entra a a far parte di "Catania al Vertice" Rapid Scacchi in Val di Noto Home Rapid Play Assoro (EN) venerdì 08 maggio 2009 La Società Sissa di Leonforte concede il bis ed organizza un'altro Rapid Play Sicilia, questa volta ad Assoro (EN) inserito nella Festa dello Sport del comune ennese. Arbitro A,R, Carlo Vella .Clicca di seguito per visualizzare il bando http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=84&Itemid=42  . Ultimo aggiornamento ( sabato 09 maggio 2009 )   Rapid Leonforte : vince Franco Bruno lunedì 09 marzo 2009 Si è disputato nel giorno dedicato alle donne , il Rapid Play di Leonforte.L' ottima organizzazione dell'  "Associazione Scacchistica Sissa " ha reso onore alla memoria di Felicia Schilirò ed alla Associazione Onlus " Il sorriso di Felicia " . Il Torneo è stato di buon livello qualitativo e di un buon numero di partecipanti  ( 26 ) , che poteva essere migliore se non ci fossero state contemporaneamente i giochi studenteschi ed un turno del Campionato Italiano.  Lotta serrata per il 1° posto, alla fine la spunta  per spareggio tecnico il giocatore con il 2° punteggio Elo Rapid più alto , e cioè il Valguarnerese Franco Bruno , quindi a pari punti , 7 su 8,  al secondo posto il favorito e cioè il gelese Salvo Cullè. Ha completato il podio il catanese dell' Amatori CT Giuseppe Rosolia. La direzione di gara è stata tranquilla ed il Torneo si è svolto senza problemi. Una nota particolare e curiosa è stata l' ottima convenzione per il pranzo ; i giocatori sono stati molto soddisfatti del mangiare e , cosa da non sottovalutare , con una spesa contenuta. Infine è stato siglato un' accordo tra l' Associazione locale e l' Amatori CT per l' organizzazione del Torneo dell' anno prossimo , con l'impegno di ambedue di organizzare nel 2010 un grande Rapid Play da ricordare !! Clicca di seguito per visualizzare la Classifica ed il Tabellone  http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=83&Itemid=42  . Carlo Vella. Ultimo aggiornamento ( martedì 10 marzo 2009 )   Rapid Play Leonforte giovedì 19 febbraio 2009 L' 8 Marzo tutti a Leonforte !! Si preannuncia un bel Torneo Rapid, valido per il circuito Rapid Play Sicilia. Clicca di seguito per il bando http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=82&Itemid=42 . Ultimo aggiornamento ( giovedì 19 febbraio 2009 )   Altri articoli... W.E.Amatori CT,1°Ljubisavljevic:il vecchio leone ruggisce ancora! << Inizio < Prec. 31 32 33 34 35 36 37 38 39 40 Pross. > Fine >> Risultati 157 - 160 di 175 Sondaggi Ti piace il nuovo sito del circolo? E' un ottimo sito! Bello Cos? cos Potevate fare di meglio E' davvero orribile   Se giochi a scacchi , ti interessa essere aggiornato sui Tornei e attività Amatori CT ? Si sono interessato . Invio un messaggio con il mio recapito al 335-6509575   Preferisci i Tornei Open ( unico ) oppure diviso per fasce elo ? Unico Torneo Diviso per fasce elo ( vari Open )   Syndication ExtCalendar Maggio 2021 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 Login Form Username Password Ricordami Password dimenticata? Nessun account? Registrati Statistiche OS: Linux h PHP: 5.2.17 MySQL: 5.0.96-community-log Ora: 05:41 Caching: Disabled GZIP: Disabled Utenti: 91529 Notizie: 294 Collegamenti web: 17 Visitatori: 16781832 Chi è online Abbiamo 1 visitatore online

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 = 1 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1715919981' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1715919981' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM chess_session
 WHERE session_id = 'bb46e4b8a37c3d583b0760aa1205f2db'
6
UPDATE chess_session SET `time`='1715920881',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='bb46e4b8a37c3d583b0760aa1205f2db'
7
SELECT *
 FROM chess_menu
 WHERE id = 1
8
SELECT COUNT(a.id)
 FROM chess_content AS a
 INNER JOIN chess_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 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.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 06:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 06:41' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
9
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, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM chess_content AS a
 INNER JOIN chess_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 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.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 06:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 06:41' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 156, 4
10
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
11
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'
12
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 = 1 )
 ORDER BY ordering
13
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
14
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
15
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 06:41' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-17 06:41' )
 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
16
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
17
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 06:41' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 06:41' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
18
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
20
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
21
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
22
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
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
24
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
25
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
26
SELECT a.id, a.title, a.sectionid, a.catid
 FROM chess_content AS a
 LEFT JOIN chess_content_frontpage AS f ON f.content_id = a.id
 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.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 06:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 06:41' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 6
27
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 294
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
29
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
30
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 293
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
31
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 292
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 291
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
33
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 290
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
34
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM chess_content AS i
 LEFT JOIN chess_sections AS s ON i.sectionid = s.id
 LEFT JOIN chess_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN chess_categories AS c ON i.catid = c.id
 LEFT JOIN chess_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 289
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
36
SELECT p.id, p.title
 FROM chess_polls AS p
 INNER JOIN chess_poll_menu AS pm ON  pm.pollid = p.id
 WHERE ( pm.menuid = 1 OR pm.menuid = 0 )
 AND p.published = 1
37
SELECT id
 FROM chess_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
38
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 15
 AND text != ''
 ORDER BY id
39
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 16
 AND text != ''
 ORDER BY id
40
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 20
 AND text != ''
 ORDER BY id
41
SELECT * FROM chess_extcal_config
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') <= 20210501 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210501 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210501 ) ) 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') <= 20210501) 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') <= 20210502 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210502 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210502 ) ) 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') <= 20210502) 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') <= 20210503 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210503 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210503 ) ) 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') <= 20210503) 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') <= 20210504 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210504 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210504 ) ) 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') <= 20210504) 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') <= 20210505 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210505 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210505 ) ) 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') <= 20210505) 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') <= 20210506 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210506 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210506 ) ) 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') <= 20210506) 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') <= 20210507 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210507 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210507 ) ) 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') <= 20210507) 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') <= 20210508 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210508 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210508 ) ) 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') <= 20210508) 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') <= 20210509 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210509 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210509 ) ) 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') <= 20210509) 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') <= 20210510 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210510 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210510 ) ) 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') <= 20210510) 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') <= 20210511 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210511 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210511 ) ) 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') <= 20210511) 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') <= 20210512 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210512 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210512 ) ) 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') <= 20210512) 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') <= 20210513 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210513 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210513 ) ) 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') <= 20210513) 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') <= 20210514 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210514 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210514 ) ) 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') <= 20210514) 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') <= 20210515 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210515 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210515 ) ) 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') <= 20210515) 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') <= 20210516 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210516 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210516 ) ) 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') <= 20210516) 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') <= 20210517 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210517 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210517 ) ) 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') <= 20210517) 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') <= 20210518 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210518 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210518 ) ) 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') <= 20210518) 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') <= 20210519 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210519 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210519 ) ) 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') <= 20210519) 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') <= 20210520 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210520 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210520 ) ) 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') <= 20210520) 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') <= 20210521 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210521 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210521 ) ) 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') <= 20210521) 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') <= 20210522 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210522 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210522 ) ) 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') <= 20210522) 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') <= 20210523 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210523 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210523 ) ) 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') <= 20210523) 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') <= 20210524 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210524 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210524 ) ) 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') <= 20210524) 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') <= 20210525 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210525 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210525 ) ) 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') <= 20210525) 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') <= 20210526 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210526 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210526 ) ) 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') <= 20210526) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
94
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') <= 20210527 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210527 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210527 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
95
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') <= 20210527) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
96
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') <= 20210528 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210528 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210528 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
97
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') <= 20210528) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
98
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') <= 20210529 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210529 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210529 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
99
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') <= 20210529) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
100
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') <= 20210530 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210530 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210530 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
101
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') <= 20210530) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
102
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') <= 20210531 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210531 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210531 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
103
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') <= 20210531) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
104
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
105
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
106
SELECT COUNT( id ) AS count_users
 FROM chess_users
107
SELECT COUNT( id ) AS count_items
 FROM chess_content
108
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
109
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1
110
SELECT guest, usertype
 FROM chess_session