| PR Agency Name | Location |  |  |  |  |
 | Quad Public Relations | .78 Countess Street, Stockport,Cheshire [Greater Manchester] [North West] [England] | | | | |
 | Quadrant Media & Communications Ltd | .Greenmeadow Springs
Tongwynlais
Cardiff [South Glamorgan] [South Wales] [Wales] | 2 |  | |  |
 | Quadrant Public Relations | .The Long Barn, Waen Farm, Nercwys Road, Mold, Flintshire [Flintshire] [North Wales] [Wales] | 1 |  | | |
 | Quant IR | .8 Marylebone Passage <BR> <BR> London<BR>
| |  | | |
 | Quantum PR Birmingham | .The Waters Edge, Birmingham, West Midlands [West Midlands] [West Midlands] [England] | | | | |
 | Quantum PR London | .12 Stukeley St, Covent Garden, London
| | | | |
 | Quantum PR Services | .Technology House, Lissadel St, Salford Lancashire M6 6AP
| | | | |
 | Quantum Public Relations | .Suite 2
Charter House
Park Street
Ashford
Kent [Kent] [South East] [England] | |  | |  |
 | Quantum Technical PR Ltd | .35 Whitefield Road, Stockton Heath,Warrington,Cheshire [Cheshire] [North West] [England] | | | | |
 | Quarrington Curtis | .3 Trinity Barns, Weston, Petersfield, Hampshire, [Hampshire] [South East] [England] | | | | |
 | Quarterback Communications | .23 Bruton St, London W1X 7DA
| | | | |
 | Quay West Communications Ltd | .Laxfield House, 2 Church Street, Coggeshall, Colchester [Essex] [South East] [England] | 1 | | | |
 | Queen of the Crop | .c/o: The Arch (Unit S2)
48-52 Floodgate Street
Birmingham [West Midlands] [West Midlands] [England] | |  | |  |
 | Queer Media Limited | .95 Wilton Road
Suite 3
LONDON
| |  | |  |
 | Quest Communications | .56 Sciennes, Edinburgh Midlothian EH9 1NL
| | | | |
 | Quest Consultants | .8 Frederick\'s Place, London
| |  | | |
 | Quicksilver Public Relations | .The Business Resource Network, Whateleys Dr, Kenilworth, Warwickshire [Warwickshire] [West Midlands] [England] | |  | |  |
 | Quicksilver Public Relations | .Po Box 10439, Solihull. [West Midlands] [West Midlands] [England] | | | | |
 | Quicksilver Writing Services | .25 High Street, Bassingbourn, Royston, Herts. [Cambridgeshire] [East Anglia] [England] | | | | |
 | Quiller Consultants | .11-12 Buckingham Gate
London SW1E 6LB
| |  | |  |
|
|
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 |
|
|