|
|
| Letter | Count | Letter | Count |
|---|
| . | 2 |
1 | 15 |
| 2 | 14 |
3 | 8 |
| 4 | 5 |
5 | 3 |
| 6 | 1 |
7 | 4 |
| 8 | 3 |
9 | 2 |
| @ | 1 |
A | 737 |
| B | 848 |
C | 1112 |
| D | 425 |
E | 319 |
| F | 325 |
G | 394 |
| H | 449 |
I | 334 |
| J | 340 |
K | 302 |
| L | 420 |
M | 964 |
| N | 271 |
O | 177 |
| P | 1045 |
Q | 57 |
| R | 471 |
S | 942 |
| T | 484 |
U | 64 |
| V | 249 |
W | 395 |
| X | 7 |
Y | 31 |
| Z | 87 |
|
|
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='se' ORDER BY IDrank ASC LIMIT 10Table 'webshop.rank' doesn't exist |
|
|
|
Sign In /
Join ActiMedia
Add Bookmark
Link to us
