/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 vote111 views1 answer
Check if file exists on s3 python
TypeScript
0 vote105 views3 answers
Check table exists in db laravel
TypeScript
0 vote108 views1 answer
Function that takes first & last name and then it greets the user using his full name.
TypeScript
0 vote107 views1 answer
Attend
TypeScript
0 vote98 views1 answer
Angular dictionary
TypeScript
0 vote104 views1 answer
Linux host file location
TypeScript
2 votes95 views3 answers
Getserversideprops
TypeScript
0 vote96 views1 answer
Typescript get object value
TypeScript
0 vote117 views1 answer
Google sheets find last cell with value in range
TypeScript
0 vote173 views1 answer
How to compare two date in typescript
TypeScript