• I put the filter in our websites but the query which are generating it’s take too much time to respond please help it’s urgent.

    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_postmeta meta108 ON meta108.post_id=wp_posts.id INNER JOIN wp_postmeta meta109 ON meta109.post_id=wp_posts.id INNER JOIN wp_postmeta meta114 ON meta114.post_id=wp_posts.id INNER JOIN wp_postmeta meta115 ON meta115.post_id=wp_posts.id INNER JOIN wp_postmeta meta129 ON meta129.post_id=wp_posts.id WHERE 1=1 AND wp_posts.post_type IN ('post', 'page', 'attachment', 'for_sale', 'vacation_rental') AND (wp_posts.post_status = 'publish') AND ( 1 AND ( wp_posts.post_type = 'for_sale') ) AND ( 1 AND 1 AND meta108.meta_value >= 1 AND meta108.meta_value <= 10000000 AND ( meta108.meta_key='bedrooms' ) ) AND ( 1 AND 1 AND meta109.meta_value >= 1 AND meta109.meta_value <= 10000000 AND ( meta109.meta_key='bathrooms' ) ) AND ( 1 AND meta114.meta_value = 'is_Titled' AND ( meta114.meta_key='documents' ) ) AND ( 1 AND meta115.meta_value = 'Residential_Use' AND ( meta115.meta_key='zoning' ) ) AND ( 1 AND meta129.meta_value = '1' AND ( meta129.meta_key='residential' ) ) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 5

    Thanks
    In advance

    https://www.ads-software.com/plugins/wp-custom-fields-search/

  • The topic ‘Result take too much time to fetch’ is closed to new replies.