(SELECT
cl.id,
cl.ro_title,
cl.ro_alias,
cl.ru_title,
cl.ru_alias,
cl.image,
ci.image_url AS image_second, -- Второе изображение
cl.price,
cl.price_sale,
cl.category,
cl.concept_id,
cl.room_id,
cl.views,
'product' AS pr_type,
cl.display_price,
cl.stock,
'0' AS sale,
CASE
WHEN co.catalog_id IS NOT NULL THEN 1
ELSE 0
END AS option_new
FROM catalog_list cl
LEFT JOIN catalog_options co
ON cl.id = co.catalog_id AND co.option = '2'
LEFT JOIN catalog_images ci
ON cl.id = ci.catalog_id
AND ci.id = (SELECT MIN(id) FROM catalog_images WHERE catalog_id = cl.id AND image_url <> cl.image) -- Первое изображение
WHERE
cl.public = '1'
AND `price_sale` > '0.00' AND `category` = '19'
AND cl.id NOT IN (SELECT catalog_id FROM catalog_options WHERE `option` = 5)
)
UNION
(SELECT
cg.id,
cg.ro_title,
cg.ro_alias,
cg.ru_title,
cg.ru_alias,
cg.image,
ci.image_url AS image_second, -- Второе изображение
cg.price,
'0' AS price_sale,
'0' AS category,
cg.concept_id,
cg.room_id,
cg.views,
'garniture' AS pr_type,
cg.price AS display_price,
'1' AS stock,
cg.sale,
'0' AS option_new
FROM `catalog_garniture` cg
LEFT JOIN catalog_garniture_images ci
ON cg.id = ci.catalog_id
AND ci.id = (SELECT MIN(id) FROM catalog_garniture_images WHERE catalog_id = cg.id AND image_url <> cg.image)
WHERE
cg.public = '1'
AND `sale` > '0' AND id > 10000
)
ORDER BY `ru_title` desc
LIMIT 0, 36;