Example ISFDB query

MariaDB [isfdb]> select tag_name, count(1) c from pubs p left outer join pub_content pc on pc.pub_id = p.pub_id left outer join tag_mapping tm on tm.title_id = pc.title_id left outer join tags t on t.tag_id = tm.tag_id where pub_year >= '2018-10-01' and pub_year <= '2018-12-31' and (pub_ctype = 'NOVEL' or pub_ctype = 'CHAPBOOK') group by tag_name order by c desc limit 10;
+---------------------+------+
| tag_name            | c    |
+---------------------+------+
| NULL                | 1985 | <-- This being the most common shows that most 2018Q4 novels/novellas haven't had a (sub)genretag
| young-adult fantasy |  262 |
| juvenile fantasy    |  260 |
| fantasy             |  235 |
| science fiction     |  181 |
| paranormal romance  |  160 |
| horror              |  146 |
| urban fantasy       |  135 |
| young-adult sf      |  111 |
| historical fantasy  |  104 |
+---------------------+------+