mysql select select count from currency as total select count from cur

1
2
3
4
5
6
7
mysql> select (select count(*) from currency) as total, (select count(*) from currency where title_en is null) as null_title_en, (select count(*) from currency where title_ru is null) as null_title_ru, (select count(*) from currency where wikipedia_en is null) as null_wiki_en, (select count(*) from currency where wikipedia_ru is null) as null_wiki_ru;
+-------+---------------+---------------+--------------+--------------+
| total | null_title_en | null_title_ru | null_wiki_en | null_wiki_ru |
+-------+---------------+---------------+--------------+--------------+
| 157 | 0 | 80 | 0 | 80 |
+-------+---------------+---------------+--------------+--------------+
1 row in set (0.01 sec)