Title: Error using Where query
Last modified: August 24, 2016

---

# Error using Where query

 *  Resolved [memtee](https://wordpress.org/support/users/memtee/)
 * (@memtee)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/error-using-where-query/)
 * Great plugin,
 * I’ve been trying to use the Where syntax, following the discussion in [Error using Order By, Where and Limit in a query together ](https://wordpress.org/support/topic/error-using-order-by-where-and-limit-in-a-query-together?replies=3).
   I can replicate this exactly. However, I get an invalid query relating to a parse
   string error when this query is applied to my own data. Can you suggest the appropriate
   string?
 * `[gdoc key="https://docs.google.com/spreadsheets/d/1amMzEK1RxAFN5MxHh0OB-fj96-
   UuYfpAqbGRY2x4H14/edit?usp=sharing" class="no-datatables" query="SELECT B, L 
   WHERE M = 'TAP'"]`
 * [https://wordpress.org/plugins/inline-google-spreadsheet-viewer/](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/error-using-where-query/#post-6063795)
 * What error, exactly? I get no error using that shortcode, it works for me.
 *  Thread Starter [memtee](https://wordpress.org/support/users/memtee/)
 * (@memtee)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/error-using-where-query/#post-6063798)
 * When I use this shortcode:
 * `[gdoc key="https://docs.google.com/spreadsheets/d/1amMzEK1RxAFN5MxHh0OB-fj96-
   UuYfpAqbGRY2x4H14/edit?usp=sharing" class="no-datatables" query="SELECT B, L 
   WHERE M = 'TAP'"]`
 * I get this error message:
 *     ```
       {"version":"0.6" 
   
       status:"error" 
   
       errors:[{"reason":"invalid_query" 
   
       message:"INVALID_QUERY" 
   
       detailed_message:"Invalid query: PARSE_ERROREncountered \u0022c2c\u0022 at line 1 
   
       column 40.\nWas expecting one of:\n \u003cEOF\u003e \n \u0022group\u0022 ...\n \u0022pivot\u0022 ...\n \u0022order\u0022 ...\n \u0022skipping\u0022 ...\n \u0022limit\u0022 ...\n \u0022offset\u0022 ...\n \u0022label\u0022 ...\n \u0022format\u0022 ...\n \u0022options\u0022 ...\n \u0022and\u0022 ...\n \u0022or\u0022 ...\n "}]}
       ```
   
 * The site is behind a firewall so I can’t send a link.
 *  Plugin Author [Meitar](https://wordpress.org/support/users/meitar/)
 * (@meitar)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/error-using-where-query/#post-6063885)
 * That’s an error from Google. Sorry, but I can’t reproduce that error. You might
   want to try changing something about your site’s environment, since there’s no
   problems with a simpler set up.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Error using Where query’ is closed to new replies.

 * ![](https://s.w.org/plugins/geopattern-icon/inline-google-spreadsheet-viewer.
   svg)
 * [Inline Google Spreadsheet Viewer](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/inline-google-spreadsheet-viewer/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/)
 * [Active Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/inline-google-spreadsheet-viewer/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [Meitar](https://wordpress.org/support/users/meitar/)
 * Last activity: [11 years, 1 month ago](https://wordpress.org/support/topic/error-using-where-query/#post-6063885)
 * Status: resolved