SELECT t.sku, CONCAT('https://testrd.online', i.path) AS image, IF(i.caption <> '' AND i.caption IS NOT NULL, i.caption, CONCAT('Изображение ', t.short_name)) AS icaption, CONCAT('https://testrd.online', f.path) AS file, IF(f.caption <> '' AND f.caption IS NOT NULL, f.caption, CONCAT('Документация ', t.short_name)) AS fcaption FROM tmp_sku s JOIN tmc t ON t.sku = s.sku LEFT JOIN ( SELECT sku, MIN(img_order) AS min_img_order FROM images GROUP BY sku) AS mi ON mi.sku = t.sku LEFT JOIN images AS i ON i.sku = mi.sku AND i.img_order = mi.min_img_order LEFT JOIN ( SELECT sku, MIN(file_order) AS min_file_order FROM files GROUP BY sku) AS mf ON mf.sku = t.sku LEFT JOIN files AS f ON f.sku = mf.sku AND f.file_order = mf.min_file_order