The problem is strictly with your query… or to be more precise, with your misunderstanding of your query 😉
You’ve put || in there and you assume it is OR operator, but… depending on configuration of server it can act as OR or… string concatenation 😉
So change it to OR and it should work fine, I guess…
Related Posts:
- simple sql query on wp_postmeta very slow
- How many WordPress SQL Queries per page?
- Multipart/formatted MySQL query problem
- Are database queries created using WordPress filters protected from SQL injection?
- Grouping related postmeta data via SQL query
- Mysql / WordPress killing my server with 80k users [closed]
- Slow meta_query with about 4 milion record on wp_postmeta
- Select User by Joining Multiple Meta Value Results
- mySQL query. ORDER BY meta_key
- Update slug (URL) of pending posts via phpMyAdmin
- My SQL function to change user_name
- You have an error in your SQL syntax – Help with query
- MySQL variable in query
- how would I create a custom query to get all users, and a related post based on a postmeta field?
- Help with MySQL to $WPDB query
- SQL query to select posts from multiple categories
- How do I see the mysql query generated by get_posts( $args )?
- Alter query with posts_clauses to retrieve NULL values last
- MySql Query very slow
- Searching With Apostrophe
- WordPress Query wp-terms SLOW
- wpdb COALESCE won’t work
- Get posts from category with custom query
- how to insert missing tags into the posts through mySQL?
- Ideas how to search & replace post_content when string contains a newline?
- Valid SQL query return empty
- mysql query – how to escape apostrophe?
- Query the WordPress database to get data together with replaced information
- Optimize slow SQL query for multiple meta values
- Updating with $qpdb->query() always returns 0 rows affected
- How to return count of custom post type posts with a specific custom field value via $wpdb?
- WordPress Mysql query and Duplicate
- Help with Related Posts Function
- How to delete all images from code in all post_content
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Displaying data from custom table
- Get 2 meta values from meta key column
- PHP Fatal error: Uncaught Error: Call to a member function insert() on null
- SQL query to delete users with multiple meta keys and comments
- Trouble migrating custom post types from non-wordpress cms
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
- How to make MySQL search queries with quotes
- Custom MySQL Query for Post and Post Meta
- Mysql query and odd results
- sql for querying post and their category
- Access Tables with number prefix
- Custom query_var causes displaying posts archive on front page
- What is the most efficient way of implementing a favorite post system?
- Why does get_the_time(‘F j’) return November 30 for all posts?
- Query by one meta_key and sort by another (possibly NULL value)
- Query & Sort Comments by custom comment meta
- How to count get_users query?
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- How to display all posts with today’s same month and day only?
- Show featured image as background image from postQuery
- Using $wpdb->update but confused on the WHERE in and SET
- Style Post Differently In Query
- order one custom post type by modified time of another post type
- is_search called incorreclty
- Function to delete a post, it’s children and it’s grand children (half way there already)
- Nested loop : wich way/order?
- Dynamically adjust single-posttype.php query, based on current taxonomies
- WordPress SQL injection
- Use mysql_query instead of $wpdb query
- Post with certain term and without any term
- Custom Query – Based on user input
- Change the destination of the URLs in post.php
- Page with custom template make get request to a custom route – Pseudo code
- get_users with array as meta_value
- How to exclude posts for current user
- Queries take 120+ seconds on my large WordPress site
- exclude pingbacks from wordpress SQL query
- wp_posts query slowing down my website
- Get the_field of Advanced Custom Fields in a custom query [closed]
- Brainstorm – Slow Query from Plugin Need to Speed It Up
- Advanced Custom Fields – Relationship post foreach query
- Select min/max meta from query
- WordPress query unique post meta – finding all of one value without duplicates for a drop down
- Exclude in get_pages() based on meta field
- Delete oldest wordpress post (SQL query)
- PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
- SQL to Query the db and return all posts and it’s metas
- WordPress Database Query works in phpMyAdmin but not in the code
- How to do a sql like query on serialized data of user meta data
- My archives page won’t sort posts by month
- How to do a MySql query in WordPress?
- “order” does not affect order of custom query
- Create a new post on a specified publish date via link?
- Exclude Posts from a Widget
- New custom post type entries are not sorted correctly in admin using pre_get_posts
- $wpdb query for price in custom field value
- Multiple terms not working on taxonomy
- Run search query again without pagination gives no results?
- Parsing External Table Arguments
- WP_Query orderby meta key/value suddely stopped working
- Where can I find the SQL to get the most used information by wordpress database?
- WooCommerce Total # orders [closed]
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- How to figure out correct wp_options to have autoload=’yes’