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_number ASC, pc.product_id ASC

Plastkasser

EURO-kasser

Arca

Dyno

Werit

Combox

 

Reolkasser

Lagerkasser

Flere modeller

Vogne og Reoler til kasser

Flere modeller

Plastkuffert

300x200mm

400x300mm

600x400mm

Forsendelseskasse

Klapkasser

400x300mm

600x400mm

600x800mm

 

Stabel og Stakbare

Specialkasser

Perforerede kasser

300x400mm

400x600mm

Indkøbskurv

 

Bigbokse og kar

Plastspande & Tønder

5L. - 1150L. 

Plastfade & Dunke

1L. - 220L.

Tanke

60L. - 4000L.

Plastpaller

1200x800mm

800x600mm

Pallerammer plast 

Skuffereol

Løse Skuffer