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="nolan-es-x-lite-ujdonsagok-2010-re-2009-10-25"
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='448' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='448' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_news_hu WHERE ACTIVE="1" AND ID!="448" ORDER BY ID DESC
SELECT * FROM cms_1_news_hu WHERE ACTIVE="1" AND ID!="448" AND CATEG="3" ORDER BY ID DESC LIMIT 2
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1048' AND MAIN='1' AND CONTENTTYPE='2'
SELECT PICTURE FROM cms_1_pictures WHERE CONTENTID='1019' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='448' AND CONTENTTYPE='2' AND MAIN!='1' ORDER BY NO ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='448' 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')
Nolan és X-lite újdonságok 2010-re | 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 SzelesÚt 2009. okt 25.

Nolan és X-lite újdonságok 2010-re

Az olaszországi Vairano versenypályán, élversenyzők részvételével mutatta be a Nolan Group az X-lite X-802 és a Nolan N20 Traffic bukósisakok új,...

Az olaszországi Vairano versenypályán, élversenyzők részvételével mutatta be a Nolan Group az X-lite X-802 és a Nolan N20 Traffic bukósisakok új, 2010-es változatait.

Jorge Lorenzo (MotoGP, Yamaha), Marco Melandri (MotoGP, Hayate) és Carlos Checa (Superbike-világbajnokság, Honda) nemcsak a fejvédőkről mesélt az újságíróknak, hanem meg is motoroztatta a vállalkozó kedvű zsurnalisztákat - persze nem a versenygépek, hanem utcai masinák hátsó ülésén. 

A résztvevők nemcsak utasként, hanem pilótaként is kipróbálhatták a Nolan Group csúcs-versenysisakját, az X-lite X-802-t, amely hamarosan fekete-fehér Lorenzo replika fényezéssel is kapható lesz. Természetesen megmarad a kínálatban a spanyol pilóta híres „epres" festése, valamint a Melandri, Carlos Checa és Stoner replika is. 

A sajtótájékoztatón mutatták be a Fiat by Nolan kollekció tagjait, azaz a nyitott N20 Traffic bukósisak speciális fényezésű változatait is. Az új modellek a Fiat autómárkát illetve annak legdivatosabb típusát, az 500-ast népszerűsítik.

Ezek az írások is érdekelhetnek:
Így kezdi a Harley az évet

Így kezdi a Harley az évet

by SzelesÚt jan 25

Jön az új Transalp

Jön az új Transalp

by SzelesÚt nov 25