Reply To: Mistake in documentation ? : Query posts by custom fields

• John Huebner

• October 17, 2015 at 12:24 am

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.