2002–03 Celta de Vigo season

Celta de Vigo participated in La Liga, Copa del Rey and the UEFA Cup in the 2002-03 season, for the first time qualifying for the UEFA Champions League, thanks to a fourth-placed finish in La Liga. This was the crown of the work former coach Víctor Fernández had put in to establish Celta as a credible force, and it was under Miguel Ángel Lotina's leadership the club reached the ultimate level of the "Euro Celta" era.

Celta Vigo
2002–03 season
ManagerMiguel Ángel Lotina
La Liga4th
Copa del Rey2nd Round
UEFA CupRound of 32

Squad

Note: Flags indicate national team as defined under FIFA eligibility rules. Players may hold more than one non-FIFA nationality.

No. Pos. Nation Player
1 GK  ARG Pablo Cavallero
2 DF  ESP Juan Velasco
3 DF  BRA Sylvinho
4 DF  ARG Fernando Cáceres
5 MF  BRA Everton Giovanella
6 DF  ARG Eduardo Berizzo
7 MF  BRA Vágner
8 MF  ESP Ángel
9 FW  EGY Mido (on loan from Ajax)
10 MF  RUS Aleksandr Mostovoi
11 MF  ARG Gustavo López
13 GK  ESP José Manuel Pinto
14 DF  ESP Juanfran
16 MF  ESP José Ignacio
17 DF  ARG Sebastián Méndez
No. Pos. Nation Player
18 DF  ESP Pablo Coira
19 MF  BRA Edu
20 MF  ESP Jesuli
21 DF  ESP Sergio
22 MF  FRA Peter Luccin
24 FW  ESP Catanha
25 FW  RSA Benni McCarthy
26 GK  ESP José Juan
27 DF  ESP Jorge Eugenio Rodríguez
28 MF  ESP Borja Oubiña
29 MF  ESP Jonathan Aspas
30 FW  ESP César Olaiz
31 DF  ESP Iago Bouzón
32 MF  ESP Jacobo Campos
36 DF  ESP Israel

Left club during season

Note: Flags indicate national team as defined under FIFA eligibility rules. Players may hold more than one non-FIFA nationality.

No. Pos. Nation Player
8 MF  ESP Jandro (on loan to Albacete)
9 FW  ECU Iván Kaviedes (on loan to Puebla)
No. Pos. Nation Player
15 MF  BRA Doriva (on loan to Middlesbrough)

Competitions

La Liga

League table

Pos Team Pld W D L GF GA GD Pts Qualification or relegation
2 Real Sociedad 38 22 10 6 71 45 +26 76 Qualification for the Champions League group stage
3 Deportivo La Coruña 38 22 6 10 67 47 +20 72 Qualification for the Champions League third qualifying round
4 Celta Vigo 38 17 10 11 45 36 +9 61
5 Valencia 38 17 9 12 56 35 +21 60 Qualification for the UEFA Cup first round
6 Barcelona 38 15 11 12 63 47 +16 56
Source: LFP
Rules for classification: 1st points; 2nd head-to-head points; 3rd head-to-head goal difference; 4th head-to-head away goals scored; 5th goal difference; 6th number of goals scored; 7th Fair-play points

Matches

