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 RAPID LIDO dei CICLOPI : grandi novità !! giovedì 09 agosto 2007 Novità importanti per il 6° Rapid Amatori CT Lido dei Ciclopi. Questa edizione vede il connubio con il Circolo A.D. Valverde di Salvatore Cosentino e Santo Spina . Il Montepremi è salito a 300 Euro con ben 17 premiati e 7 coppe. Chiusura iscrizioni ore 9,30 . Lido dei Ciclopi Via Provinciale N° 2 - Aci Trezza Fraz. di Aci Castello (CT). Entrata gratuita per un accompagnatore ed eventuali bambini. Il bando completo nella sezione Download categoria Bandi. Ultimo aggiornamento ( giovedì 09 agosto 2007 )   IL CM REITANO si aggiudica il 5° RAPID 2007 Amatori CT lunedì 23 luglio 2007 Nella bellissima cornice dell'Auditorium di Mascalucia si è svolto il 5° Rapid 2007 Amatori CT. Gli organizzatori avevano preventivato che la partecipazione non sarebbe stata numerosa , a causa del concomitante Festival Int.le di Gioiosa Marea,  comunque si ritengono soddisfatti , soprattutto per il buon livelli qualitativo. Con 7,5 su 8 il CM Marcello Reitano domina il Torneo. Nonostante l'alto livello dei partecipanti il vincitore lascia soltanto mezzo punto al CM Maurizio Tomaselli , che in verità chiude con un brillante secondo posto con solo mezzo punto di distacco.Da sottolineare inoltre il terzo posto di Francesco Furnari , noto frequentatore dei Rapid Play, che viene premiato per la sua costanza. Deludente la prova del CM Salvo Cullè , ma siamo sicuri che nei prossimi Rapid lo vedremo sul podio. Nella sezione Download categoria Varie, la classifica , il tabellone e la foto della Premiazione del vincitore.. Ultimo aggiornamento ( lunedì 30 luglio 2007 )   5° RAPID AMATORI CT SPOSTATO AL 22 LUGLIO giovedì 12 luglio 2007 ATTENZIONE : il 5° Rapid Amatori CT è stato spostato dal 15 al 22 Luglio . La sede di gioco è l'Auditorium di Mascalucia , Via Etnea N° 164, la stessa dove si è svolto il Torneo  W.E. 2007. La sala è climatizzata. Nella sezione download , categoria Bandi Tornei , il bando completo. Ultimo aggiornamento ( giovedì 12 luglio 2007 )   RAPID PLAY LIDO AMERICA : vince ancora Imbraguglia giovedì 21 giugno 2007 Dopo il 3° Rapid Amatori CT , Imbraguglia vince anche il 4° , stavolta per spareggio tecnico su Salvatore Gangemi. Al terzo posto il giovane Fabio Battaglia , figlio d'arte, tornato alle competizioni agonistiche in grande stile. Al quarto posto un'altro giovane figlio d'arte, Franco Furnari , anche lui in continua progressione. Il veterano Tommaso Palermo chiude la lista dei premiati della classifica assoluta. I due premi di fascia vanno a Battaglia padre e a Vanni Mustica.  Anche quest'anno si è svolto nel migliore dei modi il Rapid " Lido America " , uno dei migliori Lidi della Playa di Catania. Molti partecipanti hanno approfittato per concedersi il primo  bagno della stagione insieme alla famiglia, confermando la riuscita della formula " Scacchi & mare ".  Nella sezione download, categoria varie, la classifica ed il tabellone ,  le foto della premiazione del 1° ,  2° e  3° posto e due foto panoramiche del Torneo di Massimo Meli. Ultimo aggiornamento ( venerdì 22 giugno 2007 )   Scacchi Filosofici!! mercoledì 06 giugno 2007   GLI  SCACCHI E LA FILOSOFIA Inseriti 3 articoli su Scacchi e Filosofia a cura del socio prof.Di Paolo Marco. Ne consiglio la lettura a tutti perchè sono veramente interessanti! Complimentoni davvero! Ultimo aggiornamento ( mercoledì 06 giugno 2007 )   Altri articoli... 4° RAPID 2007 AMATORI CT " LIDO AMERICA " Zonale UISP 5° turno Classifica 3° Rapid 2007 Amatori CT 4° turno Zonale UISP : sempre più sorprese !! << Inizio < Prec. 21 22 23 Pross. > Fine >> Risultati 181 - 189 di 204 [Indietro] ExtCalendar Giugno 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 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: 13:47 Caching: Disabled GZIP: Disabled Utenti: 91589 Notizie: 294 Collegamenti web: 17 Visitatori: 16790647

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 < '1716035528' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1716035528' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM chess_session
 WHERE session_id = '256ea2b0c07c479477aac6c792634f34'
