Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- tanga_dev=# SELECT id FROM "products" WHERE (start_sale_date < now() and category_id = 1 and id != E'20') ORDER BY start_sale_date desc;
- id
- ----
- 13
- 2
- 15
- 25
- 33
- (5 rows)
- tanga_dev=# SELECT id FROM "products" WHERE (start_sale_date < now() and category_id = 1) ORDER BY start_sale_date desc;
- id
- ----
- 20
- 13
- 2
- 15
- 25
- 33
- (6 rows)
Add Comment
Please, Sign In to add comment