| PR Agency Name | Location |  |  |  |  |
 | Furore PR | .Studio 120
The Custard Factory
Gibb Street
Birmingham (city centre)
| |  | |  |
 | Fusion Communications | .Sovereign Gate,<BR> Lower Ground Floor,<BR>18-20 Kew Road,<BR> Richmond, <BR> Surrey [Greater London] [South East] [England] | |  | | |
 | Fusion Media (Europe) Limited | .Crown House
Home Gardens
Dartford
Kent [Greater London] [South East] [England] | |  |  |  |
 | Future Image Ltd | .26 Church Road, Holywood [County Down] [Ulster] [Northern Ireland] | |  | | |
 | Futurenet Publishing Ltd | .Throwley, Faversham, Kent [Kent] [South East] [England] | | | | |
 | Fya Ltd | .Unit 2
The Glebe
Blisland
Cornwall [Cornwall] [South West] [England] | |  | |  |
 | Fya Ltd | .Unit 2 The Glebe,Blisland,Bodmin,Cornwall [Cornwall] [South West] [England] | | | | |
 | FYI Magazine / Omnia MC | .2, Mornington Place,Belfast, [Belfast] [Ulster] [Northern Ireland] | |  | | |
 | G & L Management Consultants | .92 Castlecat Road, Ballymoney, County Antrim [County Antrim] [Ulster] [Northern Ireland] | | | | |
 | G Hutson | .41 Burnaby Gardens, London [Greater London] [South East] [England] | | | | |
 | G J W Government Relations | .Haywood House South, Dumfries Place, Cardiff [South Glamorgan] [South Wales] [Wales] | | | | |
 | G M X Communications Ltd | .16 Brunswick Place, Southampton [Southampton] [South East] [England] | | | | |
 | G P Publicity | .8 Chestnut Walk, Welwyn, Hertfordshire [Hertfordshire] [South East] [England] | | | | |
 | G Promo PR | .3, Trimpley Street
Ellesmere
Shropshire [Shropshire] [West Midlands] [England] | |  | |  |
 | G2F | .7 All Saints,
Orrell Street, Bury [Greater Manchester] [North West] [England] | |  | | |
 | Gabriel Communication Ltd | .34 Pentonville Road, London, [Greater London] [South East] [England] | | | | |
 | Gabrielle Shaw Communications Ltd | .Unit C20, 71 Warriner Gdns, London. [Greater London] [South East] [England] | | | | |
 | Galliard Healthcare Communications | .Lincoln House, 296-302 High Holborn, Holborn, London
| | | | |
 | Gamble-Ruston Public Relations Ltd | . [Leeds] [East Midlands] [England] | | | |  |
 | Gamble-Ruston Public Relations Ltd | .St. Peters Bldgs, St. Peters Sq, Leeds. [Leeds] [East Midlands] [England] | | | | |
|
|
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 |
|
|