/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 votes280 views2 answers
Typeorm find orderby
TypeScript
0 vote256 views1 answer
How to run typescript in vscode
TypeScript
55 votes436 views6 answers
Sum of list of lists python
TypeScript
0 vote269 views1 answer
If exits python sql
TypeScript
1 vote269 views1 answer
Google sheets concatenate
TypeScript
3 votes272 views1 answer
Persists meaning
TypeScript
7 votes281 views3 answers
Typescript ignore
TypeScript
0 vote315 views1 answer
How to add alias to my hosts in ansible hosts
TypeScript
5 votes265 views2 answers
Merge lists in list python
TypeScript
0 vote289 views1 answer
What do brackets mean in python
TypeScript