SELECT agency_new.Name AS Name, Address, region.Name AS Region, state.Name AS State, county.Name as County, town.Name as Town, website.Value AS Website, twitter.Value AS Twitter, agency_new.AgencyID,DomainCode, country.Name AS CountryName, count(DISTINCT(Comment)) AS Comments,RegisterStatus, IF (DATEDIFF(CURDATE(),agency_new.LastUpdate) < 30 || DATEDIFF(CURDATE(),RegisterDate) < 30 ,'Y','') AS New FROM agency_new LEFT JOIN contacts as website ON agency_new.AgencyID=website.ObjID AND website.TypeID=4 LEFT JOIN contacts AS twitter ON agency_new.AgencyID=twitter.ObjID AND twitter.TypeID=5 LEFT JOIN country ON agency_new.CountryID=country.CountryID LEFT JOIN postcode_map ON (agency_new.Outcode=postcode_map.Postcode AND postcode_map.CountryID=agency_new.CountryID) LEFT JOIN map_text AS state ON postcode_map.StateID=state.loc_ID LEFT JOIN map_text AS county ON postcode_map.CountyID=county.loc_ID LEFT JOIN map_text AS region ON postcode_map.RegionID=region.loc_ID LEFT JOIN map_text AS town ON postcode_map.TownID=town.loc_ID LEFT JOIN agency_votes ON agency_new.AgencyID=agency_votes.AgencyID AND agency_votes.Publish='Y' WHERE agency_new.Publish='Y' AND DomainCode='uk' AND agency_new.Name LIKE 'O%' GROUP BY agency_new.AgencyID ORDER BY agency_new.Name LIMIT 0,20
MySQL server has gone away
PR in United Kingdom (UK)
     PR database and media networking
Sign Into ActiMedia   Sign In / Join ActiMedia
Sign Into ActiMedia   Add Bookmark
Link to ActiMedia   Link to us
      You are here: Home > PR Agencies > United Kingdom (UK) > Alphabetical - O
ActiMedia USA ActiMedia UK
Bookmark and Share

United Kingdom (UK) Public Relations

Browse the A to Z of PR and Media Relations consultancies listed in ActiMedia.
Showing PR agencies through to .

To obtain more details about each PR consultancy, click on the name of the Public Relations company below.


  PR Agency Name Location Agency RatingEnhanced Listing
SELECT state.Name AS State, count(*) as count FROM agency_new 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 WHERE DomainCode='uk' GROUP BY state.Name ORDER BY count DESC LIMIT 28MySQL server has gone awaySELECT region.Name AS Region, count(*) as count FROM agency_new 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 region ON summary_postcode_map.RegionID=region.loc_ID WHERE DomainCode='uk' GROUP BY region.Name ORDER BY count DESC LIMIT 28MySQL server has gone away
Letter Count Letter Count
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 10MySQL server has gone away
  CountryNumber of PR Agencies
PR Agencies found = 68 [ 1 2 3 4 ]

[Back] [PR Directory] [ActiMedia] [News & Press Releases] [PR Jobs]

Fri Feb 27, 2015
Copyright © 1996-2015 ActiMedia Cookie Policy
A division of WebShop Ltd. Visit High Tech Sales Agents
Consumer Electronics
Registered in England No. 3096668.