Title: SQL Query Conditional
Last modified: August 24, 2022

---

# SQL Query Conditional

 *  Resolved [frankiewebs](https://wordpress.org/support/users/frankiewebs/)
 * (@frankiewebs)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/sql-query-conditional/)
 * Greetings. I used pods to create the custom lost type “Lot”. Each lot has a field
   called “lot_status”. I am trying to write an SQL query to show all lots with 
   a specific lot status. When I run it with no conditions, I get all the results.
   However, when I try to add a conditional WHERE clause, I get an ‘unknown column’
   error. I have tried lots of different combinations of meta_value and lot_status,
   but I keep getting the unknown column error.
 *     ```
       SELECT posts_lot.post_title AS lot_post_title,
              posts_lot.ID AS lot_ID,
              posts_lot.post_content AS lot_post_content,
              lot_meta_lot_status_tbl.meta_value AS lot_meta_lot_status,
              lot_meta_room_tbl.meta_value AS lot_meta_room,
              lot_meta_product_tbl.meta_value AS lot_meta_product
       FROM fzMCGsSFposts AS posts_lot
         INNER JOIN (SELECT lot_meta_lot_status_tbl_posts.ID as id, meta_value, meta_key  FROM fzMCGsSFpostmeta AS lot_meta_lot_status_tbl_postmeta  INNER JOIN fzMCGsSFposts AS lot_meta_lot_status_tbl_posts   ON lot_meta_lot_status_tbl_postmeta.post_id = lot_meta_lot_status_tbl_posts.ID   AND lot_meta_lot_status_tbl_posts.post_type = 'lot') AS lot_meta_lot_status_tbl
            ON lot_meta_lot_status_tbl.meta_key = 'lot_status' AND lot_meta_lot_status_tbl.id = posts_lot.ID 
         INNER JOIN (SELECT lot_meta_room_tbl_posts.ID as id, meta_value, meta_key  FROM fzMCGsSFpostmeta AS lot_meta_room_tbl_postmeta  INNER JOIN fzMCGsSFposts AS lot_meta_room_tbl_posts   ON lot_meta_room_tbl_postmeta.post_id = lot_meta_room_tbl_posts.ID   AND lot_meta_room_tbl_posts.post_type = 'lot') AS lot_meta_room_tbl
            ON lot_meta_room_tbl.meta_key = 'room' AND lot_meta_room_tbl.id = posts_lot.ID 
         INNER JOIN (SELECT lot_meta_product_tbl_posts.ID as id, meta_value, meta_key  FROM fzMCGsSFpostmeta AS lot_meta_product_tbl_postmeta  INNER JOIN fzMCGsSFposts AS lot_meta_product_tbl_posts   ON lot_meta_product_tbl_postmeta.post_id = lot_meta_product_tbl_posts.ID   AND lot_meta_product_tbl_posts.post_type = 'lot') AS lot_meta_product_tbl
            ON lot_meta_product_tbl.meta_key = 'product' AND lot_meta_product_tbl.id = posts_lot.ID 
       WHERE 1=1 
          AND posts_lot.post_content > '0'
          AND posts_lot.post_type = 'lot'
          AND lot_status.meta_value = '1199'
       ```
   
 * Can you help me find the proper syntax to target the lot_status field with a 
   where function?
 * Thanks very much! Let me know if you need more information.

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

 *  Thread Starter [frankiewebs](https://wordpress.org/support/users/frankiewebs/)
 * (@frankiewebs)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/sql-query-conditional/#post-15944069)
 * Also tried a slightly different approach that yielded the same unknown column
   error.
 *     ```
       SELECT posts_lot.post_title AS lot_post_title,
              posts_lot.ID AS lot_ID,
              posts_lot.post_content AS lot_post_content,
              lot_meta_lot_status_tbl.meta_value AS lot_meta_lot_status,
              lot_meta_room_tbl.meta_value AS lot_meta_room,
              lot_meta_product_tbl.meta_value AS lot_meta_product
       FROM fzMCGsSFposts AS posts_lot
         INNER JOIN (SELECT lot_meta_lot_status_tbl_posts.ID as id, meta_value, meta_key  FROM fzMCGsSFpostmeta AS lot_meta_lot_status_tbl_postmeta  INNER JOIN fzMCGsSFposts AS lot_meta_lot_status_tbl_posts   ON lot_meta_lot_status_tbl_postmeta.post_id = lot_meta_lot_status_tbl_posts.ID   AND lot_meta_lot_status_tbl_posts.post_type = 'lot') AS lot_meta_lot_status_tbl
            ON lot_meta_lot_status_tbl.meta_key = 'lot_status' AND lot_meta_lot_status_tbl.id = posts_lot.ID 
            AND lot_meta_lot_status = '1199'
         INNER JOIN (SELECT lot_meta_room_tbl_posts.ID as id, meta_value, meta_key  FROM fzMCGsSFpostmeta AS lot_meta_room_tbl_postmeta  INNER JOIN fzMCGsSFposts AS lot_meta_room_tbl_posts   ON lot_meta_room_tbl_postmeta.post_id = lot_meta_room_tbl_posts.ID   AND lot_meta_room_tbl_posts.post_type = 'lot') AS lot_meta_room_tbl
            ON lot_meta_room_tbl.meta_key = 'room' AND lot_meta_room_tbl.id = posts_lot.ID 
         INNER JOIN (SELECT lot_meta_product_tbl_posts.ID as id, meta_value, meta_key  FROM fzMCGsSFpostmeta AS lot_meta_product_tbl_postmeta  INNER JOIN fzMCGsSFposts AS lot_meta_product_tbl_posts   ON lot_meta_product_tbl_postmeta.post_id = lot_meta_product_tbl_posts.ID   AND lot_meta_product_tbl_posts.post_type = 'lot') AS lot_meta_product_tbl
            ON lot_meta_product_tbl.meta_key = 'product' AND lot_meta_product_tbl.id = posts_lot.ID 
       WHERE 1=1 
          AND posts_lot.post_type = 'lot'
       ```
   
 *  Plugin Author [Scott Kingsley Clark](https://wordpress.org/support/users/sc0ttkclark/)
 * (@sc0ttkclark)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/sql-query-conditional/#post-15944073)
 * Try replacing:
 * `AND lot_status.meta_value = '1199'`
 * with:
 * `AND lot_meta_lot_status_tbl.meta_value = '1199'`
 * Also, I’d probably write that query in simpler way like this:
 *     ```
       SELECT 
       	posts_lot.post_title AS lot_post_title,
       	posts_lot.ID AS lot_ID,
       	posts_lot.post_content AS lot_post_content,
       	lot_meta_lot_status_tbl.meta_value AS lot_meta_lot_status,
       	lot_meta_room_tbl.meta_value AS lot_meta_room,
       	lot_meta_product_tbl.meta_value AS lot_meta_product
       FROM fzMCGsSFposts AS posts_lot
       LEFT JOIN fzMCGsSFpostmeta AS lot_meta_lot_status_tbl
       	ON lot_meta_lot_status_tbl.post_id = posts_lot.ID
       	AND lot_meta_lot_status_tbl.meta_key = 'lot_status'
       LEFT JOIN fzMCGsSFpostmeta AS lot_meta_room_tbl
       	ON lot_meta_room_tbl.post_id = posts_lot.ID
       	AND lot_meta_room_tbl.meta_key = 'room'
       LEFT JOIN fzMCGsSFpostmeta AS lot_meta_product_tbl
       	ON lot_meta_product_tbl.post_id = posts_lot.ID
       	AND lot_meta_product_tbl.meta_key = 'product'
       WHERE
       	posts_lot.post_content != ''
       	AND posts_lot.post_type = 'lot'
       	AND lot_meta_lot_status_tbl.meta_value = '1199'
       ```
   
 *  Thread Starter [frankiewebs](https://wordpress.org/support/users/frankiewebs/)
 * (@frankiewebs)
 * [3 years, 9 months ago](https://wordpress.org/support/topic/sql-query-conditional/#post-15944101)
 * That did the trick, Scott. I also used the rewritten query you supplied. Thank
   you for your lightning fast response!

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

The topic ‘SQL Query Conditional’ is closed to new replies.

 * ![](https://ps.w.org/pods/assets/icon.svg?rev=3286397)
 * [Pods - Custom Content Types and Fields](https://wordpress.org/plugins/pods/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/pods/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/pods/)
 * [Active Topics](https://wordpress.org/support/plugin/pods/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/pods/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/pods/reviews/)

## Tags

 * [meta_value)](https://wordpress.org/support/topic-tag/meta_value/)
 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [sql-query](https://wordpress.org/support/topic-tag/sql-query/)
 * [unknown column](https://wordpress.org/support/topic-tag/unknown-column/)
 * [where](https://wordpress.org/support/topic-tag/where/)

 * 3 replies
 * 2 participants
 * Last reply from: [frankiewebs](https://wordpress.org/support/users/frankiewebs/)
 * Last activity: [3 years, 9 months ago](https://wordpress.org/support/topic/sql-query-conditional/#post-15944101)
 * Status: resolved