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

Plastpaller

Letvægtspaller

1200x1000mm

1200x800mm

800x600mm

Export og Lagerpalle
1200x1000mm
1200x800mm
800x600mm
Hygiejnepalle

1200x800mm

Plast pallerammer

Palleramme plast

1200x800mm
800x600mm
Pallerammer plast 

Plastpalle. Hygiejnepalle 1200x800mm. Plastpalle 600x800mm. Palleramme plast

 

Combox-as.dk bruger cookies til at give dig en god oplevelse og til at indsamle statistik, der kan være med til at forbedre brugeroplevelsen
Læs mere>>
Godkend