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 : a sorpresa prevale Fabio Battaglia 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" Home ETNA COMICS 2015 : GLI SCACCHI PROTAGONISTI domenica 07 giugno 2015 La quinta edizione della Rassegna " Etna Comics " ha superato in termini di affluenza e di immagine le precedenti edizioni . Dai 50.000 biglietti venduti nel 2014 si è passati ai 60.000 attuali , con un'incremento del 20% . La sezione Scacchi è stata fra le più visitate . Le 25 scacchiere sono state prese d'assalto e nei 4 giorni della Rassegna sono state quasi sempre tutte occupate . Come da Tradizione si è disputato il Rapid Italia nella giornata di Domenica . La partecipazione non è stata esaltante , ma ha raggiunto il numero minimo per l'omologazione del Rapid Play Sicilia ..In effetti 16 partecipanti è un numero a cui l'Amatori Catania non è abituato . E' vero che si possono aggiungere quelli dell'Open B per non tesserati , ma rimane comunque un numero esiguo . La ragione principale è da attribuire al biglietto d'ingresso ( € 10 ) che ha sicuramente frenato chi voleva partecipare al Rapid senza avere un particolare interesse a visitare la Rassegna . Il Rapid ha visto protagonista assoluto il neo Maestro Riccardo Marzaduri che come un carro armato ha fatto fuori tutti gli avversari non concedendo neanche una patta . Al secondo posto Franco Bruno di Valguarnera (EN) . Ha completato il podio il giovanissimo Andrea Barbagallo . Da segnalare il 4° posto di Giovanni Giustolisi con gli stessi punti del 2° e 3°(5,5) . Per tutti i dati clicca di seguito  5° RAPID PLAY   “ ETNA COMICS “ 2015 Complessivamente l'esperienza è stata sicuramente , anche quest'anno , più che positiva e noi dell'Amatori Catania siamo orgogliosi di tenere alta la bandiera degli Scacchi in questo evento , ormai reputato fra quelli più importanti dell'intera regione della sua categoria . Carlo Vella            Ultimo aggiornamento ( domenica 07 giugno 2015 )   11° RAPID LIDO AMERICA domenica 03 maggio 2015 AMATORI  SCACCHI  CATANIA   11° RAPID PLAY “ LIDO AMERICA “ 2015  CATANIA DOMENICA 14 GIUGNO 2015  Rapid Italia + Tappa Campionato Rapid Play Sicilia 2015   SEDE : LIDO AMERICA–Lungomare Kennedy–Playa di Catania Chiusura iscrizioni ore 10,00 . 1° turno ore 10,30 ENTRATA GRATIS PER UN’ ACCOMPAGNATORE DIREZIONE  ARBITRALE : A.C.N. CARLO VELLA Clicca di seguito per bando e preiscrizioni  =   11° RAPID PLAY “ LIDO AMERICA “ 2015  Informazioni : CARLO VELLA Cell. 335-6509575 ;  e-mail : Indirizzo e-mail protetto dal bots spam , deve abilitare Javascript per vederlo ; sito : www.amatoriscacchicatania.com Ultimo aggiornamento ( venerdì 05 giugno 2015 )   47° CIS : 280 giocatori e 56 squadre !! lunedì 30 marzo 2015 In 280 al Campionato Italiano a Squadre di Enna 30 mar, 2015 Si è svolta a Enna, presso il Federico II Palace Hotel, la quinta edizione del Campionato a Squadre di Scacchi, nella formula del concentramento, ovvero con la partecipazione di tutte le squadre dalla categoria Promozione, alla serie A1. La manifestazione, svolta dal 27 al 29 marzo, ha coinvolto ben  56 squadre, con oltre 280 giocatori partecipanti tra titolari e riserve. Record di partecipazione dunque, favorito certamente dalla presenza anche della Serie A1 che mai si era disputata negli altri concentramenti e che era stata assegnata alla Sicilia per l’alta presenza di squadre isolane nel girone, ma sicuramente questo risultato è anche frutto di un gradimento che l’evento in questione si è costruito nel corso degli anni creando un percorso di successo che, ricordiamo, iniziò a Palermo nel 2011. Ad oggi ricordiamo quindi le precedenti edizioni ed i circoli organizzatori: 25/27 marzo – Campo Felice di Roccella  (PA) – Centro Scacchi Palermo (48 squadre); 30 marzo/1 aprile – Baida (PA) – Centro Scacchi Palermo (40 squadre); 15/17 marzo – Acicastello (CT) President Park Hotel – Amatori Scacchi Catania  (48 squadre); 21/23 marzo – Marsala (TP) Baglio Petrosino – asd Lilybetana (54 squadre); 27/29 marzo – Enna – Hotel Federico II – Amatori Scacchi Catania (56 squadre).              Sala B , C e Promozione                                         Sala A1 e A2 Si è trattato sempre di eventi di eccellenza ben organizzati e partecipati e questo, insieme al fascino superiore del torneo a squadre, ne ha determinato l’attuale l’ampio consenso. Detto questo, entrando nei particolari di questa edizione, va segnalato innanzitutto il gran lavoro svolto dalle due associazioni organizzatrici, Amatori Catania e Sissa Leonforte, e se tutti conosciamo l’impegno che Carlo Vella mette nelle sue iniziative, ci ha sorpreso piacevolmente l’entusiasmo dell’associazione di Enna (un nome per tutti: Carmelo Falconieri) che dopo un assenza di qualche anno dal panorama federale si è ripresentata con il piglio da protagonista. Ottima la struttura alberghiera, quattro stelle di nome e di fatto,  che ha fatto da degna cornice al nostro evento. Particolarmente apprezzata la distribuzione dei giocatori in due diversi spazi con la sala principale che ha ospitato le serie Promozione, C e B, per un totale di 44 squadre (!) e la serie A2 e A1 in sala separata. Eccellente lo staff arbitrale con un Piero Arnetta sempre presente e consolidato nel suo ruolo di numero 1 del mondo siciliano arbitrale, ben affiancato dall’ACN Giuseppe Palazzotto e dall’A.R. Domenico Buffa. Bellissimo il clima generale con tutti i partecipanti, esordienti e Maestri, grandi e piccini, pronti a confrontarsi per difendere i colori del proprio circolo lottando per conquistare la promozione nella categoria superiore o, al peggio, evitare la retrocessione. La serata del 28 ha visto l’organizzazione del consueto Torneo Blitz, quest’anno “International Night-Blitz Sicilia 2015” in omaggio al M.I. Russo Vladimir Shumilin che ha fornito il montepremi della manifestazione. Cinquantotto i partecipanti con vittoria del G.M Maxim Dlugy, scacchista statunitense di origini russe, con 7,5 punti, davanti a quattro giocatori tutti ex aequo a 7 punti. Eccoli citati in ordine d’arrivo: il GM Milan Drasko, l’IM Andjelko Dragojlovic, il GM Nenad Ristic e il MF Andrea Amato. Premiazione vincitore Camp- Lampo GM Dlugy   Vince la categoria Promozione (19 squadre partecipanti) la Chessmate A di Bagheria che precede per spareggio tecnico la CPS Promo U20 di Palermo, giunta anch’essa a 8 punti. Al terzo e quarto posto un altra coppia di squadre ex aequo, la Cielo D’Alcamo e la Al Cantara di Viagrande. Al quinto posto la squadra di Casa Sissa, pure essa ex aequo con gli Amici della Scacchiera di Erice, che giungono sesti. Tutte le squadre citate vengono promosse in serie C. L'Amatori B non riesce ad essere promossa in C . La Serie C, girone 29 (17 squadre) vede la vittoria della squadra messinese della Kodokan A ex aequo con la seconda classificata, la Cielo D’Alcamo. Al terzo posto l’Ipercoop La Torre di Monreale. Le tre squadre conquistano la promozione in serie B. Retrocedono il Centro Scacchi Palermo C, il Centro Scacchi Acicastello, Arcadia Partanna, Ipercoop la Torre B di Monreale, Al Cantara 3 di Viagrande e Acireale. In Serie B (8 squadre) si impongono,  gli Amici della Scacchiera di Erice, unica squadra che conquista la promozione in serie A2. Retrocedono Al Cantara 2 di Viagrande, Rapax Horses di Grammichele e CPS Banca Nuova di Palermo. L'Ametori Catania A si salva agevolmente conquistando un'onorevole 3° posto . La Serie A2 vede la vittoria del team di Catanzaro, anch’esso unico a guadagnare la promozione nella serie superiore. Retrocedono Blacknighteam di Gioiosa Marea e Asd Enzo Crea di Messina. Nella Serie A1 caratterizzata dalla presenza di GM e MI e di diversi MF, il Circolo Palermitano Scacchi sorprende tutti e con un team di “semplici” candidati Maestri mette in riga formazioni sulla carta molto più blasonate, ottenendo un prestigioso successo (Claudio Mangione, Michel Bifulco, Luca Varriale e Guido Morello).  Al secondo posto si piazza la squadra di Roma  Steinitz ed al terzo il Centro Scacchi Palermo. Si salva il team di Al Cantara  al suo esordio nella serieA1, mentre retrocedono la Partenopea Senjor di Napoli ed il secondo team del Circolo Palermitano Scacchi.                 Premiazione La premiazione si è svolta nella sera di giorno 29, alla presenza del presidente del Comitato Scacchistico Siciliano. Ecco forse l’unica “magagna” dell’evento è tutta racchiusa qui….l’assoluta mancanza di rappresentanza della città di Enna. Insomma, stiamo parlando di un evento che ha raccolto fino a 400 persone tra giocatori e accompagnatori che, per tre giorni, hanno riempito gli alberghi della zona. Che nessuna autorità del luogo si sia presentata per dare un segnale di gradimento e di accoglienza ai nostri giocatori e al nostro sport, magari anche solo un saluto, beh questo ci ha lasciato un tantino amareggiati. Classifiche Finali CIS 2015 Classifica Blitz Video discorso d'apertura Campionato Italiano = https://www.youtube.com/watch?v=0AOdrzM0Vyg   Video Rosolia si difende = http://youtu.be/hooteeI2lC0  Video Panoramica della sala Promozione , B e C =  http://youtu.be/6Bd-i12LlH0 Ultimo aggiornamento ( venerdì 03 aprile 2015 )   Altri articoli... CONCENTRAMENTO CIS 2015 SICILIA, ENNA PALACE HOTEL FEDERICO II << Inizio < Prec. 21 22 23 24 25 26 27 28 29 30 Pross. > Fine >> Risultati 85 - 88 di 176 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 2024 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:36 Caching: Disabled GZIP: Disabled Utenti: 105013 Notizie: 295 Collegamenti web: 17 Visitatori: 18157850 Chi è 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 < '1734898897' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1734898897' )
 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 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-12-22 21:36' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 21:36' )
 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, 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-12-22 21:36' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 21:36' )
 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 84, 4
