nix artikelidsSQL: SELECT a.id FROM AppBundle:KatalogDaten a JOIN AppBundle:KatalogRubriken c WITH a.brandcode=c.brandcode AND a.master=c.master AND a.mandant=c.mandant and c.code=:rubrik JOIN AppBundle:KatalogThemen f WITH a.brandcode=f.brandcode AND a.master=f.master AND a.mandant=f.mandant and f.code=:thema WHERE a.status=8 AND a.mandant='RubiesNL' AND a.artikelart IN ('Artikel') AND a.warengruppe IN ('ACCESSOIRE','HAARTEILE','KOPFBEDECKUNGEN','KOSTUEME') ORDER BY a.master
 Rubies Netherlands b.v.
Info: B2B-Shop is tijdelijk gesloten
116248
Bos fee
2883780
Pink Rock Girl
3610382
Deluxe Doc Mcstuffins - Child
3630552
Newt Scamander Fantastic Beasts Classic kind