Wolmart - Responsive Marketplace HTML Template

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