/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

0 vote290 views1 answer
Unity get list of all gameobjects with tag
TypeScript
3 votes315 views1 answer
Mysql insert exists update
TypeScript
1 vote347 views1 answer
Getstaticpaths in nextjs
TypeScript
8 votes322 views1 answer
How to divide a list into sublists python
TypeScript
0 vote336 views1 answer
Python program to extract characters from various text files and puts them into a list
TypeScript
-1 vote302 views2 answers
Enum next value angular
TypeScript
1 vote335 views1 answer
What project management tool you use
TypeScript
4 votes317 views5 answers
Angular refresh page without reloading
TypeScript
0 vote337 views1 answer
Stackoverflow ngbdate angular
TypeScript
0 vote307 views2 answers
Verify if room exists in socket.io
TypeScript