MySQL Query Error:
SELECT
BE.ID IBLOCK_ELEMENT_ID
,BEP.IBLOCK_PROPERTY_ID
,BEP.VALUE
,BEP.VALUE_NUM
,BEP.ID PROPERTY_VALUE_ID
,BEP.DESCRIPTION
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_property FP0 ON FP0.IBLOCK_ID = B.ID AND FP0.ID=1500
INNER JOIN b_iblock_element_property FPV0 ON FPV0.IBLOCK_PROPERTY_ID = FP0.ID AND FPV0.IBLOCK_ELEMENT_ID = BE.ID
left join b_catalog_product as PRD on (PRD.ID = BE.ID)
left join b_catalog_price as PRC_18 on (PRC_18.PRODUCT_ID = BE.ID and PRC_18.CATALOG_GROUP_ID = 18 and ((PRC_18.QUANTITY_FROM <= 1 or PRC_18.QUANTITY_FROM IS NULL) and (PRC_18.QUANTITY_TO >= 1 or PRC_18.QUANTITY_TO IS NULL)))
LEFT JOIN b_iblock_element_property BEP ON BEP.IBLOCK_ELEMENT_ID = BE.ID AND BEP.IBLOCK_PROPERTY_ID IN (1500, 1501, 1502, 1503, 1504, 1505, 1506, 1507, 1508, 1509, 1510, 1511, 1512, 1513, 1514, 1515, 1517, 1518, 1519, 1520, 1521, 1522, 1523, 1554, 1555, 1556, 1557, 1558, 1560, 1561, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1628, 1629, 1630, 1631, 1632, 1633, 1634, 1635, 1640, 1643, 1646, 1651, 1655, 1659, 1660, 1669, 1673, 1674, 1675, 1676, 1680, 1681, 1690, 1691, 1692, 1693, 1695, 1700, 1701, 1702, 1703, 1752, 1753, 1754, 1755, 1756, 1757, 1758, 1759, 1760, 1761, 1762, 1763, 1764, 1765, 1766, 1767, 1768, 1769, 1770, 1771, 1772, 1773, 1774, 1775, 1776, 1777, 1778, 1779, 1780, 1781, 1782, 1783, 1784, 1785, 1786, 1787, 1788, 1789, 1790, 1791, 1792, 1793, 1794, 1795, 1796, 1797, 1798, 1799, 1808, 1809, 1810, 1811, 1812, 1813, 1814, 1815, 1816, 1820, 1822, 1823, 1824, 1830, 1833, 1872, 1877, 1883, 1884, 1886, 1889, 1891, 1894, 1902, 1903, 1904, 1905, 1906, 1908, 1915, 1916, 1917, 1918, 1919, 1922, 1924, 1931, 1932, 1934, 1936, 1938, 1940, 1942, 1947, 1956, 1957, 1958, 1959, 1960, 1961, 1964, 1966, 2016, 2017, 2018, 2019, 2020, 2021, 2022, 2023, 2024, 2025, 2026, 2027, 2028, 2029, 2030, 2031, 2032, 2033, 2034, 2035, 2036, 2037, 2038, 2039, 2040, 2041, 2042, 2043, 2044, 2045, 2046, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2061, 2062, 2063, 2064, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2111, 2112, 2113, 2114, 2115, 2116, 2117, 2118, 2119, 2120, 2121, 2122, 2123, 2124, 2125, 2126, 2127, 2128, 2129, 2130, 2131, 2132, 2133, 2134, 2135, 2136, 2137, 2138, 2139, 2140, 2141, 2142, 2153, 2154, 2155, 2156, 2157, 2158, 2159, 2160, 2161, 2162, 2213, 2214, 2215, 2216, 2217, 2218, 2219, 2220, 2221, 2222, 2223, 2224, 2225, 2226, 2227, 2228, 2229, 2230, 2231, 2232, 2233, 2234, 2235, 2236, 2237, 2238, 2239, 2240, 2241, 2242, 2243, 2244, 2245, 2246, 2247, 2248, 2249, 2250, 2251, 2252, 2253, 2254, 2255, 2256, 2257, 2258, 2259, 2260, 2261, 2262, 2274, 2275, 2276, 2277, 2278, 2279, 2280, 2281, 2282, 2283, 2284, 2293, 2294, 2295, 2296, 2297, 2298, 2299, 2300, 2306, 2307, 2308, 2315, 2316, 2317, 2318, 2319, 2320, 2322, 2328, 2329, 2330, 2331, 2332, 2334, 2336)WHERE 1=1
AND (
((((BE.IBLOCK_ID = '81'))))
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 (((FPV0.VALUE_NUM IN ('229201', '226726', '224186', '217609', '218149', '223104', '218061', '218058', '218062', '217606', '218150', '218060', '218059', '222197', '218151', '218152', '218326', '223174', '218325', '217607'))))
AND ((((PRD.AVAILABLE='Y'))))
)
AND (((BE.WF_STATUS_ID=1 AND BE.WF_PARENT_ELEMENT_ID IS NULL)))
ORDER BY
BEP.IBLOCK_ELEMENT_ID, BEP.IBLOCK_PROPERTY_ID, BEP.ID
[[3] Error writing file '/tmp/MYcJdi1f' (Errcode: 28 - No space left on device)]
DB query error.
Please try later.
|
|
