SELECT from wp_users, get Displayname too

You will need to do a JOIN on the users table in your old database, and also select the display name.

One key thing to note here, is that I aliased dbold_posts as P, and dbold_users as U – when dealing with multiple table, it’s always best practice to specify which table you are referring to when mentioning a column.

SELECT   P.post_author, count(P.ID) as amount, U.display_name
FROM     dbold_posts P
JOIN     dbold_users U on U.ID=P.post_author 
WHERE    WEEKOFYEAR( P.post_date ) = WEEKOFYEAR( NOW() )
    AND P.post_status="publish"
    AND P.post_type="post"
GROUP BY P.post_author

Related Posts:

  1. Querying Email Addresses for a List of Users with Same Last Name?
  2. WordPress SQL Issue not returning correct reselts
  3. How to get image path from id using SQL
  4. Safely changing UserID’s, re-using deleted UserID’s and automatically using deleted userID’s instead of an increment
  5. user_login vs. user_nicename
  6. Difference between update_user_meta and update_user_option
  7. Automatically delete inactive users after 2 months
  8. How to create a template for a custom URI associated with the user
  9. How to order users alphabetically by their last name?
  10. Wp_User_Query not sorting by meta key
  11. How to use hyperdb to separate and share a user dataset between wordpress installs?
  12. LEFT JOIN, INNER OUTER JOIN, LEFT OUTER JOIN is driving me crazy. Please help?
  13. \WP_User Object | What’s the Difference Between {caps} and {allcaps}?
  14. Show Biographical Info while creating new user
  15. include user profiles in search results?
  16. Where to Store Custom User Fields
  17. Plugin that would allow WordPress Authors to “follow” other Authors and query “Activity Info” from that
  18. Getting users who registered 360 days from current date
  19. How to delete users with no order history through phpmyadmin sql?
  20. User profile custom field
  21. Front end user meta options for users
  22. Drop down list in user profile page
  23. Check for user meta data at Login
  24. Searchable meta value in user.php
  25. Delete user from frontend
  26. Memory usage for scalable usermeta queries
  27. Does wp_delete_user() remove all user content?
  28. WP User Query fails when searching meta queries and search columns
  29. Log all users out of all locations after 24 hours
  30. How to set show admin bar front to true for all users?
  31. Add user data to table when user is created?
  32. User Last Login Sort Column
  33. Updating user meta
  34. WordPress User Meta & ChromePHP or other way to debug/view php variables
  35. Use wp_update_user to update custom column in wp_users table
  36. Are User Levels Still Currently Used?
  37. WPML Default Language User Meta [closed]
  38. Display users in order by an “order” custom meta field
  39. Search Users base on meta_value & meta_key
  40. mysql query two database tables, users and usermeta and sort by custom meta int value
  41. Rest API code to get ID of current user not working: get_current_user_id() gives 0
  42. Updating wp_user_level on user update
  43. Should I encrypt the response that triggers an Ajax action? Is nonce sufficient?
  44. User Meta Data in a Sortable Table
  45. get_user_meta an ID for multiple functions
  46. How can I attach a user to another user with user meta
  47. Column Sorting Code on users.php
  48. Creating user without username and password
  49. List users by meta_key and meta_value
  50. How change user type from contributor to author
  51. Is this code true or not
  52. users and usermeta table
  53. The Simple and Correct Way to Add User Meta
  54. How to pull all the contributer users records and order by Designation (which is users meta data)?
  55. cannot get user_registered date from get_user_meta
  56. How to copy user_nicename value into user_login
  57. How can I prevent certain custom roles from seeing other custom roles on the user list page?
  58. SQL Bulk update all WordPress user’s nicknames to firstname + lastname format
  59. how to set default update_user_meta values wordpress
  60. Add custom user meta data
  61. Cannot Update user meta in custom field
  62. Can I Create a Second Admin Level User Role?
  63. Get emails from users by custom field SQL
  64. How to add an attribute to a user?
  65. Adding fields to the “Add New User” but the form data not saved into DB
  66. how do I add role and capability after I create a new user
  67. User Meta stuff
  68. What does “link” refer to when you delete a user?
  69. how to delete in phpmyadmin sql – all users with certain condition and all dependencies
  70. How do I update user email from frontend input field?
  71. Reading additional fields in PMPro
  72. My custom user metadata is only active for only admin but i want it to be active on all users especially customers
  73. Update user role for expired membership
  74. SQL to set Display Name to First Name + Last Name
  75. Get UserInfo from WordPress
  76. How can i add user display name drop down menu in frontend?
  77. Hook into add_user_role and update based on new and removed roles
  78. How to prevent multiple user accounts with the same meta field?
  79. How to Moderate Edits to User Profiles?
  80. meta_query orderby sort multiple keys
  81. How to update user meta from php file?
  82. REST_query_vars for users
  83. Get meta key with value for user
  84. Require confirmation of current user’s email before updating database and before send_email_change_email
  85. Store extra user values permanently
  86. How do I change the user via SQL?
  87. Add method for tracking who referred new users
  88. Insert query not working for non-logged in user
  89. User list order by user meta
  90. User management missing after migration to new host
  91. Creating Custom user type just like custom post
  92. Validate user meta and redirect
  93. Let admin users edit member profiles from front end
  94. Sort users by custom user meta value
  95. Using and saving custom dropdown boxes on user profiles
  96. Store subscription details for users in WordPress
  97. Problem with update_user_meta() meta_value
  98. Add custom input field in new user page
  99. How can I list users by date in an array in meta_value?
  100. Export user data from Squirrly’s Starbox plugin?