FILE: /home/g/gerbud/public_html/bitrix/modules/iblock/classes/mysql/iblockelement.php
LINE: 807
MySQL Query Error:
SELECT DISTINCT BE.IBLOCK_ID as IBLOCK_ID,BE.ID as ID,BE.DETAIL_PICTURE as DETAIL_PICTURE, BE0.ID as PROPERTY_LINK_CAR_ID, JFPV0.VALUE as PROPERTY_LINK_CAR_PROPERTY_PODMODEL_VALUE,
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(
replace(B0.DETAIL_PAGE_URL, '#ID#', BE0.ID)
, '#ELEMENT_ID#', BE0.ID)
, '#CODE#', ifnull(BE0.CODE, ''))
, '#ELEMENT_CODE#', ifnull(BE0.CODE, ''))
, '#EXTERNAL_ID#', ifnull(BE0.XML_ID, ''))
, '#IBLOCK_TYPE_ID#', B0.IBLOCK_TYPE_ID)
, '#IBLOCK_ID#', BE0.IBLOCK_ID)
, '#IBLOCK_CODE#', ifnull(B0.CODE, ''))
, '#IBLOCK_EXTERNAL_ID#', ifnull(B0.XML_ID, ''))
, '#SITE_DIR#', '/')
, '#SERVER_NAME#', 'roof-box.ru')
, '#SECTION_ID#', ifnull(BE0.IBLOCK_SECTION_ID, ''))
, '#SECTION_CODE#', ifnull(BS0.CODE, ''))
as PROPERTY_LINK_CAR_DETAIL_PAGE_URL, BE0.NAME as PROPERTY_LINK_CAR_NAME, JFPEN0.VALUE as PROPERTY_LINK_CAR_PROPERTY_TYPE_VALUE, JFPEN0.ID as PROPERTY_LINK_CAR_PROPERTY_TYPE_ENUM_ID, concat(BE0.ID , ':' , 91) as PROPERTY_TYPE_LINK_CAR_VALUE_ID, JFPEN1.VALUE as PROPERTY_LINK_CAR_PROPERTY_DOOR_VALUE, JFPEN1.ID as PROPERTY_LINK_CAR_PROPERTY_DOOR_ENUM_ID, concat(BE0.ID , ':' , 89) as PROPERTY_DOOR_LINK_CAR_VALUE_ID, JFPS1.PROPERTY_90 as PROPERTY_LINK_CAR_PROPERTY_DATA_VALUE, concat(BE0.ID , ':' , 90) as PROPERTY_DATA_LINK_CAR_VALUE_ID, JFPS1.PROPERTY_97 as PROPERTY_LINK_CAR_PROPERTY_KUZOV_VALUE, concat(BE0.ID , ':' , 97) as PROPERTY_KUZOV_LINK_CAR_VALUE_ID, JFPS1.PROPERTY_98 as PROPERTY_LINK_CAR_PROPERTY_HARACTER_VALUE, concat(BE0.ID , ':' , 98) as PROPERTY_HARACTER_LINK_CAR_VALUE_ID, BE0.IBLOCK_SECTION_ID as PROPERTY_LINK_CAR_IBLOCK_SECTION_ID, FPS0.PROPERTY_152 as PROPERTY_LINK_TRADE_VALUE, FPS0.PROPERTY_153 as PROPERTY_LINK_TRUNK_VALUE, FPS0.PROPERTY_154 as PROPERTY_LINK_CHAINS_VALUE, concat(BE.ID , ':' , 154) as PROPERTY_LINK_CHAINS_VALUE_ID
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
INNER JOIN b_iblock_element_prop_s31 FPS0 ON FPS0.IBLOCK_ELEMENT_ID = BE.ID
LEFT JOIN b_iblock_element BE0 ON BE0.ID = FPS0.PROPERTY_155 AND ((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL))
LEFT JOIN b_iblock B0 ON B0.ID = BE0.IBLOCK_ID
LEFT JOIN b_iblock_section BS0 ON BS0.ID = BE0.IBLOCK_SECTION_ID
LEFT JOIN b_iblock_element_prop_s14 JFPS0 ON JFPS0.IBLOCK_ELEMENT_ID = BE0.ID
LEFT JOIN b_iblock_element_prop_s14 JFPS1 ON JFPS1.IBLOCK_ELEMENT_ID = BE0.ID
LEFT JOIN b_iblock_property JFP0 ON JFP0.IBLOCK_ID = BE0.IBLOCK_ID AND JFP0.CODE='PODMODEL'
LEFT JOIN b_iblock_element_prop_m14 JFPV0 ON JFPV0.IBLOCK_PROPERTY_ID = JFP0.ID AND JFPV0.IBLOCK_ELEMENT_ID = BE0.ID
LEFT JOIN b_iblock_property_enum JFPEN0 ON JFPEN0.PROPERTY_ID = 91 AND JFPS0.PROPERTY_91 = JFPEN0.ID
LEFT JOIN b_iblock_property_enum JFPEN1 ON JFPEN1.PROPERTY_ID = 89 AND JFPS0.PROPERTY_89 = JFPEN1.ID
WHERE 1=1
AND (
((((BE.IBLOCK_ID = '31'))))
AND ((((BE.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 (((FPS0.PROPERTY_155 IN ('0', '2085', '2086', '2154', '2649', '2156', '2267', '2268', '2269', '2270', '7044', '8021', '2272', '2273', '2088', '2089', '2090', '2091', '2332', '2333', '2334', '2995', '3639', '9823', '2402', '2403', '2404', '2361', '2362', '2363', '7503', '2093', '2094', '2367', '2368', '2369', '2370', '2371', '2372', '2374', '4908', '7805', '9305', '9307', '10913', '407', '1356', '1357', '9795', '10226', '412', '413', '414', '512', '428', '429', '430', '431', '432', '515', '516', '4860', '416', '446', '448', '449', '450', '1396', '2755', '3599', '8622', '10550', '10569', '1385', '1386', '1387', '1388', '4962', '10113', '10114', '10115', '10530', '10549', '507', '518', '6291', '8063', '519', '520', '522', '524', '526', '528', '529', '531', '532', '533', '556', '9246', '535', '537', '8616', '539', '558', '560', '561', '989', '990', '991', '996', '8754', '8757', '1092', '1094', '2802', '8839', '9253', '1096', '7719', '1099', '1101', '1102', '1176', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '8151', '10244', '1151', '1152', '1154', '1155', '1157', '1158', '1162', '1163', '1169', '1170', '3647', '11169', '1172', '1173', '1174', '10210', '10211', '10929', '1179', '1180', '5012', '1186', '1187', '1188', '1189', '1190', '1191', '1192', '1193', '1196', '1197', '1216', '1217', '1317', '1219', '1220', '1221', '1222', '1223', '10575', '10576', '10592', '10593', '1225', '4807', '1227', '10577', '10578', '10594', '10595', '1229', '4808', '1231', '1233', '1234', '1235', '1236', '1238', '1240', '1242', '1243', '1244', '1245', '1247', '7278', '10535', '1249', '1334', '7368', '1251', '7280', '7370', '1253', '1255', '1258', '1256', '1260', '1261', '1263', '4806', '9827', '10848', '1267', '1268', '1269', '1270', '1271', '1272', '1273', '1275', '1276', '1277', '1278', '1279', '1280', '1283', '1284', '1285', '1287', '2780', '3005', '3554', '1281', '1288', '1289', '1291', '1292', '1294', '1295', '3514', '4822', '4851', '1297', '1298', '1300', '1302', '1303', '4805', '1335', '10356', '1337', '1339', '1341', '1343', '1344', '1345', '1347', '1349', '1350', '1371', '1372', '7919', '1374', '1375', '2895', '3014', '8763', '1377', '3130', '1379', '1380', '1381', '11146', '1383', '1390', '1391', '1393', '1394', '1397', '1399', '1400', '3610', '10212', '10213', '1409', '1410', '1412', '9322', '1414', '1415', '1416', '8017', '1418', '1419', '1421', '1423', '1425', '1426', '1427', '7789', '10350', '1429', '1430', '1431', '1432', '1433', '10080', '10081', '1436', '1437', '1438', '2909', '2910', '1435', '1440', '1441', '1442', '1497', '1444', '3667', '1446', '1448', '1449', '1450', '3105', '10355', '1452', '1453', '1455', '1456', '1457', '1458', '1459', '1461', '1462', '1463', '1465', '7382', '7978', '9259', '10085', '10111', '10112', '10537', '1466', '1468', '1469', '6830', '1471', '10108', '10109', '1473', '1502', '1504', '1505', '1509', '1511', '1512', '1513', '1514', '1515', '1516', '1517', '1518', '2966', '3666', '7810', '9474', '10890', '10892', '1507', '1510', '7809', '1547', '1548', '1550', '9797', '1552', '1553', '1554', '1555', '1559', '1560', '3129', '1562', '1563', '1567', '1568', '1570', '1571', '1572', '1573', '1574', '2226', '6741', '6742', '1576', '1577', '1578', '1579', '1580', '1581', '1583', '3615', '8079', '10589', '1584', '1585', '1586', '1587', '1588', '1589', '1628', '2049', '6905', '7063', '10512', '10894', '11114', '1590', '1591', '1592', '1593', '7385', '7973', '1596', '1597', '1599', '1601', '1602', '1603', '1604', '1605', '1608', '1609', '1610', '1614', '1615', '10486', '10897', '1617', '1618', '1620', '1631', '1622', '3616', '1632', '1634', '1635', '1638', '10921', '1640', '1641', '1642', '1643', '1645', '1646', '1648', '1649', '1650', '3034', '1652', '1654', '1655', '1656', '1657', '10178', '1661', '1662', '1663', '1664', '7698', '1668', '1669', '1670', '1671', '1703', '1673', '1674', '1675', '2793', '7381', '8125', '10559', '1677', '1678', '1679', '1704', '1705', '3430', '1681', '1682', '1684', '1685', '1706', '10923', '1709', '1710', '1707', '1712', '1713', '1758', '1759', '3096', '3097', '8732', '8733', '1715', '1716', '1718', '1719', '1720', '1721', '1760', '1761', '1762', '1763', '3156', '7804', '10601', '1723', '1725', '6934', '1727', '1729', '1730', '1732', '1734', '1735', '1737', '1738', '1739', '1741', '1742', '1764', '1765', '1766', '1790', '9826', '1768', '1769', '1770', '1771', '1772', '1773', '5014', '5015', '10959', '10960', '1775', '1776', '1778', '1779', '1780', '1781', '1794', '2751', '7807', '10159', '1783', '1784', '2781', '9329', '1786', '1787', '1797', '1798', '1799', '1801', '1802', '1803', '1805', '1806', '1807', '1808', '1809', '1810', '1812', '1813', '1814', '1815', '1816', '1834', '4935', '7802', '7803', '8800', '9401', '10539', '1818', '1819', '1820', '1821', '1822', '1823', '1824', '1825', '1826', '2908', '2972', '3442', '1828', '3664', '1830', '1831', '1832', '8628', '1839', '1841', '1842', '1843', '1845', '1846', '1847', '1849', '1850', '1851', '1853', '1855', '1856', '1858', '6233', '1860', '1862', '1863', '1865', '10974', '1867', '1868', '7502', '8013', '1870', '1871', '1873', '1874', '1876', '1877', '1878', '1879', '1881', '9793', '9794', '1885', '1888', '1889', '1890', '1891', '1892', '1893', '1894', '1896', '1898', '1899', '1900', '10900', '1902', '1903', '1904', '1905', '1906', '1907', '1908', '1909', '1910', '6246', '10613', '1912', '1914', '1916', '1917', '1919', '1921', '1922', '1923', '7508', '1925', '1927', '1928', '9804', '9806', '10541', '1930', '1931', '1932', '7059', '7506', '9819', '10901', '1934', '1935', '1937', '1938', '1940', '1941', '1942', '3007', '3008', '7547', '8753', '1945', '1946', '1947', '1948', '3033', '1950', '1951', '1953', '1954', '1956', '1957', '1959', '1960', '9802', '10223', '10598', '1962', '1963', '1964', '1965', '1967', '1990', '1992', '1994', '1996', '1998', '1999', '2000', '10538', '2002', '2004', '2005', '2006', '2007', '2009', '2010', '2012', '2013', '2014', '2016', '2018', '2019', '2020', '2021', '2022', '2023', '3009', '7958', '8748', '8749', '8750', '2024', '2025', '2026', '2027', '2028', '2029', '3116', '10194', '10196', '10584', '10853', '2031', '2032', '2033', '2034', '2035', '2036', '2037', '4785', '4930', '2039', '2067', '2042', '10119', '2044', '2045', '2050', '2068', '10540', '2070', '2072', '2074', '2078', '2079', '2080', '2081', '2083', '2075', '2096', '2097', '2077', '2100', '2102', '2105', '2106', '2107', '2103', '2108', '2109', '3847', '7279', '8813', '8837', '10865', '11150', '2111', '2112', '2113', '2114', '6276', '2116', '2118', '2119', '2121', '2122', '2123', '10869', '2125', '2126', '2127', '2129', '2130', '2131', '2133', '10209', '10546', '376', '2158', '2160', '2172', '2173', '2175', '7960', '10510', '10873', '2177', '2178', '2179', '2181', '2182', '3131', '2184', '2185', '2187', '2188', '2190', '3004', '2192', '2193', '2195', '2197', '2198', '2199', '10502', '10563', '2201', '2203', '2205', '2230', '2207', '2209', '2210', '2219', '2232', '2233', '2235', '2237', '2239', '2242', '2243', '2245', '2246', '2248', '2249', '2251', '2253', '10528', '2255', '7969', '2258', '2259', '3652', '8838', '9249', '2261', '2263', '4800', '2275', '2287', '7342', '7505', '7626', '2277', '2278', '2810', '7812', '2280', '2281', '2283', '4848', '2285', '2288', '2290', '2292', '2293', '2294', '2295', '2296', '4928', '4929', '2298', '2299', '3621', '10249', '2301', '2807', '9299', '9535', '10160', '11121', '2303', '2305', '2306', '2307', '3017', '3018', '10202', '11123', '2336', '2337', '2338', '2339', '7631', '2341', '2342', '2344', '8020', '2346', '2348', '2350', '8625', '2352', '2358', '10203', '2354', '2356', '2357', '2359', '2365', '7787', '2375', '2377', '2378', '2380', '2381', '2382', '2384', '7806', '10916', '10918', '2385', '2387', '2389', '4917', '2391', '2393', '2394', '2395', '2397', '2399', '2400', '2412', '3661', '10166', '10167', '11129', '2414', '2415', '2417', '2419', '2421', '2422', '2424', '10566', '2426', '2427', '2429', '2430', '8836', '9250', '9251', '2432', '2433', '2434', '2436', '2438', '2439', '2440', '2441', '2443', '2444', '2445', '2449', '2447', '11133', '11134', '2450', '2457', '2459', '2461', '2463', '2464', '3676', '3677', '2466', '2467', '2468', '2469', '7813', '10529', '10547', '2471', '10168', '1686', '2507', '2474', '11140', '2476', '2477', '2478', '2479', '2480', '10548', '2482', '6746', '10562', '2484', '2485', '2486', '2487', '2488', '2489', '2491', '2492', '2752', '2783', '6763', '10941', '10943', '2493', '2494', '2495', '7046', '7047', '11139', '11144', '2497', '2498', '2513', '2514', '2515', '2517', '2519', '2520', '2522', '2524', '2525', '2527', '2531', '2532', '2533', '7724', '2529', '2534', '2535', '2537', '2540', '2541', '2543', '2545', '2547', '2548', '6902', '6903', '2550', '7461', '8840', '8841', '2552', '2554', '2563', '2565', '4946', '4947', '2567', '7335', '2569', '2570', '2572', '2573', '7815', '7816', '2575', '2576', '7963', '8767', '2578', '2580', '2581', '2582', '2584', '2585', '2586', '2587', '2590', '2591', '2592', '2594', '2595', '2597', '2598', '2599', '6811', '2601', '2603', '2604', '2605', '2606', '2608', '2609', '2647', '7962', '8758', '2611', '8759', '2613', '2614', '2615', '2617', '2643', '2644', '2619', '2620', '2622', '2663', '3242', '2624', '2626', '3000', '2628', '2629', '2773', '6813', '10970', '2631', '2632', '2633', '3159', '6972', '6973', '7961', '8016', '2635', '3688', '2637', '2638', '2639', '5016', '2641', '2659', '11125', '11126', '2670', '8808', '2672', '2673', '2674', '9564', '2676', '2677', '2678', '10370', '2681', '2684', '2687', '2689', '2691', '2693', '2695', '2697', '2699', '2700', '2701', '9566', '2703', '2714', '2715', '2716', '2717', '2720', '2722', '2725', '2740', '2741', '2743', '2744', '9799', '2746', '3006', '10197', '10861', '2748', '2749', '2753', '2775', '2777', '2813', '2884', '2912', '2930', '2933', '2935', '10479', '2943', '10097', '2945', '5217', '10536', '2947', '2964', '6265', '2970', '8760', '2973', '2975', '2978', '2983', '2984', '2980', '2985', '2998', '3001', '3002', '3012', '3059', '7064', '3031', '3037', '3057', '3084', '6812', '9205', '9206', '3102', '3119', '8765', '10966', '3121', '3122', '3124', '3135', '3136', '3423', '11137', '3511', '3513', '3518', '3558', '4820', '3586', '3588', '3594', '10103', '3596', '3612', '3617', '3632', '3655', '3656', '3660', '3662', '7383', '3668', '3670', '3672', '3674', '4755', '4757', '3665', '4789', '4790', '6858', '4792', '4793', '4798', '4825', '4826', '4849', '4852', '4868', '4869', '4871', '10158', '10490', '4872', '4874', '10124', '4898', '4899', '8573', '10514', '4912', '8619', '4973', '4974', '4983', '4986', '4988', '5009', '5215', '5774', '6239', '9800', '6263', '6492', '6743', '10867', '6769', '6770', '6778', '7814', '6800', '6859', '6884', '6888', '6889', '6906', '6907', '8575', '6909', '6911', '6913', '7881', '7882', '6916', '6917', '6921', '6922', '6964', '7004', '7039', '7041', '7061', '7094', '7151', '7152', '7153', '10910', '7156', '7238', '7241', '7242', '11096', '7245', '7247', '7248', '7281', '7496', '7337', '11132', '7344', '7387', '7389', '10208', '10919', '7391', '10501', '7480', '7482', '7499', '7500', '7523', '7621', '7628', '7630', '7651', '7713', '7715', '7717', '7921', '7956', '7964', '9309', '11166', '7966', '8018', '8066', '8488', '9798', '8568', '8570', '8594', '8620', '8751', '8806', '8809', '9081', '10972', '10973', '9122', '9201', '9202', '9239', '9241', '10125', '9244', '9321', '9262', '10093', '9302', '9820', '9480', '9550', '9603', '10073', '10076', '10087', '10090', '10099', '10106', '10116', '10117', '10145', '10147', '10162', '10165', '10169', '10939', '10198', '10888', '10889', '10200', '10205', '10914', '10216', '10218', '10259', '11160', '10263', '10348', '10411', '10414', '10421', '10464', '10480', '10483', '10488', '10899', '10492', '10494', '10496', '10499', '10504', '10957', '10507', '10508', '10857', '10859', '10516', '10517', '10933', '10531', '10533', '10579', '10542', '10544', '10551', '10553', '10555', '10557', '10905', '10560', '10591', '10564', '10567', '10573', '10574', '10580', '10582', '10585', '10587', '10590', '10953', '10599', '10628', '10629', '11117', '10809', '10849', '10854', '10863', '10871', '10875', '10877', '10878', '10881', '10882', '10883', '10902', '10907', '10924', '10926', '10930', '10931', '10935', '10937', '10945', '10948', '10950', '10955', '10963', '10968', '10976', '11111', '11112', '11119', '11130', '11142', '11147'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY BE.ID desc
[[1114] The table '/tmp/#sql_8768_28' is full]
DB query error.
Please try later.
|
|
Версия для печати
