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

Query time 0.00071

Result

product_id file_id file file_alt big_file_id big_file big_file_alt small_file_id small_file small_file_alt
32940 408071 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_c54e48676752_32942_58f6016b5c8c_0_10ba36ea4c09_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.04_e3a2a6d8.jpg 408073 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_b2a5211ab116_32942_58f6016b5c8c_0_10ba36ea4c09_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.04_e3a2a6d8.webp 408075 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_5549252de8b7_32942_58f6016b5c8c_0_10ba36ea4c09_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.04_e3a2a6d8.webp
32940 408076 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_0f308b594ce6_32942_0601c57cec72_0_ac828cb1a75e_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-22%252520%2525D0%2525B2%25252012.14.30_3a05044f.jpg 408080 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_bc890ac72851_32942_0601c57cec72_0_ac828cb1a75e_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-22%252520%2525D0%2525B2%25252012.14.30_3a05044f.webp 408081 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_d0630b85f2f3_32942_0601c57cec72_0_ac828cb1a75e_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-22%252520%2525D0%2525B2%25252012.14.30_3a05044f.webp
32940 408082 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_3e5e50967c5d_32942_937da6812cc7_0_aa2fe583ec4a_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.17_9f705d97.jpg 408086 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_3a128c85d79c_32942_937da6812cc7_0_aa2fe583ec4a_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.17_9f705d97.webp 408087 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_2517d74d9b20_32942_937da6812cc7_0_aa2fe583ec4a_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.17_9f705d97.webp
32940 408088 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_df2a895896db_32942_af968c2ce584_0_2c289c9751ae_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.17_0f746e25.jpg 408091 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_299cc264e3d3_32942_af968c2ce584_0_2c289c9751ae_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.17_0f746e25.webp 408092 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_58993ed31e3c_32942_af968c2ce584_0_2c289c9751ae_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.17_0f746e25.webp
32940 408093 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_cbd78f37725a_32942_1ccd70fa9513_0_1a21f94f323e_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.15_83c30883.jpg 408094 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_a92a92239551_32942_1ccd70fa9513_0_1a21f94f323e_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.15_83c30883.webp 408095 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_d94782df0ce1_32942_1ccd70fa9513_0_1a21f94f323e_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.15_83c30883.webp
32940 408096 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_c4b7c2e58bb8_32942_1bfd5fe45fc4_0_12eb89ddeec6_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_b9ccadf2.jpg 408097 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_56781eea2415_32942_1bfd5fe45fc4_0_12eb89ddeec6_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_b9ccadf2.webp 408098 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_356c83df758e_32942_1bfd5fe45fc4_0_12eb89ddeec6_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_b9ccadf2.webp
32940 408099 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_e74fe32a5f91_32942_e4ed9670e62f_0_74a7a44c1413_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_e1d25e34.jpg 408100 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_44c65d0b72e2_32942_e4ed9670e62f_0_74a7a44c1413_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_e1d25e34.webp 408101 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_bf2380c72f1a_32942_e4ed9670e62f_0_74a7a44c1413_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_e1d25e34.webp
32940 408102 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_84298fa11c43_32942_f6a31217fcd4_0_59c1bbe88f71_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.16_5a321c23.jpg 408103 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_d38e88d967da_32942_f6a31217fcd4_0_59c1bbe88f71_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.16_5a321c23.webp 408104 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_8f82d5c5dbe2_32942_f6a31217fcd4_0_59c1bbe88f71_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.16_5a321c23.webp
32940 408105 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_7931b3afbed4_32942_a0e95544a0b3_0_b71b64ca402c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_9243ded3.jpg 408106 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_36ed596f605d_32942_a0e95544a0b3_0_b71b64ca402c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_9243ded3.webp 408107 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_702289542d85_32942_a0e95544a0b3_0_b71b64ca402c_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.03_9243ded3.webp
32940 408108 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_acc4fc99e034_32942_c81d55c388ac_0_ee35a414c540_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.04_d1f617ee.jpg 408109 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_848662a62ae9_32942_c81d55c388ac_0_ee35a414c540_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.04_d1f617ee.webp 408110 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_001ebe5a2d37_32942_c81d55c388ac_0_ee35a414c540_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-29%252520%2525D0%2525B2%25252012.28.04_d1f617ee.webp
32940 408111 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_bf99b3352270_32942_149330ea6d7a_0_8ccb727da656_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.16_72a78d46.jpg 408112 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_f043b3260279_32942_149330ea6d7a_0_8ccb727da656_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.16_72a78d46.webp 408113 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_6b4d8f7f8fc1_32942_149330ea6d7a_0_8ccb727da656_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-27%252520%2525D0%2525B2%25252012.32.16_72a78d46.webp
32940 408114 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_82cd68fd819e_32942_a39b92943343_0_bb97d8c80a1b_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-28%252520%2525D0%2525B2%25252013.56.11_d0f3a009.jpg 408115 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_0a0d6100cc0c_32942_a39b92943343_0_bb97d8c80a1b_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-28%252520%2525D0%2525B2%25252013.56.11_d0f3a009.webp 408116 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_52734d91a49b_32942_a39b92943343_0_bb97d8c80a1b_%2525D0%252598%2525D0%2525B7%2525D0%2525BE%2525D0%2525B1%2525D1%252580%2525D0%2525B0%2525D0%2525B6%2525D0%2525B5%2525D0%2525BD%2525D0%2525B8%2525D0%2525B5%252520WhatsApp%2525202025-01-28%252520%2525D0%2525B2%25252013.56.11_d0f3a009.webp
32940 408117 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_65cce330a149_32942_b64103683371_0_3e58b189191c_%2525D0%2525A1%2525D1%252585%2525D0%2525B5%2525D0%2525BC%2525D0%2525B0.jpg 408118 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_6a0afad7bf6a_32942_b64103683371_0_3e58b189191c_%2525D0%2525A1%2525D1%252585%2525D0%2525B5%2525D0%2525BC%2525D0%2525B0.webp 408119 https://s3.timeweb.cloud/482029f9-prod/products__images/32940_ed8148e1e443_32942_b64103683371_0_3e58b189191c_%2525D0%2525A1%2525D1%252585%2525D0%2525B5%2525D0%2525BC%2525D0%2525B0.webp