Classic Trockenware

SELECT `oxv_oxarticles_1_de`.`oxid`, oxv_oxarticles_1_de.oxtimestamp FROM oxv_oxcategories_1_de LEFT JOIN oxv_oxobject2category_1 as oc ON oxv_oxcategories_1_de.oxid = oc.oxcatnid LEFT JOIN oxv_oxarticles_1_de ON oxv_oxarticles_1_de.oxid = oc.oxobjectid WHERE ( oxv_oxarticles_1_de.oxactive = 1 and oxv_oxarticles_1_de.oxhidden = 0 and ( oxv_oxarticles_1_de.oxstockflag != 2 or ( oxv_oxarticles_1_de.oxstock + oxv_oxarticles_1_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_1_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_1_de as art where art.oxparentid=oxv_oxarticles_1_de.oxid and art.oxactive = 1 and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) and ( ( ( select oxobjectrights.oxobjectid from oxobjectrights where oxobjectrights.oxobjectid = oxv_oxarticles_1_de.oxid and oxobjectrights.oxaction = 1 limit 1 ) is null ) ) ) and oxv_oxarticles_1_de.oxparentid = '' AND oxv_oxcategories_1_de.OXLEFT >= '311' AND oxv_oxcategories_1_de.OXRIGHT <= '312' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542a33ba8.19039064' Group by oxv_oxarticles_1_de.oxid ORDER BY oxv_oxarticles_1_de.`oxtitle` desc , oc.oxpos, oc.oxobjectid

Alle Artikel aus unserer Kategorie Classic Trockenware

SELECT `oxv_oxarticles_1_de`.`oxid`, oxv_oxarticles_1_de.oxtimestamp FROM oxv_oxcategories_1_de LEFT JOIN oxv_oxobject2category_1 as oc ON oxv_oxcategories_1_de.oxid = oc.oxcatnid LEFT JOIN oxv_oxarticles_1_de ON oxv_oxarticles_1_de.oxid = oc.oxobjectid WHERE ( oxv_oxarticles_1_de.oxactive = 1 and oxv_oxarticles_1_de.oxhidden = 0 and ( oxv_oxarticles_1_de.oxstockflag != 2 or ( oxv_oxarticles_1_de.oxstock + oxv_oxarticles_1_de.oxvarstock ) > 0 ) and IF( oxv_oxarticles_1_de.oxvarcount = 0, 1, ( select 1 from oxv_oxarticles_1_de as art where art.oxparentid=oxv_oxarticles_1_de.oxid and art.oxactive = 1 and ( art.oxstockflag != 2 or art.oxstock > 0 ) limit 1 ) ) and ( ( ( select oxobjectrights.oxobjectid from oxobjectrights where oxobjectrights.oxobjectid = oxv_oxarticles_1_de.oxid and oxobjectrights.oxaction = 1 limit 1 ) is null ) ) ) and oxv_oxarticles_1_de.oxparentid = '' AND oxv_oxcategories_1_de.OXLEFT >= '311' AND oxv_oxcategories_1_de.OXRIGHT <= '312' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542a33ba8.19039064' Group by oxv_oxarticles_1_de.oxid ORDER BY oxv_oxarticles_1_de.`oxtitle` desc , oc.oxpos, oc.oxobjectid

Classic Dog Pferdeohren mit Fell 250g

UVP 9,49 €
9,19 € * 0,25 kg | 36,76 €/kg

Details ansehen

Classic Dog Pansen Natur 5kg

UVP 48,99 €
47,99 € * 5 kg | 9,60 €/kg

Details ansehen

Classic Dog Ochsenziemerstücke 50 Stück

UVP 68,99 €
67,99 € * 1 Stück | 67,99 €/Stück

Details ansehen

Classic Dog Ochsenziemerstücke 12cm 5 Stück

UVP 8,99 €
8,69 € * 5 Stück | 1,74 €/Stück

Details ansehen

Classic Dog Ochsenziemer verpackt 1 Stück

UVP 14,99 €
14,49 € * 1 Stück | 14,49 €/Stück

Details ansehen

Classic Dog Ochsenschwanzspitzen 250g

UVP 4,49 €
4,29 € * 0,25 kg | 17,16 €/kg

Details ansehen

Classic Dog Luftröhren geschnitten 250g

UVP 4,99 €
4,79 € * 0,25 kg | 19,16 €/kg

Details ansehen

Classic Dog Lammpansen 250g

UVP 5,99 €
5,79 € * 0,25 kg | 23,16 €/kg

Details ansehen

Classic Dog Lammfüße 5 Stück

UVP 4,99 €
4,29 € * 5 Stück | 0,86 €/Stück

Details ansehen

Classic Dog Kauhufe 10 Stück

UVP 5,99 €
5,19 € * 10 Stück | 0,52 €/Stück

Details ansehen

Classic Dog Kaninchenohren 100g

UVP 3,99 €
3,19 € * 0,1 kg | 31,90 €/kg

Details ansehen

Classic Dog Kalbsunterbeine verpackt 1 Stück

UVP 4,49 €
4,29 € * 1 Stück | 4,29 €/Stück

Details ansehen