| PR Agency Name | Location |  |  |  |  |
 | Professional Images (PR & Editorial Photographers) | .12 Swindon Road
Highworth
Swindon [Oxfordshire] [South East] [England] | |  |  |  |
 | Profile Communication Ltd | .Blakemere Craft Centre, Chester Road, Northwich,Cheshire [Cheshire] [North West] [England] | | | | |
 | Profile Marketing | .The Studio, 1st Floor, 32 Tanners Drive, Blakelands, Milton Keynes [Milton Keynes] [South East] [England] | |  | | |
 | Profile North | .37 Rugby Road, BelfaStreet, County Antrim [Belfast] [Ulster] [Northern Ireland] | | | | |
 | Profile Nottingham | .Shire Hall, High Pavement, Nottingham Nottinghamshire NG1 1HN
| | | | |
 | Profile Plus | .78 The Shore
EDINBURGH [City of Edinburgh] [Lothian] [Scotland] | |  |  | |
 | Profile Press & Public Relations | .Vogans Mill Wharf 17 Mill Street, London. [Greater London] [South East] [England] | | | | |
 | Profile Press and P R | .2 Vogans Mill Wharf 17 Mill Street, London [Greater London] [South East] [England] | |  | | |
 | Profile Public Relations | .Layton House Kew Green Richmond Surrey [Greater London] [South East] [England] | |  | |  |
 | Profile Public Relations Ltd | .14-18 Heddon Street, St James, London
| | | | |
 | Profiles | .9 Barnsley Road, Birmingham [West Midlands] [West Midlands] [England] | | | | |
 | Prohibition PR | .7, Knox Way, Harrogate, North Yorkshire [North Yorkshire] [Yorkshire & Humberside] [England] | |  |  |  |
 | Project Associates | .Third Floor Queens House Leicester Place, London.
| | | | |
 | Project Associates (UK) Ltd | .3rd Floor, Queens House, 1 Leicester Place, St James, London
| |  | | |
 | Project Planning International | .Montalto Estate Spa Road, Ballynahinch,County Down [County Down] [Ulster] [Northern Ireland] | | | | |
 | PRojects | .meadow close hinchley wood esher, surrey [Surrey] [South East] [England] | |  | |  |
 | PRojects | .Meadow Close <BR> Hinchley Wood <BR> Esher, Surrey [Surrey] [South East] [England] | |  | | |
 | PROMARK PUBLIC RELATIONS | .Stoner House, London Road, Crawley, W Sussex, RH10 2LJ [Surrey] [South East] [England] | | | |  |
 | Promise PR & Design Ltd | .The STudio
Adwalton Business Park
132 Wakefield Road
Drighlington [West Yorkshire] [North East] [England] | |  | |  |
 | PRomote | .Heathcock Court, 410 Strand, Strand, London
| |  | | |
|
|
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 |
|
|