SELECT COUNT(*) FROM variants 
WHERE sprite_id='units/bowmen_dwarves_f' 
AND job_status='completed' 
AND raw_path IS NOT NULL 
AND (rating IS NULL OR rating != -1) 
AND COALESCE(review_tier, 0) = 0;