get posts and postmetas in assoc array

Basically, you can’t do it in a single SQL query. You need two.

You don’t have to make direct queries though, since you can use get_post() and get_post_custom().

Related Posts:

  1. Export WordPress Posts and Meta Information in CSV format
  2. post__in for get_posts with a dynamic array
  3. Using $wpdb to query posts with meta value containing current post_id
  4. how to get permalink using sql
  5. WP_Query to work with custom view
  6. Replace Main Query With Custom Query
  7. Use Cron to modify posts via sql
  8. Sql syntax error
  9. How do I batch create revisions of all posts?
  10. How do I find which articles are missing a featured image in The WordPress database?
  11. Bulk update post slugs through database
  12. Get the most repeated post contents from a search?
  13. Multiples Empty Posts were created and cannot delete them
  14. Delete WordPress posts from URL list sql query
  15. SQL query to retrieve all the records that have not indicated category
  16. How to verify wp user password by sql query in wp? [closed]
  17. Get ALL post ID’s export list (Only id’s. Php or sql not important )
  18. How to do set post permalinks using 6 digit random unique function?
  19. Using $wpdb to fetch posts with meta data
  20. Creating a post from data returned from HTML form
  21. wp_posts table: safely remove unused columns to save database storage
  22. Why Query is returning empty array?
  23. WordPress website loads more posts than expected
  24. SQL Command for restoring trashed comments
  25. meta_value timestamp older than now
  26. Displaying post excerpt using wpdb query
  27. How to Assign / Move all Deleted post to a category
  28. Migrate posts from category and sub-category via SQL
  29. Retrieving posts by their date and category
  30. remove all custom post created
  31. SQL Bulk Move old posts by one author to another category
  32. Export all posts to import as product items
  33. How can I get posts from 9/13/11 to today with SQL? [closed]
  34. query for filtering published posts?
  35. How to save template data into wp_post table (post_content column)
  36. Change published date and time using SQL query for page in every 5 hour
  37. SQL DELETE multiple post_meta on single and multi-sites
  38. Bulk find & replace on WordPress posts/pages (minus image paths)
  39. SQL query: select duplicate posts – but using duplicate meta [duplicate]
  40. Top tags with minimum number of posts
  41. WordPress MySQL Search and replace with wildcard?
  42. Using a meta_value or postdate to to query and orderby
  43. insert post fails after multiple postings
  44. wp_insert_post not inserting post
  45. Adding wordpress posts using phpmyadmin
  46. How to run select query of post with category and tags?
  47. I am not getting result from php function that is json encoded
  48. Export Posts with specific custom fields by sql
  49. Query to get data of a post, if in category?
  50. Can’t create posts with WP DB Abstraction Plugin
  51. Save/retrieve form data best practises for theme development
  52. SQL query to remove first image in all posts
  53. Delete junk text from all the post using my sql command
  54. Special Query: Title, Terms, Content – %LIKE%
  55. If meta_key exists then don’t select this post?
  56. The page that displays Posts on homepage
  57. WP_Query post_tilte search in posts table
  58. Change permalinks in posts via SQL
  59. Batch Scanning and Deleting Empty WordPress Posts
  60. How to Change Order of Posts in Admin?
  61. Multipart/formatted MySQL query problem
  62. Categories box not showing on post edit pages
  63. Removing the title attribute from links in the post content
  64. Custom function for “Submit for Review” hook
  65. how load content as pop-up using ajax
  66. Improving WP_Query for performance when random posts are ordered
  67. How to make the post summary taller?
  68. Why content_arr[‘extended’] removes paragraph tags?
  69. Getting index.php instead single.php for displaying posts
  70. Changing Permalinks for Default Post type to reflect navigation
  71. It is possible to add extra button under the ‘publish’ button in the post of wordpress? and how?
  72. 404 error on default post type and default taxonomy fronted page
  73. How i can limit period of post publication?
  74. Display post changelog in post
  75. All Posts Linking to Author Posts directly
  76. search blog posts by author first name and or last name
  77. Make loop inside slider divisible [closed]
  78. How to add convenient buttons for new custom post statuses
  79. Database hacked – random posts are modified
  80. Display value of custom field at the beginning of a post
  81. How to display post list in a table layout (multiple queries in single loop)
  82. Post is in descendant category not working in home.php
  83. How to show 3 most recent/viewed posts in a special tiles on home page using wordpress?
  84. Get content from WordPress posts in Boostrap modal window – Javascript side?
  85. How to assign a post to a post parrent?
  86. Bulk update published posts date randomly using wp-cli?
  87. How to insert custom text after H1 to all my blog posts?
  88. Sync All Post Type Tag
  89. how to redirect page after delete post inside a post page?
  90. Permalink base only for posts
  91. Custom fields in normal posts
  92. Modify WordPress loop after it has been run
  93. How to get next_posts_link working with a customised page
  94. Loop doesn’t display posts. It displays a link to the home page instead
  95. Custom Post Type Pagination 404 Error (if paged>=2) [duplicate]
  96. Show all posts in category
  97. Creating a new Sortable Column in WordPress Admin
  98. How can add custom commands in post-new.php in wordpress
  99. Filter/Sort Post Form On Taxonomy page
  100. Display post by select it from a dropdown menu