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 ('38565', '255806', '365094', '187798', '196299', '38729', '188827', '73700', '186798', '218646', '218647', '196355', '99527', '502707', '188593', '70083', '187892', '191900', '67823', '102432', '41658', '102437', '168811', '66607', '44022', '102445', '73496', '488262', '227769', '191958', '168802', '602728', '602730', '602732', '114957', '193899', '233160', '233222', '102443', '63948', '164189', '166066', '455396', '569967', '113292', '457480', '260364', '260366', '219443', '502712', '365999', '555754', '41659', '575702', '557375', '555764', '502721', '502723', '39075', '58349', '44031', '188028', '155531', '502726', '170130', '187170', '50015', '458203', '99535', '555756', '522493', '609665', '194856', '587959', '564729', '502728', '555758', '366003', '366005', '587961', '219444', '493863', '190939', '190952', '457630', '51429', '194857', '38564', '555760', '502732', '457628', '197211', '219445', '555762', '67593', '194858', '260377', '219446', '502734', '194218', '52537', '614244', '64204', '39269', '613221', '194219', '194220', '52538', '187907', '189072', '189071', '189073', '189070', '52539', '459245', '52540', '555766', '560973', '457040', '113317', '165775', '467375', '457374', '113319', '194859', '557372', '585888', '170275', '231086', '231117', '231119', '170166', '170168', '170169', '170170', '231136', '171308', '502739', '502741', '502743', '260389', '170227', '390904', '191005', '187908', '219447', '193107', '555769', '522495', '42711', '42379', '50016', '555771', '171206', '234612', '164269', '167229', '167234', '463438', '217564', '190805', '555777', '555773', '555775', '602734', '170360', '218138', '52541', '97547', '163730', '64439', '57060', '241855', '494250', '459185', '459317', '459201', '459289', '494252', '459199', '459354', '188220', '188594', '50017', '50018', '50019', '543698', '555781', '555779', '52542', '502751', '194860', '555783', '39159', '167177', '219448', '194861', '51430', '502753', '502759', '502761', '557382', '555785', '188034', '502763', '502765', '219449', '502767', '502769', '50020', '62113', '194862', '194863', '218651', '502785', '260583', '48124', '63994', '237042', '171660', '64153', '171652', '534833', '73699', '534835', '534837', '70749', '70750', '70747', '70748', '218802', '193709', '504269', '291356', '561096', '220198', '220199', '220200', '519465', '195446', '48201', '589247', '38671', '38664', '196852', '169070', '57519', '48299', '38614', '38612', '191972', '192015', '228506', '230104', '64271', '187340', '141898', '190644', '192183', '192098', '93904', '154703', '164850', '73698', '233132', '233918', '166836', '166837', '234836', '164404', '235863', '171571', '64524', '171262', '192309', '53827', '53828', '186065', '187341', '189505', '230759', '165092', '193603', '167084', '234592', '235752', '189358', '189359', '220833', '220834', '239905', '218384', '218385', '229994', '140674', '53829', '42291', '42292', '42293', '42294', '197158', '53830', '198295', '51806', '196853', '458133', '367797', '53831', '186066', '198806', '198296', '78238', '186067', '198807', '197586', '198297', '198298', '78240', '186068', '198808', '197587', '568050', '188315', '167076', '455407', '167077', '165665', '234930', '173381', '148046', '173382', '42295', '188316', '188317', '188318', '154536', '73680', '154538', '73681', '188319', '188859', '188320', '562047', '198300', '186069', '198809', '198301', '186070', '198810', '38615', '38613', '188321', '193078', '193019', '193565', '193564', '171645', '154605', '62246', '62247', '62248', '62249', '249710', '249714', '606921', '165493', '234530', '165500', '165550', '165551', '68199', '252453', '252455', '252463', '252465', '252473', '252475', '252481', '528408', '140753', '140757', '140763', '140765', '140767', '140769', '140771', '140773', '249728', '249730', '249738', '249748', '249750', '249754', '249758', '249760', '198302', '198303', '246977', '230047', '194055', '64526', '218386', '456986', '534913', '50617', '57878', '198304', '55500', '606923', '198305', '217760', '191976', '187361', '140755', '64535', '188323', '229992', '109048', '64158', '190179', '171688', '229147', '229984', '186427', '50618', '57879', '53835', '193676', '166295', '70822', '171678', '567965', '64527', '140751', '186907', '116700', '193668', '64525', '186906', '173380', '165497', '62245', '186905', '171642', '167082', '241195', '632220', '606926', '217761', '171672', '229986', '252457', '249732', '249734', '187362', '64536', '249736', '64529', '187352', '190180', '252477', '171677', '171690', '186428', '50619', '57880', '53836', '193684', '164420', '171643', '48109', '171679', '488610', '435967', '172763', '186908', '229990', '186909', '167083', '249740', '186910', '188866', '234528', '230045', '172760', '229980', '171651', '246989', '605514', '246991', '193560', '194028', '246993', '229976', '455401', '64469', '196854', '217762', '187355', '188332', '187363', '249744', '68174', '188335', '249746', '193561', '38970', '64497', '171684', '173383', '186429', '50620', '57881', '252483', '193643', '527421', '235778', '166265', '460054', '171638', '171667', '236867', '43104', '165615', '64272', '188871', '167068', '167080', '171675', '196855', '217763', '249712', '249756', '171670', '171686', '173384', '186430', '50621', '57882', '193659', '235780', '70823', '171640', '171669', '171687', '64515', '435975', '43105', '234526', '48166', '64499', '377354', '187986', '242004', '192303', '455029', '325271', '62251', '167081', '169077', '171674', '167072', '57506', '57507', '57508', '57509', '198307', '55501', '198306', '198308', '198309', '198811', '198812', '55502', '55503', '252510', '173152', '196856', '55504', '198310', '198311', '188860', '51807', '51808', '188322', '249769', '187519', '188324', '188325', '188326', '187520', '188327', '393174', '188328', '218387', '368467', '534540', '368417', '50622', '220835', '192879', '455405', '252514', '217764', '217765', '64593', '220836', '220837', '218388', '64594', '218389', '218390', '367807', '188329', '249704', '249702', '53834', '220838', '488615', '187342', '220839', '53837', '57511', '197880', '367809', '140749', '249716', '229143', '51025', '249722', '249724', '187343', '249706', '57510', '218391', '51809', '186071', '198813', '556632', '43106', '217766', '171671', '57512', '367811', '70755', '43107', '249726', '187345', '187344', '187521', '57514', '367813', '53838', '249718', '51026', '187346', '249708', '57513', '195877', '218392', '51810', '186072', '198814', '556634', '43108', '236875', '217767', '57515', '187347', '187348', '187522', '228365', '242807', '57516', '252525', '51811', '55505', '196857', '53839', '367815', '252516', '140791', '50623', '252518', '252520', '38650', '249763', '230253', '252523', '50624', '198815', '197159', '252527', '253719', '43109', '140800', '253720', '38931', '249767', '192176', '154778', '166910', '557554', '39002', '38703', '50625', '50626', '165047', '460056', '173166', '217768', '218393', '188858', '217769', '51027', '253721', '43110', '38653', '252530', '187350', '43602', '220840', '195878', '191968', '191969', '229974', '173298', '94492', '64116', '220841', '242805', '220842', '42296', '195879', '49626', '50627', '218394', '57883', '197588', '140809', '43111', '43603', '64592', '217770', '217771', '218023', '189793', '186431', '556636', '186432', '220843', '220844', '53832', '556638', '64435', '220845', '186433', '500942', '64432', '64433', '53833', '72997', '253722', '496450', '171737', '253723', '50628', '187351', '187353', '69990', '173378', '198312', '198313', '198314', '220846', '198816', '53840', '197160', '197161', '197589', '43604', '198817', '186434', '196858', '367817', '522423', '193554', '193553', '458253', '186435', '57884', '470437', '198315', '188861', '42297', '42298', '169071', '169743', '73682', '169072', '169744', '73684', '188330', '55506', '229988', '50629', '50630', '43112', '43113', '42299', '42300', '42301', '168929', '186436', '57885', '186437', '57886', '198316', '281261', '43114', '43115', '42302', '42303', '42304', '195880', '195881', '195882', '42305', '458683', '42306', '195883', '252541', '252543', '252545', '252547', '192179', '193529', '188869', '187349', '64461', '252549', '193525', '140825', '50631', '43116', '43117', '43118', '188331', '50632', '218395', '188333', '188334', '50633', '218396', '217772', '217773', '218397', '218398', '367827', '487873', '390535', '168991', '195884', '187354', '567973', '195885', '57518', '197881', '57887', '51028', '249742', '57517', '220847', '218399', '51812', '186073', '198818', '53841', '556642', '449054', '405450', '171639', '64514', '217774', '195886', '367829', '556644', '187356', '187357', '187358', '57521', '197882', '367831', '57888', '458145', '249720', '51029', '188336', '249752', '188337', '154336', '367833', '220848', '218400', '51813', '53842', '186074', '198819', '217775', '195887', '367835', '187359', '187360', '458147', '367837', '48300', '192311', '192312', '69257', '220849', '169073', '627197', '220850', '42307', '186438', '51814', '188862', '188863', '188864', '53843', '53844', '58610', '38972', '53846', '51815', '53845', '58611', '38971', '53848', '186439', '196859', '53847', '58612', '51816', '188865', '186440', '53849', '58613', '53850', '188338', '188339', '220851', '43119', '43605', '42308', '50634', '49627', '57889', '253724', '43606', '186441', '50635', '49628', '57890', '367839', '253725', '43607', '218401', '253726', '186075', '43120', '43608', '42309', '51030', '49629', '220852', '253727', '43609', '50636', '49630', '220853', '253728', '43610', '253729', '43611', '252539', '55507', '53851', '64504', '167078', '234533', '167070', '188340', '188341', '165492', '70756', '167071', '70521', '198820', '198821', '146751', '150209', '169053', '157797', '73679', '158082', '158084', '191973', '191977', '192306', '192307', '192308', '165040', '73713', '38724', '455452', '188342', '48108', '188867', '188868', '169031', '169038', '169030', '169037', '237669', '237671', '367841', '196860', '53852', '367843', '603615', '57522', '220854', '38670', '167065', '66132', '228512', '62254', '165039', '62255', '197590', '197591', '39003', '38998', '38943', '38938', '191981', '247023', '605516', '367845', '220855', '42310', '186442', '218402', '51817', '55508', '197592', '43612', '43613', '530412', '50637', '43614', '50638', '186076', '38709', '38700', '198317', '198318', '198822', '198319', '53853', '50640', '50639', '198320', '241201', '198823', '565116', '53854', '51031', '369073', '252461', '193672', '369359', '252459', '50641', '198824', '186078', '198825', '53855', '198321', '50642', '632398', '164414', '198322', '53856', '369093', '51032', '252471', '193687', '252469', '193686', '167073', '196861', '230110', '235704', '70754', '605518', '38663', '50643', '196862', '198826', '53857', '367849', '50645', '50644', '49631', '62250', '196863', '171649', '53858', '367851', '241206', '198323', '51033', '49632', '369405', '252479', '193637', '198827', '556647', '194036', '193633', '167064', '186081', '196864', '198828', '53859', '367853', '50646', '49633', '64498', '634111', '367855', '186082', '198324', '53860', '51034', '369126', '49634', '252487', '193657', '198829', '252485', '193654', '198830', '198831', '230112', '49635', '164415', '62252', '191974', '39433', '191975', '242809', '38611', '114397', '229972', '173302', '168930', '165485', '64595', '43121', '43122', '253730', '253731', '460058', '218893', '253732', '253733', '140781', '167079', '220856', '220857', '253734', '187523', '154601', '50647', '49636', '51818', '598505', '193677', '68197', '43123', '43615', '57891', '51819', '253735', '43616', '53861', '253736', '186443', '57892', '198832', '393346', '253737', '42312', '43124', '43617', '186444', '186445', '57893', '197593', '253738', '187524', '154603', '50648', '49638', '51820', '193683', '68198', '43125', '43618', '154607', '68200', '57894', '51821', '253739', '169088', '43126', '43619', '53862', '253740', '186446', '57895', '198833', '197594', '458195', '164416', '253741', '42313', '43127', '43620', '186447', '186448', '186449', '220858', '220859', '165496', '167075', '167074', '39013', '39014', '186083', '367859', '42314', '43621', '73675', '73677', '220860', '220861', '169733', '73667', '73671', '168926', '164281', '164562', '218024', '459898', '252533', '39432', '234086', '70757', '166912', '466088', '194490', '218894', '505396', '188870', '192304', '192305', '193678', '460060', '253742', '253743', '188872', '51822', '189360', '154530', '186450', '57523', '49639', '50649', '57896', '55509', '193658', '234521', '51823', '43622', '253744', '43623', '253745', '253746', '324980', '186451', '57897', '167066', '164407', '253747', '43128', '42315', '43624', '192302', '55510', '43129', '197595', '51824', '242811', '189361', '154532', '186452', '57524', '50650', '57898', '55511', '193638', '167063', '234523', '164406', '68175', '51825', '43625', '253748', '192310', '229982', '167069', '43626', '253749', '253750', '186453', '57899', '197596', '167067', '55512', '253751', '43130', '247025', '42316', '43627', '165506', '73673', '116320', '73678', '220862', '220863', '169734', '73669', '73672', '198325', '234552', '229145', '157496', '116530', '73688', '73689', '73690', '73691', '73692', '169746', '73694', '164411', '191982', '55513', '55514', '55515', '220864', '165495', '188857', '191059', '53863', '237327', '171051', '64584', '68568', '464986', '559052', '252467', '38710', '38701', '193682', '460062', '195888', '195889', '196865', '70758', '189362', '458320', '172043', '229149', '171641', '66421', '197597', '487196', '141427', '487199', '487205', '167245', '487234', '487237', '187364', '73156', '191913', '172425', '507341', '114953', '164157', '64000', '188343', '97775', '187365', '187366', '187367', '187368', '42317', '42318', '188165', '53864', '488420', '221063', '556781', '196043', '221089', '168812', '649525', '50703', '190690', '557573', '556258', '505995')))) 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-2195471-6d6.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
|