Fondata ed affiliata

alla FSI dal 1987

Sezioni

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

 
Risultati immagini per LOGO FSI
 

 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

powered_by.png, 1 kB
Home arrow Articoli arrow Analisi arrow Bronstein - Dubinin
Bronstein - Dubinin PDF Stampa E-mail
domenica 21 gennaio 2007

Talvolta capita che anche giocatori relativamente moderni si facciano sedurre da aperture d'antica data. Ed il risultato spesso non è affatto disprezzabile!

Bronstein - Dubinin (Leningrado, 1947)

Gambetto di Re, Difesa classica, variante Kieseritzky

1 e4, e5; 2 f4, e:f4; 3 Cf3, g5; 4 h4, g4; 5 Ce5, h5; 6 Ac4, Th7; 7 d4, Ah6; 8 Cc3, Cc6;

In questa posizione Bronstein riesce a portare a compimento l'idea strategica del Gambetto di Re, ovvero apertura della colonna f ed attacco al punto f7:

9 C:f7!, T:f7; 10 A:f7+, R:f7; 11 A:f4!, A:f4; 12 O-O, D:h4; 13 T:f4+, Rg7; 14 Dd2, d6; 15 Taf1, Cd8 (per neutralizzare il forte scacco 16 Tf7+); 16 Cd5, Ad7;

Posizione dopo 16 ..., Ad7  Posizione dopo la mossa 16 ..., Ac8-d7


L'ultima mossa del Nero è praticamente forzata. A 16 ..., c6? segue 17 Cc7, Tb8; 18 Ce8+ con forte attacco del Bianco.

Adesso sembra ovvio giocare 17 C:c7, Tc8; 18 Cd5, ma Bronstein ha un acume tattico fuori dalla norma e disdegna tale continuazione:

17 e5!, d:e5; 18 d:e5, Ac6; 19 e6!, A:d5;

Posizione dopo 19 ..., A:d5  Posizione dopo la mossa 19 ..., Ac6:d5


Infatti non andava 19 ..., C:e6 per la micidiale risposta 20 Tf7+!!, Rh8 (Rg6??; 21 Dd3+, Rh6; 22 Th7+, Rg5; 23 Df5#); 21 Dc3+!, Cf6; 22 T7:f6, Cg7; 23 Tg6!, Tg8; 24 Th6#.
Comunque la situazione del Nero era già insostenibile, e il Bianco lo dimostra chiudendo in bellezza:

20 Tf7+!, C:f7; 21 T:f7+, Rh8 (Rg6??; 22 Dd3+, Rg5; 23 Df5+, Rh6; 27 Th7#); 22 Dc3+, Cf6; 23 T:f6, D:f6;

Il Nero ha dovuto cedere la Donna, visto che le altre continuazioni portano al matto. Per esempio: 23 ..., Tg8??; 24 Th6#, oppure 23 ..., Rh7?; 24 Tf7+, Rg6; 25 Dg7#, oppure ancora 23 ..., Rg8?; 24 Tg6+, Rf8; 25 Dg7+, Re8; 26 Df7+, Rd8; 27 Dd7#.

Dopo la caduta della Donna nera la vittoria del Bianco è soltanto questione di tecnica...

24 D:f6+, Rh7; 25 Df5+, Rh6; 26 D:d5, Rg6; 27 Dd7, abbandona. 1-0

Una partita nel tipico stile di Bronstein!
 
< Prec.
[Indietro]

ExtCalendar

Giugno 2021 Luglio 2021 Agosto 2021
Do Lu Ma Me Gi Ve Sa
Settimana 26 1 2 3
Settimana 27 4 5 6 7 8 9 10
Settimana 28 11 12 13 14 15 16 17
Settimana 29 18 19 20 21 22 23 24
Settimana 30 25 26 27 28 29 30 31
Home
Chi siamo
Dove siamo
Links Links
Cerca
Articoli
News
Foto & Immagini
FAQ
Contattaci
download

Immagine casuale

JuditPolgar.jpg

Menu utente

Statistiche

OS: Linux h
PHP: 5.2.17
MySQL: 5.0.96-community-log
Ora: 19:06
Caching: Disabled
GZIP: Disabled
Utenti: 90271
Notizie: 294
Collegamenti web: 17
Visitatori: 16666170
© 2024 Amatori Scacchi Catania
Joomla! un software libero rilasciato sotto licenza GNU/GPL.
104 queries executed
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 = 37 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM chess_session
 WHERE (
 ( time < '1714672314' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1714672314' )
 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 = 37
12
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM chess_content AS a
 LEFT JOIN chess_categories AS cc ON cc.id = a.catid
 LEFT JOIN chess_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN chess_users AS u ON u.id = a.created_by
 LEFT JOIN chess_groups AS g ON a.access = g.id
 WHERE a.id = 32 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 20:06' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 20:06' )
 AND a.access <= 0
13
SELECT a.id
 FROM chess_content AS a
 WHERE a.catid = 19
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 20:06' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 20:06' )
 ORDER BY a.ordering
14
UPDATE chess_content
 SET hits = ( hits + 1 )
 WHERE id = '32'
15
SELECT hits
 FROM chess_core_log_items
 WHERE time_stamp = '2024-05-02'
 AND item_table = '#__content'
 AND item_id = '32'
16
UPDATE chess_core_log_items
 SET hits = ( hits + 1 )
 WHERE time_stamp = '2024-05-02'
 AND item_table = '#__content'
 AND item_id = '32'
17
SELECT folder, element, published, params
 FROM chess_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
18
SELECT a.*
 FROM chess_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
19
SELECT id, title, module, position, content, showtitle, params
 FROM chess_modules AS m
 INNER JOIN chess_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 37 )
 ORDER BY ordering
20
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
21
SELECT id
 FROM chess_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
22
SELECT a.id AS id, a.title AS title, COUNT(b.id) as cnt
 FROM chess_sections as a
 LEFT JOIN chess_content as b ON a.id = b.sectionid
 AND b.access <= 0
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2024-05-02 20:06' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2024-05-02 20:06' )
 WHERE a.scope = 'content'
 AND a.published = 1
 AND a.access <= 0
 GROUP BY a.id
 HAVING COUNT( b.id ) > 0
 ORDER BY a.ordering
