Trixie

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

Alle Artikel aus unserer Kategorie Trixie

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

Trixie Premio Chicken Bites - 100g

Trixie Premio Chicken Bites - 100g

UVP 1,99 €
1,69 € *
0,1 1kg | 16,90 €/1kg

Trixie Premio Omega Stripes Light 100g

Trixie Premio Omega Stripes Light 100g

UVP 2,49 €
2,29 € *
0,1 kg | 22,90 €/kg

Trixie Premio Duckies - 100g

Trixie Premio Duckies - 100g

UVP 2,29 €
1,89 € *
0,1 1kg | 18,90 €/1kg

Trixie PREMIO Rabbit Cubes - 100g

Trixie PREMIO Rabbit Cubes - 100g

UVP 2,79 €
2,49 € *
0,1 kg | 24,90 €/kg

Trixie PREMIO Fish Rabbit Stripes - 100 g

Trixie PREMIO Fish Rabbit Stripes - 100 g

UVP 2,49 €
2,19 € *
0,1 kg | 21,90 €/kg

Trixie PREMIO Carpaccio Ente und Fisch

Trixie PREMIO Carpaccio Ente und Fisch

2,39 € *
0,04 kg | 27,25 €/kg Details ansehen

Trixie Premio Banana Chicken 100g

Trixie Premio Banana Chicken 100g

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

Trixie PREMIO Chicken Drumsticks

Trixie PREMIO Chicken Drumsticks

UVP 2,29 €
1,99 € *
0,095 kg | 20,95 €/kg

Trixie PREMIO Cheese Chicken Stripes - 100g

Trixie PREMIO Cheese Chicken Stripes - 100g

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

Trixie Schoko-Drops - 75 g

Trixie Schoko-Drops - 75 g

UVP 1,49 €
1,39 € *
0,075 kg | 18,53 €/kg

Trixie Schoko-Drops - 200 g

Trixie Schoko-Drops - 200 g

UVP 2,79 €
2,59 € *
0,2 kg | 12,95 €/kg

Trixie Milch-Drops - 200 g

Trixie Milch-Drops - 200 g

UVP 2,79 €
2,59 € *
0,2 kg | 12,95 €/kg