Dokas

Hundesnacks vom Hersteller Dokas

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 >= '357' AND oxv_oxcategories_1_de.OXRIGHT <= '358' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542a33ba8.19039064' Group by oxv_oxarticles_1_de.oxid ORDER BY oxv_oxarticles_1_de.`oxtitle` asc , oc.oxpos, oc.oxobjectid

Alle Artikel aus unserer Kategorie Dokas

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 >= '357' AND oxv_oxcategories_1_de.OXRIGHT <= '358' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542a33ba8.19039064' Group by oxv_oxarticles_1_de.oxid ORDER BY oxv_oxarticles_1_de.`oxtitle` asc , oc.oxpos, oc.oxobjectid

Dokas 1m Kaurolle mit Ente - 315g

UVP 7,99 €
7,89 € * 0,315 kg | 25,05 €/kg

Details ansehen

Dokas 1m Kaurolle mit Huhn - 315g

UVP 7,99 €
7,89 € * 0,315 kg | 25,05 €/kg

Details ansehen

Dokas Dog Hühnerbrust Kaurolle 250 g

UVP 5,99 €
5,89 € * 0,25 kg | 23,56 €/kg

Details ansehen

Dokas Dog Hühnerbrustfilet mit Apfel 70 g

UVP 1,99 €
1,89 € * 0,07 kg | 27,00 €/kg

Details ansehen

Dokas Dog Hühnerbrustfilet mit Banane 70 g

UVP 2,19 €
2,09 € * 0,07 kg | 29,86 €/kg

Details ansehen

Dokas Dog Kauknochen mit Huhn - 5cm - 12 Stück

UVP 4,49 €
4,39 € * 12 Stück | 0,37 €/Stück

Details ansehen

Dokas Dog Lachs in Streifen 100 g

UVP 3,79 €
3,69 € * 0,1 kg | 36,90 €/kg

Details ansehen

Dokas Dog Snack Hühnchen-Rolle mit Ente 10g

UVP 0,69 €
0,59 € * 0,01 kg | 59,00 €/kg

Details ansehen

Dokas Dog Snack Hühnchen-Rolle mit Rind 10g

UVP 0,69 €
0,59 € * 0,01 kg | 59,00 €/kg

Details ansehen

Dokas Dog Snack Hühnerbrust getrocknet 70 g

UVP 1,99 €
1,79 € * 0,07 kg | 25,57 €/kg

Details ansehen

Dokas Dog Snack Insekten-Happen Mehlwürmer, Grillen, Karotte 100 g

UVP 2,49 €
2,39 € * 0,1 kg | 23,90 €/kg

Details ansehen

Dokas Dog Snack Insekten-Happen Mehlwürmer, Grillen, Süßkartoffel 100 g

UVP 2,49 €
2,39 € * 0,1 kg | 23,90 €/kg

Details ansehen