Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with sql
Search options not deleted
user 3533
Questions about using raw SQL queries. For questions about the database in general, use the database tag instead, for questions about the Magento database access layer use the appropriate tag, like: eav, model, resource-model, collections, install-script
2
votes
SQL list all categories and products (SKUs) in category
Best and easy way to fetch sku's based on the category id from sql.To help anyone looking for an answer that works with Magento 2. x
SELECT product.entity_id as product_id, product.sku FROM catalog_pr …
- 1,650
2
votes
Magento Catalog Product Flat can not index
You have exceeded the row limits in your product flat data table.
This can be fixed by removing or disabling any attributes that you do not need to appear in the product flat data table
There are se …
- 1,650
1
vote
Accepted
Magento 2: SQL Query to get product SKU's based on the Category Id
SELECT product.entity_id as product_id, product.sku FROM catalog_product_entity as product
INNER JOIN catalog_category_product as cat_prod on product.entity_id = cat_prod.product_id
WHERE cat_ …
- 1,650
1
vote
2
answers
4k
views
Magento 2: SQL Query to get product SKU's based on the Category Id
I need a sql query to get the all sku based on the category id
Following are the tables which stores category and product data:
catalog_product_entity
catalog_category_product
Thanks …
- 1,650