SELECT t.*,t1.categoryName,t2.continentName FROM tranzy_tbl_packages t,tranzy_tbl_category t1,tranzy_tbl_continent t2 WHERE t.catId=t1.catId AND t.contId=t2.contId AND t.packageStatus='1' AND t.countryId='97' AND t1.categoryName LIKE '%Leisure%' ORDER BY t.priceperPerson ASC
Tranzy Tours
