This is what worked for me:
require_once 'wp-config.php';
global $wpdb;
$args = array(
'post_type' => 'product',
'posts_per_page' => -1,
);
$Query= new WP_Query($args);
You can use similar way to achieve what you want.
Related Posts:
- Use REGEXP in WP_Query meta_query key
- Order By Multiple Meta Fields
- Single meta_query query using OR instead of AND in request’s WHERE statement
- Performance when getting post meta for post retrieved by meta value
- Mysql query and order meta value
- Meta Query doesn’t works as espected
- WP Query – grouping posts by same meta key, adding together values from another key
- Woocommerce Get Orders By Meta Value
- WordPress Query optimaization for slow query
- Order Posts By Custom Field That is an array of objects
- Slow query when selecting with large meta query or post__in
- How to query posts based on lat-lng coordinate as post meta?
- Set Alias for meta_query arguments in get_posts()
- Add indexing to meta_value in wp_postmeta
- Is it possible to orderby multiple meta_keys when using meta_value_num?
- Custom WP_Query order by post_meta and (author) user_meta
- Using custom meta_query with relation not working as expected
- Perform query with meta_value date
- WP_Query meta_query where meta value ends in space
- Nested query inside Logical operator OR not working in meta_query
- What is an efficient way to query based on post_meta?
- How do I create my own nested meta_query using posts_where / posts_join?
- How to order a post type with meta_value_num and if meta_value_num does not exist then order by date
- Compare two meta-fields in a wp_query (where meta-field-A is larger than meta-field-B)
- Meta Query querrying several post types based on ACF fields is broken after update to WP 4.1
- Exclude post on loop by multiple meta key value
- Querying by taxonomy vs Querying by Custom fields Speed Comparison
- How to get sum of meta_values of a meta_key in wp_query according to conditions
- Modern Tribe Calendar wp-query with meta query not working at all
- meta_key and meta_value not working together
- Order posts by meta value and Date
- Query sticky posts with thumbnails
- Difference between ‘LIKE’ and ‘IN’ in meta queries
- WordPress Query is taking more then 20 second and stuck on creating index
- Order WP Query posts by custom order calculated from post meta values
- how to speed up a complex wp_query?
- Meta query with order by another custom field
- How to query for custom field within Gutenberg block from outside of that post? [closed]
- Get the Plugin Which Triggered a MySql Query in WordPress?
- Meta query with JSON value
- Get meta info related to current post
- Creating arguments from loop for WP_Query meta_query
- Order by custom table and multiplication
- ACF Date Based wp_query
- How to use MySQL’s MATCH AGAINST in WP_Query?
- Get attachment by meta_key value
- Any number in meta key (wp query)
- Using meta_query with multiple keys and compare values
- Add “Category” to Mysql Query
- Help with WP_Query – Too many mySQL queries
- Is it a good idea to improve meta query performance by adding tax query?
- meta_query BETWEEN, but the range is stored in the custom field
- Order by summing multiple values
- Is it possible to set specific posts to show first in a query?
- Orderby listing issue
- Order ascending is ignored in meta query?
- database query with more than a couple meta hangs and doesn’t complete
- Make meta query treat meta_value as 1 or 0
- WP Query Meta Value – How To Identify Specific, Unique Values?
- Order by meta_key doesn’t work
- Sort by presence of thumbnail
- it’s possible make a WP_Query with math operations?
- Multiple meta_key ordering with pre_get_posts
- Sorting search results with custom dropdown
- Meta query with compare by more than 2 fields
- Query multiple meta key values for template
- WP_Query meta compare must include ALL array values
- meta_query returning excluded result
- What’s missing in this wp_query and meta_query
- meta_query weird behaviour, static int will work, but not user data
- Creating a query that get all posts but places meta items first
- ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
- wp query to use both author id and meta_query
- WP_Query for a taxonomy value OR a custom post type meta field
- Usermeta data unserialize, extract and display in table in WordPress
- Trouble with serialized metadata
- meta_query order by date present -> future then show null
- meta_query compare > not working
- Multiple wpostmeta.meta_key
- meta_query is not allowing to show posts when querying multiple arguments in a WP_Query
- Saving custom fields for WP_Query to retrieve
- Is it possible to search for a string in posts OR postmeta?
- Filter posts/pages by user_role array
- WP_Query with MetaQuery issue
- WP_Query Posts by Metadata from Option Tree
- Custom loop – Isolating post meta output depending on current query taxonomy terms
- WP_Query with meta_value_num and meta_query not paged correctly
- Post Query not working after updating to 4.1
- Orderby Meta Value and Query from Meta Query
- The sorting of posts by a meta_query with two keys fails while separated as single queries it works
- How to count post meta key values for all posts in database
- Sort posts in dashboard using custom field; also include posts where field isn’t set
- Sort Posts with custom meta key by default which is currently set as optional
- Why is WP_Query’s meta_query not filtering results?
- WP_Query with several meta_query-statements and order by meta_value
- Parsing External Table Arguments
- How to add a custom field and incrementing value for all the published posts
- How do I have multiple metaqueries inside one wordpress query
- WP query with multiple custom meta not respecting orderby
- Display only posts with thumbnails