| | PR Agency Name | Location |  |  |  |  |
|---|
 | ...Thirty30Media Ltd | .82 King Street
Manchester
[Greater Manchester] [North West] [England] | |  | | |
| ..Proteus Media Relations | .3-8 Redcliffe Parade West
[Bristol] [South West] [England] | | | | |
| 1 Up Media | .2 Coney Road, East Wittering, Chichester, West Sussex
[West Sussex] [South East] [England] | | | | |
| 1 UP Media Ltd | .23 Sussex Street, Westminster, London
| | | | |
| 10 Yetis Ltd | .3 Pullman Court
Great Western Road
Gloucester
GL1 3ND
[Gloucestershire] [South West] [England] | | | | |
| 1090 Communications Ltd | .185 Acomb Street, Manchester
| | | | |
| 2 Bits Ltd | .10 Water Croft
Long Meadow
Worcester
[Hereford and Worcester] [West Midlands] [England] | | | | |
| 2 The Fore Ltd | .34 QKendeavour
Suffield Lane
Puttenham
Surrey
GU3 1BD
[Surrey] [South East] [England] | | | | |
| 20-20 Public Relations Ltd | .Ivy House
Fernham Road
Longcot
[Oxfordshire] [South East] [England] | | | | |
| 20-20 Public Relations Ltd | .The Byre, Majors Road,Longcot, Faringdon.
[Oxfordshire] [South East] [England] | | | | |
| 24 Carat Copy | .17 Winchfield Close , Kenton, Harrow, Middlesex
[Greater London] [South East] [England] | | | | |
| 24 Seven PR Marketing | .Fitzroy Place, Sauchiehall Street, Glasgow
| | | | |
| 2Communicate | .39 Michael Tippett Drive
Worcester
[Hereford and Worcester] [West Midlands] [England] | | | | |
| 3 Monkeys Communications Ltd | .94a Milton Park, Abingdon, Oxfordshire
[Oxfordshire] [South East] [England] | | | | |
| 33rpm-public-relations | .37 Nab lane,
Nab Wood,
Shipley,
West Yorkshire
| | | | |
| 360 Communications Ltd | .58a Livingstone Rd, Hove.
[Brighton and Hove] [South East] [England] | | | | |
| 360 Integrated Marketing Solutions | .
[Hampshire] [South East] [England] | | | | |
| 3:nine Communications | .15 Townmead Business Centre, William Morris Way, Fulham, London
[Greater London] [South East] [England] | | | | |
| 4 Creative Marketing Ltd | .The Old Hay Barn Rosebery Mews,Mentmore,Leighton BuzzaRoad, Bedfordshire
[Bedfordshire] [South East] [England] | | | | |
| 4 Square Marketing Communication Ltd | .Lowther Estate OfficesLowther,Penrith,Cumbria
[Cumbria] [North West] [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
