/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 vote100 views1 answer
Typescript getting started
TypeScript
27 votes114 views6 answers
Router.navigate angular
TypeScript
1 vote107 views1 answer
Typescript variable
TypeScript
0 vote106 views1 answer
React forwardref typescript
TypeScript
0 vote121 views2 answers
Preventing letters from being placed in an input ts
TypeScript
0 vote118 views1 answer
Google fonts icons size classes
TypeScript
0 vote107 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
0 vote104 views1 answer
How to get pastebin contents c#
TypeScript
11 votes104 views1 answer
Remove dots from ul li
TypeScript
9 votes98 views1 answer
How to print list as matrix in python without brackets
TypeScript