Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- > select top 5 * from Printer_Personal_Recommendations_BO where rec_version ='THRU'
- ---------------------------------------------------------------------------------------------------------------------------
- | Create_Version | Discount_Card_ID | Coupon_ID | Rank | CDate | Rec_Version |
- ---------------------------------------------------------------------------------------------------------------------------
- | 1424985995 | 0000000000000 | 5981 | 100500.0 | 2015-02-27 19:16:21.88 | THRU |
- | 1424985995 | 2775000000067 | 5981 | 100500.0 | 2015-02-27 19:16:21.88 | THRU |
- | 1424985995 | 2775000000234 | 5981 | 100500.0 | 2015-02-27 19:16:21.88 | THRU |
- | 1424985995 | 2775000000340 | 5981 | 100500.0 | 2015-02-27 19:16:21.88 | THRU |
- | 1424985995 | 2775000000371 | 5981 | 100500.0 | 2015-02-27 19:16:21.88 | THRU |
- ---------------------------------------------------------------------------------------------------------------------------
- > select coupon_id, count(*) from Printer_Personal_Recommendations_BO where rec_version ='THRU' group by coupon_id
- -----------------------------
- | coupon_id | * |
- -----------------------------
- | 6638 | 76 |
- | 5981 | 1321748 |
- -----------------------------
- > select * from coupons_list where couponid=5981 or couponid=6638
- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- | CouponId | SKU | Name | Brand | StartDate | EndDate | Discount | insertDate | IsActive | IsGoodPeriod | Barcode | Coupon_Attribute |
- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
- | 5981 | 3008893 | Ariel Колор Порошок Для автоматических стиральных машин 1.5кг | Ariel | 2015-02-26 00:00:00.0 | 2015-02-27 02:30:01.987 | -15 | 2015-02-28 02:30:01.987 | 0 | 0 | (null) | 1 |
- | 6638 | 3008893 | Ariel Колор Порошок Для автоматических стиральных машин 1.5кг | Ariel | 2015-02-26 00:00:00.0 | 2015-02-27 02:30:02.933 | -30 | 2015-02-28 02:30:02.933 | 0 | 0 | (null) | 2 |
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement