Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> SELECT users.user_login, COUNT(*) FROM wp_posts posts JOIN wp_users users ON users.id = posts.post_author GROUP BY 1 ORDER BY 2 DESC;
- +--------------+----------+
- | user_login | COUNT(*) |
- +--------------+----------+
- | gmc | 482 |
- | bshum | 472 |
- | kmlussier | 380 |
- | tanyaprokrym | 258 |
- | brent | 256 |
- | yboston | 248 |
- | drdata | 215 |
- | roganhamby | 162 |
- | graced | 156 |
- | gcollum | 125 |
- | kgs | 102 |
- | dbs | 90 |
- | miker | 85 |
- | jason | 73 |
- | terran | 66 |
- | dbwells | 52 |
- | bill | 43 |
- | senator | 41 |
- | tspindler | 40 |
- | moodaepo | 32 |
- | terlaga | 24 |
- | buzzy | 23 |
- | jstephenson | 9 |
- | karen | 3 |
- | Christineb | 2 |
- | mjingle | 2 |
- | jpringle | 2 |
- | dmcmorris | 1 |
- | atkine | 1 |
- | artunit | 1 |
- +--------------+----------+
- 30 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement