/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 vote336 views1 answer
"Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryInterface", but its service could not be found. Make sure the service exists and is tagged with "doctrine.repository_service".
TypeScript
1 vote297 views1 answer
Json to object typescript
TypeScript
0 vote319 views1 answer
Google sheets replace dot with comma
TypeScript
0 vote298 views1 answer
What will be the result of the cp /etc/hosts . command?
TypeScript
0 vote312 views1 answer
Update multiple documents with different field value by id set. Mongoose
TypeScript
0 vote347 views1 answer
Write a C proogram to find the roots of quadratic equation
TypeScript
0 vote354 views1 answer
Sql concepts interview questions
TypeScript
0 vote317 views1 answer
Separate subplots in python
TypeScript
0 vote311 views2 answers
Python remove all double elements from list
TypeScript
0 vote365 views1 answer
Type 'FormGroup' is missing the following properties from type 'NgForm': submitted, _directives, form, ngSubmit, and 18 more
TypeScript