SELECT * FROM wp_posts INNER JOIN wp_postmeta AS m ON (wp_posts.ID = m.post_id) INNER JOIN wp_terms AS t ON x.term_id = t.term_id INNER JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id) INNER JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id) INNER JOIN wp_postmeta AS mt3 ON (wp_posts.ID = mt3.post_id) WHERE (((wp_posts.post_title LIKE '%%'))) AND (wp_posts.post_status = 'publish') AND (wp_posts.post_type IN ('ad_listing')) AND ((mt1.meta_key = 'cp_price') AND (CAST(mt1.meta_value AS SIGNED) BETWEEN '2500' AND '17200')) AND ((mt2.meta_key = 'cp_kilomtrage') AND (CAST(mt2.meta_value AS SIGNED) BETWEEN '2500km' AND '150000km'))
There are currently 1 users browsing this thread. (0 members and 1 guests)