Subscribe to our daily Deal Alert :

SELECT d.deal_title,d.deal_id,d.deal_terms_conditions,d.coupon_code,d.dom_int_all, d.deal_display_in, d.deal_link_vendor_id, dv.vendor_name AS deal_vendor_name, dv.vendor_url AS deal_vendor_link,v.vendor_url,v.vendor_name,d.deal_url,d.deal_description,v.vendor_logo_path,v.vendor_id,c.vcat_identification,DATE_FORMAT(d.`valid_from_dt`,"%d-%b-%Y" ) as from_date,DATE_FORMAT(d.`valid_till_dt`,"%d-%b-%Y" ) as to_date FROM `hotel_deals` d LEFT JOIN hotel_vendor_master AS dv ON dv.vendor_id = d.deal_link_vendor_id, `hotel_vendor_master` as v,`hotel_vendor_category` as c WHERE d.vendor_id=v.vendor_id AND d.deal_status="ACTIVE" AND v.vcat_id=c.vcat_id AND DATE_FORMAT(d.`valid_from_dt`,"%Y-%m-%d" ) <= CURDATE() AND DATE_FORMAT(d.`valid_till_dt`,"%Y-%m-%d" ) >= CURDATE() AND dom_int_all='Domestic' ORDER BY v.vendor_id, d.deal_id desc,d.valid_till_dt ASC
No Deals Found