Re:[原创]中国特色广告牌
以下是各球队与广告牌的对应关系:
adboardid teamid teamname
2 1 arsenal
2 2 aston villa
2 3 blackburn rovers
2 4 bolton wanderers
2 5 chelsea
2 7 everton fc
4 8 leeds united
2 9 liverpool
2 10 manchester city
2 11 manchester united
2 12 middlesbrough
2 13 newcastle united
4 14 nottingham forest
4 15 qpr
2 17 southampton
2 18 tottenham hotspur
4 19 west ham united
18 21 fc bayern m黱chen
18 22 borussia dortmund
18 23 borussia m'gladbach
18 25 sc freiburg
18 27 fc hansa rostock
18 28 hamburger sv
18 29 fc kaiserslautern
18 31 fc cologne
18 32 bayer 04 leverkusen
18 33 tsv 1860 m黱chen
18 34 fc schalke 04
18 36 vfb stuttgart
18 38 sv werder bremen
9 39 atalanta
9 44 internazionale
9 45 juventus fc
9 46 ss lazio
9 47 ac milan
9 50 ac parma
10 51 piacenza fc
22 52 as roma
10 54 torino calcio
9 55 udinese calcio
7 57 aj auxerre
7 58 sporting club de bastia
7 59 girondins de bordeaux
7 64 rc lens
7 65 lille osc
7 66 olympique lyonnais
7 68 fc metz
7 69 as monaco
8 70 montpellier
7 71 fc nantes
7 72 ogc nice
7 73 paris saint-germain
7 74 stade rennais fc
7 76 rc strasbourg
3 77 aberdeen f.c.
3 78 celtic
3 80 heart of midlothian
3 81 hibernian
3 82 kilmarnock
3 83 motherwell
3 86 glasgow rangers
2 88 birmingham city
2 89 charlton athletic
4 91 derby county
4 92 grimsby town
4 94 ipswich town
4 95 leicester city
4 97 millwall
4 106 sunderland afc
2 109 west bromwich albion
4 121 crewe alexandra
4 127 shrewsbury
4 139 chester
4 142 doncaster
2 144 fulham
4 149 lincoln
18 159 arminia bielefeld
18 160 vfl bochum
18 162 fc energie cottbus
18 165 spvgg greuther f黵th
18 166 hertha bsc berlin
18 169 fsv mainz 05
18 171 fc n黵nberg
18 172 spvgg unterhaching
18 175 vfl wolfsburg
3 180 dundee
3 181 dundee united
3 182 dunfermline athletic f.c.
9 189 bologna fc
9 190 brescia calcio
16 191 sv salzburg
9 192 ac chievo verona
10 200 pescara
9 203 reggina calcio
10 205 ac venezia
10 206 hellas verona
16 209 sturm graz
7 210 sm caen
8 212 ch鈚eauroux
8 217 fc lorient
7 219 olympique marseille
7 226 fc sochaux
11 229 rsc anderlecht
11 231 club brugge
11 232 standard club de li鑗e
1 234 benfica
1 236 fc porto
1 237 sporting lisbon
11 239 lierse sk
5 240 atl閠ico de madrid s.a.d.
5 241 f鷗bol club barcelona
5 242 deportivo de la coru馻
5 243 real madrid
5 244 real zaragoza
14 245 ajax
14 246 feyenoord
14 247 psv
16 254 sk rapid wien
16 255 vfb herold admira
16 256 fk austria magna
6 260 c.d. tenerife sad
19 267 ac sparta praha
12 269 br鴑dby if
12 270 silkeborg if
12 271 aarhus gf
12 272 odense bk
20 280 olympiakos
8 294 es troyes ac
13 298 rosenborg bk
13 299 lillestr鴐 sk
13 300 viking fk stavanger
15 319 ifk g鰐eborg
15 320 malm?ff
15 321 halmstads bk
17 322 grasshoppers z黵ich
17 324 servette fc
20 325 galatasaray sk
19 330 olomouc
4 346 yeovil
9 347 u.s. lecce
8 378 stade brestois 29
8 379 stade reims
1 383 palmeiras
20 393 paok
13 417 molde fk
13 418 troms?il
15 432 helsingborgs if
15 433 aik solna
17 435 neuch鈚el xamax
5 448 athletic club de bilbao
5 449 real betis
5 450 rc celta de vigo
5 452 espanyol
5 453 mallorca
5 456 racing club de santander
5 457 real sociedad
6 459 sporting gijon
5 461 valencia
5 462 real valladolid
6 463 deportivo alav閟
6 467 s.d. eibar sad
6 468 elche cf sad
6 475 u.e. lleida
6 477 numancia
5 479 club atl閠ico osasuna
5 481 sevilla
5 483 villareal
18 485 hannover 96
18 503 dynamo dresden
11 504 louvi閞oise
18 506 fc erzgebirge aue
1 517 botafogo
18 523 fc saarbrucken
18 540 sv wacker burghausen
1 567 fluminense
1 568 cruzeiro
1 569 vasco da gama
10 570 ternana
6 571 rc recreativo de huelva
5 573 m醠aga
1 598 s鉶 paulo
8 613 cs sedan-ardennes
7 614 ac ajaccio
3 620 inverness ct
3 621 livingston
14 635 de graafschap
14 650 ado den haag
1 665 v. set鷅al
11 669 ksk beveren
11 670 royal charleroi sporting club
11 672 excelsior mouscron
11 673 krc genk
11 674 kaa gent
11 675 germinal beerschot
11 680 sint-truidense vv
11 681 kvc westerlo
23 687 columbus crew
23 688 d.c. united
23 689 ny/nj metrostars
23 691 new england revolution
23 693 chicago fire
23 694 colorado rapids
23 695 dallas burn
23 696 kansas city wizards
23 697 los angeles galaxy
23 698 san jose earthquakes
15 700 if elfsborg
15 703 trelleborgs ff
15 705 謗ebro sk
15 706 謗gryte is
15 708 hammarby if
15 710 djurg錼dens if
20 734 panalikaos
1 744 rio ave
12 819 fc k鴅enhavn
12 820 aalborg bk
12 826 herf鴏ge bk
17 894 fc z黵ich
17 896 fc basel 1893
17 898 fc st.gallen
17 900 bsc young boys
13 917 stab鎘 if b鎟um
13 918 fk bod?glimt
13 919 sk brann bergen
13 920 valerenga if
1 980 daejeon citizen
1 981 seongnam
1 982 fc seoul
1 983 suwon
24 1028 monarcas morelia
24 1032 monterrey
1 1035 atl閠ico mineiro
1 1039 atl閠ico paranaense
1 1041 corinthians
1 1043 flamengo
1 1048 internacional
1 1053 santos
16 1266 sw bregenz
1 1318 england
1 1322 austria
1 1325 belgium
1 1327 bulgaria
1 1328 croatia
1 1330 czech republic
1 1331 denmark
1 1334 finland
1 1335 france
1 1337 germany
1 1338 greece
1 1343 italy
1 1352 norway
1 1353 poland
1 1354 portugal
1 1355 ireland
1 1356 romania
1 1357 russia
1 1359 scotland
1 1361 slovenia
1 1362 spain
1 1363 sweden
1 1364 switzerland
1 1365 turkey
1 1367 wales
1 1369 argentina
1 1370 brazil
1 1375 paraguay
1 1377 uruguay
1 1383 costa rica
1 1386 mexico
1 1387 united states
1 1391 tunisia
1 1393 nigeria
1 1395 cameroon
1 1413 china pr
1 1415 australia
15 1439 kalmar ff
15 1440 landskrona bois
12 1443 viborg ff
12 1445 esbjerg fb
13 1456 odd grenland skien
13 1464 fc lyn oslo
13 1465 sogndal il
1 1473 ulsan hyundai horangi
1 1474 pohang steelers
1 1475 chunnam dragons
1 1476 busan icons
1 1477 chonbuk motors
1 1478 bucheon sk
12 1516 fc midtjylland
8 1530 sco angers
4 1587 kidderminster
15 1596 gif sundsvall
1 1598 bahia
1 1629 gr阭io
17 1715 fc thun
1 1719 vit髍ia
8 1738 le havre ac
8 1739 le mans uc 72
6 1742 xerez c.d.
10 1744 modena
10 1746 empoli
11 1747 raec mons
11 1750 ksv cercle brugge
13 1756 hamarkameratene
16 1785 sv mattersburg
12 1786 randers fc
16 1787 sv pasching
12 1788 fc nordsj鎙land
1 1789 s鉶 caetano
2 1790 portsmouth
2 1792 norwich
4 1793 reading
4 1794 sheffield unitedd
4 1795 watford
4 1796 burnley
4 1797 rotherham
4 1798 milton keynes
2 1799 crystal palace
4 1800 coventry city
4 1801 preston
4 1802 gillingham
4 1803 bradford city
4 1803 walsall
8 1805 grenoble foot 38
4 1806 stoke city
4 1807 sheffield w.
4 1808 brighton
7 1809 toulouse fc
8 1812 cr閠eil
8 1813 chamois niortais fc
8 1813 niort
8 1814 stade lavallois mfc
8 1815 clermont foot
8 1816 amiens scf
7 1819 as saint-ettienne
7 1820 istres
8 1822 fc gueugnon
8 1823 as nancy-lorraine
18 1825 msv duisburg
18 1826 alemannia aachen
18 1827 eintracht trier
18 1828 rot-wei?oberhausen
18 1832 karlsruher sc
18 1834 lr ahlen
9 1837 u.c. sampdoria
9 1838 ac siena
10 1839 triestina
9 1842 cagliari calcio
9 1844 as livorno
9 1845 messina
10 1846 ascoli
10 1847 vicenza calcio
10 1848 as bari
6 1853 levante
5 1854 albacete
6 1856 u.d. salamanca s.a.d.
6 1857 c.p. ejido s.a.d.
6 1858 terrassa cf s.a.d.
6 1860 getafe
6 1861 u.d. almer韆 sad
6 1867 c髍doba cf
20 1871 legia warszawa
20 1873 wisla krakow
20 1876 river plate
20 1877 boca juniors
24 1878 cruz azul
24 1879 am閞ica
24 1880 guadalajara
24 1881 u.n.a.m.
24 1882 toluca
20 1884 panathinaikos
21 1886 hungary
1 1887 vit髍ia sc
1 1888 gil vicente
1 1889 belenenses
1 1891 nacional
1 1893 mar韙imo
1 1895 uni鉶 leiria
1 1896 braga
1 1897 sc beira-mar
1 1898 boavista
1 1900 moreirense
1 1901 associa玢o acad閙ica de coimbra
14 1902 roda jc
14 1903 fc utrecht
14 1904 nac breda
14 1905 rkc waalwijk
14 1906 az
14 1907 willem ii
14 1908 fc twente
14 1909 vitesse
14 1910 nec
14 1911 rbc roosendaal
14 1913 sc heerenveen
14 1915 fc groningen
4 1917 wigan
4 1919 bristol city
4 1920 oldham
4 1923 luton
4 1924 chesterfield
4 1925 brentford
4 1926 blackpool
4 1928 port vale
4 1929 plymouth
4 1930 northampton
4 1931 stockport
4 1932 barnsley
4 1933 wycombe
4
