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 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 Maestro Int.le LJUBISAVLJEVIC , ANCORA TU !!! martedì 19 febbraio 2013 Per la terza volta consecutiva il Maestro Internazionale serbo LJUBISAVLJEVIC si aggiudica il Torneo Festival Internazionale di Scacchi di Mascalucia , organizzato dall’Amatori Scacchi Catania . Il Torneo , arrivato alla 17 a edizione , è diventato un’ appuntamento tradizionale degli scacchi in Sicilia . Da sette anni ha come sede Mascalucia e da cinque l' originale e bellissima Villa Buscemi , concessa dal Comune della cittadine etnea . Nell’Open Principale l’andamento è risultato molto avvincente , con l’ exploit iniziale del Maestro Fide catanese Giuseppe Fabiano che con le prime tre vittorie aveva fatto sperare che finalmente il Torneo se lo aggiudicasse un indigeno . Invece nel secondo week-end il Maestro Int.le serbo imponeva la sua tecnica superiore , collaudata da decenni di esperienza ed il Maestro Fabiano crollava perdendo al 4° e 5° turno . Al 6° turno , evidentemente scoraggiato , non si presentava , completando la debacle . Da segnalare la performance del giovane catanese Riccardo Marzaduri ,che si aggiudica il terzo posto , grazie ad una vittoria spettacolare all’ultimo turno sul Maestro palermitano Girolamo Valguarnera . Ottimo secondo posto , raggiunto con prestazioni regolari , del veterano CM Salvatore Gangemi . Nell’Open Secondario due super frequentatori di Tornei  , si trovano appaiati al primo posto con gli stessi punti , il catanese Giuseppe Rosolia ed il siracusano Stefano Nobile . La spunta il catanese per spareggio tecnico , ma bisogna dire meritatamente , essendosi aggiudicato lo scontro diretto . La terza posizione è appannaggio di Salvatore Zuccarotto  , che si può vantare di aver battuto il vincitore Rosolia . L’Open Terziario si è caratterizzato dalla parte alta della classifica composta prevalentemente da giovani . Infatti troviamo nei primi posti , due giovani dell’ Amatori Catania in grande ascesa , Angelo Caponnetto e Gabriele Arena , rispettivamente primo e secondo . Completa il podio Vincenzo Scardamaglia . Complessivamente l’organizzazione è rimasta soddisfatta sia della partecipazione che dell’andamento del Torneo e rimanda tutti gli scacchisti siciliani all’appuntamento dell’evento scacchistico più importante dell’anno in Sicilia : il Concentramento del Campionato italiano a squadre , che l’Amatori Scacchi Catania , Società storica degli Scacchi in Sicilia , fondata ed affiliata alla FSI da 25 anni , ha l’onore di organizzare .Le gare si disputeranno i giorni 15 , 16 e 17 Marzo presso il President Park Hotel di Acicastello ( CT )  e si prevede la partecipazione di 50 squadre con 200 giocatori . Carlo Vella                Clicca di seguito (leggi tutto) per le Classifiche 17° TORNEO WE di SCACCHI AMATORI SCACCHI CATANIA 2013 MASCALUCIA (CT) (09/02/2013, 17/02/2013)   OPEN A Classifica Finale   Pos Pts ID Ctg NAME Rtg Fed   Buc1    BucT    BucM  1  5.0 1 IM LJUBASAVLEVIC ZJIO 2247 SER    19.5    22.5    15.0 2  4.5 4 CM GANGEMI SALVATORE 2066 ITA    17.5    19.5    13.0 3  4.5 8 1N MARZADURI RICCARDO 1876 ITA    17.0    19.0    12.5 4  4.0 3 M VALGUARNERA GIROLA 2070 ITA    19.5    20.0    15.0 5  4.0 11 1N FURNARI FRANCESCO 1838 ITA    17.0    17.5    12.5 6  3.5 5 CM PISACANE PIETRO 2035 ITA    17.5    20.0    13.0 7  3.0 2 FM FABIANO GIUSEPPE 2117 ITA    18.5    20.5    14.0 8  3.0 12 2N GELARDI DAVIDE 1784 ITA    15.5    17.5    11.0 9  3.0 13 1N SPINA SIMONPIETRO 1761 ITA    15.5    16.0    11.0 10  3.0 9 1N MARZADURI MARCO 1869 ITA    14.0    15.5    10.5 11  2.5 15 1N SILECI SALVATORE 1724 ITA    15.5    16.0    11.5 12  2.5 14 2N FERRERI DANIELE 1753 ITA    13.5    14.0    10.0 13  2.5 6 1N ZARBA CALOGERO 1895 ITA    12.5    14.5    10.0 14  2.0 7 1N SIGNORELLI GAETANO 1886 ITA    17.5    20.0    13.0 15  1.0 10 1N CONTI SILVANO 1847 ITA    14.5    16.0    10.5   OPEN B Classifica Finale   Pos Pts ID Ctg NAME Rtg Fed   Buc1    BucT    BucM  1  5.0 1 1N ROSOLIA GIUSEPPE 1796 ITA    20.0    21.5    15.0 2  5.0 2 1N NOBILE STEFANO 1790 ITA    18.5    20.0    13.5 3  4.5 7 1N ZUCCAROTTO SALVATO 1706 ITA    20.5    23.5    15.5 4  4.0 6 2N CAMPANELLA ALESSAN 1713 ITA    18.0    20.5    13.5 5  4.0 3 2N FRESTA SALVATORE 1754 ITA    18.0    20.5    13.0 6  4.0 10 2N ANNINO VINCENZO 1623 ITA    16.5    17.0    11.5 7  3.5 18 3N MANNINO FABIO 1551 ITA    19.0    22.0    14.0 8  3.5 24 3N PALADINO ANTONIO 1500 ITA    16.5    19.0    12.0 9  3.5 11 2N FICUCCIO DANTE 1616 ITA    13.5    14.0     9.5 10  3.0 4 2N CALI' PAOLO 1747 ITA    18.5    20.0    14.0 11  3.0 26 NC GIUSTOLISI GIOVANN 1470 ITA    17.5    19.0    12.5 12  3.0 5 1N RUSSO CARMELO 1715 ITA    16.5    18.0    12.5 13  3.0 12 2N IUVARA DARIO 1614 ITA    16.0    18.5    12.0 14  3.0 9 2N LA FRANCA VINCENZO 1629 ITA    15.5    18.0    12.0 15  3.0 22 3N TIRENNA FRANCESCO 1504 ITA    15.5    17.0    11.0 16  3.0 8 2N CONDORELLI ROBERTO 1706 ITA    14.5    16.0     9.5 17  3.0 16 2N GIUFFRIDA FRANCESC 1584 ITA    13.0    13.5     8.0 18  2.5 20 2N COSTA SALVATORE 1532 ITA    16.5    19.0    13.0 19  2.5 13 2N BATTAGLIA GIUSEPPE 1613 ITA    15.0    16.5    11.5 20  2.5 19 3N PRIOLO DOMENICO 1533 ITA    13.5    14.0    10.0 21  2.0 15 3N MURLI PAOLO 1587 ITA    15.0    16.0    10.0 22  2.0 28 3N CHITE' CARMELO   (W) 1569 ITA    15.0    15.5    11.0 23  2.0 27 2N SILECI ANTONINO 1406 ITA    14.5    16.5    11.0 24  2.0 23 3N FINOCCHIARO DANTE 1500 ITA    14.5    16.0    10.5 25  1.5 14 3N MANGIAGLI SALVATOR 1595 ITA    18.0    20.5    13.0 26  1.0 25 3N FERRARELLO FRANCES 1485 ITA    16.0    17.5    12.0 27  1.0 21 3N DAGNINO MARCELLO (W) 1528 ITA    14.5    16.0    10.5 28  0.0 17 2N CONSENTINO GIUSEP(W) 1577 ITA    12.5    13.5     9.0   OPEN C Classifica Finale   Pos Pts ID Ctg NAME Rtg Fed   Buc1    BucT    BucM  1  5.0 3 NC CAPONNETTO ANGELO 1449 ITA    18.0    20.0    14.0 2  4.0 1 NC ARENA GABRIELE 1476 ITA    19.5    22.5    15.0 3  4.0 2 3N SCARDAMAGLIA VINCE 1467 ITA    18.5    20.0    14.0 4  4.0 4 NC COMPAGNONE MICHELE 1443 ITA    17.5    19.5    13.5 5  3.5 5 NC BRANCATO ANTONIO 1440 ITA    17.5    18.5    13.0 6  3.0 10 3N BOTTINO SEBASTIANO 1394 ITA    15.0    16.0    10.5 7  3.0 7 NC MESSINA LUCIANO 1428 ITA    13.5    14.5     9.5 8  2.5 9 NC CANNAVO' MICHELE (W) 1413 ITA    17.5    18.5    13.0 9  2.5 12 NC BARBAGALLO FRANCO 1353 ITA    16.0    17.0    11.5 10  2.5 11 NC FRANCESCHINO LUCA 1386 ITA    14.5    15.5    10.5 11  1.0 6 NC CIARAMELLA CARMELO 1440 ITA    14.5    16.5    11.0 12  0.0 8 NC GULINO ROSARIO   (W) 1419 ITA    13.5    14.5     9.5 Ultimo aggiornamento ( venerdì 22 febbraio 2013 )   < Prec.   Pros. > [Indietro] 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 Dicembre 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 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: 20:07 Caching: Disabled GZIP: Disabled Utenti: 88540 Notizie: 294 Collegamenti web: 17 Visitatori: 16546104 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 < '1713552774' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713552774' )
 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 id = 1
