select DISTINCT S.ShipCode, B.ShipName from SPAESPEURPricingFeed as S join BarcosAPI as B on S.ShipCode = B.ShipCode where ((B.cruiselinecode = 'RCC') or (B.cruiselinecode = 'CEL') or (B.cruiselinecode = 'AZA')) and (RegionCode = '') and month(SailDate) = '' and year(SailDate) = '' and DeparturePortCode = '' and S.ShipCode = ''
:
  
:
:
: