Title: proper sql query format
Last modified: June 17, 2020

---

# proper sql query format

 *  [011rtc](https://wordpress.org/support/users/011rtc/)
 * (@011rtc)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/proper-sql-query-format/)
 * Usign this plugin, I am trying to execute SQL query
    $post_count = $wpdb->get_var(“
   SELECT * FROM 011wp_posts WHERE post_type = ‘post’ AND post_status=’publish’ ”);
 * WHen saving it I get:
    412 Error Your request got filtered out due to possible
   security issues. One or more things in your request were suspicious (defective
   request header, invalid cookies, bad parameters)
 * In phpMySQL query (SELECT * FROM 011wp_posts WHERE post_type = ‘post’ AND post_status
   = ‘publish’; ) works and I would get 3 rows accounted for.
 * Any suggestion please.

The topic ‘proper sql query format’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/custom-css-js-php.svg)
 * [Custom css-js-php](https://wordpress.org/plugins/custom-css-js-php/)
 * [Support Threads](https://wordpress.org/support/plugin/custom-css-js-php/)
 * [Active Topics](https://wordpress.org/support/plugin/custom-css-js-php/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/custom-css-js-php/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/custom-css-js-php/reviews/)

 * 0 replies
 * 1 participant
 * Last reply from: [011rtc](https://wordpress.org/support/users/011rtc/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/proper-sql-query-format/)
 * Status: not resolved