6
UPDATE chess_session SET `time`='1716036428',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='256ea2b0c07c479477aac6c792634f34'
7
SELECT *
 FROM chess_menu
 WHERE published = 1 AND
 link LIKE 'index.php?option=com_content&task=blogsection%'
8
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-05-18 14:47' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 14:47' )
 AND ( a.sectionid=1 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
9
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 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-05-18 14:47' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 14:47' )
 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 180, 9
10
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
11
SELECT a.*
 FROM chess_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
12
SELECT id, title, module, position, content, showtitle, params
 FROM chess_modules AS m
 INNER JOIN chess_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 99999999 )
 ORDER BY ordering
13
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
14
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
15
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM chess_sections as a
 LEFT JOIN chess_content as b ON a.id = b.sectionid
 AND b.access <= 0
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-05-18 14:47' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-18 14:47' )
 WHERE a.scope = 'content'
 AND a.published = 1
 AND a.access <= 0
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 5
16
SELECT m.id AS Itemid, m.componentid AS sectionid
 FROM chess_menu AS m
 WHERE ( m.type = 'content_section' OR m.type = 'content_blog_section' )
 AND m.published = 1
 AND m.access <= 0
 AND ( m.componentid=1 OR m.componentid=4 OR m.componentid=2 OR m.componentid=3 OR m.componentid=0 )
 ORDER BY m.type DESC, m.id DESC
17
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-18 14:47' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-18 14:47' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
18
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
19
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
20
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
21
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
22
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
23
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
 FROM chess_content
 WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
 GROUP BY created_year DESC, created_month DESC
LIMIT 10
24
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
25
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
26
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
27
SELECT * FROM chess_extcal_config
28
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') <= 20240601 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240601 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240601 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
29
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') <= 20240601) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
30
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') <= 20240602 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240602 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240602 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
31
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') <= 20240602) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20240603 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240603 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240603 ) ) 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') <= 20240603) 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') <= 20240604 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240604 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240604 ) ) 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') <= 20240604) 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') <= 20240605 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240605 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240605 ) ) 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') <= 20240605) 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') <= 20240606 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240606 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240606 ) ) 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') <= 20240606) 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') <= 20240607 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240607 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240607 ) ) 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') <= 20240607) 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') <= 20240608 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240608 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240608 ) ) 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') <= 20240608) 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') <= 20240609 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240609 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240609 ) ) 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') <= 20240609) 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') <= 20240610 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240610 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240610 ) ) 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') <= 20240610) 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') <= 20240611 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240611 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240611 ) ) 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') <= 20240611) 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') <= 20240612 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240612 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240612 ) ) 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') <= 20240612) 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') <= 20240613 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240613 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240613 ) ) 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') <= 20240613) 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') <= 20240614 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240614 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240614 ) ) 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') <= 20240614) 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') <= 20240615 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240615 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240615 ) ) 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') <= 20240615) 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') <= 20240616 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240616 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240616 ) ) 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') <= 20240616) 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') <= 20240617 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240617 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240617 ) ) 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') <= 20240617) 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') <= 20240618 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240618 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240618 ) ) 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') <= 20240618) 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') <= 20240619 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240619 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240619 ) ) 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') <= 20240619) 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') <= 20240620 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240620 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240620 ) ) 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') <= 20240620) 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') <= 20240621 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240621 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240621 ) ) 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') <= 20240621) 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') <= 20240622 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240622 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240622 ) ) 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') <= 20240622) 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') <= 20240623 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240623 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240623 ) ) 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') <= 20240623) 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') <= 20240624 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240624 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240624 ) ) 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') <= 20240624) 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') <= 20240625 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240625 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240625 ) ) 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') <= 20240625) 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') <= 20240626 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240626 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240626 ) ) 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') <= 20240626) 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') <= 20240627 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240627 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240627 ) ) 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') <= 20240627) 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') <= 20240628 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240628 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240628 ) ) 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') <= 20240628) 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') <= 20240629 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240629 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240629 ) ) 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') <= 20240629) 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') <= 20240630 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20240630 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20240630 ) ) 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') <= 20240630) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
88
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
89
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
90
SELECT COUNT( id ) AS count_users
 FROM chess_users
91
SELECT COUNT( id ) AS count_items
 FROM chess_content
92
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
93
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1