/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 vote213 views1 answer
Disable out of stock products shopify
TypeScript
0 vote263 views1 answer
A tuple type element list cannot be empty.
TypeScript
0 vote220 views1 answer
Accessing widgets in screen manager kivy
TypeScript
0 vote231 views1 answer
Accessing formcontrol from fromgroup
TypeScript
0 vote214 views1 answer
Get elements by id like jquery
TypeScript
0 vote246 views1 answer
Contents links python jupyter
TypeScript
21 votes223 views6 answers
Map to object
TypeScript
0 vote226 views1 answer
Get date list from date of range in react ts
TypeScript
0 vote212 views1 answer
How to check if file exists lua
TypeScript
0 vote252 views1 answer
Delphi call function from its name
TypeScript