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 Campionato Giovanile Scacchistico 2012 della Provincia di Catania venerdì 24 febbraio 2012 COMITATO PROVINCIALE SCACCHISTICO di CATANIA   Il Campionato provinciale catanese giovanile (under 8-under 20)   domenica 4 marzo a CasaRiccioli, presso la Piazza del Santuario accanto al   Comando Polizia Municipale,  Valverde (CT).    Per qualsiasi informazione rivolgersi a : Prof. Santo Spina Cell. 346.8236699 , Prof. Dante   Finocchiaro Cell.328.4712188 , A.C.N. Carlo Vella Cell. 335.6509575 .   Per il COMITATO PROVINCIALE SCACCHISTICO di CATANIA ,  Carlo Vella . Ultimo aggiornamento ( lunedì 13 agosto 2012 )   16° FESTIVAL W.E. AMATORI CT dati finali mercoledì 22 febbraio 2012     AMATORI CT WE 2012  MASCALUCIA (CT) (11/02/2012, 19/02/2012) OPEN A  Classifica finale   Pos Pts ID Ctg NAME Rtg Fed   Buc1    BucT    BucM  1  5.0 1 IM LJUBISAVLJEVIC ZIV 2214 SRB    18.0    19.0    13.5 2  4.5 4 FM FABIANO GIUSEPPE 2118 IT    20.0    22.0    15.0 3  4.5 3 M VALGUARNERA GIROLA 2139 IT    19.5    20.5    14.5 4  3.5 2 M SARDO GABRIELE 2202 IT    20.5    23.0    15.5 5  3.5 10 1N SIGNORELLI GAETANO 1865 IT    16.5    18.5    12.0 6  3.5 14 1N CARMENI GIOVANNI 1808 IT    14.0    16.0    10.5 7  3.0 8 CM PISACANE PIETRO 2004 IT    17.0    18.5    12.0 8  3.0 9 CM RUSSO ALFIO 1903 IT    13.0    14.0     9.5 9  2.5 7 CM BOTTINO ALEXIEI  (W) 2019 IT    18.5    21.0    14.0 10  2.5 11 1N MELI MASSIMO 1851 IT    16.0    17.5    11.5 11  2.5 13 1N MARZADURI RICCARDO 1830 IT    14.0    15.0    10.5 12  2.0 5 CM CAPPADONA SALVATO(W) 2094 IT    18.0    19.5    13.0 13  2.0 12 1N FURNARI FRANCESCO 1833 IT    12.0    13.0     9.0 14  1.5 15 1N SILECI SALVATORE 1751 IT    17.0    18.5    12.0 15  0.5 6 CM TUTTOBENE SERGIO (W) 2064 IT    13.0    14.5     9.5     OPEN B Classifica finale   Pos Pts ID Ctg NAME Rtg Fed   Buc1    BucT    BucM  1  5.0 1 1N NOBILE STEFANO 1788 IT    20.0    23.0    15.5 2  4.5 12 2N BATTAGLIA GIUSEPPE 1568 IT    20.0    22.0    15.5 3  4.5 9 2N LA FRANCA VINCENZO 1634 IT    18.5    20.0    14.0 4  4.5 19 3N ANNINO VINCENZO 1518 IT    17.5    19.0    13.0 5  4.0 13 3N TOSTO FRANCESCO 1566 IT    18.0    20.5    13.5 6  4.0 10 2N FERRERI DANIELE 1632 IT    18.0    20.0    13.5 7  4.0 5 2N MECCA TOMMASO 1703 IT    17.5    19.5    13.0 8  3.5 14 3N SANCHEZ RICARDO 1548 MEX    19.5    21.5    15.0 9  3.5 23 3N ARDIZZONE LUIGI 1490 IT    15.0    16.5    11.0 10  3.0 3 2N CONDORELLI ROBERTO 1745 IT    18.5    20.0    14.0 11  3.0 6 2N VERDE SALVATORE 1694 IT    16.5    19.0    12.0 12  3.0 25 2N SILECI ANTONINO 1319 IT    15.0    16.0    10.5 13  3.0 26 3N ASTORINA DAVIDE 1521 IT    14.5    16.5    10.5 14  3.0 11 3N IUVARA DARIO 1599 IT    13.0    14.5    10.0 15  3.0 21 3N PALADINO ANTONIO 1506 IT    13.0    14.0     9.5 16  2.5 4 1N ZUCCAROTTO SALVATO 1706 IT    18.0    20.5    13.5 17  2.5 8 2N CONTI SILVANO 1646 IT    17.5    20.0    13.5 18  2.5 16 3N MANNINO FABIO 1533 IT    15.5    17.5    11.0 19  2.5 17 3N LO GRANDE GAETANO 1530 IT    14.0    15.5    11.0 20  2.5 15 3N CAMPANELLA ALESSAN 1533 IT    10.5    11.5     7.5 21  2.0 18 2N COSTA SALVATORE 1529 IT    16.5    18.5    12.0 22  2.0 7 2N CONSENTINO GIUSEPP 1685 IT    15.5    16.5    11.0 23  1.5 2 2N ALBERIO NICOLO' 1767 IT    17.0    19.5    12.5 24  1.5 24 NC MODICA SANTO 1437 IT    14.5    15.5    11.0 25  1.0 22 3N MACCARIONE FRANCES 1491 IT    17.0    19.0    12.5 26  1.0 20 3N RAPICAVOLI FRANCES 1511 IT    11.5    11.5     8.5 OPEN C Classifica finale   Pos Pts ID Ctg NAME Rtg Fed   Buc1    BucT    BucM  1  5.5 1 NC PRIOLO DOMENICO 1473 IT    18.0    20.5    14.0 2  4.0 8 NC BAFFO SALVATORE 1434 IT    18.5    21.0    13.0 3  4.0 12 NC ARENA GABRIELE 1326 IT    18.0    18.5    12.5 4  3.5 2 NC CAPONNETTO ANGELO 1440 IT    19.0    21.5    13.5 5  3.5 3 NC COMPAGNONE MICHELE 1440 IT    19.0    21.5    13.5 6  3.5 11 3N BOTTINO SEBASTIANO 1388 IT    19.0    20.5    13.5 7  3.0 4 NC GULINO ROSARIO 1440 IT    14.0    14.5    10.0 8  2.5 10 NC FRANCESCHINO LUCA 1395 IT    16.5    18.0    12.5 9  2.5 9 NC MENDOLA GIOVANNI 1404 IT    14.5    15.0    10.5 10  2.0 5 NC SCUDERI ROSARIO 1440 IT    12.0    12.5     9.0 11  1.0 7 NC SPERANZA DAVIDE  (W) 1440 IT    16.5    17.0    11.0 12  1.0 6 NC SCUDERI SALVATORE 1440 IT    13.5    14.0     9.5     16° WE Amatori CT 2012 4° Turno e Classifiche domenica 12 febbraio 2012 AMATORI CT WE OPEN A 2012 MASCALUCIA (CT) (11/02/2012, 19/02/2012) Abbinamento turno 4 1    M SARDO GABRIELE           2.5    M VALGUARNERA GIROLAMO     2.5      2 -   3    2    FM FABIANO GIUSEPPE         2.5    CM BOTTINO ALEXIEI          2.5      4 -   7        3    CM CAPPADONA SALVATORE      2.0    IM LJUBISAVLJEVIC ZIVOJ     2.0      5 -   1         4    CM RUSSO ALFIO              1.5    1N MELI MASSIMO             1.5      9 -  11        5    1N SIGNORELLI GAETANO       1.5    1N CARMENI GIOVANNI         1.5     10 -  14       6    CM PISACANE PIETRO          1.0    1N FURNARI FRANCESCO        1.0      8 -  12         7    1N SILECI SALVATORE         1.0    1N MARZADURI RICCARDO       0.5     15 -  13           I seguenti giocatori sono assenti: 6 - TUTTOBENE SERGIO  AMATORI CT WE OPEN A 2012 MASCALUCIA (CT) (11/02/2012, 19/02/2012) Classifica al turno 3 Pos     Pts    ID    Ctg    NAME    Rtg    Fed      Buc1        BucT        BucM  1     2.5    2    M    SARDO GABRIELE    2202    IT         4.5         6.0         2.0 2     2.5    4    FM    FABIANO GIUSEPPE    2118    IT         4.5         5.5         2.0 3     2.5    3    M    VALGUARNERA GIROLA    2139    IT         4.0         4.5         1.5 4     2.5    7    CM    BOTTINO ALEXIEI    2019    IT         3.5         4.5         1.0 5     2.0    1    IM    LJUBISAVLJEVIC ZIV    2214    SRB         3.5         4.0         1.0 6     2.0    5    CM    CAPPADONA SALVATOR    2094    IT         3.5         4.0         1.0 7     1.5    11    1N    MELI MASSIMO    1851    IT         4.0         4.5         1.5 8     1.5    14    1N    CARMENI GIOVANNI    1808    IT         4.0         4.5         1.5 9     1.5    9    CM    RUSSO ALFIO    1903    IT         3.5         4.0         1.0 10     1.5    10    1N    SIGNORELLI GAETANO    1865    IT         3.5         4.0         1.0 11     1.0    15    1N    SILECI SALVATORE    1751    IT         4.5         5.5         2.0 12     1.0    8    CM    PISACANE PIETRO    2004    IT         4.0         4.5         2.0 13     1.0    12    1N    FURNARI FRANCESCO    1833    IT         3.5         3.5         1.5 14     0.5    6    CM    TUTTOBENE SERGIO    2064    IT         4.0         4.5         1.5 15     0.5    13    1N    MARZADURI RICCARDO    1830    IT         2.5         3.5         1.0 AMATORI CT WE OPEN B 2012 MASCALUCIA (CT) (11/02/2012, 19/02/2012) Abbinamento turno 4 1    2N BATTAGLIA GIUSEPPE       3.0    2N LA FRANCA VINCENZO       2.5     12 -   9         2    1N NOBILE STEFANO           2.5    2N MECCA TOMMASO            2.0      1 -   5         . 3    3N ANNINO VINCENZO          2.5    3N TOSTO FRANCESCO          2.5     19 -  13        4    2N CONDORELLI ROBERTO       2.0    2N FERRERI DANIELE          2.0      3 -  10       5    1N ZUCCAROTTO SALVATORE     2.0    3N SANCHEZ RICARDO          2.0      4 -  14        6    2N VERDE SALVATORE          1.5    3N ARDIZZONE LUIGI          1.5      6 -  23         7    2N CONTI SILVANO            1.5    2N CONSENTINO GIUSEPPE      1.5      8 -   7         . 8    3N MANNINO FABIO            1.5    3N IUVARA DARIO             1.0     16 -  11         ...     9    2N ALBERIO NICOLO'          1.0    3N MACCARIONE FRANCESCO     1.0      2 -  22         10    3N LO GRANDE GAETANO        1.0    3N PALADINO ANTONIO         1.0     17 -  21        11    2N COSTA SALVATORE          1.0    2N SILECI ANTONINO          1.0     18 -  25         12    NC MODICA SANTO             0.5    3N ASTORINA DAVIDE          1.0     24 -  26        13    3N CAMPANELLA ALESSANDR     0.0    3N RAPICAVOLI FRANCESCO     0.0     15 -  20        AMATORI CT WE OPEN B 2012 MASCALUCIA (CT) (11/02/2012, 19/02/2012) Classifica al turno 3 Pos     Pts    ID    Ctg    NAME    Rtg    Fed      Buc1        BucT        BucM  1     3.0    12    2N    BATTAGLIA GIUSEPPE    1568    IT         3.5         4.5         1.5 2     2.5    1    1N    NOBILE STEFANO    1788    IT         4.5         6.0         2.0 3     2.5    13    3N    TOSTO FRANCESCO    1566    IT         4.0         5.0         2.0 4     2.5    19    3N    ANNINO VINCENZO    1518    IT         3.0         4.0         1.5 5     2.5    9    2N    LA FRANCA VINCENZO    1634    IT         3.0         4.0         1.0 6     2.0    5    2N    MECCA TOMMASO    1703    IT         5.0         6.0         2.0 7     2.0    3    2N    CONDORELLI ROBERTO    1745    IT         4.0         4.5         1.5 8     2.0    10    2N    FERRERI DANIELE    1632    IT         3.5         4.5         1.5 9     2.0    4    1N    ZUCCAROTTO SALVATO    1706    IT         3.5         4.5         1.0 10     2.0    14    3N    SANCHEZ RICARDO    1548    MEX         3.0         4.0         1.0 11     1.5    16    3N    MANNINO FABIO    1533    IT         4.5         6.0         2.0 12     1.5    6    2N    VERDE SALVATORE    1694    IT         4.5         5.5         2.0 13     1.5    7    2N    CONSENTINO GIUSEPP    1685    IT         4.5         4.5         1.5 14     1.5    8    2N    CONTI SILVANO    1646    IT         4.0         5.0         1.5 15     1.5    23    3N    ARDIZZONE LUIGI    1490    IT         3.0         3.5         1.0 16     1.0    2    2N    ALBERIO NICOLO'    1767    IT         5.0         5.0         2.5 17     1.0    25    2N    SILECI ANTONINO    1319    IT         5.0         5.0         2.0 18     1.0    26    3N    ASTORINA DAVIDE    1521    IT         4.5         5.5         2.0 19     1.0    22    3N    MACCARIONE FRANCES    1491    IT         4.5         4.5         2.0 20     1.0    21    3N    PALADINO ANTONIO    1506    IT         4.0         4.0         2.0 21     1.0    18    2N    COSTA SALVATORE    1529    IT         3.5         4.5         1.5 22     1.0    17    3N    LO GRANDE GAETANO    1530    IT         3.0         3.0         1.0 23     1.0    11    3N    IUVARA DARIO    1599    IT         2.5         3.0         1.0 24     0.5    24    NC    MODICA SANTO    1437    IT         3.5         4.5         1.5 25     0.0    20    3N    RAPICAVOLI FRANCES    1511    IT         2.5         3.5         1.0 26     0.0    15    3N    CAMPANELLA ALESSAN    1533    IT         2.0         3.0         1.0 AMATORI CT WE OPEN B 2012 MASCALUCIA (CT) - 11/02/2012, 19/02/2012 Variazione Elo al turno 3   ID  NAME                  K   Rtg     var   Per.Rtg ---------------------------------------------------------    1  NOBILE STEFANO         0  1788     0     1784    2  ALBERIO NICOLO'       30  1767   -39     1437    3  CONDORELLI ROBERTO     0  1745     0     1637    4  ZUCCAROTTO SALVATORE   0  1706     0     1597    5  MECCA TOMMASO         30  1703     0     1701    6  VERDE SALVATORE       30  1694   -12     1588    7  CONSENTINO GIUSEPPE   30  1685   -18     1537    8  CONTI SILVANO         30  1646    12     1793    9  LA FRANCA VINCENZO     0  1634     0     1955   10  FERRERI DANIELE       30  1632     6     1686   11  IUVARA DARIO          30  1599   -21     1428   12  BATTAGLIA GIUSEPPE    30  1568    45     2369   13  TOSTO FRANCESCO       30  1566    42     1930   14  SANCHEZ RICARDO       30  1548    21     1730   15  CAMPANELLA ALESSANDR  30  1533   -39      796   16  MANNINO FABIO         30  1533    15     1649   17  LO GRANDE GAETANO     30  1530    -9     1462   18  COSTA SALVATORE       30  1529    -6     1472   19  ANNINO VINCENZO       30  1518    48     1938   20  RAPICAVOLI FRANCESCO  30  1511   -45      703   21  PALADINO ANTONIO      30  1506    -6     1443   22  MACCARIONE FRANCESCO  30  1491    -3     1475   23  ARDIZZONE LUIGI       30  1490     6     1533   24  MODICA SANTO          30  1437   -12     1338   25  SILECI ANTONINO       30  1319    15     1470   26  ASTORINA DAVIDE       30  1521   -12     1423 OPEN C AMATORI CT WE 2012 MASCALUCIA (CT) (11/02/2012, 19/02/2012) Abbinamento turno 4 1    NC CAPONNETTO ANGELO        2.5    NC PRIOLO DOMENICO          3.0      2 -   1    2    NC COMPAGNONE MICHELE       2.0    NC BAFFO SALVATORE          2.5      3 -   8       3    NC FRANCESCHINO LUCA        2.0    NC ARENA GABRIELE           2.0     10 -  12       4    3N BOTTINO SEBASTIANO       1.0    NC SPERANZA DAVIDE          1.0     11 -   7        5    NC MENDOLA GIOVANNI         1.0    NC GULINO ROSARIO           1.0      9 -   4         6    NC SCUDERI SALVATORE        0.0    NC SCUDERI ROSARIO          0.0      6 -   5        OPEN C AMATORI CT WE 2012 MASCALUCIA (CT) (11/02/2012, 19/02/2012) Classifica al turno 3 Pos     Pts    ID    Ctg    NAME    Rtg    Fed      Buc1        BucT        BucM  1     3.0    1    NC    PRIOLO DOMENICO    1473    IT         3.0         4.0         1.0 2     2.5    2    NC    CAPONNETTO ANGELO    1440    IT         4.5         5.5         2.0 3     2.5    8    NC    BAFFO SALVATORE    1434    IT         3.5         4.5         1.0 4     2.0    3    NC    COMPAGNONE MICHELE    1440    IT         5.0         6.0         2.0 5     2.0    12    NC    ARENA GABRIELE    1326    IT         3.5         3.5         1.0 6     2.0    10    NC    FRANCESCHINO LUCA    1395    IT         3.0         3.0         1.0 7     1.0    7    NC    SPERANZA DAVIDE    1440    IT         5.5         5.5         2.5 8     1.0    11    3N    BOTTINO SEBASTIANO    1388    IT         5.0         5.0         2.0 9     1.0    4    NC    GULINO ROSARIO    1440    IT         4.5         4.5         2.0 10     1.0    9    NC    MENDOLA GIOVANNI    1404    IT         4.5         4.5         2.0 11     0.0    6    NC    SCUDERI SALVATORE    1440    IT         3.0         4.0         1.0 12     0.0    5    NC    SCUDERI ROSARIO    1440    IT         3.0         4.0         1.0 OPEN C AMATORI CT WE 2012 MASCALUCIA (CT) - 11/02/2012, 19/02/2012 Variazione Elo al turno 3  ID  NAME                  K   Rtg     var   Per.Rtg ---------------------------------------------------------    1  PRIOLO DOMENICO       30  1473    39     2223    2  CAPONNETTO ANGELO     30  1440    24     1673    3  COMPAGNONE MICHELE    30  1440    12     1549    4  GULINO ROSARIO        30  1440   -18     1298    5  SCUDERI ROSARIO       30  1440   -51      596    6  SCUDERI SALVATORE     30  1440   -51      602    7  SPERANZA DAVIDE       30  1440   -12     1326    8  BAFFO SALVATORE       30  1434    30     1701    9  MENDOLA GIOVANNI      30  1404   -12     1313   10  FRANCESCHINO LUCA     30  1395    21     1565   11  BOTTINO SEBASTIANO    30  1388   -12     1288   12  ARENA GABRIELE        30  1326    27     1548 Ultimo aggiornamento ( mercoledì 15 febbraio 2012 )   CAMPIONATO PROVINCIALE di CATANIA mercoledì 18 gennaio 2012 CAMPIONATO PROVINCIALE DI CATANIA 2012 Zafferana Etnea (CT) (14/01/2012, 22/01/2012) Abbinamento turno 4 Tav.    Bianco    Pnt    Nero    Pnt      1    IM LJUBISAVLEVIC ZIJOIN     3.0    M SARDO GABRIELE       3.0   2    1N SIGNORELLI GAETANO       2.5    FM FABIANO GIUSEPPE         3.0  3    CM GRASSO GAETANO           2.0    M SANTAGATI ALESSANDRO     2.0    4    CM IMBRAGUGLIA FABIO        2.0    2N CANNELLA SIMONE          2.0    5    CM GANGEMI SALVATORE        2.0    CM TOMASELLI MAURIZIO       2.0    Ultimo aggiornamento ( sabato 21 gennaio 2012 )   16° FESTIVAL AMATORI CT sabato 31 dicembre 2011 E' arrivato alla 16 a edizione il tradizionale Festival dell' Amatori CT. Da sei anni  siamo a Mascalucia e da quattro la sede è sempre la stessa : l' originale e bellissima Villa Buscemi e quindi quando ci si trova bene non si cambia . La formula rimane anche questa sempra la stessa , tre Open divisi per fasce ELO . I giorni sono : 11-12-18-19 febbraio 2012 , 6 turni con sistema Svizzero con cadenza di 2 ore q.p.f.  Carlo Vella .  Per visualizzare il bando completo clicca di seguito : http://www.amatoriscacchicatania.com/index.php?option=com_docman&task=doc_download&gid=113&Itemid=42   Ultimo aggiornamento ( lunedì 13 febbraio 2012 )   Altri articoli... RAPID " GAME PRIDE " 2011 RAPID " ACICASTELLO 2 " RAPID " ETNA COMICS " 7° Rapid Lido America << Inizio < Prec. 11 12 13 14 15 16 17 18 19 20 Pross. > Fine >> Risultati 118 - 126 di 204 [Indietro] ExtCalendar Aprile 2018 Do Lu Ma Me Gi Ve Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 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: 10:43 Caching: Disabled GZIP: Disabled Utenti: 88506 Notizie: 294 Collegamenti web: 17 Visitatori: 16543125

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM chess_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 99999999 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1713518916' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1713518916' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
6
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Mozilla 5.0'
 AND type = 0
