| PR Agency Name | Location |  |  |  |  |
 | V T Banham | .Harmans, Thornfalcon, Taunton [Somerset] [South West] [England] | | | | |
 | Vahdaty | . [Greater London] [South East] [England] | | | |  |
 | Vail & Associates | .Battersea Business Cntr, 99-109 Lavender Hl, London. [Greater London] [South East] [England] | | | | |
 | Vail Resorts | .54 Courtenay Gardens, Upminster, Essex [Essex] [South East] [England] | | | | |
 | Valerie Barber Management Ltd | .2 Highgate Spinney, Crescent Rd, London. [Greater London] [South East] [England] | | | | |
 | Vanbrugh Financial Communications | .147 Alderney Street, London,
| |  | |  |
 | Vane Percy & Associates | .Robert Denholm House,
Bletchingley Road,
Nutfield,
Surrey. [Surrey] [South East] [England] | |  | |  |
 | Vane Percy and Roberts | .Robert Denholm House
Bletchingley Rd
Nutfield
Surrey [Surrey] [South East] [England] | |  | |  |
 | Vanilla Public Relations Ltd | .38 Waverley Road
Weybridge
Surrey [Surrey] [South East] [England] | |  | |  |
 | VANTAGE Public Relations | .14, White Swan Court,Monmouth,Gwent [Monmouthshire] [South Wales] [Wales] | |  |  | |
 | Variations PR | .11 Jew St, Brighton, East Sussex [Brighton and Hove] [South East] [England] | |  | | |
 | Vast PR | .1 The Hay Barn Business ParkCublington Road, Aston Abbotts,Aylesbury,Buckinghamshire [Buckinghamshire] [South East] [England] | | | | |
 | Vause and Associates | .115a Gloucester Place, London
| | | | |
 | Vector Business Communications | .Chiltern House,
184 High Street,
Berkhamsted [Hertfordshire] [South East] [England] | |  | | |
 | Vee Search | .31 Bedford Square <BR> London
| |  | | |
 | Vee-Search-Limited | .31 Bedford Square London
| |  | |  |
 | Vega Media Group | . [Greater London] [South East] [England] | | | |  |
 | Velocity Communications | .Bourlet House, 4 Bourlet Close, Soho, London
| | | | |
 | Velvet Communications | . [Darlington] [North East] [England] | |  |  | |
 | Venture Public Relations | .17 Queen Square,Bristol,Avon [Bristol] [South West] [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 |
|
|