| PR Agency Name | Location |  |  |  |  |
 | JJ Public Relations | .190 Western Road, Mickleover,Derby,Derbyshire [Derby] [East Midlands] [England] | | | | |
 | JK Wildman | .32 Norsey Road, Billericay, Essex [Essex] [South East] [England] | | | | |
 | Jo Foster | .Langford Lodge, 109 Pembroke Road, Clifton, Bristol [North Somerset] [South West] [England] | | | | |
 | Jo Olsen | .24 Prah Road, London [Greater London] [South East] [England] | | | | |
 | Jo Spink Public Relations | .150 Falcon Rd, London. [Greater London] [South East] [England] | | | | |
 | Joanna Smyth Writing & PR | .44 Moor Lane, Charlton, Malmesbury, Wiltshire [Wiltshire] [South West] [England] | | | | |
 | Jocelyne Fildes Public Relations | .26 High Street, Bridgnorth [Shropshire] [West Midlands] [England] | 2 | | | |
 | Joe Bailey Communications | .44 Ham Garden, Pill, Bristol [North Somerset] [South West] [England] | | | | |
 | John Baker Communications | .6 Boswell Road
Lower Westwood
Bradford on Avon
Wiltshire [Wiltshire] [South West] [England] | |  |  |  |
 | John Collier Associates | .3 Wharfe Bk, Collingham, Wetherby, West Yorkshire [North Yorkshire] [Yorkshire & Humberside] [England] | | | | |
 | John Fisher & Associates | .East Gnge, Toadpit Lane, West Hi, Ottery St. Mary, Devon [Devon] [South West] [England] | | | | |
 | John Fordree | .276 Eastern Av, Ilford.
| | | | |
 | John Howard | .Ramsey Manor, High Street, Burwell, Cambridge [Cambridgeshire] [East Anglia] [England] | | | | |
 | John Hutchinson Press & Public Relations | .Gloddfa, Engine Hill, Glascoed, Abergele, Clwyd [Conwy] [North Wales] [Wales] | |  | | |
 | John Kendall Associates | .4 East Bank House, Tide Mill Way, Woodbridge [Suffolk] [East Anglia] [England] | | | | |
 | John Laird Public Relations Ltd | .104 Holywood Road, Belfast [Belfast] [Ulster] [Northern Ireland] | | | | |
 | John Lawson Associates | .Dalmally, Church Hl, Nottingham. [Nottinghamshire] [East Midlands] [England] | | | | |
 | John Little Associates | .Old Keepers Village Lane,Hedgerley,Slough,Berkshire [Buckinghamshire] [South East] [England] | | | | |
 | John M Davis & Associates | .Annie Reed RdBeverley,North Humberside [E Riding of Yorkshire] [Yorkshire & Humberside] [England] | | | | |
 | John Michael | .25 Albemarle Street, Mayfair, London
| | | | |
|
|
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 |
|
|