SELECT 
  cscart_images_links.*, 
  cscart_images.image_path, 
  cscart_common_descriptions.description AS alt, 
  cscart_images.image_x, 
  cscart_images.image_y, 
  cscart_images.image_id as images_image_id 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images_links.detailed_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 = 'fr' 
WHERE 
  cscart_images_links.object_type = 'category' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    747, 746, 927, 924, 930, 904, 961, 962, 
    963, 964, 965, 966, 967, 968, 969, 970, 
    972, 971, 973, 902
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id

Query time 0.00107

Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE cscart_images_links range object_id object_id 81 20 Using index condition; Using filesort
1 SIMPLE cscart_images eq_ref PRIMARY PRIMARY 3 mahm3t_cs443.cscart_images_links.detailed_id 1 Using where
1 SIMPLE cscart_common_descriptions eq_ref PRIMARY PRIMARY 107 mahm3t_cs443.cscart_images.image_id,const,const 1 Using where

Result

pair_id object_id object_type image_id detailed_id type position emo_md5 image_path alt image_x image_y images_image_id
32627 747 category 0 28205 M 0 logo_1_1_VELUX_a9vs-wg.jpg 283 283 28205
32628 746 category 0 28206 M 0 logo_1_1_FAKRO_ez6h-m1.jpg 374 374 28206
32629 927 category 0 28207 M 0 logo_1_1_OPTILIGHT_tqzj-dg.jpg 200 200 28207
32630 924 category 0 28208 M 0 logo__1_1_RoofLITE__q7zj-eq.jpg 2434 2434 28208
32631 930 category 0 28209 M 0 logo_1_1_Skylight_on85-26.png 300 300 28209
32632 904 category 0 28210 M 0 1_1_Roto_1lut-04.jpg 800 800 28210
32633 961 category 0 28211 M 0 1_1wood_4fht-4i.jpg 875 875 28211
32634 962 category 0 28212 M 0 1_1_plastik_vira-a9.jpg 700 700 28212
32635 963 category 0 28213 M 0 1_1_pakietdwuszybowy_63xa-x8.jpg 875 875 28213
32636 964 category 0 28214 M 0 1_1_pakiettrojszybowy_r7dw-gu.jpg 875 875 28214
32637 965 category 0 28215 M 0 1_1_pakietczteroszybowy_4ev9-6w.jpg 875 875 28215
32638 966 category 0 28216 M 0 1_1__top_pivot_2ycw-70.jpg 3200 3200 28216
32639 967 category 0 28217 M 0 1_1_bottom_pivot_ghhk-y1.jpg 1024 1024 28217
32640 968 category 0 28218 M 0 1_1_wysokoosiowe_2wck-07.jpg 500 500 28218
32641 969 category 0 28219 M 0 1_1_VK_gajg-01.jpg 300 300 28219
32642 970 category 0 28220 M 0 1_1_top_hung_pivot_7aqt-07.jpg 2000 2000 28220
32643 972 category 0 28221 M 0 1_1_flashing_52gc-8v.jpg 1920 1920 28221
32644 971 category 0 28222 M 0 1_1_4b8g-i7.jpg 1509 1509 28222