6 lines
199 B
SQL
6 lines
199 B
SQL
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;
|