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 (129' 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 (1298,1307,1312,1313,1314,1316,1318,1319,1320,1324,1325,1326,1327,1328,1329,1330,1331,1332,1333,1334,1340,1341,1346,1347,1348,1350,1351,1359,1365,1367,1368,1369,1370,1371,1372,1373,1374,1375,1376,1396,1400,1402,1403,1404,1405,1406,1407,1408,1417,1431,1433,1437,1438,1442,1445,1446,1447,1448,1484,1487,1488,1491,1493,1494,1500,1519,1520,1521,1522,1525,1537,1540,1541,1542,1546,1554,1555,1556,1594,1595,1596,1597,1598,1600,1601,1602,1603,1604,1605,1606,1608,1611,1734,1736,1737,1738,1742,1744,1745,1747,1814,1815,1816,1817,1819,1820,1822,1823,1825,1826,1829,1830,1891,1914,1915,1917,1943,1944,1946,1947,1949,1955,1956,1961,1966,1972,2000,2003,2008,2009,2010,2021,2028,2065,2090,2092,2093,2094,2104,2105,2106,2122,2170,2171,2174,2175,2176,2177,2178,2179,2182,2185,2186,2187,2190,2191,2192,2193,2194,2195,2196,2214,2215,2217,2219,2223,2224,2225,2232,2243,2244,2246,2247,2248,2249,2252,2254,2255,2257,2258,2279,2282,2283,2284,2310,2311,2313,2320,2321,2323,2326,2327,2330,2331,2332,2333,2334,2350,2353,2358,2359,2360,2361,2362,2364,2366,2367,2371,2374,2380,2381,2390,2392,2393,2395,2407,2408,2419,2421,2423,2424,2425,2426,2427,2428,2431,2432,2433,2434,2435,2436,2437,2439,2443,2444,2447,2448,2449,2450,2454,2461,2463,2465,2466,2467,2472,2479,2480,2481,2483,2484,2486,2487,2488,2491,2493,2495,2497,2498,2513,2523,2524,2528,2536,2539,2542,2544,2547,2548,2549,2550,2551,2556,2557,2558,2559,2560,2561,2563,2565,2566,2569,2570,2571,2578,2580,2590,2591,2597,2598,2600,2601,2602,2603,2605,2606,2607,2608,2610,2611,2612,2613,2614,2615,2616,2617,2620,2623,2625,2627,2628,2630,2631,2633,2634,2638,2652,2655,2656,2657,2658,2659,2660,2661,2664,2666,2667,2670,2671,2672,2673,2674,2675,2676,2678,2682,2683,2684,2692,2693,2694,2695,2697,2698,2699,2700,2701,2703,2704,2706,2707,2708,2709,2710,2711,2712,2713,2714,2716,2717,2718,2720,2721,2726,2727,2728,2729,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2744,2746,2747,2748,2749,2751,2752,2755,2761,2762,2832,2833,2834,2835,2839,2840,2841,2842,2844,2851,2852,2854,2855,2856,2857,2859,2860,2861,2862,2863,2864,2865,2866,2868,2869,2870,2871,2872,2873,2874,2875,2876,2878,2879,2888,2890,2891,2897,2906,2907,2908,2909,2910,2914,2918,2919,2920,2921,2924,2925,2929,2936,2939,2940,2951,2952,2957,2958,2960,2961,2973,2974,2976,2977,2978,2979,2986,2987,2988,2989,2990,2992,2993,2997,2999,3000,3009,3066,3068,3069,3071,3081,3082,3084,3085,3088,3090,3105,3107,3111,3112,3113,3114,3115,3118,3119,3120,3121,3122,3127,3128,3133,3135,3136,3174,3175,3181,3182,3187,3192,3199,3200,3205,3210,3211,3216,3219,3220,3221,3222,3231,3263,3264,3265,3266,3267,3268,3279,3281,3282,3283,3284,3287,3288,3290,3294,3296,3297,3300,3337,3338,3341,3342,3344,3345,3351,3352,3353,3360,3361,3362,3363,3364,3365,3366,3369,3370,3375,3376,3411,3412,3413,3414,3415,3416,3417,3418,3419,3420,3421,3423,3425,3426,3428,3429,3447,3451,3454,3458,3461,3462,3463,3464,3465,3560,3561,3562,3563,3564,3566,3567,3569,3577,3578,3579,3580,3581,3582,3583,3590,3591,3592,3595,3596,3597,3598,3604,3699) GROUP BY filter_option_id")