Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save gauravgargtech/8cc4a8406289c060cfc612e6408612d7 to your computer and use it in GitHub Desktop.
Save gauravgargtech/8cc4a8406289c060cfc612e6408612d7 to your computer and use it in GitHub Desktop.
unit price zero values
select id_sales_order_item,created_at from sales_order_item where (original_unit_price=0 || original_unit_price IS NULL) and created_at >'2016-07-25 00:00:00';
+---------------------+---------------------+
| id_sales_order_item | created_at |
+---------------------+---------------------+
| 84911406 | 2016-07-29 04:54:40 |
| 84911408 | 2016-07-29 04:54:40 |
| 84911410 | 2016-07-29 04:54:40 |
| 84911418 | 2016-07-29 05:00:06 |
| 84911420 | 2016-07-29 05:00:06 |
| 84911426 | 2016-07-29 05:01:33 |
| 84911428 | 2016-07-29 05:01:33 |
| 84911430 | 2016-07-29 05:01:33 |
| 84911432 | 2016-07-29 05:01:33 |
| 84911434 | 2016-07-29 05:01:33 |
| 84911438 | 2016-07-29 05:01:42 |
| 84911440 | 2016-07-29 05:01:42 |
| 84911442 | 2016-07-29 05:01:42 |
| 84911446 | 2016-07-29 05:02:00 |
| 84911448 | 2016-07-29 05:02:00 |
| 84911450 | 2016-07-29 05:02:00 |
| 84911452 | 2016-07-29 05:02:02 |
| 84911454 | 2016-07-29 05:02:02 |
| 84911458 | 2016-07-29 05:02:34 |
| 84911462 | 2016-07-29 05:03:38 |
| 84911464 | 2016-07-29 05:05:58 |
| 84911528 | 2016-07-29 05:13:59 |
| 84911530 | 2016-07-29 05:13:59 |
| 84911532 | 2016-07-29 05:13:59 |
| 84911534 | 2016-07-29 05:13:59 |
| 84911536 | 2016-07-29 05:14:00 |
| 84911538 | 2016-07-29 05:14:00 |
| 84911540 | 2016-07-29 05:14:00 |
| 84911542 | 2016-07-29 05:14:00 |
| 84911544 | 2016-07-29 05:14:00 |
| 84911546 | 2016-07-29 05:14:00 |
| 84911548 | 2016-07-29 05:14:00 |
| 84911550 | 2016-07-29 05:14:00 |
| 84911552 | 2016-07-29 05:14:00 |
| 84911554 | 2016-07-29 05:14:00 |
| 84911556 | 2016-07-29 05:14:00 |
| 84911558 | 2016-07-29 05:14:00 |
| 84911560 | 2016-07-29 05:14:00 |
| 84911562 | 2016-07-29 05:14:00 |
| 84911564 | 2016-07-29 05:14:00 |
| 84911566 | 2016-07-29 05:14:00 |
| 84911568 | 2016-07-29 05:14:00 |
| 84911570 | 2016-07-29 05:14:00 |
| 84911572 | 2016-07-29 05:14:00 |
| 84911574 | 2016-07-29 05:14:00 |
| 84911576 | 2016-07-29 05:14:00 |
| 84911580 | 2016-07-29 05:14:00 |
+---------------------+---------------------+
47 rows in set (0.57 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment