SELECT t1.name, t2.uid_foreign FROM tx_bookentries_categories AS t1 LEFT JOIN tx_bookentries_entries_categoriesid_mm AS t2 ON t2.uid_foreign = '278' AND t2.uid_local = t1.uid WHERE t1.deleted = 0 AND t1.t3ver_state != 1
Schriftgröße: A A A Drucken Mobile Version





Verkaufspreis:
€ 14,90

Online-Shop

Online blättern

Ski Guide TV

Fakten

Sportarten:

Rodeln Snowboard Langlauf Touren Nachtski Nachtrodeln Skating Freeride

Bilder

Share |