SELECT * FROM cms_1_contents_hu WHERE SUB='0' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='1' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='98' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO ASC
SELECT * FROM cms_1_newscategs_hu ORDER BY NO DESC
SELECT * FROM cms_1_contents_hu WHERE SUB='102' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='80' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='103' AND ACTIVE='1' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="98" ORDER BY POSITION ASC
SELECT * FROM cms_1_news_hu WHERE ACTIVE="1" ORDER BY PUBDATE DESC LIMIT 3
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1051' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1050' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1049' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_newscategs_hu ORDER BY NAME ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT ID,TEXT FROM cms_1_templates_hu WHERE (ANCHOR='banner1' OR ANCHOR='banner2' OR ANCHOR='banner3' OR ANCHOR='banner4' OR ANCHOR='banner5')
SELECT ID,TEXT FROM cms_1_templates_hu WHERE (ANCHOR='banner1' OR ANCHOR='banner2' OR ANCHOR='banner3' OR ANCHOR='banner4' OR ANCHOR='banner5')
SELECT ID,TEXT FROM cms_1_templates_hu WHERE (ANCHOR='banner1' OR ANCHOR='banner2' OR ANCHOR='banner3' OR ANCHOR='banner4' OR ANCHOR='banner5')
SELECT * FROM cms_1_news_hu WHERE SEARCHNAME="tour-de-hongrie-spanyol-gyozelem-az-elso-szakaszon-744"
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='744' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='744' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_news_hu WHERE ACTIVE="1" AND ID!="744" ORDER BY ID DESC
SELECT * FROM cms_1_news_hu WHERE ACTIVE="1" AND ID!="744" AND CATEG="4" ORDER BY ID DESC LIMIT 2
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1051' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1049' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='744' AND CONTENTTYPE='2' AND MAIN!='1' ORDER BY NO ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='744' AND CONTENTTYPE='2' AND MAIN!='1'
SELECT ID,TEXT FROM cms_1_templates_hu WHERE (ANCHOR='banner1' OR ANCHOR='banner2' OR ANCHOR='banner3' OR ANCHOR='banner4' OR ANCHOR='banner5')
Tour de Hongrie - spanyol győzelem az első szakaszon | szelesut.hu
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND PUBDATE>date_sub(now(), interval 1 year) ORDER BY VIEW DESC LIMIT 8
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1045' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1047' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1044' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1046' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1042' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1050' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1049' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1043' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND PUBDATE>date_sub(now(), interval 1 month) ORDER BY RAND() LIMIT 8
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='0' AND (MODULE="home" OR MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="news" OR MODULE="faq" OR MODULE="calendar") ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='103' ORDER BY NO ASC
SELECT * FROM cms_1_templates_hu WHERE EXTRA="0"
by 2020. aug 30.

Tour de Hongrie - spanyol győzelem az első szakaszon

Sprintbefutóval ért véget és a spanyol Jon Aberasturi győzelmét hozta a 41. Tour de Hongrie első szakasza: az Esztergom körül kijelölt körpályán 118 kilométert tett meg a mezőny, a befutóra gyönyörű környezetben, a Bazilika lábánál került sor. A viadal történetében először született spanyol szakaszsiker.

EREDMÉNYEK

41. Tour de Hongrie

1. szakasz, Esztergom-Esztergom (118 km):

1. Jon Aberasturi (spanyol, Caja Rural-Seguros-RGA) 2:48:04

2. Kaden Groves (ausztrál, Mitchelton-Scott) azonos idővel

3. Adam Toupalik (cseh, Elkov-Kasper) a. i.

4. Kamil Gradek (lengyel, CCC Team) a. i.

5. David van der Poel (holland, Alpecin-Fenix) a. i.

6. Itamar Einhorn (izraeli, Israel Start-Up Nation) a. i.

18. Dina Márton (magyar, Kometa-Xstra) a. i.

27. Valter Attila (magyar, CCC Team) a. i.

46. Kusztor Péter (magyar, Team Novo Nordisk) a. i.

52. Szatmáry András (magyar válogatott) a. i.

 

Az összetett versenyben:

1. (sárga mezben az Aktív Magyarország díjáért) Jon Aberasturi (spanyol, Caja Rural-Seguros-RGA)

 

A gyorsasági pontversenyben:

1. (zöld mezben a Skoda és az Europcar díjáért) Jon Aberasturi (spanyol, Caja Rural-Seguros-RGA)

 

A hegyi pontversenyben:

1. (piros mezben a Cofidis díjáért) David Lozano (spanyol, Team Novo Nordisk)

 

A legjobb magyar versenyző:

1. (fehér mezben a Magyar Közút Zrt. és a Bringasportdíjáért) Dina Márton (Kometa-Xstra)

Forrás: tourdehongrie.hu

Ezek az írások is érdekelhetnek: