| PR Agency Name | Location |  |  |  |  |
 | Molly McKellar | .Flat 3, Fleur Gates, London. [Greater London] [South East] [England] | | | | |
 | Momentum PR Ltd | .1 Pont St, London.
| | | | |
 | Monkey Business PR | .Cumberland House, 80 Scrubs Lane, London [Greater London] [South East] [England] | | | | |
 | Mono Design | .4 St Andrew's House
Vernon Gate
Derby [Derby] [East Midlands] [England] | |  | |  |
 | Montage Communications | .Media House
13 Oak road [Bristol] [South West] [England] | |  |  |  |
 | Montage Communications | .30, Wellington Park,Clifton,Bristol, [North Somerset] [South West] [England] | |  |  | |
 | Montage Communications Ltd | .13 Oak Road, Bristol,Avon [Bristol] [South West] [England] | | | | |
 | Monument PR Worldwide | .14 Queen Square
Bath [Bath Avon] [South West] [England] | |  | |  |
 | Moonlight Media Ltd | .5 St. John's Lane,
Smithfield,
London [Greater London] [South East] [England] | 1 |  | |  |
 | Moonlight Media Ltd | .5 St Johns Lane, London.
| | | | |
 | Moontrip | ."Foxhollows"
Penylan Rd.
St Brides Major
Vale of Glamorgan
CF32 0SB [Bridgend] [Mid and West Wales] [Wales] | | | |  |
 | Moor Street Media | .32 Moor Street
Hereford [Hereford and Worcester] [West Midlands] [England] | |  | |  |
 | Moore Communications Consultancy | .35 Burfield Road, Old Windsor,Windsor,Berkshire [Buckinghamshire] [South East] [England] | | | | |
 | Moorgate Group | .16 Brune Street,
London [Greater London] [South East] [England] | |  | | |
 | Moorland Publicity Ltd | .3 Woodgate, Rothley, Leicester [Leicestershire] [East Midlands] [England] | | | | |
 | Morel Bryan | .Heddon House, 149-151 Regent Street, St James, London
| | | | |
 | Morgan Allen Moore | .1st Floor, 14b Chapel Place, Tunbridge Wells Kent [Kent] [South East] [England] | |  | | |
 | Morgan Allen Moore Cardiff | .First Floor,
Bay Chambers,
West Bute Street,
Cardiff [South Glamorgan] [South Wales] [Wales] | |  | | |
 | Morgan O'Driscoll Photography | .Airewood, Baxter Wood, Crosshills, North Yorkshire [North Yorkshire] [Yorkshire & Humberside] [England] | |  | |  |
 | Morrow Communications | .Pavilions Office Park
Kinnegar Drive
Holywood
Belfast
Co. Down [County Down] [Ulster] [Northern Ireland] | |  |  |  |
|
|
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 |
|
|