| 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 |
|
|