select TT.PROPERTY_53 as АЙДИ,
TT.PROPERTY_54 as Состав,
TT.PROPERTY_44 as Стоимость,
TT.PROPERTY_47 as СтоимостьДоставки,
TT.PROPERTY_73 as ДатаДоставки,
TT.PROPERTY_74 as ВремяДоставки,
TT.PROPERTY_60 as ИмяПокупателя,
TT.PROPERTY_67 as ИмяПолучателя,
TT.PROPERTY_61 as ТелефонПокупателя,
TT.PROPERTY_69 as НомерПолучателя,
TT.PROPERTY_62 as Email,
TT.PROPERTY_71 as АдресДоставки,
TT.PROPERTY_75 as ВремяДоставки,
GT.Name as Номенклатура
from b_iblock_element_prop_s10 as TT
left join b_iblock_element as GT ON GT.ID = TT.PROPERTY_53