PR database and media networking
Sign In / Join ActiMedia   Add Bookmark   Link to us
Home PR Agencies PR Clients PR Jobs News Feeds Publishers Publications Statistics PR Organisations
You are here: Home > PR Agencies > United Kingdom (UK) > Alphabetical - 1

. 1 2 3 4 5 7 8 9 @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

PR Agency Name Location 1 Up Media .2 Coney Road, East Wittering, Chichester, West Sussex [West Sussex] [South East] [England]         1 UP Media Ltd .23 Sussex Street, Westminster, London       10 Yetis Ltd .3 Pullman Court Great Western Road Gloucester GL1 3ND [Gloucestershire] [South West] [England]   1090 Communications Ltd .185 Acomb Street, Manchester

Location Count PR agencies in England 3116 PR agencies in Scotland 216 PR agencies in Wales 132 PR agencies in Northern Ireland 87 PR agencies in Channel Islands 18 PR agencies in Isle of Man 11

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   Country Number of PR Agencies United Kingdom (UK) 4254 United States of America (USA) 2432 Netherlands 2020 Australia 1142 France 523 Ireland 204 New Zealand 174 Germany 131 India 59 Sweden 41 Switzerland 35 Belgium 34 Spain 29 Canada 23 Italy 18 South Africa 18 Hong Kong 16 United Arab Emirates 15 Singapore 11 China 10 Vietnam 8 Pakistan 7 Brazil 6 Bulgaria 6 Russia 6 Austria 5

PR Agencies found = 4