/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 votes151 views2 answers
Key value typescript
TypeScript
1 vote141 views1 answer
Tsconfig path if you are sure the module exists, try these steps:
TypeScript
0 vote154 views1 answer
How to concate a string to all elements in a list in python
TypeScript
2 votes147 views5 answers
Ng class in angular
TypeScript
15 votes194 views3 answers
Can't bind to 'formGroup' since it isn't a known property of 'form
TypeScript
0 vote157 views1 answer
Get elements in list in another list c#
TypeScript
1 vote132 views1 answer
Add correct host key in known_hosts to get rid of this message
TypeScript
-2 votes205 views1 answer
Nuclear power plants
TypeScript
0 vote153 views1 answer
Stripe typescript
TypeScript
4 votes155 views1 answer
Typescript string interpolation
TypeScript