/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 vote194 views1 answer
Requests get with sign in
TypeScript
0 vote189 views1 answer
Targe id that starts with
TypeScript
3 votes206 views1 answer
/C:/flutter/packages/flutter/lib/src/widgets/localizations.dart:413:17: Context: Found this candidate, but the arguments don't match.
TypeScript
0 vote188 views1 answer
Typescript implement
TypeScript
1 vote195 views1 answer
Require statement not part of import statement.eslint@typescript-eslint/no-var-requires
TypeScript
2 votes202 views2 answers
For (... in ...) statements must be filtered with an if statement (forin)
TypeScript
0 vote188 views1 answer
Surround substring with quotes
TypeScript
19 votes230 views4 answers
Number of digits in a number python
TypeScript
3 votes203 views1 answer
Typescript parameter function type
TypeScript
0 vote204 views1 answer
What types of Collections/Data structures you have used
TypeScript