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 ('194006', '164374', '49902', '228563', '238238', '230063', '234567', '172117', '191593', '191996', '248208', '475767', '49903', '196323', '52277', '473512', '52278', '52280', '52281', '164289', '164290', '96971', '190786', '192288', '228529', '192142', '64056', '192495', '232121', '73333', '64226', '164009', '166925', '234991', '164552', '164553', '64319', '47821', '171381', '170987', '164011', '64804', '164012', '171602', '171988', '172801', '52282', '189620', '189619', '165736', '141709', '190703', '243959', '243902', '191995', '147532', '114368', '192251', '192232', '192275', '150328', '191665', '193492', '39074', '194009', '194008', '194007', '627224', '455433', '64108', '166913', '234550', '165640', '235314', '235361', '171591', '507383', '171966', '63930', '169134', '166987', '189621', '189622', '519970', '519831', '527894', '228853', '73794', '191581', '527896', '72670', '70094', '52285', '49904', '190680', '614215', '614217', '219311', '457604', '190824', '63908', '100017', '63902', '63901', '227712', '190681', '502340', '52284', '194761', '52283', '519309', '519311', '526015', '232552', '52286', '553678', '58256', '617455', '458080', '52287', '52289', '52288', '52292', '52290', '58257', '52291', '192103', '52293', '52294', '193371', '193372', '99341', '393440', '393438', '99342', '52295', '52296', '458432', '393436', '458322', '458464', '458532', '460813', '458412', '458468', '458534', '52297', '52298', '52299', '52300', '52301', '458358', '99343', '120427', '170985', '368711', '189429', '42622', '42623', '54244', '77527', '458189', '257971', '194762', '52302', '250871', '52303', '58258', '52304', '58259', '41514', '41515', '472339', '253119', '43289', '250873', '38936', '268526', '192239', '219312', '170091', '51360', '51361', '138981', '66390', '186614', '575678', '190670', '190669', '92200', '219313', '219314', '41516', '49905', '555632', '106746', '169613', '467172', '138983', '189103', '138985', '365459', '96631', '96632', '58260', '52305', '197086', '250878', '166734', '171790', '171807', '171820', '457949', '167092', '171779', '38999', '187840', '168801', '167094', '192221', '52306', '42624', '43290', '236854', '42625', '236858', '253120', '38623', '38622', '217201', '253121', '99344', '198511', '519944', '365463', '57670', '186203', '55186', '257996', '365465', '365467', '585445', '585447', '219315', '258003', '258005', '106774', '497101', '172764', '57671', '553745', '219316', '251411', '251420', '365469', '365471', '365473', '192313', '171810', '246947', '192314', '192316', '192315', '192317', '171827', '171828', '58262', '96634', '66723', '49906', '49907', '154017', '154084', '67839', '169545', '41517', '192220', '172613', '169544', '41518', '287272', '42626', '42627', '456988', '253122', '236392', '171383', '236395', '171382', '189623', '258024', '219317', '51362', '190855', '192621', '97505', '49908', '170228', '170158', '165269', '56967', '56968', '52307', '52308', '52309', '297837', '189624', '241689', '169640', '72968', '192118', '72961', '258096', '164361', '368649', '248227', '196324', '99345', '99346', '99347', '186709', '258032', '171811', '173288', '165580', '165579', '165581', '164542', '167365', '54573', '54574', '68937', '170986', '187841', '58263', '73327', '73331', '73332', '42628', '138989', '51363', '51364', '560934', '164488', '502342', '49909', '191580', '568379', '63990', '50807', '50808', '52310', '253123', '99348', '632640', '99349', '258040', '197728', '54575', '258042', '197729', '258045', '258047', '171837', '56969', '56970', '219318', '99350', '41519', '41520', '171826', '237727', '99351', '99352', '632687', '99353', '99354', '632677', '187839', '58264', '58265', '58266', '58267', '73654', '614077', '96635', '96636', '593141', '187842', '608536', '258064', '458223', '458153', '106810', '106812', '397795', '172672', '165007', '99355', '632621', '258068', '258062', '186710', '493594', '173289', '169696', '70766', '458328', '49910', '609519', '197730', '198512', '138991', '258073', '258075', '609521', '197731', '258077', '70767', '138993', '405558', '192207', '51365', '194763', '194764', '242037', '217202', '602323', '602325', '49293', '365483', '186204', '56971', '57672', '258086', '52311', '457849', '460764', '365491', '590499', '219319', '189625', '219320', '189626', '194765', '57673', '169626', '66605', '234517', '166059', '457974', '172377', '150310', '166788', '192219', '154002', '231078', '231080', '231095', '231122', '231124', '73541', '167088', '171601', '191983', '455518', '455520', '166945', '627221', '171802', '171824', '273802', '563696', '568122', '241693', '168790', '193515', '238256', '64431', '250884', '234076', '241691', '173151', '169620', '164268', '48121', '237655', '250886', '248220', '64478', '248222', '613040', '167353', '172659', '509700', '542389', '172658', '172673', '586803', '586805', '248229', '39018', '39017', '186711', '194017', '171500', '472343', '326746', '461574', '250888', '469292', '250890', '243957', '187843', '192943', '193552', '193551', '193965', '193994', '117982', '193972', '39243', '517875', '52312', '258104', '96637', '96638', '52313', '58269', '52314', '52315', '171812', '186712', '186713', '99356', '99357', '258112', '258114', '258116', '219321', '56972', '258119', '56973', '610332', '52316', '186714', '599327', '194766', '187845', '475345', '193508', '99358', '99359', '525217', '193503', '533811', '64089', '458350', '458096', '52317', '458344', '590360', '590362', '521136', '237665', '169041', '164484', '379360', '64487', '169035', '165596', '237663', '164487', '64488', '197732', '379035', '258123', '458131', '77530', '258125', '258127', '169034', '169040', '79142', '241697', '64485', '165584', '164483', '379358', '197087', '165595', '64486', '237661', '241699', '164486', '614611', '614613', '614607', '614609', '186874', '193594', '250895', '237277', '609523', '173394', '234729', '173396', '234731', '229334', '99360', '632570', '43291', '49911', '457546', '49912', '51366', '172741', '64511', '56974', '56975', '594789', '56976', '165089', '169051', '171965', '171733', '250868', '469300', '459838', '57980', '52318', '258137', '106864', '171986', '73334', '73335', '233121', '519101', '38941', '172000', '166522', '52319', '57674', '365500', '57675', '365502', '57676', '57677', '52320', '52321', '58270', '188560', '234610', '164141', '48090', '171635', '193536', '235585', '188561', '39113', '188827', '197194', '106878', '542387', '190860', '614219', '186716', '186717', '186715', '186718', '58271', '258153', '58272', '258155', '458259', '186796', '229185', '228902', '64135', '258157', '258159', '38916', '194767', '219322', '56966', '73567', '507310', '53116', '229266', '627209', '220078', '193499', '193505', '233864', '70659', '70807', '57876', '196848', '367778', '198290', '198291', '198292', '198293', '57877', '196849', '367780', '603969')))) 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-1f894cb-2711.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
|