How can I display a query in a page?

You can use the $wpdb object

// Print last SQL query string
$wpdb->last_query

or:

<?php
  if (current_user_can('administrator')){
    global $wpdb;
    echo "<pre>";
    print_r($wpdb->queries);
    echo "</pre>";
  }//Lists all the queries executed on your page
?>

You might have to set define('SAVEQUERIES', true); in wp-config.php

Related Posts:

  1. Delete post revisions on post publish
  2. Why is variable not working on custom sql query using wpdb?
  3. Create WP_Query to search for posts by their categories or their parent/child categories
  4. SQL error with custom query
  5. Query doesn’t display text data with apostrophes
  6. the_date() not working
  7. Query multiple custom post types in single loop
  8. Build a content and excerpt grid loop with paging and options for # of posts
  9. How to create a WP_Query to search the Title or Tag?
  10. Show only one post for each author ( Page loads too slow )
  11. How to sort results from a custom database table
  12. Dynamically Override Fancy Title – Part II
  13. How to add 2 posts under another post? Formatting should be intact
  14. Modern Tribe Calendar wp-query with meta query not working at all
  15. WP database error for comments_popup_link()
  16. if statement on database query
  17. Is the regular ajax request method safe or I should use admin-ajax.php?
  18. Successful or Error Message after running mysql code in functions.php
  19. my function doesn’t return my post from today
  20. Insert all post IDs in new database table
  21. How to get to a specific position in wp_query?
  22. Looking for most performant way to execute several similar WP queries within shortcodes
  23. Use wp_get_recent_posts with search term
  24. Remove query string specific key value
  25. PHP code inside shortcodes
  26. How to securely provide a $_POST var in WP_Query with PHP 7?
  27. WSoD being caused by this piece of code
  28. mysql query from wordpress page using custom table
  29. only show container with next/prev links if they exist?
  30. ACF: how do I get the fields and its values of a specific group?
  31. How to check if a meta value has already been assigned to any user?
  32. How to prevent WP_Query function from returning all posts when empty?
  33. Display a specific category of products in shop page and disable code for specific actions
  34. WP_Query adds “(wp_posts.ID = ‘0’)” so no results are returned
  35. Get users that likes the post
  36. Long running queries
  37. get_posts() and WP_query limits ‘AND’ conditions to a maximum of 6 for meta value queries in WordPress
  38. inserting a post from an extern php file but post content doesn’t show on wp site
  39. Using $wpdb (WPDB class) ‘replace’ with multiple WHERE criteria problem
  40. Remove echo from shortcode
  41. $wpdb->wp_users returning empty value for
  42. register_taxonomy() take much queries
  43. WordPress SQL injection
  44. Security for data obtained from the database
  45. unable to use ‘new WP_Query’ in AJAX call
  46. How to overwrite orderby with add_query_var
  47. Issue with fetching mysql data and displaying results via shortcode in webpage
  48. WP_Query | IF within $args array | Help me only add specific arguments if the argument is not blank
  49. How to display SQL query that ran in WC_Order_Query?
  50. Custom route and query
  51. change the default order of posts only for specific categories
  52. How to use mysql LIKE with wpdb?
  53. How to hide posts of a specific custom category in WordPress?
  54. Post not populating for custom post type based on category selection
  55. Custom query vars filters problem with pagination
  56. WordPress WP_Query without query GET parameters
  57. How to get post category list as select in front-end?
  58. mySQL queries are executed twice on wordpress website
  59. Displaying Event within two given time frames
  60. making php value numeric
  61. WordPress Custom Query: Combining Two Functions
  62. How can I modify this code to make the search box include tags and meta
  63. How to WP_Query posts order by parent title?
  64. Let current user know pending posts counts using wp_query
  65. Output product category link from WP_Query
  66. Isn’t Returning Value While Using SELECT COUNT(*) FROM {$wpdb->prefix}
  67. Reject all malicious URL requests functions.php
  68. “pre_get_posts” orderby custom date field in different format?
  69. Passing in MySQL prepare statement parameter separately throwing error
  70. WP query posts BUT show the most recent and one per author
  71. Ajax filter with loadmore button
  72. posts_per_page displays only 2 posts instead of 4 posts
  73. Usermeta data unserialize, extract and display in table in WordPress
  74. how to get data from two different table from wordpress database
  75. Delete post meta by serialized meta value
  76. How can i limit the number of posts to the most recent 6 in my query?
  77. Modify post image in full size
  78. WP_Query To Display Product Of Brand On Taxonomy Page
  79. Offset with ajax load more posts duplicates
  80. wordpress query returning unexpected results
  81. Custom Post type Ajax search results
  82. How to do a MySql query in WordPress?
  83. My query keeps looping infinitely ! how to stop it?
  84. Include a custom field in mysql query
  85. insert thumbnail image from php script
  86. How to set up an auto delete post?
  87. Weird Behaviour: Not all WordPress Posts appearing
  88. List sibling pages widget, exclude current page
  89. Check if values exists DB
  90. How to get category pages to look like a certain archive page?
  91. Custom query_posts() parameter
  92. Does wp_query and query_posts affect website performance? [duplicate]
  93. Query Concatenation
  94. How to modify this function to exclude also the post belonging to a specific category?
  95. Show post like this image in my newssite [closed]
  96. Execute multiple PHP Snippets causes error?
  97. Three different queries on same page
  98. /page/2/ redirect to 404
  99. Add adjacent post function inside custom recent post function
  100. Exclude a category ID from the following function