1 September 2002 1Sevilla0–1Celta Vigo
21:30 CEST G. López  39'
15 September 2002 2Celta Vigo3–1Mallorca
19:00 CEST Catanha  27'
Jesuli  40, 83'
Niño  78'
22 September 2002 3Recreativo Huelva0–3Celta Vigo
Mostovoi  40, 70'
McCarthy  90'
29 September 2002 4Celta Vigo2–2Málaga
18:00 CEST Catanha  25' (pen.)
Berizzo  38'
Musampa  14'
Cáceres  40' (o.g.)
6 October 2002 5Valencia0–1Celta Vigo
19:00 CEST Vágner  90'
20 October 2002 6Celta Vigo0–1Rayo Vallecano
18:00 CEST Bolo  6'
26 October 2002 7Celta Vigo0–0Atlético Madrid
21:30 CEST
3 November 2002 8Athletic Bilbao2–1Celta Vigo
17:00 CET Etxeberría  80'
Urzaiz  90'
Edu  32'
10 November 2002 9Celta Vigo1–0Espanyol
17:00 CET José Ignacio  17'
17 November 2002 10Real Betis2–1Celta Vigo
20:30 CET Alfonso  71'
Joaquín  88'
José Ignacio  66'
24 November 2002 11Celta Vigo0–0Osasuna
17:00 CET
1 December 2002 12Real Valladolid0–2Celta Vigo
17:00 CET Catanha  10'
Edu  53'
8 December 2002 13Celta Vigo2–1Deportivo Alavés
17:00 CET Karmona  21' (o.g.)
Luccin  26' (pen.)
Ilie  49' (pen.)
15 December 2002 14Racing Santander3–0Celta Vigo
17:00 CET Moratón  59'
Benayoun  60, 73'
21 December 2002 15Celta Vigo3–1Villarreal
20:30 CET Catanha  1'
Edu  7'
Jesuli  63'
Palermo  44'
4 January 2003 16Deportivo3–0Celta Vigo
Tristán  43'
Sergio  48'
Luque  90 + 1'
11 January 2003 17Celta Vigo0–1Real Madrid
21:00 CET Ronaldo  6'
18 January 2003 18Real Sociedad1–0Celta Vigo
20:00 CET de Pedro  65'
26 January 2003 19Celta Vigo2–0Barcelona
20:30 CET Jesuli  47'
Sylvinho  73'
2 February 2003 20Celta Vigo0–1Sevilla
17:00 CET Casquero  78'
9 February 2003 21Mallorca0–2Celta Vigo
17:00 CET Edu  54, 64'
16 February 2003 22Celta Vigo4–1Recreativo Huelva
17:00 CET Edu  38, 56'
Jesuli  63, 70'
Sylvinho  90 + 2' (o.g.)
23 February 2003 23Málaga1–1Celta Vigo
18:00 CET Koke  89' José Ignacio  5'
2 March 2003 24Celta Vigo1–1Valencia
17:00 CET Edu  10' Carew  7'
9 March 2003 25Rayo Vallecano1–0Celta Vigo
17:00 CET de Quintana  86'
16 March 2003 26Atlético Madrid0–1Celta Vigo
17:00 CET Berizzo  87'
23 March 2003 27Celta Vigo2–1Athletic Bilbao
17:00 CET Mido  19'
McCarthy  77'
Del Horno  7'
5 April 2003 28Espanyol0–0Celta Vigo
21:30 CEST
13 April 2003 29Celta Vigo1–0Real Betis
18:00 CEST Mostovoi  44'
20 April 2003 30Osasuna0–2Celta Vigo
18:00 CEST Mido  14, 50'
27 April 2003 31Celta Vigo0–0Real Valladolid
18:00 CEST
4 May 2003 32Deportivo Alavés0–0Celta Vigo
17:30 CEST
11 May 2003 33Celta Vigo2–2Racing Santander
18:00 CEST Juanfran  35'
Edu  84' (pen.)
Javi Guerrero  56' (pen.)
Alonso  90 + 9'
18 May 2003 34Villarreal5–0Celta VigoEstadio El Madrigal
18:00 CEST Guayre  48, 88'
Víctor  53'
J. López  58'
Palermo  61'
Referee: Rodríguez Santiago
24 May 2003 35Celta Vigo3–0Deportivo
20:45 CEST Jesuli  56'
Edu  62, 73'
31 May 2003 36Real Madrid1–1Celta Vigo
21:30 CEST Raúl  68' Mostovoi  35'
15 June 2003 37Celta Vigo3–2Real Sociedad
21:00 CEST Mostovoi  10, 49'
Mido  70'
Nihat  66, 83'
22 June 2003 38Barcelona2–0Celta Vigo
21:00 CEST Sorín  6'
Saviola  50'
gollark: Basically, if I want to run a search it just goes `SELECT * FROM page_tokens WHERE token = 'one token in search query'` or something like that, and it now has a list of pages with the right token, and SQLite can execute this query relatively fast.
gollark: I mean, as far as I can tell there isn't really a faster *and* more storage-efficient way to do search than the inverted-index page_tokens thing.
gollark: ```sqlCREATE TABLE crawl_queue ( id INTEGER PRIMARY KEY, url TEXT NOT NULL UNIQUE, lockTime INTEGER, added INTEGER NOT NULL, referrer TEXT);CREATE TABLE pages ( id INTEGER PRIMARY KEY, url TEXT NOT NULL UNIQUE, rawContent BLOB NOT NULL, rawFormat TEXT NOT NULL, textContent TEXT NOT NULL, updated INTEGER NOT NULL);CREATE TABLE page_tokens ( id INTEGER PRIMARY KEY, page INTEGER NOT NULL REFERENCES pages(id), token TEXT NOT NULL, weight REAL NOT NULL);CREATE TABLE links ( id INTEGER PRIMARY KEY, toURL TEXT NOT NULL, fromURL TEXT NOT NULL, lastSeen INTEGER NOT NULL, UNIQUE (toURL, fromURL))```Here is the database.
gollark: To be fair, the text content field isn't that necessary, as for search it uses the page_tokens table anyway and it can be rebuilt from the HTML if I need it.
gollark: The frequency of every word *must* be stored for quick (O(log n) time or something) search, the raw HTML or at least might be needed if I come up with a better way to weight frequency or something, the links are useful for (future) better search ranking algorithms.
This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.