/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

1 vote203 views1 answer
React protected routes typescript
TypeScript
0 vote204 views1 answer
How many arguments does a call to the Math.sqrt method have?
TypeScript
0 vote192 views1 answer
Node fetch image to base64
TypeScript
1 vote185 views1 answer
Nextjs hot reload not working after file change
TypeScript
1 vote183 views1 answer
Deno router
TypeScript
0 vote202 views1 answer
Typescript key as string
TypeScript
0 vote190 views1 answer
Startswith multiple arguments python
TypeScript
0 vote207 views2 answers
Rails precompile assets in a directory
TypeScript
0 vote207 views1 answer
Generics in arrow function
TypeScript
0 vote191 views1 answer
C code for insrting elements in set
TypeScript