ERROR:

SELECT

COUNT( products__items_general.id ) AS "total"

FROM products__items_general
LEFT JOIN products__items_general_translations
ON products__items_general.id = products__items_general_translations.id_shared

WHERE products__items_general_translations.language = ?
AND products__items_general.id_parent IN ()