SELECT c.*, c.title as header, cc.name as category, date_part('epoch', c.edate) as expire FROM coupons c JOIN coupon_category cc ON c.category = cc.name WHERE c.active = true AND CURRENT_DATE BETWEEN c.sdate AND c.edate AND c.active = true ORDER BY cc.name, c.sdate