| PR Agency Name | Location |  |  |  |  |
 | Quiller Consultants | .11-12 Buckingham Gate, Westminster, London
| |  | | |
 | Quintus Public Affairs | .Regency House, 1-4 Warwick Street, St James, London
| | | | |
 | Quisk Communications Ltd | .36 Crosby Road Nth, Liverpool [Merseyside] [North West] [England] | | | | |
 | Quite Great Publicity | .Unit D
Magog Court
Shelford Bttm
Cambridge
| |  | |  |
 | Quite Great Publicity | .Unit DMagog Court, Shelford Bottom,Cambridge,Cambridgeshire
| 1 | | | |
 | Quite Storm Consultants | .Unit 11, Whitwick Business Park, Stenson Road, Coalville, Leicestershire [Leicestershire] [East Midlands] [England] | | | | |
 | R & Associates | .Ferensby Gnge, Harrogate Road, Ferrensby, Knaresborough, North Yorkshire [North Yorkshire] [Yorkshire & Humberside] [England] | | | | |
 | R & M Marketing Ltd | .Brook Ho, Clappers La, Henfield. [West Sussex] [South East] [England] | | | | |
 | R & R Teamwork | .754 Fulham Road, London [Greater London] [South East] [England] | | | | |
 | R D A Communications Ltd | .Chelsea Wharf, 15 Lots Road, Kensington, London [Greater London] [South East] [England] | | | | |
 | R D W Advertising | .Fairfax House, 34 High Street, Yarm [North Yorkshire] [Yorkshire & Humberside] [England] | | | | |
 | R Holloway & Associates Ltd | .23-24 Henrietta Street London
| 1 | | | |
 | R M G & Co | .11 Old Burlington Street, Mayfair, London
| | | | |
 | R M P R Ltd | .27 Canmore Street, Dunfermline, Fife [Fife] [Fife] [Scotland] | | | | |
 | R P M Promotions | .46B Sea King Road,Lynx Trading Estate, Yeovil, Somerset [Somerset] [South West] [England] | |  | | |
 | R Queenborough | .2b Wesley Road, Ironbridge, Telford [Shropshire] [West Midlands] [England] | | | | |
 | Racepoint Group UK Limited | .Building 5
50 Brook Green
London X [Greater London] [South East] [England] | |  |  | |
 | Racso Ltd | .48 Carver Street, Birmingham [West Midlands] [West Midlands] [England] | | | | |
 | Radiator PR Ltd | .8 Northington Street, Bloomsbury, London
| 1 | | | |
 | Radish | . [Tyne and Wear] [North 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 |
|
|