add_filter > posts_where works partially

This doesn’t look like it would produce meaningful SQL, keys cannot hold different values at the same time (that’s why JOINs are usually required in complex queries).

Also using $_GET global in queries is horribly insecure, if you have this anywhere near live site you should remove it immediately.

You earlier question used WP_Query, if it did work at all (even if slowly) you should start with studying SQL it produced and optimize from that point.

Related Posts:

  1. Used with meta_query in query_posts works slowly
  2. Media library – Limit images to custom post type
  3. post_type_link filter causes 404 on the CPT page it’s used on
  4. WooCommerce product search titles only
  5. Setting proper query for multiple custom admin filters
  6. filter custom post type by meta key in dashboard
  7. How to filter wp_list_categories output with some custom post type meta query?
  8. A method for ordering mixed dates in search result loop (theory only, no actual code)
  9. search suggest – filter post type
  10. Insert custom taxonomy into category query
  11. Enable shortcodes on custom post type
  12. Simple Share Buttons Add Plugin and Custom Post Type
  13. How can I filter records in a custom post type list in the admin based on the ACF field in the post that contains the current user?
  14. Is there any filter to add a custom attribute to the tag in admin panel?
  15. Filter result of Custom Post Type using meta_query with ACF
  16. build child and anchestor three from post parent
  17. Display category filters for custom post type when category is shared by multiple post types
  18. Store a value in global scope after init hook is fired
  19. Unable to gather Image URL from Custom Post Type’s; Custom Meta Field
  20. Query posts by current ACF meta key value on single page as related posts
  21. Filter in Custom post type to find the parent post
  22. meta query condition don’t work
  23. Custom query result empty on page 2
  24. Meta query and compare “!=” not working as expected
  25. meta_query Where the key value is stored as an array
  26. Orderby if between two meta fields
  27. How to select meta key in custom database query
  28. Dynamic page for nav items used as filters
  29. Create Post Types from a XML url (Real Estate website)
  30. Use WP_query to match post types based on custom field values
  31. Filter posts by their related field’s custom field
  32. Post Click Redirect to Custom URL instead of Single Post Page
  33. Show posts from WP Custom Post Type selected from a field in a metabox
  34. custom post type single page not found after aotumatic publish By the author’s robot
  35. Accessing download link from the loop with WP Download Manager Pro
  36. Set a template on a custom post in the plugin
  37. Simple way to hide\show an announcement (just a div) on homepage?
  38. Custom Post Type works when registered in functions.php but not when registered in plugin
  39. How can I add image sizes for a specific custom post type?
  40. Reading Custom Post data so I can have user update Manually
  41. ACF meta_key and meta_value break loop
  42. Why is this function so slow?
  43. meta query multiple values for the same key
  44. Permalink URL connection between two custom types
  45. How to show link to product in custom fields?
  46. Sort custom post archives by a meta value from a different custom post type?
  47. Taxonomy counter on Taxonomy List(plugin)
  48. Is it possible to arrange Custom Post Types from CPTUI into a Folder?
  49. Restrict Custom Post Type to One Item
  50. Custom Post Type Front Page Gives 404
  51. Multiple useres editing specified content
  52. Show Post columns to specific users on condition
  53. Add content to wordpress edit.php page
  54. Filter Custom Post Type Posts by Taxonomy
  55. How to use multiple orderby conditions on query search results? (orderby one post type, relevance)
  56. Add input radio menu to post
  57. Custom post types – meta_query: search lesson which starts sooner
  58. add_rewrite_tag broke permalinks that doesn’t use that specific tag
  59. Disable ‘Add New’ in custom post that is made from CPT UI
  60. pricefilter without WooCommerce
  61. Output all terms slugs for a loop filter
  62. post type => ‘any’ not applied my custom queries
  63. Custom Post Type single post type shown in theme single.php
  64. CPT UI: Connect a custom post type to a custom post type
  65. filter rest api post by a acf filed
  66. Group Custom Posts Types in a Relation field of ACF
  67. Help Adding filter to Add Media button for custom post type
  68. Simple Data picker meta box
  69. How to check if a new private custom post type is created?
  70. How to get the posts that my following users are liked?
  71. Meta_Query refuses to return results
  72. Looping through image object using ACF and CPT UI [SOLVED]
  73. Sort loop by custom field from different post type
  74. Default custom post type url
  75. Run query on specific admin options page and send results to select field in another function
  76. Meta_query by date for Events archive
  77. Link two different post using there post_id in post meta
  78. Apply pre_get_posts to specific custom post type in the admin area
  79. Not able to get my custom search result using meta_query and tax_query together?
  80. how it’s possible to show from a post of a custom post type the taxonomy/terms?
  81. Custom post type that lets users create a set of posts?
  82. Include images from pages in wp search.php results in default wp search
  83. Keep br tags from stripping
  84. Meta query broken since 4.7.4 Update
  85. Create Inclusions and exclusions
  86. How to create groups like that in buddypress?
  87. Post that populates itself (almost) automatically using data from imported excel file
  88. I broke it! Custom post type archive gets redirected to home
  89. Populate metabox dropdown with post title from another Custom Post Type (issues with wp_reset / global $post)
  90. Custom Fields through plugin in a Custom Post Type
  91. Add filter button to custom post type in admin area
  92. Can’t save custom post type fields
  93. Filter between Custom Posts depending on meta_value
  94. Multiple domains, Single database, 1 Parent/Master with all content, other domains/slaves with filtered content (based on “location” variable)
  95. How to shows CPT which has specific meta key?
  96. How to Create movie schedule by custom post type query
  97. Best Plugins for Complex Index of Resources [closed]
  98. Querying, storing, and using data from 2 separate custom post types
  99. Query events post type after current date and timezone
  100. How to display all custom fields associated with a post type – IN THE ADMIN AREA?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)