SELECT

BE.ID IBLOCK_ELEMENT_ID

,BEP.IBLOCK_PROPERTY_ID

,BEP.VALUE

,BEP.VALUE_NUM

,BEP.ID PROPERTY_VALUE_ID

,BEP.DESCRIPTION

FROM

b_iblock B

INNER JOIN b_lang L ON B.LID=L.LID

INNER JOIN b_iblock_element BE ON BE.IBLOCK_ID = B.ID

LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID AND BEP.IBLOCK_PROPERTY_ID IN (283, 284, 285, 286, 287, 288, 289, 290, 296, 298, 311, 391, 392, 522, 523, 525, 527, 528, 529, 530, 531, 532, 533, 534, 535, 536, 617, 773, 774, 775, 776, 1042, 1043, 1044, 1045, 1050, 1051, 1052, 1053, 1054, 1055, 1058, 1061, 1062, 1063, 1069, 1074, 1079, 1080, 1082, 1084, 1085, 1086, 1087, 1089, 1090, 1091, 1092, 1095, 1096, 1097, 1098, 1099, 1100, 1101, 1102, 1103, 1104, 1106, 1107, 1108, 1109, 1110, 1111, 1114, 1115, 1116, 1117, 1118, 1119, 1120, 1121, 1122, 1123, 1124, 1125, 1126, 1127, 1128, 1129, 1130, 1131, 1132, 1133, 1134, 1135, 1136, 1137, 1138, 1139, 1140, 1142, 1143, 1144, 1145, 1146, 1147, 1148, 1149, 1150, 1151, 1153, 1154, 1155, 1156, 1157, 1158, 1160, 1161, 1162, 1163, 1164, 1165, 1167, 1168, 1169, 1170, 1171, 1172, 1173, 1174, 1175, 1176, 1177, 1178, 1179, 1180, 1181, 1182, 1183, 1184, 1185, 1186, 1187, 1188, 1189, 1190, 1191, 1192, 1193, 1194, 1195, 1196, 1197, 1198, 1199, 1200, 1201, 1202, 1203, 1204, 1205, 1206, 1207, 1208, 1209, 1210, 1211, 1212, 1213, 1214, 1215, 1216, 1217, 1218, 1219, 1220, 1221, 1222, 1223, 1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1245, 1246, 1247, 1248, 1249, 1250, 1251, 1252, 1253, 1254, 1255, 1256, 1257, 1258, 1259, 1260, 1261, 1262, 1263, 1273, 1279, 1288, 1290, 1293, 1294, 1295, 1296, 1297, 1298, 1299, 1318, 1319, 1320, 1321, 1322, 1323, 1324, 1963, 2003, 2008, 2010, 2015, 2017, 2019, 2020, 2023)WHERE 1=1

AND (

(((BE.ID IN (‘2227’, ‘2871’, ‘2041’, ‘2123’, ‘2445’))))

AND ((((BE.IBLOCK_ID = ‘9’))))

)

AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))

ORDER BY

BEP.IBLOCK_ELEMENT_ID