Post meta filter query very slow
-
Please help me it’s very very important. My query is like as
SELECT wposts.* FROM wp_posts wposts, wp_postmeta pt, wp_postmeta pm, wp_postmeta pl, wp_postmeta ps, wp_postmeta cm, wp_postmeta li, wp_postmeta of WHERE wposts.ID = pt.post_id AND wposts.ID = pm.post_id AND wposts.ID = pl.post_id AND wposts.ID = ps.post_id AND wposts.ID = cm.post_id AND wposts.ID = li.post_id AND wposts.ID = of.post_id AND (pt.meta_key = 'documents' AND pt.meta_value = 'is_Titled') AND (pm.meta_key = 'neighborhood' AND pm.meta_value = 'Esperanza') AND (pl.meta_value = 'Residential_Use' AND pl.meta_key='zoning' ) AND (ps.meta_value = '1' AND ps.meta_key='residential' ) AND (cm.meta_value = '1' AND cm.meta_key='commercial' ) AND (li.meta_value = '12' AND li.meta_key='listing_id' ) AND (of.meta_value = '1' AND of.meta_key='owner_financing' ) AND wposts.post_type IN ('post', 'page', 'attachment', 'for_sale', 'vacation_rental') AND (wposts.post_type = 'for_sale') AND wposts.post_status = 'publish' GROUP BY wposts.ID DESC
Please help.
Thanks
In advance
- The topic ‘Post meta filter query very slow’ is closed to new replies.