Zahnpflege

Zahnpflege bei Katzen, Katzenzahnbürsten, Fingerzahnbürsten

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 >= '365' AND oxv_oxcategories_1_de.OXRIGHT <= '366' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542b56e58.74000468' Group by oxv_oxarticles_1_de.oxid ORDER BY `oxv_oxarticles_1_de`.`OXARTNUM` asc , oc.oxpos, oc.oxobjectid

Alle Artikel aus unserer Kategorie Zahnpflege

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 >= '365' AND oxv_oxcategories_1_de.OXRIGHT <= '366' AND oxv_oxcategories_1_de.OXROOTID = 'ad8479f2542b56e58.74000468' Group by oxv_oxarticles_1_de.oxid ORDER BY `oxv_oxarticles_1_de`.`OXARTNUM` asc , oc.oxpos, oc.oxobjectid

Trixie Zahnpflege-Gel mit Rindfleischgeschmack - 100g

UVP 3,99 €
3,49 € * 0,1 kg | 34,90 €/kg

Details ansehen

Trixie Finger-Zahnbürstenset - 2 Stück

UVP 1,99 €
1,59 € *

Details ansehen

Trixie 4er Zahnbürsten-Set für Katzen und kleine Hunde

UVP 2,99 €
2,39 € *

Details ansehen

Trixie Silikon-Finger-Zahnbürsten-Set

UVP 2,99 €
2,49 € *

Details ansehen

Trixie Dental Care Plaque-Stopper für Katzen - 70g

UVP 7,99 €
6,99 € * 0,07 1kg | 99,86 €/1kg

Details ansehen

PlaqueOff Animal

ab 49,90 € *

Details ansehen

Trixie Zahnpflege Einweg-Fingerpads - 50 Stück

UVP 6,99 €
5,99 € *

Details ansehen

cdVet dentaVet Gel 35 g

16,95 € * 0,035 kg | 484,29 €/kg

Details ansehen