mysqli error: [1064: 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 ') ) AS remainingAmount FROM `product_filteroptions` WHERE product_id IN (56,' at line 3] in EXECUTE("SELECT filter_option_id, COUNT(product_id) AS amount, ( SELECT COUNT(pf.product_id) AS amount FROM product_filteroptions AS pf WHERE pf.filter_option_id=product_filteroptions.filter_option_id AND pf.product_id IN () ) AS remainingAmount FROM `product_filteroptions` WHERE product_id IN (56,101,107,108,111,112,115,123,125,128,130,131,133,138,140,142,144,145,147,148,149,153,155,158,160,165,177,187,188,189,191,192,193,194,195,196,197,198,199,200,203,463,464,465,466,467,468,469,470,473,475,528,546,571,588,589,593,594,600,601,605,610,612,613,616,618,621,622,625,628,630,631,639,645,646,647,649,650,651,652,653,654,655,659,660,661,667,668,669,670,671,672,678,679,680,681,682,683,684,685,686,687,688,689,690,691,694,695,707,719,720,721,722,724,726,727,736,739,741,744,745,755,756,757,763,764,765,768,769,773,774,936,993,1035,1036,1042,1043,1089,1090,1091,1106,1107,1117,1121,1145,1149,1150,1151,1152,1153,1156,1158,1191,1194,1199,1203,1206,1207,1208,1209,1210,1211,1212,1213,1218,1219,1220,1244,1245,1260,1262,1271,1273,1294,1309,1310,1334,1335,1402,1404,1434,1482,1483,1484,1485,1486,1487,1490,1491,1505,1506,1510,1511,1516,1629,1653,1654,1659,1665,1684,1685,1686,1689,1701,1704,1715,1723,1724,1725,1726,1729,1733,1734,1738,1741,1742,1762,1803,1804,1816,1817,1818,1820,1822,1823,1828,1829,1830,1831,1867,1875,1876,1877,1878,1879,1880,1894,1895,1896,1898,1899,1900,1902,1903,1905,1911,1912,1913,1916,1937,1939,1940,1941,1942,1945,1946,1947,1950,1951,1952,1960,1963,1982,1984,1985,1986,1987,1988,1989,1990,1991,1992,1998,1999,2007,2008,2009,2010,2011,2013,2016,2017,2018,2019,2020,2026,2030,2031,2032,2033,2034,2035,2036,2060,2089,2103,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2121,2123,2124,2125,2128,2131,2133,2134,2135,2136,2137,2217,2220,2221,2222,2223,2224,2237,2238,2239,2240,2241,2242,2243,2244,2269,2271,2272,2288,2289,2296,2297,2298,2311,2312,2313,2316,2318,2319,2320,2321,2322,2323,2324,2325,2326,2327,2328,2329,2359,2361,2373,2374,2387,2390,2398,2427,2429,2430,2431,2432,2436,2439,2441,2442,2445,2446,2450,2457,2458,2460,2461,2462,2463,2464,2465,2468,2470,2475,2478,2483,2484,2486,2487,2513,2514,2535,2580,2581,2629,2631,2632,2659,2660,2666,2667,2671,2673,2675,2677,2685,2694,2696,2697,2704,2705,2706,2707,2713,2714,2716,2719,2720,2727,2729,2732,2733,2734,2760,2761,2763,2764,2765,2766,2767,2768,2770,2774,2776,2780,2783,2787,2803,2807,2820,2825,2826,2828,2829,2830,2831,2832,2833,2841,2843,2844,2845,2847,2848,2849,2850,2851,2852,2853,2862,2870,2872,2874,2875,2876,2877,2879,2880,2881,2882,2883,2884,2894,2895,3035,3036,3087,3088,3094,3095,3096,3117,3118,3119,3120,3124,3126,3127,3128,3129,3130,3131,3132,3133,3134,3135,3136,3137,3139,3140,3141,3142,3143,3157,3158,3164,3165,3201,3202,3205,3206,3207,3208,3209,3210,3211,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3239,3240,3241,3254,3256,3257,3258,3259,3261,3263,3264,3270,3271,3290,3291,3322,3323,3324,3325,3327,3329,3330,3331,3332,3333,3334,3335,3336,3337,3338,3340,3342,3343,3349,3350,3351,3352,3355,3356,3360,3364,3365,3368,3370,3371,3372,3373,3374,3375,3378,3381,3384,3386,3397,3399,3400,3409,3413,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3444,3445,3446,3447,3448,3457,3458,3462,3463,3464,3465,3467,3468,3469,3470,3472,3473,3474,3475,3476,3478,3479,3481,3483,3484,3487,3488,3489,3490,3491,3492,3502,3503,3504,3505,3506,3507,3508,3509,3510,3511,3512,3513,3514,3515,3516,3520,3521,3529,3530,3531,3532,3533,3534,3547,3548,3555,3557,3558,3559,3560,3562,3563,3564,3565,3579,3583,3585,3586,3587,3588,3589,3590,3591,3592,3593,3599,3600,3608,3614,3615,3616,3621,3622,3623,3624,3626,3627,3633,3637,3638,3640,3645,3646,3649,3650,3651,3652,3653,3659,3660,3661,3662,3663,3664,3665,3666,3667,3668,3673,3674,3676,3677,3678,3679,3680,3682,3683,3684,3686,3687,3694,3696,3697,3698,3699,3700,3701,3702,3712,3713,3723) GROUP BY filter_option_id")