It’s a little bit hard to guess, what exactly are you trying to achieve, because your code isn’t correct SQL, but…
It looks like you want to select posts based on custom fields… So all you need to do is to use Meta_Query
.
$q = new WP_Query( array(
'post_type' => 'post', // <- or whatever post type you're searching
'posts_per_page' => -1, // <- let's get all of such posts
'meta_query' => array(
'relation' => 'AND',
array(
'key' => 'jersy color',
'value' => '1',
),
array(
'key' => 'teamnumbr',
'value' => '20',
),
)
) );
Related Posts:
- Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
- Should I use Transients with W3 Total Cache APC Caching? [closed]
- Add indexing to meta_value in wp_postmeta
- Get posts by menu ID
- Slow SQL_CALC_FOUND_ROWS Query
- What is an efficient way to query based on post_meta?
- WP_Query Performance Issues with meta_query
- Should close $wpdb via $wpdb->close()
- Get the post permalink within the loop but without additional DB query
- Filter WordPress posts by between parameter
- Retrieve featured image (thumbnail) url from multiple posts with one query
- How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
- What’s faster? One big query, or several smaller ones?
- How WordPress attaches its Featured Images with posts?
- Order by custom table and multiplication
- why update and delete query not worked in custom table?
- How to implement a new row_count method in WordPress?
- querying data via $wpdb and get_row
- wp_Qwery works to slow
- Show all data in database table and make it into an interactive table
- No results found from a $wpdb->get_results() query when trying to join more than one meta key query
- database query with more than a couple meta hangs and doesn’t complete
- How to access custom WordPress database tables
- Is it possible to query from external database? [duplicate]
- WP User Query with Custom Fields and Search Results
- List of ways to access WordPress database?
- Specify strict ‘order by’ in WordPress query
- How to set up hierarchical relationships without using plugins / meta query
- how to get Nearby zipcode
- Does WordPress have something like Drupal’s DB API?
- Using Transients
- Slow Query On Search
- Wpdb->query result show 1 but is not an integer
- Why having more than 10 clauses in WP_Query results in some outputs being dropped?
- Storing an array of objects related to each user
- Retrieve data from wordpress db via input and put those result in dropdown
- WP Query – filtering terms with regex
- WP_Query with page_ids in arguments without a result
- Function to retrieve IDs of posts, cache results, and improve wp_query
- Issue with data array format
- Why last row deleted when refresh page
- Query a database based on form input then output to another page [closed]
- wp query search multi terms
- How to get meta key list efficiently?
- How to get user avatar via WPDB
- How to extend WP_query to a specific table?
- Fix wp_term_relationships slow query in get_posts
- Translating WP query into to SQL query
- update_post_meta performance in a loop woocommerce
- update_post_meta performance in a loop woocommerce
- WP_Term_Query->get_terms() very slow query for WordPress filter
- Separate by Category Post Type
- I removed the “wp_rm_logs” table and am constantly getting this error
- Track write actions to the database
- Include post_status check within $wpdb query
- wpdb get_results() returns only 2 rows
- Website goes slow down after importing long database
- WP_Query always returning the last custom post
- option select form always deleting the sql query
- Optimising amount of calls to custom fields
- 294 Queries on Mainpage of WordPress
- how to add limit records in wordpress query
- Custom WP_query in Jnews theme returns thousands of posts
- WP_Query by meta key not returning any posts
- SQL query into to WP query
- WP_Query with “post_title LIKE ‘something%'”?
- How to extend WP_Query to include custom table in query?
- compare meta_query in get_posts arguments
- How to do a query only on a specific admin page?
- WP Cron and wp_insert_post
- How to adjust found_posts so that it accounts for offset and pagination
- SQL query equivalent to WP User Query
- Function to check if author has posted within the last x days
- Show default content if custom WP_Query has no posts
- WP Query for Posts (Products) in Specific Category that has 2 Specific Tags (*AND* both tags not *OR*)
- Pagination for custom query on single.php
- Remove ellipsis from the excerpt retrieved using get_the_excerpt()
- WordPress query vars are not added
- Alternative to query->set that appends conditions instead of overriding
- Group WP_Query by meta_key date
- get_users is missing or skipping over users in loop
- WP_Query sorted by custom taxonomy
- problem by deleting new plugin installed inside the WordPress after any heroku app sleeping [closed]
- Adding multiple meta_key fields as orderby options to a WP Query via a function
- Get posts by list of post IDs ordered by those IDs?
- Reset WordPress Post Query to default
- Woocommerce – exclude only older out-of-stock items
- ACF accessing a field from the query, but not in post
- What is the best way (regarding performance) to set transients for logged in users?
- Is there a ‘compare’ option when using WP_Query apart from meta_query
- Differentiate Nested WP_Query from Parent
- WP_Query returns no posts for category
- Post__not_in only removing first 2 pages
- Query posts by searching for a string in a meta field
- How can I build a query that returns all attachments of a page and it’s children pages?
- Query ACF relationship field – Comparator IN – Value array
- WP_Query paginate with one term per page?
- using custom meta user data to run queries in WordPress
- WordPress wp_query add custom query as field
- Pagination only showed when no category is set in wp_query