MySQL Query Error: SELECT BE.ID as ID,BE.IBLOCK_ID as IBLOCK_ID,BE.CODE as CODE,BE.XML_ID as XML_ID,BE.NAME as NAME,BE.ACTIVE as ACTIVE,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_FROM)>0, DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_FROM, '%d.%m.%Y')) as DATE_ACTIVE_FROM,IF(EXTRACT(HOUR_SECOND FROM BE.ACTIVE_TO)>0, DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y %H:%i:%s'), DATE_FORMAT(BE.ACTIVE_TO, '%d.%m.%Y')) as DATE_ACTIVE_TO,BE.SORT as SORT,BE.PREVIEW_TEXT as PREVIEW_TEXT,BE.PREVIEW_TEXT_TYPE as PREVIEW_TEXT_TYPE,BE.DETAIL_TEXT as DETAIL_TEXT,BE.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE,DATE_FORMAT(BE.DATE_CREATE, '%d.%m.%Y %H:%i:%s') as DATE_CREATE,BE.CREATED_BY as CREATED_BY,BE.TAGS as TAGS,DATE_FORMAT(BE.TIMESTAMP_X, '%d.%m.%Y %H:%i:%s') as TIMESTAMP_X,BE.MODIFIED_BY as MODIFIED_BY,BE.IBLOCK_SECTION_ID as IBLOCK_SECTION_ID,B.DETAIL_PAGE_URL as DETAIL_PAGE_URL,BE.DETAIL_PICTURE as DETAIL_PICTURE,BE.PREVIEW_PICTURE as PREVIEW_PICTURE,L.DIR as LANG_DIR,BE.XML_ID as EXTERNAL_ID,B.IBLOCK_TYPE_ID as IBLOCK_TYPE_ID,B.CODE as IBLOCK_CODE,B.XML_ID as IBLOCK_EXTERNAL_ID,B.LID as LID , CAT_PR.QUANTITY as CATALOG_QUANTITY, CAT_PR.QUANTITY_RESERVED as CATALOG_QUANTITY_RESERVED, IF (CAT_PR.QUANTITY_TRACE = 'D', 'Y', CAT_PR.QUANTITY_TRACE) as CATALOG_QUANTITY_TRACE, CAT_PR.QUANTITY_TRACE as CATALOG_QUANTITY_TRACE_ORIG, IF (CAT_PR.CAN_BUY_ZERO = 'D', 'N', CAT_PR.CAN_BUY_ZERO) as CATALOG_CAN_BUY_ZERO, CAT_PR.CAN_BUY_ZERO as CATALOG_CAN_BUY_ZERO_ORIG, IF (CAT_PR.NEGATIVE_AMOUNT_TRACE = 'D', 'N', CAT_PR.NEGATIVE_AMOUNT_TRACE) as CATALOG_NEGATIVE_AMOUNT_TRACE, CAT_PR.NEGATIVE_AMOUNT_TRACE as CATALOG_NEGATIVE_AMOUNT_ORIG, IF (CAT_PR.SUBSCRIBE = 'D', 'N', CAT_PR.SUBSCRIBE) as CATALOG_SUBSCRIBE, CAT_PR.SUBSCRIBE as CATALOG_SUBSCRIBE_ORIG, CAT_PR.AVAILABLE as CATALOG_AVAILABLE, CAT_PR.WEIGHT as CATALOG_WEIGHT, CAT_PR.WIDTH as CATALOG_WIDTH, CAT_PR.LENGTH as CATALOG_LENGTH, CAT_PR.HEIGHT as CATALOG_HEIGHT, CAT_PR.MEASURE as CATALOG_MEASURE, CAT_VAT.RATE as CATALOG_VAT, CAT_PR.VAT_ID as CATALOG_VAT_ID, 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, CAT_PR.PURCHASING_PRICE as CATALOG_PURCHASING_PRICE, CAT_PR.PURCHASING_CURRENCY as CATALOG_PURCHASING_CURRENCY, CAT_PR.TYPE as CATALOG_TYPE, CAT_PR.BUNDLE as CATALOG_BUNDLE 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_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.ID IN ('38447', '49714', '241424', '217407', '168983', '165653', '165654', '165606', '165607', '43306', '169594', '50876', '197946', '52815', '52816', '52817', '52818', '52819', '52820', '52821', '52822', '42818', '192477', '192478', '228663', '115552', '115618', '186914', '169014', '192374', '147769', '192154', '192326', '154672', '188653', '165042', '157572', '39005', '39006', '39007', '166918', '166797', '167140', '192124', '51514', '51515', '57739', '57740', '393002', '57741', '366438', '57742', '366440', '393004', '197768', '197769', '164508', '594480', '164503', '164507', '238689', '509829', '167005', '172710', '192125', '561622', '172711', '164506', '167006', '52823', '197947', '52824', '197948', '198583', '457857', '606396', '198584', '164498', '64350', '171350', '164500', '392994', '366444', '57743', '366446', '57744', '366448', '197770', '197771', '172708', '509831', '234060', '171352', '172709', '509835', '171351', '509833', '48100', '229884', '164497', '192690', '229414', '173324', '57148', '57745', '50877', '50163', '193598', '253339', '52825', '52826', '193987', '172728', '50878', '42819', '50879', '50880', '52827', '52828', '168902', '50881', '42820', '64468', '171603', '48095', '248734', '47962', '165013', '164376', '173275', '99045', '558545', '164364', '248689', '196270', '99044', '242013', '41777', '189796', '187481', '51516', '51517', '51518', '51519', '57149', '58410', '42821', '57150', '58411', '42822', '187482', '52829', '52830', '52831', '58412', '262814', '52832', '52833', '52834', '58413', '186996', '50164', '50165', '50166', '262820', '632408', '197949', '474589', '197269', '197107', '197270', '197108', '458019', '185873', '52835', '52836', '52837', '58414', '218173', '51520', '51521', '186915', '186916', '186919', '186918', '186917', '186920', '51522', '51523', '51524', '51525', '51526', '51527', '189122', '186921', '186922', '186923', '186924', '393322', '458129', '393242', '458050', '393324', '393244', '219639', '219640', '193585', '73370', '50167', '58415', '58416', '186925', '186926', '219641', '171800', '48175', '219642', '219643', '51528', '51529', '51530', '51531', '51532', '51533', '50168', '50169', '50170', '50171', '50172', '50173', '50174', '50175', '51534', '51535', '51537', '51536', '173489', '173490', '42823', '42824', '50176', '50177', '50178', '189123', '50882', '51538', '51539', '50179', '50883', '50884', '50885', '50886', '50180', '50181', '50182', '50183', '50184', '50887', '50185', '50888', '50186', '51540', '51541', '51542', '51543', '50889', '262849', '50891', '262852', '50893', '51544', '51545', '51546', '189124', '43399', '186273', '366453', '186274', '366455', '168963', '70826', '598518', '197950', '197951', '172705', '189188', '555913', '614585', '171968', '48248', '614588', '614590', '237720', '393330', '393332', '193646', '73651', '73652', '70692', '168771', '366457', '197952', '197772', '43400', '366459', '52838', '52839', '197773', '193988', '139522', '217384', '70806', '169075', '217385', '217386', '519839', '253340', '57746', '262868', '366461', '57747', '366463', '393008', '172748', '237729', '217387', '391477', '169076', '217388', '217389', '253341', '57748', '262876', '57749', '393006', '393010', '168763', '379514', '521341', '244869', '154065', '166022', '171152', '171150', '238694', '217390', '139600', '139602', '251409', '173329', '165608', '217391', '217392', '253342', '240661', '366465', '217393', '217394', '139611', '469644', '139613', '251418', '173330', '229166', '217395', '519821', '253343', '197774', '366467', '168767', '42825', '42826', '57151', '50092', '172147', '459900', '274050', '167104', '154068', '168768', '168769', '168772', '168986', '73452', '73454', '169563', '73646', '73647', '73648', '73649', '73653', '73656', '73657', '73660', '232675', '232678', '173306', '229133', '166193', '488580', '219644', '57152', '57153', '499490', '173478', '488582', '57154', '57155', '42827', '42828', '48231', '58417', '366469', '58418', '173365', '173199', '147918', '173314', '499492', '509837', '57156', '193660', '171465', '171462', '171823', '237106', '58419', '521174', '366471', '58420', '173312', '455392', '172075', '327240', '57157', '57158', '173313', '458064', '42829', '193601', '57159', '57160', '164434', '164435', '193969', '494944', '193977', '475018', '475020', '217396', '217397', '217398', '499494', '499496', '197775', '318320', '475024', '57161', '383091', '197109', '185874', '262910', '197271', '594919', '366475', '366477', '196422', '559261', '524786', '58421', '562166', '197110', '458675', '169646', '72969', '72980', '198585', '198586', '617922', '96748', '197272', '366481', '591041', '72970', '232050', '72982', '198587', '198588', '217400', '198589', '198590', '251341', '232054', '72984', '186275', '73619', '47752', '217402', '217403', '366483', '237723', '197776', '555915', '197777', '52840', '58422', '42830', '52841', '58423', '42831', '189126', '189125', '189128', '189127', '189129', '189130', '534823', '534825', '219645', '219646', '50187', '262933', '50188', '262935', '55284', '169089', '197953', '632496', '237731', '172746', '64540', '186927', '186928', '169561', '509839', '171803', '70700', '70701', '366485', '96749', '197778', '457972', '458496', '458416', '509841', '154072', '67873', '393334', '96750', '479187', '479185', '197779', '195059', '458037', '198591', '198592', '229406', '229410', '229412', '195060', '369283', '189131', '275912', '51547', '51548', '51549', '51550', '51551', '186276', '186277', '189132', '42832', '458240', '189133', '479437', '52842', '457827', '189134', '458336', '186278', '186279', '38691', '289488', '38517', '73575', '73578', '169114', '463877', '192087', '64191', '73611', '172053', '43401', '197273', '197274', '41778', '50189', '41779', '491611', '192089', '64570', '172060', '43402', '172937', '219647', '219648', '219649', '487673', '198593', '473751', '366497', '189135', '366499', '189136', '51552', '55285', '51553', '236060', '253344', '170352', '379872', '193920', '57162', '57750', '57163', '57751', '42833', '57164', '57752', '43403', '57165', '57753', '42834', '43404', '43405', '42835', '43406', '43407', '219650', '43408', '186280', '52843', '58424', '52844', '57166', '96751', '96752', '96753', '96754', '96755', '187990', '189797', '186929', '166967', '237629', '188655', '188654', '194013', '218174', '188657', '188656', '189138', '189137', '189139', '73566', '50894', '50895', '186930', '51554', '189140', '197954', '632553', '197955', '197956', '197957', '632528', '50190', '41780', '192271', '165548', '555920', '457953', '604836', '52845', '52846', '52847', '52848', '52849', '52850', '393198', '458420', '251383', '555922', '594921', '148108', '229250', '229420', '217404', '64425', '384046', '253345', '263018', '263020', '230073', '230069', '164035', '186931', '166978', '147774', '173295', '458002', '219651', '219652', '457951', '479183', '479181', '393012', '458017', '48084', '171612', '193979', '171614', '188559', '169087', '193665', '251402', '194039', '169069', '173367', '171039', '219653', '237778', '219654', '366505', '171738', '50191', '50192', '50193', '368884', '50194', '369049', '166707', '57167', '58426', '57168', '197958', '52852', '52854', '52851', '52853', '58425', '57169', '458310', '52855', '58427', '197960', '632421', '479479', '197959', '517818', '366509', '38619', '38616', '38618', '38617', '253346', '253347', '253348', '253349', '253350', '253351', '253352', '253353', '253354', '253355', '172378', '487760', '64181', '241797', '236063', '67611', '38760', '231922', '139568', '43410', '43409', '43412', '43411', '50195', '50896', '50897', '50196', '50898', '50899', '50197', '50900', '50901', '50198', '50902', '50903', '171539', '568398', '567844', '499503', '454841', '50199', '173487', '218175', '58429', '58428', '197111', '55286', '52856', '52857', '479350', '52858', '186932', '189141', '186933', '186934', '189142', '186936', '186935', '248738', '186937', '263063', '219656', '42836', '42837', '219657', '253356', '192662', '171841', '185875', '49411', '185876', '57170', '57171', '57172', '77726', '594923', '197112', '366512', '366514', '193806', '73702', '228757', '73703', '236948', '52861', '52859', '52860', '58430', '73704', '219658', '219659', '219660', '219661', '219662', '50200', '50201', '369047', '50202', '139570', '248687', '52866', '42838', '42839', '249631', '73559', '192169', '186938', '172800', '168949', '70764', '230021', '57173', '594925', '219663', '263086', '534304', '499507', '219664', '263088', '186939', '186940', '186941', '186942', '186943', '230023', '42840', '171517', '229107', '187999', '186944', '55287', '185878', '185879', '185880', '167368', '524080', '234573', '58431', '479232', '96756', '58432', '96757', '458285', '58433', '218176', '39042', '57754', '58434', '55288', '168953', '219665', '366516', '197961', '197962', '197963', '185881', '185882', '198595', '458330', '52864', '52863', '43413', '219666', '219667', '366520', '219668', '50904', '50203', '39041', '57755', '58435', '55289', '96758', '393066', '96759', '219669', '42841', '58436', '42842', '49412', '218177', '57756', '57174', '57757', '58437', '57758', '96760', '50905', '186282', '186281', '50906', '57759', '219670', '192178', '196423', '185877', '198594', '52862', '197113', '43414', '197275', '197276', '49414', '197277', '253357', '368831', '50204', '186283', '57760', '197780', '218178', '197278', '197279', '49415', '253358', '253359', '50205', '368719', '186284', '57761', '197280', '197781', '218179', '41781', '50907', '189143', '164599', '219671', '187991', '469614', '219672', '251387', '52865', '381443', '469620', '139576', '251389', '237432', '366523', '186947', '193797', '139580', '219673', '186945', '251393', '366525', '366527', '594927', '192199', '475029', '475031', '475033', '475036', '458444', '230106', '195061', '195062', '188658', '188659', '188660', '217405', '217406', '475040', '475042', '217409', '57175', '197114', '242017', '317102', '555927', '476871', '509848', '185883', '96761', '96762', '197281', '366529', '519823', '499513', '509850', '198596', '198597', '198598', '198599', '198600', '198601', '42843', '42844', '458348', '50206', '50908', '50207', '50909', '366531', '366533', '617512', '617514', '39047', '42845', '42846', '189798', '458297', '458277', '50910', '50911', '188662', '187993', '58438', '172024', '219674', '219675', '96763', '479166', '479168', '479170', '479164', '96764', '479172', '173257', '147973', '217410', '217411', '509852', '168762', '96765', '479174', '188663', '598535', '189458', '70768', '248694', '164442', '164444', '164443', '230065', '169050', '509854', '168765', '70698', '96766', '479176', '218707', '186946', '41782', '41783', '42847', '41784', '41785', '42848', '197964', '197965', '185884', '197966', '197967', '185885', '187994', '43415', '41786', '43416', '41787', '229396', '229398', '188665', '195063', '197782', '263186', '197783', '263189', '197968', '632417', '168583', '49416', '49417', '479450', '187996', '171468', '522505', '55290', '55291', '503269', '42849', '457111', '496442', '193359', '193360', '193361', '193919', '194048', '193364', '193365', '193366', '193367', '194049', '193917', '193916', '193355', '193356', '193357', '194018', '193368', '193369', '193370', '193921', '194019', '194052', '55292', '197969', '632565', '566496', '289382', '503271', '290547', '555929', '197970', '219676', '186948', '186949', '274060', '274062', '47942', '197971', '197972', '393542', '186285', '197973', '188666', '38966', '38967', '189799', '171476', '38964', '38965', '38963', '41788', '242019', '41789', '42850', '41790', '41791', '42851', '171471', '171460', '168900', '70744', '38629', '38630', '193577', '139588', '38968', '193578', '193976', '139590', '171464', '193985', '171474', '171472', '47951', '171475', '185886', '50912', '189144', '57176', '50208', '52867', '52868', '52869', '43417', '198602', '50913', '189145', '57177', '594929', '50209', '186286', '52870', '52871', '52872', '96767', '43418', '70745', '197974', '197975', '459243', '263223', '41792', '41793', '192152', '228485', '192165', '169720', '171463', '228489', '240663', '393130', '197976', '41794', '188667', '189800', '41795', '488586', '488588', '189801', '245001', '192166', '219677', '219678', '491442', '229557', '459475', '229559', '47940', '188077', '253360', '192691', '230035', '72943', '242021', '164501', '172702', '186950', '234156', '186287', '219679', '42852', '42853', '490990', '50210', '173172', '229064', '395100', '398104', '476878', '594931', '57762', '164032', '197282', '52873', '57178', '490820', '96768', '96769', '57179', '552497', '490824', '197283', '459337', '459340', '81172', '189146', '96771', '490822', '626672', '197784', '366541', '242025', '594933', '52874', '96772', '197785', '366543', '193582', '604621', '193583', '583640', '171447', '198603', '189147', '57180', '196424', '366545', '185887', '185888', '185889', '185890', '52875', '52876', '164470', '43419', '154121', '67996', '52879', '164471', '189148', '57181', '366547', '185891', '185892', '185893', '185894', '473764', '52880', '52878', '393126', '43420', '154119', '165554', '67995', '39046', '52877', '197977', '197978', '632365', '41796', '188661', '189802', '189803', '41797', '228477', '189804', '197979', '197980', '632524', '41798', '189806', '189805', '41799', '192151', '169725', '168899', '193974', '50211', '253361', '242028', '192692', '230037', '72944', '164502', '594395', '173176', '172703', '189149', '186951', '167002', '594935', '186288', '219680', '42854', '42855', '476884', '594937', '57763', '229959', '634065', '55293', '55294', '230071', '229268', '186952', '42856', '114297', '173296', '458092', '219681', '219682', '457947', '457945', '171613', '171630', '236845', '171615', '171631', '194005', '187998', '186953', '192230', '116176', '73461', '188668', '186955', '186956', '189150', '186954', '116181', '73462', '189151', '38640', '57182', '519913', '519915', '366549', '476887', '168863', '168864', '489470', '555931', '217413', '217415', '165006', '171806', '186289', '197284', '186290', '555933', '57764', '197285', '186291', '186292', '57765', '197286', '96773', '57183', '96774', '96775', '57184', '96776', '366551', '197287', '366553', '197288', '197289', '197290', '197291', '197292', '165590', '366555', '197293', '366557', '197294', '165568', '96777', '57185', '96778', '96779', '57186', '96780', '165574', '41801', '41800', '121073', '189152', '168981', '168982', '41802', '503274', '503276', '503278', '192693', '188000', '585928', '188001', '242031', '188002', '242033', '188003', '188004', '219683', '41803', '41804', '195064', '52881', '52882', '52883', '232340', '219684', '232344', '171799', '171783', '171784', '455314', '64534', '167380', '263319', '51555', '263322', '51556', '171801', '463914', '229181', '194067', '194073', '591092', '391475', '237710', '173372', '173373', '194041', '193629', '242035', '230128', '237684', '57188', '594939', '64520', '172743', '237686', '64494', '189153', '189154', '237030', '237032', '171805', '171842', '57189', '57190', '594941', '57191', '594943', '57192', '594945', '173361', '173360', '57193', '230087', '171835', '230089', '42857', '479563', '42858', '253362', '165617', '167379', '189155', '171832', '171804', '457026', '191416', '191417', '191418', '191419', '303052', '632435', '366561', '189807', '193698', '52886', '52884', '52885', '58439', '198604', '52887', '52888', '52889', '58440', '198605', '70769', '41805', '41806', '41807', '41808', '235058', '235060', '164583', '172001', '169109', '169112', '169575', '193595', '70778', '41809', '41810', '197981', '197982', '42859', '197983', '42860', '197984', '197985', '632472', '198606', '198607', '197986', '632543', '458070', '197987', '198609', '458151', '186293', '57194', '594947', '198608', '52891', '52892', '58441', '198610', '186294', '57195', '52893', '52895', '58442', '52890', '52894', '57196', '594949', '52896', '458213', '52897', '52898', '57197', '594951', '52899', '52901', '458098', '52900', '229400', '229404', '164475', '52902', '52903', '41811', '43421', '41812', '43422', '41813', '43423', '41814', '43424', '229402', '171616', '171594', '171617', '171596', '171598', '164445', '51557', '51558', '51559', '51560', '52907', '52904', '52905', '52906', '139777', '452110', '197989', '52908', '58443', '52909', '52910', '58444', '197988', '186295', '186296', '43425', '43426', '79237', '79239', '173480', '455273', '164467', '164466', '171627', '171626', '231308', '114338', '229139', '229408', '172725', '197991', '197990', '632538', '197993', '632549', '197992', '632604', '57198', '594953', '57199', '594955', '198611', '473768', '52911', '52912', '479248', '52913', '58446', '479251', '58445', '58447', '57200', '594957', '57201', '594959', '458035', '198612', '604877', '52914', '52915', '52916', '58449', '479255', '58448', '58450', '479257', '193568', '193567', '366575', '52917', '52918', '52919', '58451', '52920', '52921', '52922', '58452', '192267', '192283', '165546', '192269', '192284', '165547', '165540', '455338', '171618', '171632', '171619', '171595', '231312', '231310', '172726', '193971', '38962', '193973', '38960', '192261', '164463', '164462', '173308', '192262', '165541', '164465', '164464', '172727', '193581', '193580', '193966', '228565', '192281', '230041', '166976', '192263', '192276', '165542', '235351', '192264', '165543', '242039', '195065', '195066', '195067', '55295', '519380', '218708', '218709', '218710', '194283', '503290', '218711', '218712', '503282', '194282', '503284', '503286', '503288', '503292', '503294', '503296', '503298', '503300', '218714', '503303', '605673', '503305', '503307', '503309', '503311', '605675', '194284', '195068', '555935', '503314', '587987', '38448', '195069', '230017', '193544', '193543', '168950', '251405', '164291', '251414', '193557', '251423', '193556', '599317', '189156', '249700', '189157', '189158', '248680', '248682', '189159', '189160', '189161', '189162', '186958', '186957', '617516', '393574', '563547', '51561', '394807', '194016', '459906', '193970', '38958', '193975', '186961', '192249', '192244', '192227', '219685', '193534', '197994', '186962', '197995', '197996', '366577', '48031', '171532', '189163', '57202', '594961', '58453', '52923', '52924', '73565', '253363', '197997', '197999', '197998', '185895', '185896', '366579', '58454', '96781', '57203', '52926', '52925', '43427', '198613', '479234', '479236', '52927', '52928', '58455', '42861', '58456', '189164', '194015', '52929', '52930', '57204', '164457', '173268', '188006', '188005', '186963', '189165', '192266', '192289', '73664', '165545', '165549', '235732', '189166', '188008', '188007', '189167', '519712', '198039', '583553', '603056', '583520', '198103', '198104', '172479', '172043', '53903')))) AND (EXISTS ( SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID AND (((SITE_ID='s1'))) )) AND (((BE.ACTIVE_TO >= now() OR BE.ACTIVE_TO IS NULL) AND (BE.ACTIVE_FROM <= now() OR BE.ACTIVE_FROM IS NULL))) AND ((((BE.ACTIVE='Y')))) AND ((((BE.IBLOCK_ID = '1')))) ) AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))) AND (( B.ID IN ( SELECT IBLOCK_ID FROM b_iblock_group IBG WHERE IBG.GROUP_ID IN (2) AND IBG.PERMISSION >= 'R' AND (IBG.PERMISSION='X' OR B.ACTIVE='Y') ) OR (B.RIGHTS_MODE = 'E' AND EXISTS ( SELECT ER.ELEMENT_ID FROM b_iblock_element_right ER INNER JOIN b_iblock_right IBR ON IBR.ID = ER.RIGHT_ID INNER JOIN b_user_access UA ON UA.ACCESS_CODE = IBR.GROUP_CODE AND UA.USER_ID = 0 WHERE ER.ELEMENT_ID = BE.ID AND IBR.OP_EREAD = 'Y' )) )) ORDER BY CAT_PR.QUANTITY desc ,BE.NAME asc LIMIT 0, 12[[1021] Disk full (/tmp/#sql-temptable-5fe-1f6eb57-9e7.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
|