Support

Account

Home Forums Add-ons Repeater Field Mistake in documentation ? : Query posts by custom fields Reply To: Mistake in documentation ? : Query posts by custom fields

  • This is the reason it times out

    
    FROM
        wp_posts
            INNER JOIN
        wp_postmeta ON (wp_posts.ID = wp_postmeta.post_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)
            INNER JOIN
        wp_postmeta AS mt4 ON (wp_posts.ID = mt4.post_id)
            INNER JOIN
        wp_postmeta AS mt5 ON (wp_posts.ID = mt5.post_id)
            INNER JOIN
        wp_postmeta AS mt6 ON (wp_posts.ID = mt6.post_id)
    

    This is why I said

    My only concern for this would might be the length of time it takes the query to run, that might give you a problem.

    There is a known issue in WP with multiple joins on the meta table.

    I’m not sure that there is a solution, at least I have not seen one so far, at least not a direct solution.