Advertisement
Guest User

Changes made to wp_posts (pages) for evgils wordpress site

a guest
May 10th, 2017
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 1.13 KB | None | 0 0
  1. 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;
  2. +--------------+----------+
  3. | user_login   | COUNT(*) |
  4. +--------------+----------+
  5. | gmc          |      482 |
  6. | bshum        |      472 |
  7. | kmlussier    |      380 |
  8. | tanyaprokrym |      258 |
  9. | brent        |      256 |
  10. | yboston      |      248 |
  11. | drdata       |      215 |
  12. | roganhamby   |      162 |
  13. | graced       |      156 |
  14. | gcollum      |      125 |
  15. | kgs          |      102 |
  16. | dbs          |       90 |
  17. | miker        |       85 |
  18. | jason        |       73 |
  19. | terran       |       66 |
  20. | dbwells      |       52 |
  21. | bill         |       43 |
  22. | senator      |       41 |
  23. | tspindler    |       40 |
  24. | moodaepo     |       32 |
  25. | terlaga      |       24 |
  26. | buzzy        |       23 |
  27. | jstephenson  |        9 |
  28. | karen        |        3 |
  29. | Christineb   |        2 |
  30. | mjingle      |        2 |
  31. | jpringle     |        2 |
  32. | dmcmorris    |        1 |
  33. | atkine       |        1 |
  34. | artunit      |        1 |
  35. +--------------+----------+
  36. 30 rows in set (0.01 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement