SELECT melec_images.*, melec_images_links.*, melec_common_descriptions.description AS alt, melec_images.image_id AS images_image_id FROM melec_images_links LEFT JOIN melec_images ON melec_images_links.detailed_id = melec_images.image_id LEFT JOIN melec_common_descriptions ON melec_common_descriptions.object_id = melec_images.image_id AND melec_common_descriptions.object_holder = 'images' AND melec_common_descriptions.lang_code = 'ru' WHERE melec_images_links.object_type = 'category' AND melec_images_links.type = 'M' AND melec_images_links.object_id IN (4095, 6276, 4195, 4331, 7957, 3540, 3532, 4029, 9566, 4270, 4599, 4705, 4490, 4481, 4593, 11930, 4266, 7982, 4663, 3614, 3572, 7468, 9205, 3563, 10116, 7933, 10111, 3585, 7620, 4674, 3715, 3625, 3638, 4361, 7963, 7865, 8082, 7923, 7952, 10140, 4193, 12113, 4338, 3546, 3600, 3550, 4321, 3644, 3554, 3621, 3724, 3583, 3548, 3595, 3617, 3579, 3682, 4313, 3570, 3552, 3560, 3633, 3670, 3593, 3534, 3857, 3646, 4292, 3967, 3925, 3908, 3790, 4172, 3608, 3640, 3696, 4616, 8698) ORDER BY melec_images_links.position, melec_images_links.pair_id