nix artikelidsSQL: SELECT a.id FROM AppBundle:KatalogDaten a WHERE a.status=8 AND a.mandant='RubiesNL' AND a.lizenz = 'TRANSROBDI' AND a.lizenzgeber = 'HASBRO' 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
333871
Optimus prime Sword & Shield set

333873
Bumblebee Sword & Shield Set - Child

118215
Bloody Bride
3880998
Tinker Bell Adult
3881541
Tweety Romper
3888830
Pink Cupcake Minnie - Child