/TypeScript/Woocommerce sql query pulls products from category

Woocommerce sql query pulls products from category

SELECT * from `wp_term_relationships` where term_taxonomy_id=$subcatId and object_id in(select ID from `wp_posts` where `post_type`='product' and post_status='publish' and ID=wp_term_relationships.object_id) LIMIT 0,15000000

Source: stackoverflow.com

Similar codes

-2 votes172 views5 answers
Mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given
TypeScript
0 vote174 views1 answer
Does any event get triggered when checked value changes programatically?
TypeScript
1 vote157 views1 answer
Comments in asymptote
TypeScript
1 vote183 views1 answer
How to destroy all widgets in a frame
TypeScript
0 vote174 views1 answer
How were sonnets used in rennaisance litireture
TypeScript
0 vote195 views1 answer
Typescript throw not implemented exception
TypeScript
5 votes170 views1 answer
Check if column exists in dataframe
TypeScript
4 votes170 views2 answers
Push in typescript
TypeScript
1 vote152 views1 answer
Readonly vs const
TypeScript
6 votes173 views3 answers
Mongodb count based on array of ids
TypeScript