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 ()