| PR Agency Name | Location |  |  |  |  |
 | Positive Profile Communications Consultants | .Hamilton House, 1 Temple Avenue, London
| | | | |
 | Positive Reaction | .4 Church Lane, Henley, Ipswich [Suffolk] [East Anglia] [England] | | | | |
 | Potion PR & Marketing | .2 Crossways
London Road
Sunninghill
Berkshire [Berkshire] [South East] [England] | |  |  |  |
 | Powdene Publicity Ltd | .Unit 17, St. Peters Whf, St. Peters Marina, Newcastle Upon Tyne [Tyne and Wear] [North East] [England] | |  | | |
 | Powell Communication Consultants | .3 The Parsonage
Manchester [Greater Manchester] [North West] [England] | |  | |  |
 | Powell Communication Consultants | .11 Brewery Yard,Deva Centre, Manchester [Greater Manchester] [North West] [England] | |  | | |
 | Power Movez | . [Greater London] [South East] [England] | |  | |  |
 | Powerhouse | .Berhem Mews Blythe Road London [Greater London] [South East] [England] | | | |  |
 | PPR | .69 Grosvenor Street, London
| |  | | |
 | PPR & Pitch Perfect Management | .30b Livingstone Road, Bournemouth [Bournemouth] [South East] [England] | | | | |
 | PPR Publicity | .77 Rylett Crescent
London [Greater London] [South East] [England] | |  | | |
 | PPRG | .Woodlands, Holton, Oxford, Oxon. [Oxfordshire] [South East] [England] | | | | |
 | PPRG | .Brook Farm Barns, Dorton, Aylesbury. [Buckinghamshire] [South East] [England] | | | | |
 | PPS Group London | .69 Grosvenor Street, Mayfair, London
| |  | | |
 | PPS Local & Regional Ltd | .9 North Court The Courtyard, Woodlands, Bristol.
| | | | |
 | PR Agency One | .17 Kingshill Road, Chorlton, Manchester, [Greater Manchester] [North West] [England] | |  |  | |
 | PR Company | .12 Victoria Ter, Hove. [Brighton and Hove] [South East] [England] | | | | |
 | PR Contact | .32 Newman Street, Soho, London
| | | | |
 | PR Continuum | .Unit 16, Six Harmony Row, Govan, Glasgow [Glasgow City] [Strathclyde] [Scotland] | |  | | |
 | PR Department | .Hads House, 9 Preston Road, Portsmouth [Portsmouth] [South 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 |
|
|