EOF
SELECT Advertisers.Name, Advertisers.ImageFileName, Advertisers.WebAddress, Advertisers.Description, Addresses.Line1, Addresses.Line2, Addresses.Line3, Addresses.Line4, Addresses.Postcode, Addresses.Country, Addresses.Telephone1, Addresses.Telephone2, Addresses.Fax, Addresses.Email, Addresses.Contact, Advertisers.IsActive, Advertisers.ImageCount, Advertisers.IsDealerBroker, Advertisers.CurrentEMagLink, Addresses.WebAddress, Addresses.Id, Advertisers.HasBanner, Advertisers.Facebook, Advertisers.Twitter, Advertisers.LinkedIn FROM (Advertisers INNER JOIN AdvertiserAddressLink ON Advertisers.Id = AdvertiserAddressLink.AdvertiserId) INNER JOIN Addresses ON AdvertiserAddressLink.AddressId = Addresses.Id WHERE Advertisers.Id=1353 AND (Addresses.AddressType=0 OR Addresses.AddressType=2) Order By Addresses.Sequence