12
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 = 176 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 21:07' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:07' )
 AND a.access <= 0
13
SELECT a.id
 FROM chess_content AS a
 WHERE a.catid = 28
 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-04-19 21:07' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:07' )
 ORDER BY a.ordering
14
UPDATE chess_content
 SET hits = ( hits + 1 )
 WHERE id = '176'
15
SELECT hits
 FROM chess_core_log_items
 WHERE time_stamp = '2024-04-19'
 AND item_table = '#__content'
 AND item_id = '176'
16
UPDATE chess_core_log_items
 SET hits = ( hits + 1 )
 WHERE time_stamp = '2024-04-19'
 AND item_table = '#__content'
 AND item_id = '176'
17
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
18
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'
19
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
20
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
21
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
22
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 21:07' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-19 21:07' )
 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
23
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
24
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 21:07' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:07' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
25
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
27
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
28
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
29
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
30
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
31
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
32
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 1
33
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-04-19 21:07' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 21:07' )
 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
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 = 294
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
35
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
36
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
37
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
38
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
39
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
40
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
41
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
42
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
43
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
44
SELECT id
 FROM chess_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
45
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 15
 AND text != ''
 ORDER BY id
46
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 16
 AND text != ''
 ORDER BY id
47
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 20
 AND text != ''
 ORDER BY id
