Can I use mysql queries to replace query_posts()?

It’s not clear what do you mean by template “accepting” variables.

WP_Query (which query_posts()/get_posts() are build on top of) is very flexible. In many cases it’s not as much being able to do something with it, as having experience using it to achieve results.

Typically even when queries cannot be expressed in single set of arguments, it is still very possible to make “compound” queries, by querying partial post sets and further using them in additional queries.

That said it is quite possible to use raw SQL. As long as you retrieve records from posts table accurately, you can instance WP_Post objects from them. Note that this will skip much of related WP functionality, such as caching, etc.

Related Posts:

  1. Column count doesn’t match value count at row 1
  2. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  3. MySQL string replace
  4. Access denied for user ‘root@localhost’ (using password:NO)
  5. Which MySQL data type to use for storing boolean values
  6. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  7. Cannot delete or update a parent row: a foreign key constraint fails
  8. MySQL server startup error ‘The server quit without updating PID file’
  9. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  10. Your password does not satisfy the current policy requirements
  11. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  12. What is the definition of cardinality in SQL
  13. How to restart remote MySQL server running on Ubuntu linux?
  14. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  15. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  16. Selecting data from two different tables without using joins
  17. Difference between VARCHAR and TEXT in MySQL
  18. MySQL: Invalid use of group function
  19. How can I loop through all rows of a table? (MySQL)
  20. Simple Random Samples from a Sql database
  21. What does SQL clause “GROUP BY 1” mean?
  22. LAST_INSERT_ID() MySQL
  23. SQL select only rows with max value on a column
  24. Trying to perform MINUS operation in MySQL
  25. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  26. mysql count duplicates
  27. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  28. MySQL config file location – redhat linux server
  29. Get the new record primary key ID from MySQL insert query?
  30. Create boolean column in MySQL with false as default value?
  31. Is there a naming convention for MySQL?
  32. How to get the max of two values in MySQL?
  33. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  34. MySql – HAVING vs WHERE 
  35. How to stop mysqld
  36. Is merge statement available in MySQL
  37. GROUP_CONCAT comma separator – MySQL
  38. Set page template for all pages?
  39. How to log mysql errors from wordpress core?
  40. Optimize Multiple Taxonomy Term MySQL Query?
  41. WordPress MySQL & PHP Performance
  42. What specific database privileges does WordPress need?
  43. Using source control with WordPress
  44. My WordPress site always displays a cached version of its homepage
  45. wpdb Custom Meta Data with 2 conditions
  46. Updating User Meta with SQL Query
  47. wpdb prepare syntax
  48. How to run this SQL query of wp_terms database
  49. Proper way to work with wpdb to get user’s firstname
  50. How to change post format from Aside to Image for all posts?
  51. Inserting Hundreds of Thousands of Posts at Once
  52. wp_admin edit.php slow with lots of queries
  53. How to add and SQL query of posts only published
  54. Slow Mysql Queries
  55. can database and media folder be moved to a different drive?
  56. Find duplicate posts with same slug and author
  57. How to Create a Admin User for A WordPress Site via MySQL (PHPMyAdmin)?
  58. writing inner join in wpdb
  59. How to get data from WordPress site sql file
  60. Unknown collation when I import a dump from an existing site into a development database?
  61. PHP script can’t connect to Database on port 3307
  62. WordPress with php5-fpm and nginx
  63. Migrating from Existing MySQL Setup to WordPress
  64. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  65. How to translate this mySQL query to $wpdb query
  66. $wpdb to insert html form information
  67. Proper usage of $wpdb->update()?
  68. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  69. Separate DB by yearly archive of WordPress
  70. What should a WordPress developer know about MySQL? [closed]
  71. Copyright: Get first and last date of post type
  72. Update MySQL query so that it functions again
  73. Is there a page length limit?
  74. Query posts by custom taxonomy and sort by post_modified
  75. WordPress $wpdb get posts from category and sort by custom meta
  76. WordPress insert query is not working : Showing no Error
  77. Some Post Content Does Not Show Up In DB Search
  78. Array Formation Issue
  79. Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
  80. WordPress $wpdb no result
  81. How can I view my site directly from WordPress dashboard?
  82. Word Press and database from another server sync
  83. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  84. When I add metadata, metavalue length is added in to the value in some cases
  85. edit_user_created_user hook – using to update Groups
  86. Mysql Error in querying form entries in Gravity Form plugin
  87. WordPress database error Duplicate entry for key ‘slug’
  88. Improving performance of SQL sub-queries in WordPress
  89. MySQL – How to combine data from two tables into one?
  90. Stop my loop to register data twice
  91. `#1215 – Cannot add foreign key constraint
  92. How to restore: Database intact but folders deleted
  93. XML RPC post produces immediate revision with odd post_date_gmt
  94. Woocommerce: Grab total revenue of a product over all orders
  95. cannot log in to the mysql server (wamp and wordpress)
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. SQL Database Lost
  98. InnoDB: Error: log file ./ib_logfile0 is of different size
  99. Postgres equivalent to MySQL’s \G?
  100. How can I show mysql locks?