WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY Departure ASC' at line 8]
SELECT DISTINCT import_main.SailingID as SailingID,CruiseItineraryID, SailingName, DT.Name as Destination,Duration,DATE_FORMAT(Departure,'%Y%m%d') as Departure,DP.Name as DeparturePort,import_main.DeparturePort as DPortID,RP.Name as ReturnPort,SH.shipid as ShipID,SH.Name as ShipName,SH.VendorID as VendorID,Currency,import_main.Inside as Inside,import_main.Outside as Outside,import_main.Balcony as Balcony,import_main.Suite as Suite,import_main.PercentOffInside as PercentOffInside,import_main.PercentOffOutside as PercentOffOutside,import_main.PercentOffBalcony as PercentOffBalcony,import_main.PercentOffSuite as PercentOffSuite,SH.HasInside as HasInside,SH.HasOutside as HasOutside,SH.HasBalcony as HasBalcony,SH.HasSuite as HasSuite,import_main.PromotionText as PromoText,import_main.PromotionID as PromoID,AG.Visible as Visible,AG.VendorName as Agency FROM import_main left join import_ports DP on import_main.DeparturePort = DP.PortID left join import_ports RP on RP.PortID = import_main.ReturnPort left join import_ships SH on SH.shipid = import_main.ShipID left join import_agency AG on AG.VendorID = SH.VendorID right join import_destinations DT on DT.DestinationID = import_main.Destination WHERE ORDER BY Departure ASC