How to test the outcome of a wpdb query?

First of all, you should look into using WP_Query for this:

http://scribu.net/wordpress/advanced-metadata-queries.html

Secondly, to see the results, just do a var_dump() before the return:

echo '<pre>';
var_dump( $data );

Related Posts:

  1. How to get all term meta for a taxonomy – getting term_meta for taxonomy
  2. Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
  3. Triple meta_key on custom SELECT query
  4. Get updated post meta on save_post action?
  5. MySQL Query To Select Post By Postmeta
  6. Set Condition echo function get_post_meta
  7. Get a row from a separate table by matching a posts meta_key to a tables ID column
  8. Compare string with post id in wpdb and do stuff when match is found
  9. Read post meta values, only if posts are public
  10. wpdb->get_var – count author posts, meta value
  11. How to query and update one colum in postmeta table?
  12. Display current ranking of post as a number in post title
  13. get specific values from WordPress meta_value
  14. Get data from custom table and update relative post_meta based on meta_key
  15. Get table parameter and save in meta value
  16. Exclude category from DB query
  17. Fetching array of postmeta with $wpdb and in_array conditional
  18. Which query method to use? (edit- wpdb syntax problems)
  19. Cache metadata for set of posts
  20. How to get all the related ids without array?
  21. How do I retrieve the slug of the current page?
  22. Most efficient way to get posts with postmeta
  23. Get posts by meta value
  24. Explanation of update_post_(meta/term)_cache
  25. How to extract data from a post meta serialized array?
  26. How to save an array with one metakey in postmeta?
  27. WordPress is stripping escape backslashes from JSON strings in post_meta
  28. How can I get the post ID from a WP_Query loop?
  29. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  30. How to update_post_meta value as array
  31. Adding meta tag without plugin
  32. What’s the point of get_post_meta’s $single param?
  33. What is the different between an attachment in wp_posts and an attachment in wp_postmeta?
  34. How to edit a post meta data in a Gutenberg Block?
  35. Sanitizing integer input for update_post_meta
  36. post formats – how to switch meta boxes when changing format?
  37. Execute action after post is saved with all related post_meta records (data)
  38. Lack of composite indexes for meta tables
  39. Get a single post by a unique meta value
  40. if get_post_meta is empty do something
  41. How we get_post_meta without post id
  42. How get post id from meta value
  43. What is the code to get the download link for a product in WooCommerce?
  44. Safe to delete blank postmeta?
  45. So much data in postmeta
  46. advanced custom fields update_field for field type: Taxonomy
  47. update_post_meta not saving when value is zero
  48. Content hooks vs User hooks
  49. Meta compare with date (stored as string) not working
  50. Trying to get custom post meta through Jetpack JSON API [closed]
  51. How to update/insert custom field(post meta) data with wordpress REST API?
  52. What is the advantage of the wp_options design pattern?
  53. Restrict post edit/delete based on user ID and custom field
  54. get_post_meta returning empty string when data shows in the database
  55. publish_post action hook doesn’t give post_meta_data
  56. Remove WordPress.org Meta link
  57. Remove post meta keys
  58. How to access the post meta of a post that has just been published?
  59. Why time functions show invalid time zone when using ‘c’ time format?
  60. Why is get_post_meta returning an array when I specify it as single?
  61. How to update/delete array in post meta value?
  62. Adding an assisting editor box to Post page
  63. WPDB Multiple site’s posts and get featured images
  64. delete unused postmeta
  65. Should I sanitize custom post meta if it is going to be escaped later?
  66. Add post meta based on another post meta value before publish post
  67. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  68. Front-end update_post_meta snippet displays white screen?
  69. Query between two meta values?
  70. Save both current and new version of post meta
  71. Get Advanced Custom Fields values before saving [closed]
  72. Give extra post-meta to RSS feeds
  73. How to get meta value in wp_attachment_metadata
  74. WP REST API “rest_no_route” when trying to update meta
  75. Clean up output added via wp_head()
  76. List posts under meta_value heading
  77. Why am I getting an infinite loop with have_posts?
  78. get_post_meta – get a single value
  79. delete value 0 in post meta [closed]
  80. Can I safely delete a record, manually, in the wp postmeta table?
  81. How to store post meta in an array?
  82. What action hook updates post meta?
  83. Can’t translate the post meta data (Date) in another language
  84. get_post_meta / update_post_meta array
  85. adding a URL to a post meta
  86. Exclude a category from the filed under list
  87. How do I access post meta data when publishing a new post in Gutenberg?
  88. update_post_meta() not working when used with WordPress action
  89. Using Advanced Custom Field (ACF) to insert meta description on each page
  90. get_post_custom()
  91. Adding meta data to an attachment post
  92. update_post_meta not adding anything.(Nor add_post_meta)
  93. loop through all meta keys with get_post_meta
  94. Get posts by meta value with date
  95. How to add meta tag to wordpress posts filter?
  96. Are multiple values from get_post_meta guaranteed to be ordered?
  97. Identifying Importer Posts
  98. Get post from meta_key and meta_value
  99. Add a post metadata if only the key and value does not exist
  100. get_post_meta returns bool(false)