google
Open Travkart App & Avail Special Deals!
Open
×

Flash Sales !!!

SELECT ohrm_multi_acc_coupon_pkg_rln.*,ohrm_multi_acc_discount_coupon.* FROM ohrm_multi_acc_discount_coupon,ohrm_multi_acc_coupon_pkg_rln WHERE ohrm_multi_acc_discount_coupon.status='active' and ohrm_multi_acc_coupon_pkg_rln.coupon_id=ohrm_multi_acc_discount_coupon.coupon_id and ohrm_multi_acc_discount_coupon.coupon_type='1' group by ohrm_multi_acc_coupon_pkg_rln.parent_roomtype_id ORDER BY ohrm_multi_acc_coupon_pkg_rln.dispaly_order= 0, ohrm_multi_acc_coupon_pkg_rln.dispaly_order Affordable Maldives Fly-N-Stay