I think something like this, but not tested, and my SQL-foo is rather weak:
$test = $wpdb->get_col( $wpdb->prepare(
"
SELECT DISTINCT $wpdb->posts.*
FROM $wpdb->posts
INNER JOIN $wpdb->postmeta AS mt1 ON (
wp_posts.ID = $wpdb->postmeta.post_id
)
WHERE $wpdb->postmeta.meta_key = 'goals-made'
AND( mt1.meta_key = 'goals-against'
AND CAST($wpdb->postmeta.meta_value AS INT) > CAST(mt1.meta_value AS INT)
)
"
));
This should return a list of post_ids that you can then process. But then again, it might just fail miserably.
Related Posts:
- How to List Events by Year and Month Using Advanced Custom Fields?
- Advanced Custom Fields – Query Efficiency
- can’t get query to order posts by acf datepicker
- Order posts by custom field DATE value
- Get the_field of Advanced Custom Fields in a custom query [closed]
- Advanced Custom Fields – Relationship post foreach query
- Querying Advanced Custom Fields
- How can I get the name of term post meta value which equals term id
- Exclude in get_pages() based on meta field
- WordPress query: merge meta key (number) values and sort
- wp query multiple values > display a specific value first
- Advanced Custom Fields Query with Different Values of the Same Key
- Modify a query using both a text field and a true/false AFC field
- How can I create a meta_query with an array as meta_field?
- Query multiple meta key values?
- Is there a way of increasing the speed of this query?
- How can I query all users who registered today?
- Reversing the order of posts AFTER the query is performed
- what are the numbers between curly brackets in search query
- When/why does ‘$query->get( ‘tax_query’ );’ return empty?
- How to get link and title of next and previous post on single page
- How to display Section for certain time
- Search custom post type by meta data
- Multipart/formatted MySQL query problem
- Remove [gallery] shortcode altogether
- Query set using tax_query with relation ‘OR’ modifies category object?
- Query by 2 values of a repeater ACF field
- When add_query_arg() is necessary?
- Insert html after certain amount of posts?
- wp remove query
- Filter query posts by the count of metas for a meta key
- $wpdb->get_var not returning a result
- $args numberposts variable
- Save default value for empty or missing post meta
- Listing posts by grouping dates
- $wpdb->query() vs. $wpdb->get_results() vs. phpMyAdmin
- How to mass delete one line from all posts after site hack
- Query posts by content lenght
- $wpdb doesn’t appear to work on page inside of a plugin
- add_query_arg() and empty variables inside
- How to export current year posts from WordPress?
- Search query -> Show all pages except certain template
- WordPress post type “event” query string fix?
- How do I see the mysql query generated by get_posts( $args )?
- WordPress Query wp-terms SLOW
- I can’t figure out what’s wrong with this statement. $wpdb->query update
- Different values for get_author_posts_url and get_the_author (posts 2 posts)
- Problem when try to add ++1 for user meta
- query statement containing variable won’t execute
- Get posts from category with custom query
- Related post based on content
- Slow Search Queries – How to exclude pages, media, excerpt, authors, private posts?
- How to interfere to default search to make it search in custom fields?
- WP_User_Query with more than two custom meta values
- Declaring a var, placing it in a query and using the output of the query?
- how do i register global query in template
- How do I query for posts by custom meta and those that have been stickied?
- Select min/max meta from query
- Combining two meta_values within one row with query
- Sort query_terms_list for post_tags alphabetically
- Target a page with query
- List only parent attributes on woocommerce admin atrributes page
- Merge CPT Taxonomy and Post Taxonomy in $query->set
- Problem with revisions only returning four results
- How do I get specific readable results from this query and array results
- I want to get on those users their meta value are like “AGENT” .. but this query is not working
- Add rewrite rule for archive search
- How to create a filter and add query params to all links
- Get 2 meta values from meta key column
- WordPress add_query_arg from ajax and make url friendly
- My custom pagination not displaying
- Order WordPress Query by Custom Field While Still Using Tax_query Argument
- Wpdb->last_query returns bad query
- WP search exclude last letter from string
- Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
- Query reversed when I use “category__not_in”
- How to reduce the load / no of queries on MySql Database
- Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
- $query->set( ‘post_type’, ‘post’ ); not working
- How i make a custom sql query for Woocommerce
- Display result from custom post meta query
- Show certain number of post from tags
- Wpdb empty result only if language is Russian
- Include custom table in query
- How to fix this insert? Don’t work for me!
- Display Upload Author & Get Uploaded Post ID
- Display list of most recent grandchild (third tier) pages
- How can I display a number to represent the order of post?
- Update vs Insert logic but the last key is always inserted?
- Sort order in get_posts [closed]
- Query unique author ids with published post of type job
- Wpdb generates too many queries
- Custom Query for searching through custom fields
- Query posts alphabetically within this function
- Conditional Tag Custom Querys?
- query posts only works on the first page
- Custom Query for wp_posts using wp_postmeta
- WP Query outputs three items within a div
- Query filter on custom post by current author in post widget for elementor query id
- Querying Posts from ACF Repeater Subfield Select Value