Die irische Firma BACH steht seit mehr als 30 Jahren für klare und einfache Konzepte und gute, in der Praxis entwickelte und erprobte Produkte. Kein Schnickschnack und Firlefanz - Design und Qualität pur. Wie dieser Whiskey, den sie in der Nähe von Kilken
    select oxv_oxcategories_de.oxid as oxid, oxv_oxcategories_de.oxactive as oxactive, oxv_oxcategories_de.oxhidden as oxhidden, oxv_oxcategories_de.oxparentid as oxparentid, oxv_oxcategories_de.oxdefsort as oxdefsort, oxv_oxcategories_de.oxdefsortmode as oxdefsortmode, oxv_oxcategories_de.oxleft as oxleft, oxv_oxcategories_de.oxright as oxright, oxv_oxcategories_de.oxrootid as oxrootid, oxv_oxcategories_de.oxsort as oxsort, oxv_oxcategories_de.oxtitle as oxtitle, oxv_oxcategories_de.oxdesc as oxdesc, oxv_oxcategories_de.oxpricefrom as oxpricefrom, oxv_oxcategories_de.oxpriceto as oxpriceto, oxv_oxcategories_de.oxicon as oxicon, oxv_oxcategories_de.oxextlink as oxextlink , if( oxv_oxcategories_de.oxid not in ( select distinct oxcatnid from oxobject2category where oxobjectid in ( select oxid from oxv_oxarticles_de WHERE oxmanufacturerid = 'dafca2726d4fb6676d1fc1e1ea71e662' ) ), 1, 0) as oxppremove from oxv_oxcategories_de where 1 order by oxparentid, oxsort, oxtitle
*: inkl. MwSt., zzgl. Versandkosten.