SELECT `p`.`product_id`
FROM `j25_redshop_product` AS `p`
LEFT JOIN `j25_redshop_product_category_xref` AS `pc` ON `pc`.`product_id` = `p`.`product_id`
WHERE `p`.`published` = 1 AND `p`.`expired` = 0 AND `p`.`product_parent_id` = 0
GROUP BY `p`.`product_id`
ORDER BY p.product_name ASC, pc.product_id ASC

EURO-kasser

ARCA Eurokasser

Mange størrelser

ARCA Eurokasser Genbrug

400x300mm

600x400mm

ARCA Uni-kasser

400x300mm

600x400mm

Werit Eurokasser

400x300mm

600x400mm

800x600mm

 

Indsatsskuffer

Indsats til Euro kasser 

Dyno Eurokasse

400x300mm

600x400mm

Combox Transportkasser

600x400mm

ENB Kasser

Mange størrelser

 

  

 

Skillevæg

Flere højder

Vogn til kasser

600x400mm

800x600mm