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!
ACF wouldn’t be so widely used in WordPress if it didn’t have some pretty amazing capabilities. In this article, we look at a few of the features we’ll discuss during “7 things you didn’t know you could do with ACF” at #WPEDecode later this month. https://t.co/5lnsTxp81j pic.twitter.com/Yf0ThPG1QG
— Advanced Custom Fields (@wp_acf) March 16, 2023
© 2023 Advanced Custom Fields.
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 Cookie Policy. If you continue to use this site, you consent to our use of cookies.