7
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
8
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
9
SELECT COUNT(*)
 FROM chess_stats_agents
 WHERE agent = 'com'
 AND type = 2
10
UPDATE chess_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
11
SELECT *
 FROM chess_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com_content&task=blogsection%'
12
SELECT COUNT(a.id)
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_sections AS s ON a.sectionid = s.id
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 11:43' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 11:43' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
13
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_sections AS s ON a.sectionid = s.id
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 11:43' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 11:43' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 117, 9
14
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT a.*
 FROM chess_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
16
SELECT id, title, module, position, content, showtitle, params
 FROM chess_modules AS m
 INNER JOIN chess_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 99999999 )
 ORDER BY ordering
17
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
18
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
19
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM chess_sections as a
 LEFT JOIN chess_content as b ON a.id = b.sectionid
 AND b.access <= 0
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-04-19 11:43' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-04-19 11:43' )
 WHERE a.scope = 'content'
 AND a.published = 1
 AND a.access <= 0
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 5
20
SELECT m.id AS Itemid, m.componentid AS sectionid
 FROM chess_menu AS m
 WHERE ( m.type = 'content_section' OR m.type = 'content_blog_section' )
 AND m.published = 1
 AND m.access <= 0
 AND ( m.componentid=1 OR m.componentid=4 OR m.componentid=2 OR m.componentid=3 OR m.componentid=0 )
 ORDER BY m.type DESC, m.id DESC
