|
Вы еще ничего не заказали
Типы товаров
|
MySQL Query Error: SELECT DISTINCT BE.ID as ID, FPV0.VALUE as PROPERTY_266_VALUE, FPV0.ID as PROPERTY_266_VALUE_ID , CAT_PR.QUANTITY as CATALOG_QUANTITY, CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE, CAT_PR.WEIGHT as CATALOG_WEIGHT, CAT_VAT.RATE as CATALOG_VAT, CAT_PR.VAT_INCLUDED as CATALOG_VAT_INCLUDED, CAT_PR.PRICE_TYPE as CATALOG_PRICE_TYPE, CAT_PR.RECUR_SCHEME_TYPE as CATALOG_RECUR_SCHEME_TYPE, CAT_PR.RECUR_SCHEME_LENGTH as CATALOG_RECUR_SCHEME_LENGTH, CAT_PR.TRIAL_PRICE_ID as CATALOG_TRIAL_PRICE_ID, CAT_PR.WITHOUT_ORDER as CATALOG_WITHOUT_ORDER, CAT_PR.SELECT_BEST_PRICE as CATALOG_SELECT_BEST_PRICE 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_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.ID=266 INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='PTYPE' INNER JOIN b_iblock_property FP2 ON FP2.IBLOCK_ID = B.ID AND FP2.CODE='BRAND' LEFT JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_element_property FPV1 ON FPV1.IBLOCK_PROPERTY_ID = FP1.ID AND FPV1.IBLOCK_ELEMENT_ID = BE.ID INNER JOIN b_iblock_element_property FPV2 ON FPV2.IBLOCK_PROPERTY_ID = FP2.ID AND FPV2.IBLOCK_ELEMENT_ID = BE.ID LEFT JOIN b_catalog_product CAT_PR ON (CAT_PR.ID = BE.ID) LEFT JOIN b_catalog_iblock CAT_IB ON ((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0) AND CAT_IB.IBLOCK_ID = BE.IBLOCK_ID) LEFT JOIN b_catalog_vat CAT_VAT ON (CAT_VAT.ID = IF((CAT_PR.VAT_ID IS NULL OR CAT_PR.VAT_ID = 0), CAT_IB.VAT_ID, CAT_PR.VAT_ID)) WHERE 1=1 AND ( ((((BE.IBLOCK_ID = '15')))) AND ((((BE.ACTIVE='Y')))) AND ((((CAT_PR.QUANTITY > '0')))) AND ((((FPV1.VALUE_NUM IN (17560951))))) AND ((((FPV2.VALUE_NUM IN (, 17560116, 17560118, 17560119, 17560120, 17560121, 17560122, 17560144, 17560145, 17560146, 17560147, 17560259, 17560291, 17560307, 17560308, 17560314, 17560319, 17560574, 17560575, 17560576, 17560577, 17560579, 17560582, 17560583, 17560584, 17560585, 17560587, 17560599, 17560600, 17560602, 17560603, 17560604, 17560605, 17560606, 17560607, 17560624, 17560630, 17560631, 17560632, 17560633, 17560634, 17560635, 17560636, 17560637, 17560643, 17560644, 17560645, 17560646, 17560647, 17560660, 17560672, 17560673, 17560674, 17560681, 17560682, 17560683, 17560688, 17560691, 17560692, 17560693, 17560787, 17560788, 17560789, 17560790, 17560791, 17560792, 17560793, 17560794, 17560795, 17560796, 17560797, 17560798, 17560799, 17560800, 17560801, 17560802, 17560803, 17560804, 17560805, 17560806, 17560807, 17560808, 17560809, 17560810, 17560811, 17560812, 17560814, 17560815, 17560816, 17560817, 17560818, 17560819, 17560820, 17560821, 17560822, 17560823, 17560824, 17560825, 17560826, 17560827, 17560828, 17560829, 17560830, 17560831, 17560832, 17560833, 17560834, 17560835, 17560836, 17560837, 17560838, 17560839, 17560840, 17560841, 17560842, 17560843, 17560844, 17560845, 17560846, 17560847, 17560849, 17560850, 17560851, 17560852, 17560853, 17560854, 17560855, 17560856, 17560857, 17560858, 17560859, 17560860, 17560861, 17560862, 17560863, 17560864, 17560865, 17560896, 17560952, 17560953, 17560954, 17560955, 17561018, 17561028, 17561031, 17561033, 17561041, 17561044, 17561045, 17561048, 17561049, 17561053, 17561054, 17561056, 17561059, 17561062, 17561063, 17561067, 17561071, 17561073, 17561075, 17561076, 17561078, 17561081, 17561083, 17561084, 17561088, 17561089, 17561092, 17561094, 17561100, 17561101, 17561105, 17561106, 17561107, 17561108, 17561109, 17561110, 17561111, 17561112, 17561113, 17561114, 17561115))))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) ORDER BY FPV0.VALUE asc [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 17560116, 17560118, 17560119, 17560120, 17560121, 17560122, 17560144, 17560145,' at line 23]
|