• 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.