Outdoor-Katzenspielzeug, Außen-Kratzbäume

SELECT `oxv_oxarticles_1_de`.`oxid`, `oxv_oxarticles_1_de`.`oxshopid`, `oxv_oxarticles_1_de`.`oxparentid`, `oxv_oxarticles_1_de`.`oxvarstock`, `oxv_oxarticles_1_de`.`oxstock`, `oxv_oxarticles_1_de`.`oxstockflag`, `oxv_oxarticles_1_de`.`oxvarcount`, `oxv_oxarticles_1_de`.`oxvarname`, `oxv_oxarticles_1_de`.`oxtitle`, `oxv_oxarticles_1_de`.`oxvarselect`, `oxv_oxarticles_1_de`.`oxthumb`, `oxv_oxarticles_1_de`.`oxpic1`, `oxv_oxarticles_1_de`.`oxunitquantity`, `oxv_oxarticles_1_de`.`oxtprice`, `oxv_oxarticles_1_de`.`oxvat`, `oxv_oxarticles_1_de`.`oxvarminprice`, `oxv_oxarticles_1_de`.`oxskipdiscounts`, `oxv_oxarticles_1_de`.`oxprice`, `oxv_oxarticles_1_de`.`oxvarmaxprice`, `oxv_oxarticles_1_de`.`oxweight`, `oxv_oxarticles_1_de`.`oxunitname`, `oxv_oxarticles_1_de`.`oxpricec`, `oxv_oxarticles_1_de`.`oxshortdesc`, 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 >= '299' AND oxv_oxcategories_1_de.OXRIGHT <= '300' 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 Spielzeug & Ruheplätze

SELECT `oxv_oxarticles_1_de`.`oxid`, `oxv_oxarticles_1_de`.`oxshopid`, `oxv_oxarticles_1_de`.`oxparentid`, `oxv_oxarticles_1_de`.`oxvarstock`, `oxv_oxarticles_1_de`.`oxstock`, `oxv_oxarticles_1_de`.`oxstockflag`, `oxv_oxarticles_1_de`.`oxvarcount`, `oxv_oxarticles_1_de`.`oxvarname`, `oxv_oxarticles_1_de`.`oxtitle`, `oxv_oxarticles_1_de`.`oxvarselect`, `oxv_oxarticles_1_de`.`oxthumb`, `oxv_oxarticles_1_de`.`oxpic1`, `oxv_oxarticles_1_de`.`oxunitquantity`, `oxv_oxarticles_1_de`.`oxtprice`, `oxv_oxarticles_1_de`.`oxvat`, `oxv_oxarticles_1_de`.`oxvarminprice`, `oxv_oxarticles_1_de`.`oxskipdiscounts`, `oxv_oxarticles_1_de`.`oxprice`, `oxv_oxarticles_1_de`.`oxvarmaxprice`, `oxv_oxarticles_1_de`.`oxweight`, `oxv_oxarticles_1_de`.`oxunitname`, `oxv_oxarticles_1_de`.`oxpricec`, `oxv_oxarticles_1_de`.`oxshortdesc`, 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 >= '299' AND oxv_oxcategories_1_de.OXRIGHT <= '300' 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

Karlie Kitty Pool

UVP 25,99 €
22,99 € *

Details ansehen

Karlie In- und Outdoor Rascheltunnel FELINE CRUISER

UVP 41,99 €
32,99 € *

Details ansehen

Trixie Rascheltunnel Crunch - 50 cm

UVP 9,99 €
7,99 € *

Details ansehen

Trixie Rascheltunnel Crunch - 115 cm

UVP 12,99 €
10,99 € *

Details ansehen

Trixie Spieltunnel aus Nylon - 4 Eingänge

UVP 16,99 €
13,99 € *

Details ansehen

Trixie Katzenhaus Cat's Home mit Balkon

UVP 69,99 €
59,99 € *

Details ansehen

Dog Agility Mini-Tunnel - 35 x 100 cm

UVP 15,99 €
12,99 € *

Details ansehen