SELECT DISTINCT `a`.*, `b`.`id` as `offersId`, `b`.`cashBackType`, MAX(b.cashBackValue) as cashBackValue FROM `stores` as `a`, `storeCashBack` as `b` WHERE `isBusStore` = 1 AND `b`.`storeCategoryCode` = 'c09' GROUP BY `a`.`code` ORDER BY `a`.`storePageOrder` ASC
Book your Bus Tickets with your preferred vendor and
get additional CASHBACK from MyLeastPrice:
Online Tickets and Hotel booking makes it comfortable for you to choose the right deals by comparing the fares and checking the availability. In fact nowadays people prefer this method for all their Air ticket and hotel booking as they are reliable and affordable as compared to any broker and middleman.
MyLeastPrice helps you find the best deals on Air tickets of all Domestic and International Flights and Hotels. With several online booking sites it's now easy to find the air tickets and hotel that best suits your needs at the discounted rates. Not just low fare but you also get Cashback on every bookings.