De volgende query heeft gefaald: ' SELECT COUNT(DISTINCT(webshop_products.id)) FROM content LEFT JOIN content_translations ON content.id = content_translations.content_id JOIN webshop_products ON content.id = webshop_products.content_id WHERE ( content.parent_id IN (1970,1974,1975,1999,2000,2001,2002,2003,2004,2005,2006,2078,20791977,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2077,2080,2081,2082,2086,2087,2088,2081978,1979,2007,2008,2009,2010,2011,2012,2013,20141980,2022,2023,2024,2025,2026,2027,20281981,2015,2016,2017,2018,2019,2020,20211982,2029,2030,2031,2032,2033,2034,20351983,2044,2045,2046,2047,2048,2049,20501984,2036,2037,2038,2039,2040,2041,2042,20431985,2051,2052,2053,2054,2055,2056,2051986,2132,2133,11959,119722134,10507,10522,10536104,9770,9788,9789,10575,10576,10572083,2084,2142,5182,18521,18524,18528,18582085,18600,512091,2119,2128,21295030,5031,5032,5033,5034,5035,5291,10429,10545,10561,10562,10565,10570,12708,12709,12710,12717,127182092,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2120,2126,2127,4332,5037,5039,5040,5041,5144,5145,5146,5147,8038,8057,9978,10625,10626,10670,18379,18412,190582093,2109,2110,2115,2116,2117,2121,2122,2137,2138,2139,2151,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5036,5042,5302,5303,8551,8552,8553,8554,8555,8556,8557,8558,9805,10417,10592,10608,10907,10908,10922,10923,10924,11064,11065,11066,12184,12188,12376,12377,12378,12701,12702,12703,12704,12705,16569,16949,17001,170152111,2112,2113,2114,2123,2124,2125,2130,2131,2140,2143,5028,5029,10611,10614,10615,14050,140582148,2149,2150,5290,10768,10769,1077,) OR content.id IN (SELECT p.content_id FROM webshop_product_category AS pc JOIN webshop_products AS p ON pc.product_id = p.id WHERE pc.category_id IN (1970,1974,1975,1999,2000,2001,2002,2003,2004,2005,2006,2078,20791977,2065,2066,2067,2068,2069,2070,2071,2072,2073,2074,2075,2077,2080,2081,2082,2086,2087,2088,2081978,1979,2007,2008,2009,2010,2011,2012,2013,20141980,2022,2023,2024,2025,2026,2027,20281981,2015,2016,2017,2018,2019,2020,20211982,2029,2030,2031,2032,2033,2034,20351983,2044,2045,2046,2047,2048,2049,20501984,2036,2037,2038,2039,2040,2041,2042,20431985,2051,2052,2053,2054,2055,2056,2051986,2132,2133,11959,119722134,10507,10522,10536104,9770,9788,9789,10575,10576,10572083,2084,2142,5182,18521,18524,18528,18582085,18600,512091,2119,2128,21295030,5031,5032,5033,5034,5035,5291,10429,10545,10561,10562,10565,10570,12708,12709,12710,12717,127182092,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2120,2126,2127,4332,5037,5039,5040,5041,5144,5145,5146,5147,8038,8057,9978,10625,10626,10670,18379,18412,190582093,2109,2110,2115,2116,2117,2121,2122,2137,2138,2139,2151,5009,5010,5011,5012,5013,5014,5015,5016,5017,5018,5019,5020,5021,5022,5023,5024,5025,5026,5027,5036,5042,5302,5303,8551,8552,8553,8554,8555,8556,8557,8558,9805,10417,10592,10608,10907,10908,10922,10923,10924,11064,11065,11066,12184,12188,12376,12377,12378,12701,12702,12703,12704,12705,16569,16949,17001,170152111,2112,2113,2114,2123,2124,2125,2130,2131,2140,2143,5028,5029,10611,10614,10615,14050,140582148,2149,2150,5290,10768,10769,1077,)) ) AND content_translations.status = 1 AND content.type = 'product' AND webshop_products.stock > 0 AND content_translations.website_view_id = '3' '
. En gaf de volgende MySQL fout: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') OR content.id IN (SELECT p.content_id FROM webshop_product_category AS pc J...' at line 9