| PR Agency Name | Location |  |  |  |  |
 | Verrill Public Relations | .Suite 5Market Weighton Business Centre,Becklands Park, York Road, Market Weighton,York,North Yorkshire [E Riding of Yorkshire] [Yorkshire & Humberside] [England] | | | | |
 | Vertical Marketing Ltd | .Communications House
23d West Street
Wimborne
Dorset
| |  |  |  |
 | Vertical Marketing Ltd | .39c East Street, Wimborne, Dorset
| | | | |
 | Verve Public Relations | .Park House 8 Grove Ash,Mount Farm,Milton Keynes,Buckinghamshire
| | | | |
 | Vf1 Public Relations | .14 Lichfield Street, Wolverhampton [West Midlands] [West Midlands] [England] | | | | |
 | Vibe | .Vibe HouseDeryn Court, Wharfedale Road, Cardiff,South Glamorgan [South Glamorgan] [South Wales] [Wales] | | | | |
 | Vibe PR & Marketing | .Vibe House,Deryn Court,Cardiff,South Glamorgan [South Glamorgan] [South Wales] [Wales] | |  |  | |
 | Vibrant C Ltd | .The Garret, Flat 7, London. [Greater London] [South East] [England] | | | | |
 | Vibrant Media Ltd | .Gensurco House, 46 Rosebery Avenue, Finsbury, London
| | | | |
 | VibrantC Ltd | .The Garret, Flat 7, 16 Talbot Road, London [Greater London] [South East] [England] | | | | |
 | Vickers PR Ltd | .28 Elthiron Road, London [Greater London] [South East] [England] | | | | |
 | Vicky Huntley Associates | .83-84 Berwick Street, Soho, London
| | | | |
 | Vigilant Communication | .Vigilant House, 120 Wilton Road, Westminster, London
| | | | |
 | Vigour Communications Ltd | .Lower Stock Lane Farm
Marchington Woodlands
Uttoxeter
Staffordshire [Staffordshire] [West Midlands] [England] | |  | | |
 | Viney Communications | .Kingsclere, Lodge Road, Whistley Garden, Reading, Berkshire [Berkshire] [South East] [England] | |  | | |
 | Violet Mount | .The Clarendon Centre
38 Clarendon Road
Eccles
Manchester [Greater Manchester] [North West] [England] | 1 |  | |  |
 | Virtual PR & Communications Ltd | .Conveth House,Church Lane,Tydd St. Giles,Wisbech,Cambridgeshire [Cambridgeshire] [East Anglia] [England] | |  | | |
 | Vision | .The Works, 5 Union St, Manchester. [Greater Manchester] [North West] [England] | | | | |
 | Vision Pr | .92 Lots Road, Kensington, London [Greater London] [South East] [England] | | | | |
 | Vision PR & Marketing | .6 Church St, Twyford, Reading Berkshire RG10 9DR
| | | | |
|
|
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 |
|
|