SELECT Company.CompanyCounter,
  Company.CompanyName,
  Company.Address1 AS "Addr1-Line1",
  Company.Address2 AS "Addr1-Line2",
  Company.Address3 AS "Addr1-Line3",
  Company.Town AS "Addr1-City",
  Company.County AS "Addr1-State",
  Company.PostCode AS "Addr1-Postcode",
  Company.Country AS "Addr1-Country",
  Company.MainTelephone AS "Addr1-PhoneNo1",
  Company.Cellular AS "Addr1-PhoneNo2",
  Company.EmailAddress AS "Addr1-Email",
  Company.MainFax AS "Addr1-PhoneNo3"
FROM Company
WHERE Company.EmailAddress = ?
ORDER BY Company.CompanyCounter