quick select to find content marketers

query.txt

select domain, count(*) as submitted, count(distinct stories.user_id) as submitters from domains join stories on domains.id = stories.domain_id group by domain having count(*) > 5 and count(distinct stories.user_id) =1 order by 2 desc limit 30;
+----------------------------+-----------+------------+
| domain                     | submitted | submitters |
+----------------------------+-----------+------------+
| vuejsdevelopers.com        |        52 |          1 |
| driftingruby.com           |        48 |          1 |
| pythonspeed.com            |        40 |          1 |
| tboox.org                  |        38 |          1 |
| newrustacean.com           |        34 |          1 |
| joezimjs.com               |        28 |          1 |
| geeklan.co.uk              |        27 |          1 |
| davidgerard.co.uk          |        26 |          1 |
| blog.higg.im               |        25 |          1 |
| pragtob.wordpress.com      |        25 |          1 |
| hoelz.ro                   |        24 |          1 |
| beastie.pl                 |        20 |          1 |
| blog.dantup.com            |        19 |          1 |
| monades.roperzh.com        |        18 |          1 |
| oshug.org                  |        17 |          1 |
| prathamesh.tech            |        17 |          1 |
| silvestarbistrovic.from.hr |        17 |          1 |
| lauradhamilton.com         |        16 |          1 |
| microservicesweekly.com    |        16 |          1 |
| notamonadtutorial.com      |        16 |          1 |
| aiprobook.com              |        15 |          1 |
| blog.asrpo.com             |        15 |          1 |
| blog.cubehero.com          |        15 |          1 |
| blog.garage-coding.com     |        15 |          1 |
| cmcenroe.me                |        15 |          1 |
| dev.theladders.com         |        15 |          1 |
| thefullstack.xyz           |        15 |          1 |
| zendev.com                 |        15 |          1 |
| jugad2.blogspot.com        |        14 |          1 |
| penguindreams.org          |        14 |          1 |
+----------------------------+-----------+------------+
30 rows in set (2.39 sec)