LIMIT 5
23
SELECT m.id AS Itemid, m.componentid AS sectionid
 FROM chess_menu AS m
 WHERE ( m.type = 'content_section' OR m.type = 'content_blog_section' )
 AND m.published = 1
 AND m.access <= 0
 AND ( m.componentid=1 OR m.componentid=4 OR m.componentid=2 OR m.componentid=3 OR m.componentid=0 )
 ORDER BY m.type DESC, m.id DESC
24
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM chess_content AS a
 INNER JOIN chess_categories AS cc ON cc.id = a.catid
 INNER JOIN chess_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-02 20:06' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-02 20:06' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
25
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
SELECT COUNT( id )
 FROM chess_menu 
 WHERE type = 'content_typed'
 AND published = 1
27
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'
28
SELECT id
 FROM chess_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=12'
29
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
30
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
 FROM chess_content
 WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
 GROUP BY created_year DESC, created_month DESC
LIMIT 10
31
SELECT *
 FROM chess_banner
 WHERE showBanner = 1
32
UPDATE chess_banner
 SET impmade = impmade + 1
 WHERE bid = 3
33
SELECT id, name, link, parent, type, menutype, access
 FROM chess_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
34
SELECT title, catid, id, access
 FROM chess_content
 WHERE id = 32
35
SELECT c.title AS title, s.id AS sectionid, c.id AS id, c.access AS cat_access
 FROM chess_categories AS c
 LEFT JOIN chess_sections AS s
 ON c.section = s.id
 WHERE c.id = 19
 AND c.access <= 0
36
SELECT * FROM chess_extcal_config
37
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') <= 20210701 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210701 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210701 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
38
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') <= 20210701) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
39
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') <= 20210702 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210702 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210702 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
40
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') <= 20210702) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
41
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') <= 20210703 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210703 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210703 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
42
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') <= 20210703) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
43
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') <= 20210704 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210704 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210704 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
44
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') <= 20210704) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
45
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') <= 20210705 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210705 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210705 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
46
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') <= 20210705) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
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') <= 20210706 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210706 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210706 ) ) 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') <= 20210706) 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') <= 20210707 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210707 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210707 ) ) 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') <= 20210707) 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') <= 20210708 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210708 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210708 ) ) 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') <= 20210708) 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') <= 20210709 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210709 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210709 ) ) 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') <= 20210709) 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') <= 20210710 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210710 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210710 ) ) 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') <= 20210710) 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') <= 20210711 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210711 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210711 ) ) 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') <= 20210711) 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') <= 20210712 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210712 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210712 ) ) 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') <= 20210712) 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') <= 20210713 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210713 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210713 ) ) 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') <= 20210713) 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') <= 20210714 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210714 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210714 ) ) 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') <= 20210714) 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') <= 20210715 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210715 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210715 ) ) 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') <= 20210715) 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') <= 20210716 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210716 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210716 ) ) 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') <= 20210716) 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') <= 20210717 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210717 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210717 ) ) 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') <= 20210717) 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') <= 20210718 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210718 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210718 ) ) 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') <= 20210718) 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') <= 20210719 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210719 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210719 ) ) 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') <= 20210719) 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') <= 20210720 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210720 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210720 ) ) 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') <= 20210720) 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') <= 20210721 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210721 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210721 ) ) 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') <= 20210721) 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') <= 20210722 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210722 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210722 ) ) 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') <= 20210722) 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') <= 20210723 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210723 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210723 ) ) 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') <= 20210723) 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') <= 20210724 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210724 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210724 ) ) 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') <= 20210724) 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') <= 20210725 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210725 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210725 ) ) 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') <= 20210725) 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') <= 20210726 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210726 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210726 ) ) 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') <= 20210726) 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') <= 20210727 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210727 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210727 ) ) 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') <= 20210727) 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') <= 20210728 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210728 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210728 ) ) 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') <= 20210728) 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') <= 20210729 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210729 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210729 ) ) 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') <= 20210729) 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') <= 20210730 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210730 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210730 ) ) 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') <= 20210730) 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') <= 20210731 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20210731 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20210731 ) ) 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') <= 20210731) AND c.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
99
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
100
SELECT m.*
 FROM chess_menu AS m
 WHERE menutype = 'usermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
101
SELECT COUNT( id ) AS count_users
 FROM chess_users
102
SELECT COUNT( id ) AS count_items
 FROM chess_content
103
SELECT COUNT( id ) AS count_links
 FROM chess_weblinks
 WHERE published = 1
104
SELECT SUM( hits ) AS count
 FROM chess_stats_agents
 WHERE type = 1