SELECT t1.IDN, t1.hotelCode, t1.hotelImageLink FROM prd_hotels_images AS t1 WHERE t1.hotelCode = AND vStatus = 1 ORDER BY t1.isMain, t1.imgOrder, t1.hotelImageLink