Электронные компоненты

Array ( [0] => 0 [1] => 0.0021491050720215 [2] => 0.99610805511475 [3] => 1.3425469398499 [4] => 2.3367919921875 [5] => 3.8147740364075 [6] => 6.5625369548798 [7] => 6.9675590991974 [8] => 6.9675600528717 ) 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