SQL statement leads into an error

    AND (tx_dmftravelagent_domain_model_city.sys_language_uid IN (4,-1)
         OR (tx_dmftravelagent_domain_model_city.sys_language_uid=0
             AND tx_dmftravelagent_domain_model_city.uid NOT IN
                 (SELECT tx_dmftravelagent_domain_model_city.l10n_parent
                  FROM tx_dmftravelagent_domain_model_city
                  WHERE tx_dmftravelagent_domain_model_city.l10n_parent>0
                      AND tx_dmftravelagent_domain_model_city.sys_language_uid>0
                      AND tx_dmftravelagent_domain_model_city.deleted=0)))