Nyelv
Belépés
Keresés
Elérhetőségeink
Cím: Budapest, 1036 Pacsirtamező u. 16. bejárat a Viador utca felől
Telefon: (+36 1) 453 0819
Fax: (+36 1) 453 0818
Skype: k2.si.snowboard.kozpont
Mobil: +36 30/995-2728
E-mail: k2@skiing.hu
Őszi nyitvatartás:
H-P: 10-18 óráig
SZ: 10-14 óráig
V: ZÁRVA
Kosár
Got error 28 from storage engine
SELECT a.news_id, headline, teaser, seo_url_default, pub_time FROM news_news as a, news_lang as b, news_categories_link as c WHERE a.news_id=b.news_id AND status='Y' AND a.news_id=c.news_id AND cid IN (2) AND lang='HU' ORDER BY pub_time DESC LIMIT 6
SELECT a.news_id, headline, teaser, seo_url_default, pub_time FROM news_news as a, news_lang as b, news_categories_link as c WHERE a.news_id=b.news_id AND status='Y' AND a.news_id=c.news_id AND cid IN (2) AND lang='HU' ORDER BY pub_time DESC LIMIT 6