Exception: Query error 42S02: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'proriderz.tmp_shop_item_allowed_filter' doesn't exist. Query: SELECT `shop_items`.`id`, `shop_items`.`shop_group_id`, `shop_items`.`modification_id`, `shop_items`.`shop_producer_id`, `shop_items`.`shop_seller_id`, `shop_items`.`weight`, `shop_items`.`length`, `shop_items`.`width`, `shop_items`.`height`, IF (shop_items.modification_id = 0 AND shop_items.price = 0 AND mods.id IS NOT NULL, `mods`.`abs_price`, (`shop_items`.`price` * `shop_currencies`.`exchange_rate`) - IF(`shop_discounts`.`id` IS NOT NULL, IF(`shop_discounts`.`type` = 0, (`shop_items`.`price` * `shop_currencies`.`exchange_rate` * `shop_discounts`.`value` / 100), `shop_discounts`.`value`), 0) + IF(`shop_taxes`.`id` IS NOT NULL AND `shop_taxes`.`tax_is_included` = 0, (`shop_taxes`.`rate` / 100 * (`shop_items`.`price` * `shop_currencies`.`exchange_rate`)), 0)) AS `absolute_price`, IF((COALESCE(SUM(shop_warehouse_items.count),0) + COALESCE(SUM(modifications_shop_warehouse_items.count),0)) > 0, 0, 1) AS `dataInStock` FROM `shop_items` LEFT OUTER JOIN (SELECT `tmp`.`id`, ((`tmp`.`price` * `tmp_currencies`.`exchange_rate`) - IF(`tmp_discounts`.`id` IS NOT NULL, IF(`tmp_discounts`.`type` = 0, (`tmp`.`price` * `tmp_currencies`.`exchange_rate` * `tmp_discounts`.`value` / 100), `tmp_discounts`.`value`), 0) + IF(`tmp_taxes`.`id` IS NOT NULL AND `tmp_taxes`.`tax_is_included` = 0, (`tmp_taxes`.`rate` / 100 * (`tmp`.`price` * `tmp_currencies`.`exchange_rate`)), 0)) AS `abs_price`, `tmp`.`modification_id` FROM `shop_items` AS `tmp` LEFT OUTER JOIN `shop_taxes` AS `tmp_taxes` ON `tmp_taxes`.`id` = `tmp`.`shop_tax_id` LEFT OUTER JOIN `shop_currencies` AS `tmp_currencies` ON `tmp_currencies`.`id` = `tmp`.`shop_currency_id` LEFT OUTER JOIN `shop_item_discounts` AS `tmp_item_discounts` ON `tmp_item_discounts`.`shop_item_id` = `tmp`.`id` LEFT OUTER JOIN `shop_discounts` AS `tmp_discounts` ON `tmp_discounts`.`id` = `tmp_item_discounts`.`shop_discount_id` AND `tmp_discounts`.`id` IN ('58', '60', '62', '65', '66', '75', '77') WHERE `tmp`.`active` IS NOT NULL AND `tmp`.`deleted` IS NOT NULL GROUP BY `tmp`.`modification_id` HAVING `abs_price` > 0 ORDER BY `abs_price` ASC) AS `mods` ON `mods`.`modification_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_taxes` ON `shop_taxes`.`id` = `shop_items`.`shop_tax_id` LEFT OUTER JOIN `shop_currencies` ON `shop_currencies`.`id` = `shop_items`.`shop_currency_id` LEFT OUTER JOIN `shop_item_discounts` ON `shop_items`.`id` = `shop_item_discounts`.`shop_item_id` LEFT OUTER JOIN `shop_discounts` ON `shop_item_discounts`.`shop_discount_id` = `shop_discounts`.`id` AND `shop_discounts`.`id` IN ('58', '60', '62', '65', '66', '75', '77') LEFT OUTER JOIN `shop_warehouse_items` ON `shop_warehouse_items`.`shop_item_id` = `shop_items`.`id` AND `shop_warehouse_items`.`shop_item_id` IN (SELECT `n` FROM `tmp_shop_item_allowed_filter`) LEFT OUTER JOIN `shop_items` AS `modifications` ON `modifications`.`modification_id` = `shop_items`.`id` LEFT OUTER JOIN `shop_warehouse_items` AS `modifications_shop_warehouse_items` ON `modifications_shop_warehouse_items`.`shop_item_id` = `modifications`.`id` AND `modifications_shop_warehouse_items`.`shop_item_id` IN (SELECT `n` FROM `tmp_shop_item_mods_filter`) WHERE `shop_items`.`shop_id` = '3' AND ( `shop_items`.`start_datetime` < '2024-03-19 09:55:37' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-03-19 09:55:37' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1) AND `shop_items`.`active` = 1 AND ( `shop_items`.`shop_group_id` IN (1961, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1962, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2127, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2220, 1961, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1962, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2127, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2220, 0) AND `shop_items`.`modification_id` = 0 OR `shop_items`.`shop_group_id` = 0 AND `shop_items`.`modification_id` IN (SELECT `shop_items`.`id` FROM `shop_items` WHERE `shop_items`.`shop_id` = '3' AND `shop_items`.`deleted` = 0 AND `shop_items`.`active` = 1 AND `shop_items`.`shop_group_id` IN (1961, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1962, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2127, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2220, 1961, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1985, 2093, 2094, 2095, 2096, 2246, 2093, 2094, 2095, 2096, 2246, 2025, 1987, 2097, 2098, 2099, 2097, 2098, 2099, 1988, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2100, 2101, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2272, 2270, 2265, 2266, 2267, 2268, 2269, 2271, 2102, 2103, 2104, 2105, 2106, 2107, 2108, 2109, 2110, 2121, 2124, 2156, 2228, 2229, 2232, 2233, 2234, 2235, 2236, 2153, 1994, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 2111, 2112, 2113, 2114, 2115, 2230, 2231, 1996, 1998, 1999, 2010, 2123, 2245, 2250, 2123, 2245, 2250, 2016, 2022, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 2116, 2117, 2118, 2119, 2237, 2238, 2239, 1986, 1982, 1983, 1981, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 2085, 2086, 2087, 2088, 2089, 2090, 2091, 2092, 1977, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 2072, 2073, 2074, 2075, 2076, 2077, 2078, 2079, 2240, 2241, 2242, 1978, 2080, 2081, 2082, 2083, 2084, 2080, 2081, 2082, 2083, 2084, 1976, 1975, 2068, 2069, 2070, 2071, 2221, 2068, 2069, 2070, 2071, 2221, 1973, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 2054, 2055, 2056, 2057, 2058, 2059, 2060, 1974, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 2061, 2062, 2063, 2064, 2065, 2066, 2067, 2215, 2243, 2296, 1971, 1966, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 2046, 2045, 2044, 2043, 2042, 2041, 2040, 2039, 2038, 2037, 1967, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 2047, 2048, 2049, 2050, 2051, 2052, 2053, 2244, 1968, 1963, 2028, 2027, 2029, 2028, 2027, 2029, 1964, 2033, 2031, 2030, 2033, 2031, 2030, 1965, 2036, 2034, 2035, 2294, 2036, 2034, 2035, 2294, 2126, 2128, 2129, 2191, 2226, 2222, 2223, 2224, 2225, 2222, 2223, 2224, 2225, 2247, 2248, 2000, 2001, 2002, 2003, 2125, 2000, 2001, 2002, 2003, 2125, 2249, 1962, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2154, 1989, 1990, 1991, 1992, 1995, 2004, 2164, 1980, 1979, 1972, 1970, 1969, 2192, 2127, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2163, 2181, 2182, 2183, 2184, 2185, 2186, 2187, 2188, 2193, 2220, 0) AND ( `shop_items`.`start_datetime` < '2024-03-19 09:55:37' OR `shop_items`.`start_datetime` = '0000-00-00 00:00:00' ) AND ( `shop_items`.`end_datetime` > '2024-03-19 09:55:37' OR `shop_items`.`end_datetime` = '0000-00-00 00:00:00' ) AND `shop_items`.`siteuser_group_id` IN (0, -1)) ) AND `shop_items`.`deleted` = 0 GROUP BY `shop_items`.`id`, `shop_items`.`id` HAVING ( SUM(`shop_warehouse_items`.`count`) > 0 OR SUM(`modifications_shop_warehouse_items`.`count`) > 0 )
modules/core/database/pdo.php:680 Core_Exception->__construct
modules/core/querybuilder/statement.php:87 Core_DataBase_Pdo->query
modules/asmp/shop/controller/show.php:1492 Core_QueryBuilder_Statement->execute
modules/asmp/shop/controller/show.php:719 ASMP_Shop_Controller_Show->_preQueryBuilderInit
hostcmsfiles/lib/lib_82/lib_config_82.php:357 ASMP_Shop_Controller_Show->procces
modules/core/command/controller/default.php:558 include
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:240 Core_Router_Route->execute