/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 vote284 views1 answer
Angular Workspace
TypeScript
5 votes275 views2 answers
Init empty object typescript
TypeScript
0 vote256 views1 answer
Loc multiple conditions string and integer
TypeScript
22 votes257 views4 answers
Generate random numbers in python within a range
TypeScript
3 votes287 views2 answers
Sort array by date typescript
TypeScript
1 vote323 views2 answers
When i console log a obj its printing object
TypeScript
0 vote266 views1 answer
Typescript how to define class properties to empty
TypeScript
0 vote270 views1 answer
Import hostlistener angular
TypeScript
2 votes258 views1 answer
Type casting in typescript
TypeScript
45 votes340 views5 answers
Cra typescript
TypeScript