SELECT `iblock_element_dark_photo`.`PROPERTY_113` AS `DARK_PHOTO_VALUE`
FROM
`b_iblock_element` `iblock_element`
LEFT JOIN `b_iblock_element_prop_s11` `iblock_element_dark_photo` ON `iblock_element`.`ID` = `iblock_element_dark_photo`.`IBLOCK_ELEMENT_ID`
WHERE
`iblock_element`.`IBLOCK_ID` = 11 AND UPPER(`iblock_element`.`ACTIVE`) like upper('Y')
GROUP BY
`iblock_element`.`ID`, `iblock_element_dark_photo`.`PROPERTY_113`, `iblock_element`.`SORT`
ORDER BY
`iblock_element`.`SORT` ASC