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 2403 Trendy Women's Footwear with Modern Design
Tsh. 134,000.00
Tracer Aurora L 2237 Stylish Women's Shoes for Daily Comfort
Tsh. 119,000.00
Tracer Nova L 711 Futuristic Design Meets Everyday Comfort
Tsh. 139,000.00
Tracer Vortex 11c Lightweight Casual Shoes with Futuristic Style
Tsh. 115,000.00
Tracer Felicity L 2021 Stylish and Comfortable Women's Sneakers
Tsh. 109,000.00
Havaianas Flip Flop
Tsh. 45,000.00
Havaianas Multi Colour Flip Flops
Tsh. 45,000.00