14
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
15
SELECT params
 FROM chess_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
16
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'
17
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
18
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
19
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
20
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-12-22 21:36' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-12-22 21:36' )
 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
21
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
22
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-12-22 21:36' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 21:36' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
23
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
24
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
25
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
26
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
27
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
28
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
29
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
30
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 2
31
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-12-22 21:36' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-12-22 21:36' )
 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
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 = 295
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
33
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
34
SELECT id 
 FROM chess_menu 
 WHERE type = 'content_blog_category'
 AND published = 1
 AND componentid = 0
35
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
36
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
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 = 292
 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 = 291
 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 = 290
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
40
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
41
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
42
SELECT id
 FROM chess_menu
 WHERE type = 'components'
 AND published = 1
 AND link = 'index.php?option=com_poll'
43
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 15
 AND text != ''
 ORDER BY id
44
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 16
 AND text != ''
 ORDER BY id
45
SELECT id, text
 FROM chess_poll_data
 WHERE pollid = 20
 AND text != ''
 ORDER BY id
46
SELECT * FROM chess_extcal_config
47
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20241201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241201 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
48
SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20241201) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
49
SELECT e.extid, start_date, end_date from chess_extcal_events AS e LEFT JOIN chess_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20241202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241202 ) ) 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') <= 20241202) 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') <= 20241203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241203 ) ) 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') <= 20241203) 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') <= 20241204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241204 ) ) 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') <= 20241204) 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') <= 20241205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241205 ) ) 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') <= 20241205) 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') <= 20241206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241206 ) ) 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') <= 20241206) 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') <= 20241207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241207 ) ) 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') <= 20241207) 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') <= 20241208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241208 ) ) 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') <= 20241208) 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') <= 20241209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241209 ) ) 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') <= 20241209) 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') <= 20241210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241210 ) ) 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') <= 20241210) 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') <= 20241211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241211 ) ) 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') <= 20241211) 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') <= 20241212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241212 ) ) 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') <= 20241212) 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') <= 20241213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241213 ) ) 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') <= 20241213) 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') <= 20241214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241214 ) ) 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') <= 20241214) 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') <= 20241215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241215 ) ) 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') <= 20241215) 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') <= 20241216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241216 ) ) 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') <= 20241216) 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') <= 20241217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241217 ) ) 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') <= 20241217) 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') <= 20241218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241218 ) ) 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') <= 20241218) 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') <= 20241219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241219 ) ) 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') <= 20241219) 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') <= 20241220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241220 ) ) 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') <= 20241220) 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') <= 20241221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241221 ) ) 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') <= 20241221) 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') <= 20241222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241222 ) ) 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') <= 20241222) 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') <= 20241223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241223 ) ) 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') <= 20241223) 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') <= 20241224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241224 ) ) 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') <= 20241224) 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') <= 20241225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241225 ) ) 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') <= 20241225) 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') <= 20241226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241226 ) ) 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') <= 20241226) 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') <= 20241227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241227 ) ) 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') <= 20241227) 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') <= 20241228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241228 ) ) 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') <= 20241228) 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') <= 20241229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241229 ) ) 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') <= 20241229) 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') <= 20241230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241230 ) ) 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') <= 20241230) 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') <= 20241231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20241231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20241231 ) ) 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') <= 20241231) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
109
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
110
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
111
SELECT COUNT( id ) AS count_users
 FROM chess_users
112
SELECT COUNT( id ) AS count_items
 FROM chess_content
113
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
114
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1
115
SELECT guest, usertype
 FROM chess_session