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 (841' 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 (841,842) GROUP BY filter_option_id")