48
SELECT * FROM chess_extcal_config
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') <= 20171201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171201 ) ) 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') <= 20171201) 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') <= 20171202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171202 ) ) 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') <= 20171202) 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') <= 20171203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171203 ) ) 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') <= 20171203) 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') <= 20171204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171204 ) ) 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') <= 20171204) 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') <= 20171205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171205 ) ) 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') <= 20171205) 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') <= 20171206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171206 ) ) 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') <= 20171206) 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') <= 20171207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171207 ) ) 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') <= 20171207) 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') <= 20171208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171208 ) ) 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') <= 20171208) 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') <= 20171209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171209 ) ) 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') <= 20171209) 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') <= 20171210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171210 ) ) 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') <= 20171210) 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') <= 20171211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171211 ) ) 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') <= 20171211) 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') <= 20171212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171212 ) ) 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') <= 20171212) 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') <= 20171213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171213 ) ) 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') <= 20171213) 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') <= 20171214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171214 ) ) 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') <= 20171214) 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') <= 20171215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171215 ) ) 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') <= 20171215) 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') <= 20171216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171216 ) ) 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') <= 20171216) 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') <= 20171217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171217 ) ) 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') <= 20171217) 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') <= 20171218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171218 ) ) 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') <= 20171218) 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') <= 20171219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171219 ) ) 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') <= 20171219) 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') <= 20171220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171220 ) ) 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') <= 20171220) 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') <= 20171221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171221 ) ) 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') <= 20171221) 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') <= 20171222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171222 ) ) 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') <= 20171222) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
93
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20171223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171223 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20171223) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
95
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') <= 20171224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171224 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
96
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') <= 20171224) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
97
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') <= 20171225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171225 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98
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') <= 20171225) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
99
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') <= 20171226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171226 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100
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') <= 20171226) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
101
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') <= 20171227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171227 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102
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') <= 20171227) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
103
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') <= 20171228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171228 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104
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') <= 20171228) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
105
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') <= 20171229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171229 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106
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') <= 20171229) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
107
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') <= 20171230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171230 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108
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') <= 20171230) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
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') <= 20171231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20171231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20171231 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110
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') <= 20171231) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
111
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
112
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
113
SELECT COUNT( id ) AS count_users
 FROM chess_users
114
SELECT COUNT( id ) AS count_items
 FROM chess_content
115
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
116
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1
117
SELECT guest, usertype
 FROM chess_session