Kevin Young
MySQL Query Error: SELECT 'x' 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.CODE='COLOR_FILTER' INNER JOIN b_iblock_property FP1 ON FP1.IBLOCK_ID = B.ID AND FP1.CODE='BREND' 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 left join b_catalog_product as CAT_PR on (CAT_PR.ID = BE.ID) left join b_catalog_iblock as 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 as 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 = '8')))) AND (EXISTS ( SELECT IBLOCK_ID FROM b_iblock_site WHERE IBLOCK_ID = B.ID AND (((SITE_ID='s1'))) )) AND ((((B.ACTIVE='Y')))) 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.ID IN ('14859', '32266', '32286', '32304', '32307', '32322', '32356', '32358', '32461', '32478', '32523', '32536', '32560', '32569', '32349', '32631', '32633', '32667', '32740', '32763', '32778', '32891', '32924', '32942', '32543', '33051', '33068', '33195', '33213', '33263', '33274', '33278', '33289', '33303', '33307', '33320', '33321', '32258', '33378', '33512', '33539', '32976', '32496', '33552', '32544', '33591', '33622', '32858', '33687', '33709', '33081', '33411', '32472', '33852', '33874', '33083', '33695', '32717', '32367', '33120', '33977', '33287', '34006', '34048', '34058', '34068', '33425', '34039', '33479', '34131', '33262', '34081', '32517', '33298', '34255', '34098', '32644', '32433', '32695', '34198', '32903', '33472', '32316', '33249', '34439', '34382', '34111', '33739', '34365', '33143', '32494', '33059', '32570', '33712', '33436', '34040', '33819', '33162', '34626', '33272', '32234', '32238', '33015', '33948', '33770', '34659', '33484', '43602', '43699', '43713', '34245', '44018', '44047', '44099', '32432', '32227', '32418', '33342', '44710', '32233', '44700', '44848', '44849', '44876', '34613', '44875', '44891', '45039', '45037', '32719', '44882', '44844', '33794', '35894', '33854', '45534', '45542', '33590', '34453', '34146', '32294', '45976', '34568', '46227', '45538', '46622', '46887', '46889', '33543', '29972', '47398', '47441', '47474', '47687', '47827', '47828', '47831', '47876', '34182', '34009', '33516', '48708', '33394', '48768', '48772', '48855', '34561', '46864', '49274', '49275', '49277', '49280', '49360', '32272', '50129', '33110', '32331', '34374', '47712', '34137', '50962', '51094', '51455', '51456', '51460', '51454', '47809', '44699', '51815', '33596', '34148', '34056', '45468', '44898', '33701', '34562', '46431', '33494', '47017', '33904', '34270', '32303', '29974', '33091', '44046', '32832', '32471', '47654', '45535', '34346', '43704', '46880', '44546', '34670', '53019', '53021', '53028', '34602', '53394', '53412', '49497', '53828', '53911', '54038', '54039', '33972', '33369', '54355', '54560', '54644', '54668', '49685', '54758', '54759', '54767', '54776', '54783', '54784', '54815', '54777', '54766', '55521', '54627', '54582', '54642', '44775', '44169', '34196', '32760', '50955', '50961', '56241', '56242', '56244', '56246', '56265', '33250', '55205', '55502', '33542', '55881', '57080', '57086', '57112', '32786', '32264', '57789', '57566', '48061', '58028', '58044', '34308', '58203', '58318', '58361', '58364', '58421', '57409', '58459', '58363', '58362', '33024', '58640', '53737', '58715', '57135', '33304', '58908', '58918', '58984', '59091', '34500', '51421', '59303', '53097', '46670', '54341', '54523', '59542', '34592', '34574', '59298', '57120', '57797', '57792', '33857', '59090', '60988', '61142', '61143', '61144', '61145', '34324', '33305', '60989', '49938', '34507', '53460', '60803', '60151', '62627', '52021', '58101', '46790', '55907', '60057', '46755', '57563', '64258', '65032', '46401', '57839', '61148', '47733', '65391', '63928', '65484', '65485', '65491', '65492', '65493', '65494', '65495', '65496', '46430', '65498', '53917', '65658', '65678', '59356', '66145', '66146', '66147', '66197', '66213', '66221', '66222', '66224', '66226', '66237', '66238', '66242', '66251', '66255', '66521', '66522', '66532', '66543', '57791', '58654', '63927', '66776', '66791', '66809', '67310', '67473', '50632', '66195', '67918', '67919', '68014', '68354', '68396', '68401', '68437', '68400', '68741', '33731', '68131', '68080', '67432', '67322', '69776', '67920', '67675', '70262', '70265', '70268', '70269', '70271', '56115', '70835', '70860', '71371', '71379', '71384', '71559', '71620', '72227', '68819', '71615', '72335', '72325', '72323', '72322', '72318', '71616', '72541', '72542', '72545', '72546', '72595', '72540', '72676', '72956', '54880', '73168', '73274', '73275', '70370', '74177', '74191', '74193', '74207', '74234', '74242', '74244', '74249', '74251', '0', '68989', '72573', '74753', '67133', '67134', '75023', '75035', '75036', '75171', '75173', '75360', '75651', '75652', '75653', '75654', '75656', '75657', '75658', '75659', '75660', '75661', '75662', '75663', '75723', '75796', '75827', '76001', '76076', '76524', '76529', '76681', '76682', '76838', '76847', '76849', '76918', '76920', '76922', '76924', '76926', '76928', '76930', '76932', '76934', '76938', '76940', '76942', '76944', '76946', '76948', '76950', '76997', '76999', '77001', '77003', '77011', '77017', '77019', '77021', '77023', '77029', '77033', '77039', '77043', '77047', '77093', '76960', '77500', '77503', '77506', '77508', '77869', '77873', '77876', '77879', '77882', '69741', '78664', '78666', '69712', '78928', '78946', '78953', '78954', '79046', '79147', '79161', '79171', '79173', '79175', '79177', '79179', '79181', '79183', '79185', '79189', '79191', '79197', '79237', '79866', '79868', '79870', '79872', '80063', '80065', '80067', '80093', '80101', '80107', '80109', '80111', '80215', '80252', '80254', '80256', '80394', '80396', '80834', '80836', '80888', '80892', '80900', '81148', '81150', '81151', '81153', '81156', '81207', '81559', '81560', '81562', '81563', '78827', '78828', '82865', '82906', '82907', '82910', '82913', '82916', '82920', '82922', '82923', '82925', '82926', '82994', '83000', '83004', '83020', '83021', '83024', '83094', '83095', '83101', '83102', '83107', '83115', '83122', '83129', '83326', '83357', '84271', '84850', '82357', '87053', '87057', '87086', '87089', '87090', '82997', '83096', '83120', '83093', '83199', '82891', '87212', '87254', '87256', '87265', '71533', '87342', '87368', '87389', '57798', '87436', '87444', '81149', '87714', '87715', '87716', '87717', '83025', '84266', '84264', '82988', '87711', '82919', '82354', '89915', '90048', '90067', '90530', '83017', '90752', '90755', '44892', '47807', '45399', '44885', '44887', '44895', '44888', '44884', '47814', '92373', '92538', '92652', '92608', '92745', '47820', '47821', '47806', '33688', '47852', '47805', '34084', '34149', '47877', '47811', '47815', '47823', '47816', '45315', '44963', '92766', '44961', '44896', '44886', '44873', '53393', '47810', '45398', '47838', '44960', '47818', '44878', '53392', '44962', '47813', '47817', '44883', '47812', '47819', '47822', '47824', '47808', '47871', '47833', '47837', '47346', '47829', '45393', '92767', '92768', '47341', '92769', '92770', '45401', '45402', '45400', '45403', '45397', '47853', '92894', '92970', '93268', '93271', '93466', '95255', '95309', '95322', '95324', '95889', '96002', '96029', '96056', '96620', '96621', '84093', '96634', '82914', '96808', '96826', '96827', '96829', '96830', '96847', '96848', '96849', '96850', '96851', '96871', '96872', '96873', '96874', '96877', '96878', '96879', '96880', '96884', '96888', '96893', '96894', '96895', '96896', '96898', '96900', '98616', '98617', '98621', '98622', '98624', '98625', '98626', '98629', '98798', '98799', '98838', '98841', '99926', '82904', '101029', '101323', '101324', '101332', '102447', '102457', '102458', '102459', '102480', '102535', '102539', '102542', '102543', '102546', '102548', '102629', '102664', '102698', '102699', '102700', '102701', '102704', '102860', '102861', '102863', '102864', '102870', '102873', '102951', '102954', '102957', '103034', '103053', '103155', '103179', '103302', '103336', '103359', '103360', '83018', '83013', '103593', '103620', '80233', '104172', '104206', '104328', '105383', '105386', '105387', '105389', '105390', '105395', '105397', '105399', '105401', '105484', '105514', '105561', '105662', '105673', '105675', '105676', '105677', '105679', '105680', '105681', '105684', '105685', '105687', '105689', '105729', '105737', '105738', '105739', '105740', '105742', '105755', '105756', '105757', '105758', '105762', '105765', '105787', '105841', '105842', '105844', '105845', '105682', '105935', '105936', '105937', '105938', '105939', '105940', '105941', '105942', '105943', '105944', '105945', '105946', '105947', '105948', '105949', '105950', '105951', '105952', '105953', '105954', '105955', '105956', '105957', '105958', '105959', '105960', '105961', '105962', '105963', '105964', '105965', '105966', '105967', '105968', '105969', '105970', '105971', '105972', '105973', '105974', '105975', '105976', '105977', '105978', '105979', '105980', '105981', '105982', '105983', '105984', '105985', '105986', '105987', '105988', '105989', '105990', '105991', '105992', '105993', '105994', '105995', '105996', '108307', '108310', '69698', '33905', '79148', '64620', '108727', '108730', '108732', '108791', '108818', '108819', '108826', '78825', '109112', '109114', '109115', '109116', '109117', '109120', '109121', '109122', '109123', '109124', '109130', '109131', '109133', '109135', '109136', '109137', '109139', '109140', '109141', '109142', '109144', '109145', '109155', '109157', '109159', '109253', '109255', '109257', '109259', '109260', '109261', '109262', '109263', '109264', '109266', '109267', '109268', '109269', '109270', '109316', '109317', '109334', '109335', '109336', '109337', '109339', '109340', '109349', '109404', '109405', '109406', '109407', '109421', '109422', '109423', '109424', '109425', '109426', '109428', '109429', '109430', '109431', '109432', '109433', '109434', '109435', '109436', '109437', '109438', '109439', '109440', '109441', '109442', '109443', '109444', '109445', '109446', '109447', '109448', '109449', '109450', '109451', '109452', '109453', '109454', '109455', '109456', '109457', '109458', '109459', '109460', '109461', '109635', '109641', '109642', '109643', '109644', '109650', '109652', '109653', '109654', '109663', '109664', '109665', '109666', '109667', '109669', '109670', '109671', '109672', '109673', '109674', '109675', '109676', '109677', '109678', '109679', '109681', '109683', '109685', '109686', '109687', '109688', '109689', '109690', '109691', '109692', '109886', '109900', '109901', '109923', '109924', '109925', '109927', '109928', '109929', '109930', '109931', '109932', '109933', '109934', '109935', '109936', '109937', '109938', '109939', '109940', '109941', '109942', '110031', '110036', '110037', '110045', '110046', '110047', '110048', '110049', '110050', '110051', '110052', '110053', '110054', '110055', '110056', '110057', '110058', '110101', '110102', '110103', '110104', '110105', '110106', '110107', '110108', '110109', '110126', '110127', '110128', '110129', '110130', '110131', '110132', '110133', '110134', '110135', '110136', '110137', '110138', '110139', '110140', '110235', '110236', '110237', '110238', '110239', '110240', '110241', '110243', '110244', '110245', '110246', '110247', '110248', '110249', '110250', '110251', '110252', '110253', '110254', '110255', '110316', '110317', '110339', '110319', '110320', '110321', '110322', '110242', '110324', '110325', '110340', '110326', '110327', '110328', '110341', '110329', '110330', '110331', '110332', '110333', '110334', '110342', '110318', '110343', '110344', '110345', '110346', '110347', '110348', '110349', '110350', '110351', '110352', '110430', '110431', '110433', '110434', '110435', '110437', '110438', '110439', '110440', '110441', '110442', '110443', '110444', '110445', '110446', '110447', '110448', '110449', '110450', '110451', '110452', '110453', '110454', '110455', '110456', '110457', '110458', '110459', '110460', '110462', '110519', '110432', '110526', '110527', '110528', '110529', '110542', '110549', '110550', '110551', '110552', '110553', '110554', '110555', '110556', '110557', '110558', '110559', '110560', '110561', '110562', '110563', '110564', '110566', '110567', '110568', '110570', '110571', '110572', '110573', '110574', '110575', '110576', '110577', '110578', '110579', '110580', '110582', '110583', '110584', '110622', '110623', '110624', '110625', '110626', '110627', '110628', '110629', '110630', '110631', '110632', '110633', '110634', '110635', '110668', '110669', '110670', '110671', '110672', '110673', '110674', '110675', '110676', '110677', '110688', '110689', '110690', '110691', '110692', '110693', '110710', '110711', '110712', '110713', '110714', '110715', '110716', '110717', '110718', '110731', '110741', '110742', '110743', '110744', '110745', '110746', '110747', '110748', '110749', '110750', '110751', '110763', '110764', '110765', '110766', '110767', '110768', '110787', '110817', '110884', '111010', '111092', '111108', '111109', '111110', '111112', '111113', '111114', '111115', '111116', '111117', '111118', '111119', '111120', '111121', '111122', '111123', '111124', '111125', '111126', '111127', '111128', '111129', '111130', '111131', '111132', '111133', '111134', '111135', '111136', '111137', '111138', '111139', '111140', '111141', '111142', '111143', '111144', '111145', '111146', '111147', '111148', '111149', '111150', '111151', '111152', '111153', '111154', '111155', '111156', '111157', '111158', '111159', '111160', '111161', '111162', '111163', '111164', '111165', '111166', '111167', '111168', '111169', '111170', '111171', '111172', '111173', '111174', '111175', '111176', '111177', '111178', '111179', '111180', '111181', '111182', '111183', '111184', '111185', '111186', '111187', '111188', '111189', '111190', '111191', '111192', '111193', '111194', '111195', '111196', '111197', '111198', '111199', '111200', '111201', '111202', '111203', '111204', '111205', '111206', '111207', '112585', '112593', '112596', '112601', '112743', '112744', '112745', '112746', '112747', '112748', '112749', '112750', '112751', '112752', '112753', '112754', '112755', '112756', '112757', '112758', '112759', '112760', '112761', '112762', '112763', '112765', '112766', '112767', '112768', '112771', '112772', '112773', '112774', '112775', '112776', '112777', '112778', '112779', '112780', '113329', '113538', '113539', '113540', '113541', '113542', '113543', '113544', '113545', '113572', '113879', '113878', '113888', '113887', '113885', '113898', '113886', '113854', '113896', '113895', '113844', '113882', '113843', '113842', '113893', '113891', '113850', '102865', '102858', '114165', '114166', '114167', '114168', '114169')))) AND ((((FPV1.VALUE LIKE 'Kevin Young')))) ) 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' )) )) GROUP BY BE.ID,BE.IBLOCK_ID,BE.NAME,B.DETAIL_PAGE_URL, FPV0.VALUE,BE.SHOW_COUNTER,BE.SHOW_COUNTER_START [[1] Can't create/write to file '/tmp/#sql_5856_1.MAI' (Errcode: 28 "No space left on device")]
|