Is it possible to wrap Geo Location search around WP_Query?

I would duplicate the coordinates of the posts in a separate table (post_id, lat, lon), with an index on (lat, lon). With all the joins and the casts I doubt the database can use an efficient index with your query.

I once wrote an answer to a similar question using this approach.

Related Posts:

  1. WP_Query with “post_title LIKE ‘something%'”?
  2. Pagination with custom SQL query
  3. Whats the difference between post_limits and pre_get_posts?
  4. Using OR conditions in meta_query for query_posts argument
  5. Is it possible to select against a post’s parent’s fields with WP_Query?
  6. Extending WP_Query — Optimise SQL query
  7. How to filter sql only for a specific post type
  8. How to make an activities stream mixing posts and comments?
  9. Finding all results from database within 500 miles of the given latitude and longitude [closed]
  10. SQL Statement generated by WP_Query not producing expected results
  11. What is an efficient way to query based on post_meta?
  12. SQL query equivalent to WP User Query
  13. Post queries by latitude and longitude
  14. Recommended way to drop a pending query (in pre_get_posts)?
  15. how to retrieve specific product attribute value in an sql query?
  16. Filter WordPress posts by between parameter
  17. SQL User Query by Multiple Roles using PHP
  18. Advanced WP Query hogs the SQL server
  19. SELECT * FROM $wpdb->posts WHERE ID > 160
  20. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  21. Query post with meta_query where date is not in future
  22. WP User Query get all authors with last name starting with specific letter
  23. Select from wp_post and multiple meta_value from wp_postmeta
  24. How to correctly pass values to wpdb->prepare()?
  25. Sort users by “birthday” using WP_User_Query
  26. $wpdb select date range of posts
  27. How To Fix WP Query Returns Results But Shouldn’t?
  28. List of the years with posts presented
  29. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  30. Slow WP_Query for custom post type
  31. Complex WP SQL Query
  32. Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
  33. Optional Meta Query
  34. Sorting events by descending date, and ascending time if multiple events on a date
  35. Editing the default wordpress search
  36. WP Query related posts by tags
  37. Order by summing multiple values
  38. How to extract specific post
  39. Woocommerce – Changing the order of the upsell products [closed]
  40. Changing sort order for presentation by Jetpack infinite scroll
  41. Include data from custom table in WP_Query
  42. wordpress ajax relationship query
  43. How to pass orderby params to $wpdb->prepare()?
  44. Debugging wp_query orderby for taxonomy
  45. Is it possible to query from external database? [duplicate]
  46. Include post content of linked posts in search
  47. Make a SQL query with wpdb in WordPress
  48. Getting additional columns from sql
  49. List of ways to access WordPress database?
  50. Getting rid of unwanted nonSQL syntax characters when debugging a query
  51. How I can change the condition or compare operator for WP_Query in pre_get_posts
  52. Query where ANDing slug values not working
  53. Slow Query On Search
  54. WP_Query: apply an SQL function to meta fileld value
  55. How to avoid filling up an array each time I run a WP_query?
  56. How to SQL query posts IDs by categories AND authors?
  57. Randomly select one of last 3 posts
  58. SQL query injection with fifu image
  59. Passing a SQL query to the WP Query
  60. WP_Query() not working as expected
  61. WP Query – grouping posts by same meta key, adding together values from another key
  62. Any way to use FETCH_KEY_PAIR with $wpdb?
  63. What is the equivalent WP_Query of a SQL Query?
  64. Translating WP query into to SQL query
  65. Filtering posts for unique titles, only the most recent
  66. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  67. How to search CPTs in draft using get_page_by_title()
  68. Calculating efficiently on large amount of data generated by wp_query
  69. What argument does my function need to echo get_results() query results
  70. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  71. Include post_status check within $wpdb query
  72. Find by post_meta, then sort by post_meta, then sort by date (wp_posts)
  73. WP Query to order posts by multiple meta fields
  74. Custom WP_Query with SQL directives for getting posts by authors and terms
  75. How to return value from sql and display it
  76. orderby in WP_query doesn’t works
  77. WP_Query with several meta_query-statements and order by meta_value
  78. wpdb LIKE request shows all database data
  79. Convert a WP Query into a simpler SQL query to fetch only COUNT of posts
  80. Add custom argument to WP_Query and modify SQL where clause
  81. Group By query based on Custom Field
  82. How to make OR condition in WP_Query
  83. Executing Queries in tag.php
  84. WP_Query meta_query by array key
  85. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  86. Count total number of post in foreach loop
  87. WP_Query not retrieving by random order under parent
  88. Get images only if parent status is publish
  89. Using WP_Query and WP_Meta_Query Outside of WordPress
  90. query offset countdown by 2 each day?
  91. Filter posts in category archive page by year using a dropdown
  92. Better wordpress attachment query than this
  93. How to number the posts (ie #1, #2, #3) in a wp_query?
  94. How can I check for a thumbnail in WordPress?
  95. WP_Query gives me different results depending on the category order
  96. Add parameter to first post only
  97. Ignore image urls in wp_query search
  98. meta_query where the meta value is not the post title
  99. Is WP Query skipping to check next post when an argument is not met?
  100. How to query most recent post for each author?

Leave a Comment