/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 vote314 views1 answer
Nestjs get request header in guard
TypeScript
1 vote343 views1 answer
Swift code of paytm payments bank
TypeScript
1 vote335 views1 answer
Ts playground download
TypeScript
8 votes391 views2 answers
Typescript react elements
TypeScript
0 vote328 views1 answer
Which electromagnetic radiation is used for heating and night vision equipment
TypeScript
2 votes307 views2 answers
Typescript convert numer to string
TypeScript
0 vote317 views1 answer
Wordpress get_posts custom posts by meta key
TypeScript
0 vote325 views1 answer
Url prod
TypeScript
0 vote331 views1 answer
Update object in array in ngxrx store in angular
TypeScript
0 vote322 views2 answers
How to check listening ports on a server
TypeScript