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 (
    105798, 105799, 106788, 106789, 107716, 
    107717, 108002, 108003, 108604, 108605, 
    108606, 108607, 108608, 108609, 109722, 
    109723, 109724, 109725, 109750, 109751, 
    109932, 109933, 109956, 109957, 110012, 
    110013, 110014, 110015, 110032, 110033, 
    110212, 110213, 110220, 110221, 110300, 
    110301, 110410, 110411, 110746, 110747, 
    110776, 110777, 110778, 110779, 110782, 
    110783, 110798, 110799, 110968, 110969, 
    110970, 110971, 110988, 110989, 110990, 
    110991, 110998, 110999, 111080, 111081, 
    111172, 111173, 111208, 111209, 111210, 
    111211, 111452, 111453, 111454, 111455, 
    111494, 111495, 111496, 111497, 111498, 
    111499, 111684, 111685, 239356, 239357
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id