| PR Agency Name | Location |  |  |  |  |
 | Ascot Editorial Services | .74 Kennel Ride Ascot Berkshire [Berkshire] [South East] [England] | |  | |  |
 | Ash Communications | .15 - 19 Great Chapel Street
London
| |  |  | |
 | Ash Hugh Communication | .9 Livsey St Whitefield, Manchester Lancashire M45 6AE [Greater Manchester] [North West] [England] | | | | |
 | Ashford Media | .Gwyon House, Church Road, North Curry, Taunton, Somerset [Somerset] [South West] [England] | |  | | |
 | Ashgate Public Relations | .Unit 14. Midway Business Centre, Bridge Street, Clay Cross,Chesterfield,Derbyshir [Derbyshire] [East Midlands] [England] | | | | |
 | Ashgrove Marketing | .1st Floor Cameo House
19 Duke Street
Douglas
Isle of Man [Middle] [Isle of Man] | |  | | |
 | Ashley Public Relations & Ashley Events | .Torr House, Stoke Climsland, Callington, Cornwall [Cornwall] [South West] [England] | | | | |
 | Ashwell PR | .18 Victoria Square,Bristol,Avon [North Somerset] [South West] [England] | |  | | |
 | Asitis Consulting | .32-36 Dublin Road, BelfaStreet, County Antrim [Belfast] [Ulster] [Northern Ireland] | | | | |
 | Aspect Conferencing Ltd | .Aspect Ho, 126 Brookside Rd, Derby. [Derby] [East Midlands] [England] | | | | |
 | Assistance 2 Business | .Suite 2b12, Saltergate,Chesterfield,Derbyshir
| | | | |
 | Assistance 2 Business | .853 Sheffield Road, Sheepbridge,Chesterfield,Derbyshir
| | | | |
 | Associated Publicity Holdings | .7 Kensington Church Court, London [Greater London] [South East] [England] | 1 | | | |
 | Astrolabe Comunications Ltd | .104 Lancaster Gate, London. [Greater London] [South East] [England] | | | | |
 | Athena Medical PR Ltd | .500 Chiswick High Road, London [Greater London] [South East] [England] | |  |  | |
 | Athene Communications | .26 Priestgate
Peterborough [Cambridgeshire] [East Anglia] [England] | |  | |  |
 | Athene Communications | .Td Priestgate,Peterborough,Cambridgeshire [Cambridgeshire] [East Anglia] [England] | | | | |
 | Atkinson Courage | .152 Buckingham Palace Road London
| |  | | |
 | Atlantis International | .The Auction Rooms, 55 High Street, London [Greater London] [South East] [England] | | | | |
 | Atlas Public Relations Ltd | .South Ldg, Moor End, Wetherby. [West Yorkshire] [North East] [England] | | | | |
|
|
SELECT DISTINCT AgencyID, @row:=@row+1 AS IDrank, agency_new.Name AS Name FROM rank LEFT JOIN agency_new ON ID=AgencyID LEFT JOIN country ON agency_new.CountryID=country.CountryID LEFT JOIN summary_postcode_map ON (agency_new.Outcode=summary_postcode_map.Postcode AND summary_postcode_map.CountryID=agency_new.CountryID) LEFT JOIN map_text AS state ON summary_postcode_map.StateID=state.loc_ID LEFT JOIN map_text AS county ON summary_postcode_map.CountyID=county.loc_ID LEFT JOIN map_text AS region ON summary_postcode_map.RegionID=region.loc_ID WHERE AgencyID!=341 AND Trading='Y' AND Publish='Y' AND DomainCode='uk' ORDER BY IDrank ASC LIMIT 10Table 'webshop.rank' doesn't exist |
|
|