SELECT 
  PI.product_id, 
  F1.id AS file_id, 
  F1.path AS file, 
  (
    SELECT 
      PI1.alt 
    FROM 
      `cscart_products__images` PI1 
    WHERE 
      PI1.original_file_id = F1.id
  ) AS file_alt, 
  F2.id AS big_file_id, 
  F2.path AS big_file, 
  (
    SELECT 
      PI2.alt 
    FROM 
      `cscart_products__images` PI2 
    WHERE 
      PI2.watermark_big_file_id = F2.id
  ) AS big_file_alt, 
  F3.id AS small_file_id, 
  F3.path AS small_file, 
  (
    SELECT 
      PI3.alt 
    FROM 
      `cscart_products__images` PI3 
    WHERE 
      PI3.watermark_small_file_id = F3.id
  ) AS small_file_alt 
FROM 
  `cscart_products__images` AS `PI` 
  LEFT JOIN `files` AS `F1` ON `F1`.`id` = `PI`.`original_file_id` 
  LEFT JOIN `files` AS `F2` ON `F2`.`id` = `PI`.`watermark_big_file_id` 
  LEFT JOIN `files` AS `F3` ON `F3`.`id` = `PI`.`watermark_small_file_id` 
WHERE 
  `PI`.`product_id` = 28902

Query time 0.00149

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28902 365047 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_e25faf07e727_28879_1c3464055a6e_0_e463959f0814_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192001.png 365048 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_c055b4df30f3_28879_1c3464055a6e_0_e463959f0814_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192001.webp 365049 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_a44333989bd2_28879_1c3464055a6e_0_e463959f0814_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192001.webp
28902 365050 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_b2953a183b17_28879_f7d79470b88a_0_972e717d26de_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192029.png 365051 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_20544c70a1ec_28879_f7d79470b88a_0_972e717d26de_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192029.webp 365052 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_6799a21e38f4_28879_f7d79470b88a_0_972e717d26de_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192029.webp
28902 365053 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_8f32884178a8_28879_cabb785cd573_0_d8edd597be7b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192046.png 365054 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_05168c4f359d_28879_cabb785cd573_0_d8edd597be7b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192046.webp 365055 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_d1c459ac7d48_28879_cabb785cd573_0_d8edd597be7b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192046.webp
28902 365056 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_af7d0391d2c3_28879_cc4e7597097c_0_81e754e5423f_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192114.png 365057 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_64ac9d4f0d39_28879_cc4e7597097c_0_81e754e5423f_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192114.webp 365058 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_88fb1b31fd1a_28879_cc4e7597097c_0_81e754e5423f_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192114.webp
28902 365059 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_fddf1b3e2ce7_28879_d1331bbb5f10_0_404337ab5074_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192134.png 365060 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_fbf648554092_28879_d1331bbb5f10_0_404337ab5074_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192134.webp 365061 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_c8300cd44717_28879_d1331bbb5f10_0_404337ab5074_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192134.webp
28902 365062 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_daede6780827_28879_98cd885edd31_0_d1e880cff591_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192431.png 365063 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_29b8d5abe954_28879_98cd885edd31_0_d1e880cff591_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192431.webp 365064 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_a785b6382013_28879_98cd885edd31_0_d1e880cff591_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192431.webp
28902 365065 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_9fdb25991be8_28879_a99d1264255d_0_e0d24de8266b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192357.png 365066 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_50a72760cb2d_28879_a99d1264255d_0_e0d24de8266b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192357.webp 365067 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_716bc04b6bc8_28879_a99d1264255d_0_e0d24de8266b_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192357.webp
28902 365068 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_081bb0130d60_28879_fdda3ac8500b_0_f1f76ff80d00_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192413.png 365069 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_24683effdc4c_28879_fdda3ac8500b_0_f1f76ff80d00_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192413.webp 365070 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_eb025cc2adb2_28879_fdda3ac8500b_0_f1f76ff80d00_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192413.webp
28902 365071 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_ed76b2b8783f_28879_d4acdc6fcae1_0_e25e0ea3a089_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192150.png 365072 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_0074027671d2_28879_d4acdc6fcae1_0_e25e0ea3a089_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192150.webp 365073 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_cf7a4de04c3b_28879_d4acdc6fcae1_0_e25e0ea3a089_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192150.webp
28902 365074 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_b48be44679d1_28879_80dfb355d0ad_0_5484ea8e2ac2_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192227.png 365075 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_b523b3679593_28879_80dfb355d0ad_0_5484ea8e2ac2_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192227.webp 365076 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_a8b64d566dcf_28879_80dfb355d0ad_0_5484ea8e2ac2_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192227.webp
28902 365077 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_b9b5dc4542d7_28879_094e2b7d4956_0_8228e62678ab_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192302.png 365078 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_43b664898983_28879_094e2b7d4956_0_8228e62678ab_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192302.webp 365079 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_037325c738ad_28879_094e2b7d4956_0_8228e62678ab_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192302.webp
28902 365080 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_3158e6ec11df_28879_dc17a5a84bf7_0_cadbd0114d35_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192319.png 365081 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_f67d6f3332b4_28879_dc17a5a84bf7_0_cadbd0114d35_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192319.webp 365082 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_4a78be3d2197_28879_dc17a5a84bf7_0_cadbd0114d35_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192319.webp
28902 365083 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_38059e802034_28879_46069123f226_0_c01ff4604cd7_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192341.png 365084 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_400a74f0cfd3_28879_46069123f226_0_c01ff4604cd7_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192341.webp 365085 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_c20e83b4f92b_28879_46069123f226_0_c01ff4604cd7_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192341.webp
28902 365086 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_d818429749a5_28879_935eb52b9dd1_0_9aab84df0a85_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192243.png 365087 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_353dd0f5b238_28879_935eb52b9dd1_0_9aab84df0a85_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192243.webp 365088 https://s3.timeweb.cloud/482029f9-prod/products__images/28902_82b08b8409de_28879_935eb52b9dd1_0_9aab84df0a85_%2525D0%2525A1%2525D0%2525BD%2525D0%2525B8%2525D0%2525BC%2525D0%2525BE%2525D0%2525BA%252520%2525D1%25258D%2525D0%2525BA%2525D1%252580%2525D0%2525B0%2525D0%2525BD%2525D0%2525B0%2525202024-12-18%252520192243.webp