Timeline for SQL Queries not executing
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 11, 2022 at 18:13 | comment | added | MagePal Extensions |
Are you sure it not returning no result? Does your DB has order from 2015? Also, I don't think your sql is correct try SELECT B.value AS "BARCODE", A.sku AS "SKU", A.name AS "NAME", A.price AS "PRICE", A.created_at AS "DATE" FROM `sales_order_item` AS A left JOIN `catalog_product_entity_varchar` AS B on A.`product_id` = B.`entity_id` WHERE (A.created_at LIKE "2021-11%" OR A.created_at LIKE "2021-12%") AND B.attribute_id = 88 GROUP BY A.sku ORDER BY `DATE` ASC
|
|
| Jul 11, 2022 at 10:26 | comment | added | Divyarajsinh Barad | what result you want to get ? | |
| Jul 11, 2022 at 6:53 | history | asked | LittleDTLe | CC BY-SA 4.0 |