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` = 28881

Query time 0.00096

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
28881 365089 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_5d5d358a5f38_28882_cc0e691d6b6f_0_15aaf11079f4_%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-17%252520151719.png 365090 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_742825c725dd_28882_cc0e691d6b6f_0_15aaf11079f4_%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-17%252520151719.webp 365091 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_f76f1fd44d7c_28882_cc0e691d6b6f_0_15aaf11079f4_%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-17%252520151719.webp
28881 365092 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_8de35f1fc9a7_28882_49beb84dfeaf_0_9478772d5954_%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-17%252520151804.png 365093 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_58d5fc375d4d_28882_49beb84dfeaf_0_9478772d5954_%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-17%252520151804.webp 365094 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_d7b708ffdf5b_28882_49beb84dfeaf_0_9478772d5954_%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-17%252520151804.webp
28881 365095 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_3ca3197b5559_28882_432dcd286874_0_9b53f020f774_%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-17%252520151827.png 365096 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_ce9bb54bbbb6_28882_432dcd286874_0_9b53f020f774_%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-17%252520151827.webp 365097 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_a7e1715af214_28882_432dcd286874_0_9b53f020f774_%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-17%252520151827.webp
28881 365098 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_c87b17b6a5c3_28882_35940a1265c5_0_7d31f2ea3677_%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-17%252520151849.png 365099 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_de9b23746515_28882_35940a1265c5_0_7d31f2ea3677_%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-17%252520151849.webp 365100 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_2fbb5dcdb63b_28882_35940a1265c5_0_7d31f2ea3677_%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-17%252520151849.webp
28881 365101 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_bbc94a529013_28882_49a35f8ebe38_0_70f2b04770e6_%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-17%252520151913.png 365102 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_e9f912dff9fd_28882_49a35f8ebe38_0_70f2b04770e6_%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-17%252520151913.webp 365103 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_1db0e4eca14a_28882_49a35f8ebe38_0_70f2b04770e6_%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-17%252520151913.webp
28881 365104 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_09946e3cd1d9_28882_9bd5f8aec4cc_0_961f8e87a292_%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-17%252520151944.png 365105 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_62a603a4f2bc_28882_9bd5f8aec4cc_0_961f8e87a292_%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-17%252520151944.webp 365106 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_ce45d7c24faf_28882_9bd5f8aec4cc_0_961f8e87a292_%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-17%252520151944.webp
28881 365107 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_0d1c4f0ce496_28882_fef12c4d7d3b_0_42f9b1cfa71c_%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-17%252520151958.png 365108 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_c6473fb8620a_28882_fef12c4d7d3b_0_42f9b1cfa71c_%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-17%252520151958.webp 365109 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_63443e53471e_28882_fef12c4d7d3b_0_42f9b1cfa71c_%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-17%252520151958.webp
28881 365110 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_5684ecd0222e_28882_aec22a43f640_0_0a757a206f7c_%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-17%252520152017.png 365111 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_7094c0672ecb_28882_aec22a43f640_0_0a757a206f7c_%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-17%252520152017.webp 365112 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_b2d4179c0e96_28882_aec22a43f640_0_0a757a206f7c_%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-17%252520152017.webp
28881 365113 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_e44f55f46f1c_28882_cb229211cc45_0_2c7340048d11_%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-17%252520152034.png 365114 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_bde5a54144ae_28882_cb229211cc45_0_2c7340048d11_%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-17%252520152034.webp 365115 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_f3f1210f62c7_28882_cb229211cc45_0_2c7340048d11_%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-17%252520152034.webp
28881 365116 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_786591d94911_28882_0e4b7d584216_0_ba08eaa33074_%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-17%252520152049.png 365117 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_b57a633bd971_28882_0e4b7d584216_0_ba08eaa33074_%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-17%252520152049.webp 365118 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_656e8f988e21_28882_0e4b7d584216_0_ba08eaa33074_%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-17%252520152049.webp
28881 365119 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_376a8c1cec85_28882_96b692026cbe_0_a1ee6439d74b_%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-17%252520152106.png 365120 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_cdfca014b2a7_28882_96b692026cbe_0_a1ee6439d74b_%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-17%252520152106.webp 365121 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_f7cd5bea5b0a_28882_96b692026cbe_0_a1ee6439d74b_%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-17%252520152106.webp
28881 365122 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_0dd5076c7891_28882_4dd4c9024374_0_3b6f2760f88a_%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-17%252520152123.png 365123 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_8cc40ce43930_28882_4dd4c9024374_0_3b6f2760f88a_%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-17%252520152123.webp 365124 https://s3.timeweb.cloud/482029f9-prod/products__images/28881_294a2f405582_28882_4dd4c9024374_0_3b6f2760f88a_%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-17%252520152123.webp