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.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.