| PR Agency Name | Location |  |  |  |  |
 | Karen Gray Ltd | .Low Woodside, Consett, County Durham [Northumberland] [North East] [England] | | | | |
 | Karla Otto Ltd | .30 Sackville Street, London
| 1 |  |  | |
 | Karol Marketing | .The Old Pub, Albion Row, East Quayside,Newcastle Upon Tyne [Tyne and Wear] [North East] [England] | 1 |  | | |
 | Karol Marketing (South) Ltd | .43 Moss Drive
Marchwood
Southampton
SO40 4YD [Hampshire] [South East] [England] | |  | |  |
 | Kartupelis Associates | .St Johns Innovation Cente <BR> Cowley Road <BR> Cambridge<BR> [Cambridgeshire] [East Anglia] [England] | | | | |
 | Kate Horton Public Relations | .10 York Road, Riccall, York [York, Yorkshire] [Yorkshire & Humberside] [England] | | | | |
 | Kate Whyman PR | .21-22 Old Steine,Brighton,East Sussex [Brighton and Hove] [South East] [England] | |  | | |
 | Kath Harding PR Ltd | .Abbeyfield Park House, Abbeyfield Road, Sheffield
| | | | |
 | Kathleen Forssman Public Relations (KFPR) | .17 Forest End, Waterlooville, Hampshire [Hampshire] [South East] [England] | | | | |
 | Kathryn Holloway Press Alert Media Training | .5 Flitwick Road, Ampthill,BedfoRoad, Bedfordshire [Bedfordshire] [South East] [England] | | | | |
 | Katie Brewin Consulting | .22 Maidstone Avenue, Manchester. [Greater Manchester] [North West] [England] | | | | |
 | Katrin Naefe PR | .7 Warkworth Close
Banbury [Oxfordshire] [South East] [England] | |  | |  |
 | Kay Hocking Public Relations | .21 The British,Yate,Bristol,Avon [South Gloucestershire] [South West] [England] | | | | |
 | Kazoo Communications | .12 Goslett Yard, London
| |  |  | |
 | KBC PR and Marketing Ltd | .Suite 3, Falmer Court
London Road
Uckfield
East Sussex [East Sussex] [South East] [England] | |  | |  |
 | KBC Public Relations & Marketing Ltd | .3 Falmer Court London Road, Uckfield,East Sussex [East Sussex] [South East] [England] | | | | |
 | KBPR | .15 Boulevard Soult, Mazamet, France
| |  | | |
 | KC3 Ltd | .The Exchange
Bridge Street
Kington [Powys] [Mid and West Wales] [Wales] | |  |  |  |
 | KDA | .Catchpell House Business Centre Carpet Lane Bernard Street Edinburgh [City of Edinburgh] [Lothian] [Scotland] | | | |  |
 | KDA-PR | .Catchpell House Carpet Lane Leith Edinburgh Scotland UK [City of Edinburgh] [Lothian] [Scotland] | |  | |  |
|
|
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 |
|
|