21
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-04-19 11:43' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-04-19 11:43' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
22
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
24
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
25
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
26
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
27
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
 FROM chess_content
 WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
 GROUP BY created_year DESC, created_month DESC
LIMIT 10
28
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
29
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 2
30
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
31
SELECT * FROM chess_extcal_config
32
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180401 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180401 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180401 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
33
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180401) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
34
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180402 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180402 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180402 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
35
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180402) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
36
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180403 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180403 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180403 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
37
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180403) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
38
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180404 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180404 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180404 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
39
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180404) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
40
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180405 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180405 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180405 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
41
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180405) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
42
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20180406 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180406 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180406 ) ) 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') <= 20180406) 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') <= 20180407 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180407 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180407 ) ) 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') <= 20180407) 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') <= 20180408 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180408 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180408 ) ) 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') <= 20180408) 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') <= 20180409 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180409 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180409 ) ) 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') <= 20180409) 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') <= 20180410 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180410 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180410 ) ) 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') <= 20180410) 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') <= 20180411 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180411 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180411 ) ) 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') <= 20180411) 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') <= 20180412 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180412 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180412 ) ) 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') <= 20180412) 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') <= 20180413 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180413 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180413 ) ) 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') <= 20180413) 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') <= 20180414 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180414 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180414 ) ) 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') <= 20180414) 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') <= 20180415 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180415 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180415 ) ) 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') <= 20180415) 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') <= 20180416 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180416 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180416 ) ) 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') <= 20180416) 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') <= 20180417 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180417 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180417 ) ) 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') <= 20180417) 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') <= 20180418 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180418 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180418 ) ) 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') <= 20180418) 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') <= 20180419 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180419 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180419 ) ) 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') <= 20180419) 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') <= 20180420 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180420 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180420 ) ) 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') <= 20180420) 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') <= 20180421 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180421 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180421 ) ) 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') <= 20180421) 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') <= 20180422 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180422 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180422 ) ) 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') <= 20180422) 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') <= 20180423 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180423 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180423 ) ) 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') <= 20180423) 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') <= 20180424 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180424 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180424 ) ) 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') <= 20180424) 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') <= 20180425 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180425 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180425 ) ) 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') <= 20180425) 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') <= 20180426 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180426 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180426 ) ) 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') <= 20180426) 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') <= 20180427 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180427 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180427 ) ) 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') <= 20180427) 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') <= 20180428 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180428 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180428 ) ) 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') <= 20180428) 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') <= 20180429 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180429 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180429 ) ) 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') <= 20180429) 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') <= 20180430 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20180430 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20180430 ) ) 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') <= 20180430) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
92
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
93
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
94
SELECT COUNT( id ) AS count_users
 FROM chess_users
95
SELECT COUNT( id ) AS count_items
 FROM chess_content
96
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
97
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1