Our offer
Concrete Pump
Concrete Mixer Trailer
Skidder
Concrete Mixer truck with Pomp
Cranes
LOG Trailer
 
nv SECREMO
Rijksweg 78
B-3650 Dilsen-Stokkem
Belgium
SELECT A.*, B.picture_item_id, B.picture_item_name FROM se_tm_category_items A LEFT OUTER JOIN se_tm_pictures_items B ON A.category_item_id = B.category_item_id AND B.picture_item_type = 1 WHERE A.category_id = 2 AND A.category_item_online = 1 ORDER BY A.category_item_id DESC LIMIT 0, 12