SELECT
cscart_images.*,
cscart_images_links.*,
cscart_common_descriptions.description AS alt,
cscart_images.image_id AS images_image_id
FROM
cscart_images_links
LEFT JOIN cscart_images ON cscart_images_links.image_id = cscart_images.image_id
LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id
AND cscart_common_descriptions.object_holder = 'images'
AND cscart_common_descriptions.lang_code = 'en'
WHERE
cscart_images_links.object_type = 'variant_image'
AND cscart_images_links.type = 'V'
AND cscart_images_links.object_id IN (
67592,
67593,
67626,
67627,
67628,
67629,
67630,
67631,
67632,
67633,
67634,
67635,
67636,
67637,
67638,
67639,
67640,
67641,
67642,
67643,
67644,
67645,
67646,
67647,
67648,
67649,
67650,
67651,
67652,
67653,
67662,
67663,
67680,
67681,
67682,
67683,
67684,
67685,
67686,
67687,
67970,
67971,
68392,
68393,
68394,
68395,
68396,
68397,
68398,
68399,
68400,
68401,
68402,
68403,
68404,
68405,
68406,
68407,
68408,
68409,
68410,
68411,
68412,
68413,
68414,
68415,
68416,
68417,
68418,
68419,
68634,
68635,
68636,
68637,
68638,
68639,
68640,
68641,
68642,
68643,
68644,
68645,
68646,
68647,
68648,
68649,
68650,
68651,
68652,
68653,
68654,
68655,
68656,
68657,
68658,
68659,
68660,
68661,
68662,
68663,
68664,
68665,
68666,
68667,
68668,
68669,
68670,
68671,
68672,
68673,
68728,
68729,
68730,
68731,
68732,
68733,
68734,
68735,
68736,
68737,
68738,
68739,
68740,
68741,
68742,
68743,
68744,
68745,
68746,
68747,
68748,
68749,
68750,
68751,
68752,
68753,
68754,
68755,
68756,
68757,
68758,
68759,
68760,
68761,
68762,
68763,
68764,
68765,
68766,
68767,
68768,
68769,
68770,
68771,
68772,
68773,
68774,
68775,
68776,
68777
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id