| | 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 |
|
|
|
Sign In /
Join ActiMedia
Add Bookmark
Link to us
