SELECT count(*) AS anzahl FROM tbl_pkw WHERE db_online = 1 AND db_fahrzeugstatus = 1 AND db_fahrzeugart_id NOT IN (1,4,5,7,8,9) AND db_bereich IN (1,2,3,4) AND db_haendlerfahrzeug = 0