SELECT p.*, pr.*, pi.id AS main_image, pi.extension AS mainImageExtension, v.vat, p.id AS productId,
a.name as availability,
 `pi`.`id` AS `mainImage`, `pi`.`extension` AS `mainImageExtension`
FROM products_sets AS pr
LEFT JOIN products AS p ON p.id = pr.set_products_id
LEFT JOIN vats AS v ON v.id = p.vats_id
LEFT JOIN availabilities AS a ON a.id = p.availabilities_id
LEFT JOIN `products_images` AS `pi` ON `p`.`id` = `pi`.`products_id` AND `pi`.`main_image` = 1
WHERE pr.products_id = 2648472
ORDER BY p.active DESC, a.sequence ASC, pr.sequence ASC, pr.id DESC