SELECT p.ref, e.filepath, e.filename
FROM ft_product p
JOIN ft_ecm_files e ON e.src_object_id = p.rowid
WHERE p.ref IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND e.entity = 1 AND e.position = 1
GROUP BY p.ref
Tracer Alexa L 2501 Modern Women's Sneakers for Effortless Style
Tsh. 134,000.00
Havaianas Slim Summer Light and Breezy Style for Warm Days
Tsh. 45,000.00
Havaianas Spring Fresh and Light Flip Flops for the Season
Tsh. 45,000.00
Havaianas Sunny LI Bright, Simple, and Stylish Flip Flops
Tsh. 45,000.00
Havaianas Top Camu Classic Flip Flops with a Camouflage Edge
Tsh. 45,000.00
