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 ('191707', '252961', '49739', '252962', '96607', '96608', '186679', '186681', '186680', '186683', '186682', '596957', '607771', '632083', '632168', '47897', '172617', '390887', '609148', '559864', '380542', '171111', '171136', '171102', '188541', '219286', '219287', '219288', '49863', '49864', '187829', '188540', '585435', '191718', '191719', '114226', '147649', '114232', '192217', '192236', '191807', '191808', '253096', '171106', '193926', '194758', '49284', '457022', '49865', '219289', '106419', '99306', '52229', '41471', '41473', '164970', '232258', '51347', '458004', '51349', '51350', '51351', '51352', '51353', '51354', '51355', '51356', '51357', '198429', '171133', '42606', '42607', '253097', '52230', '458526', '393456', '257660', '189606', '197726', '197080', '186684', '186685', '56958', '188542', '457992', '473494', '55794', '106430', '106432', '198430', '52232', '58221', '257668', '392836', '99309', '99307', '99308', '106441', '253098', '189607', '187465', '187466', '188543', '186686', '189007', '189008', '187830', '51358', '49286', '49866', '368677', '596466', '49867', '368599', '50804', '50805', '188544', '189608', '457803', '253099', '96609', '197081', '187467', '193931', '193929', '96610', '186200', '49287', '193930', '57667', '52233', '58222', '479095', '479097', '96611', '257679', '97493', '197727', '99310', '99311', '173462', '173463', '49288', '173063', '99312', '632384', '198431', '198508', '457715', '96612', '173064', '99313', '632440', '457580', '96613', '166778', '193932', '193928', '96614', '173059', '49289', '99314', '99315', '99316', '99317', '173060', '49290', '99318', '99319', '96615', '365386', '365388', '188545', '189009', '186687', '187468', '189609', '189610', '56959', '49291', '49868', '219290', '219291', '54569', '96616', '52234', '52235', '97494', '52237', '106475', '173133', '188546', '56960', '189611', '253100', '253101', '188547', '193066', '38778', '38683', '186201', '257708', '49869', '41475', '49870', '365390', '188548', '187831', '52239', '253102', '189612', '186689', '58223', '457941', '58224', '58225', '189010', '186688', '49871', '55183', '52240', '58226', '197082', '457875', '42608', '186691', '58227', '96617', '58228', '189011', '186690', '49872', '457780', '52241', '58229', '457825', '197083', '257730', '42609', '189012', '186693', '187470', '188549', '186692', '187469', '41476', '41477', '41478', '186694', '99320', '99321', '632610', '198432', '457883', '97495', '198433', '198434', '41480', '49873', '49874', '49875', '186202', '49292', '49876', '57668', '189613', '257744', '257746', '186695', '52242', '52243', '96618', '52244', '58230', '257752', '457909', '52245', '58231', '257755', '219292', '219293', '219294', '219295', '219296', '219297', '219298', '219299', '219300', '457897', '219301', '365400', '49877', '189013', '189014', '253103', '188550', '185796', '198509', '257760', '96619', '457807', '52246', '52247', '58232', '58233', '52249', '41482', '58234', '457986', '257769', '257771', '97496', '106544', '187832', '56961', '457901', '43286', '187833', '253104', '99322', '228399', '171119', '191703', '191709', '191708', '191706', '191710', '229905', '193414', '49878', '58235', '457927', '58237', '96620', '457921', '257780', '457931', '459417', '171120', '559763', '38957', '502332', '49879', '52250', '58238', '97497', '49880', '49881', '253105', '49882', '609647', '189614', '57669', '479087', '51359', '41484', '41485', '41486', '41487', '41488', '41489', '365404', '41491', '365406', '219302', '253106', '56962', '173465', '173464', '166767', '188551', '433658', '253107', '172616', '187834', '41492', '41493', '173461', '41494', '41495', '41496', '56963', '219303', '55184', '196321', '97498', '52251', '99323', '632228', '99324', '257800', '457831', '96621', '52252', '52253', '457887', '52255', '632069', '52256', '58239', '457889', '632028', '96622', '257811', '257813', '457893', '457988', '457990', '479071', '479075', '517761', '521152', '521150', '457879', '49883', '49884', '42610', '99325', '632057', '99326', '99327', '632036', '99328', '632064', '99329', '55185', '253108', '39170', '96623', '189615', '189616', '171104', '253109', '49885', '49886', '58241', '197084', '42611', '58242', '58243', '49887', '198435', '257827', '457514', '96624', '96625', '52257', '58244', '457877', '257833', '257835', '73432', '42612', '188552', '187835', '187836', '49888', '49889', '96626', '58245', '58246', '189015', '49890', '198436', '257842', '457516', '96627', '96628', '52258', '58247', '457784', '457885', '257848', '257850', '253110', '42613', '52259', '52260', '457943', '52262', '58248', '97499', '42614', '42615', '41498', '41499', '42616', '42617', '42618', '41500', '41501', '41502', '99330', '99331', '99332', '99333', '632112', '632260', '632430', '99334', '99335', '632161', '198437', '257866', '457907', '458627', '253111', '253112', '99336', '457829', '186696', '188553', '188554', '187838', '187837', '186697', '187471', '186698', '187472', '198510', '457811', '52263', '52264', '457911', '632020', '58249', '457956', '106649', '97500', '97501', '253113', '253114', '253115', '52266', '52267', '457881', '457905', '479083', '97502', '52269', '457833', '97503', '365431', '253116', '41504', '56964', '193417', '49891', '49892', '58250', '106665', '253117', '365433', '197085', '50806', '49893', '49894', '41505', '41506', '41507', '41508', '41509', '41510', '49895', '52271', '52272', '457895', '58251', '479077', '479079', '457903', '257906', '457805', '479081', '49896', '49897', '397754', '590178', '106677', '49898', '49899', '49900', '193933', '257910', '457774', '257912', '42619', '189617', '186699', '186700', '188555', '186705', '188556', '186703', '186702', '186704', '186701', '194759', '186706', '43287', '219304', '219305', '219306', '96629', '502334', '166776', '166781', '234464', '189016', '58253', '96630', '479099', '457835', '99337', '99338', '99339', '99340', '475343', '49901', '41512', '43288', '219307', '457760', '219308', '593883', '502336', '196322', '253118', '56965', '457809', '457925', '194760', '219309', '167243', '42620', '42621', '41513', '58255')))) 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-1f82f16-30e.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
|