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 3105 PR agencies in Scotland 215 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) 4239 United States of America (USA) 2419 Netherlands 2020 Australia 1142 France 523 Ireland 203 New Zealand 174 Germany 129 India 46 Sweden 41 Switzerland 35 Belgium 34 Spain 28 Canada 23 Italy 18 Hong Kong 15 South Africa 15 China 10 Singapore 10 United Arab Emirates 8 Brazil 6 Russia 6 Austria 5 Bulgaria 5 Israel 5 Poland 5

PR Agencies found = 4