SELECT Name FROM country WHERE DomainCode='uk'MySQL server has gone awaySELECT count(DISTINCT(agency_new.AgencyID)) FROM agency_new 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 WHERE agency_new.Publish='Y' AND DomainCode='uk' MySQL server has gone away
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' GROUP BY agency_new.AgencyID ORDER BY agency_new.Name LIMIT 3400,20
MySQL server has gone away
PR directory
     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
ActiMedia USA ActiMedia UK
Bookmark and Share

PR Directory - A-Z of PR

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
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' ORDER BY IDrank ASC LIMIT 10MySQL server has gone away
  CountryNumber of PR Agencies
PR Agencies found =

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

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