4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
« Temporada Anterior
Temporada 2003
Temporada Siguiente »
Publicidad 600x120.gif
Liga Puerto Rico 2003
2002/2003

Liga Puerto Rico 2003

Información Histórica 
						
Liga Premier Fútbol de Puerto Rico 2003/04

This is a new, unified league under the jurisdiction of the
Federación Puertorriqueña de Fútbol.    

Participants are not entirely clear but may include:

Gigantes de Carolina (Carolina)
Fénix Soccer Club (Vega Baja)
Monarcas (Manatí)
Atléticos de Levittown (Toa Baja)
Dorados del Plata (Dorado)
Atléticos de Añasco (Añasco)
Atléticos de Río Piedras (Trujillo Alto)
Criollos de Caguas (Caguas) 
Utuado Soccer Club (Utuado) and Taínos de Aguada (Aguada) to merge
  into one club

Round 1 [Dec 14, at Carolina]
Gigantes de Carolina     7-0 Atléticos de Río Piedras 
Atléticos de Añasco      9-0 Atléticos de Levittown 
Fraigcomar               1-1 Fénix SC

Round 2 [Jan 11, at Carolina]
Gigantes de Carolina      -  Atléticos de Añasco 
Atléticos de Levittown    -  Fénix SC

Round 5 [at various venues]
Gigantes de Carolina     1-4 Atléticos de Levittown
Atléticos de Río Piedras 2-1 Fénix de Vega Baja 
Fraigcomar               0-4 Atléticos de Añasco 

Postponed Match [Feb 8, at Fraigcomar]
Fénix SC                 1-5 Atléticos de Añasco 

Round 6 [Feb 15, inferred]
Fénix SC                 4-0 Fraigcomar
Atléticos de Añasco      6-0 Atléticos de Levittown
Atléticos de Río Piedras ppd Gigantes de Carolina 

Table:

 1.Atléticos de Añasco            6  5  1  0 28- 3  16
 2.Gigantes de Carolina           5  3  1  1 13- 5  10
 3.Fraigcomar                     6  2  1  3 11-12   7
 4.Fénix SC                       6  1  3  2 10-17   6  [2 1 3 10-17 7`]
 5.Atléticos de Levittown         6  1  1  4 11-26   4  [3 0 3 11-26 6??]
 6.Atléticos de Río Piedras       5  1  0  4  8-16   3

NB: 2 more goals scored than conceded

Round 7 [Feb 22?]
Gigantes de Carolina     3-1 Deportivo Trujillo Alto (= Río Piedras?)
Fénix SC                 1-1 Atléticos de Levittown


Liga Mayor 2003

Table:

 1.Sporting Carolina          14  12  1  1  60- 8  37
 2.Vaqueros Bayamón           14  11  2  1  39-12  35
 3.Huracanes Caguas           14   7  2  5  26-24  23
 4.San Juan Islanders         14   6  2  6  26-30  20
 5.Lobos Arecibo              14   5  4  5  19-30  19
 6.Brujos Guayama             14   5  1  8  19-29  16
 7.Humacao Tornados           14   1  3 10  13-37   6
 8.Borikén Yabucoa            14   1  1 12  19-51   4

Round 1 [May 25?]
San Juan        2-0     Arecibo
Carolina        3-1     Humacao
Caguas          1-0     Yabucoa
Bayamón         2-1     Guayama

Round 3 [Jun 1]
Bayamon         2-0     Caguas
Arecibo         1-1     Humacao
Yabucoa         1-2     Guayama
Carolina        3-0     San Juan

Round 2
[Jun 4]
San Juan        1-5     Yabucoa
[Jun 5]
Guayama         0-2     Carolina
Arecibo         0-4     Bayamón
Humacao         0-2     Caguas

Round 4
[Jun 7]
San Juan        2-2     Caguas
[Jun 8]
Guayama         3-1     Arecibo
Humacao         2-2     Yabucoa
Bayamón         2-2     Carolina

Round 5
[Jun 13]
Carolina        4-0     Arecibo
Bayamón         4-0     Yabucoa
[Jun 14]
San Juan        3-2     Humacao
Guayama         1-4     Caguas

Round 6
[Jun 21]
Humacao         0-2     Bayamón
Guayama         4-1     San Juan
[Jun 22]
Caguas          0-2     Arecibo
Carolina        8-1     Yabucoa

Round 7
[Jun 27]
Humacao         1-1     Guayama
[Jun 28]
Bayamón         3-1     San Juan
[Jun 29] 
Caguas          0-8     Carolina
Yabucoa         3-6     Arecibo

Round 8
Guayama         0-2     Bayamón 
Yabucoa         2-4     Caguas 
Arecibo         2-2     San Juan 
Humacao         0-5     Carolina 

Round 9
Bayamón         1-1     Arecibo 
Yabucoa         1-6     San Juan 
Caguas          4-0     Humacao 
Carolina        4-0     Guayama 

Round 10
Bayamón         4-1     Caguas 
Carolina        0-1     San Juan 
Humacao         1-3     Arecibo 
Guayama         2-1     Yabucoa 

Round 11
Arecibo         2-1     Guayama
Caguas          3-1     San Juan
Carolina        2-2     Bayamón        [awarded as win to Carolina]
Yabucoa         0-1     Humacao

Round 12
Guayama         1-5     Caguas
Arecibo         0-8     Carolina
Humacao         2-3     San Juan
Yabucoa         2-3     Bayamón

Round 13 [Aug 13]
San Juan        2-1     Guayama
Bayamón         6-1     Humacao
Carolina       10-1     Yabucoa
Arecibo         0-0     Caguas

Round 14
[Aug 16]
Arecibo         1-0     Yabucoa
Carolina        1-0     Caguas
[Aug 17]
Humacao         1-2     Guayama
San Juan        1-2     Bayamón
        
Table:

 1.Sporting Carolina          14  12  1  1  60- 8  37
 2.Vaqueros Bayamón           14  11  2  1  39-12  35
 3.Huracanes Caguas           14   7  2  5  26-24  23
 4.San Juan Islanders         14   6  2  6  26-30  20
 5.Lobos Arecibo              14   5  4  5  19-30  19
 6.Brujos Guayama             14   5  1  8  19-29  16
 7.Humacao Tornados           14   1  3 10  13-37   6
 8.Borikén Yabucoa            14   1  1 12  19-51   4

Playoffs

First Round
NB: Bayamón and Carolina byes to semifinals

First Legs
[Aug 20]
Arecibo         1-2     San Juan
Guayama         1-1     Caguas

Second Legs
[Aug 23]
San Juan        2-1     Arecibo
[Aug 24]
Caguas          1-2     Guayama        [asdet]

Semifinals

First Legs 
[Aug 28]
Guayama         0-0     Bayamón
[Aug 30]
Carolina        6-1     San Juan

Second Legs 
[Aug 30]
Bayamón         3-1     Guayama
[Sep 1]
San Juan        0-6     Carolina

Third Place Match [Sep 7]
San Juan        1-1     Guayama        [5-4 pen]

Final [Sep 7]
Bayamón         1-2     Carolina
  [Sancho 44; Torres 73, Quiles 82] 


Topscorers:
Quiles Francisco     Carolina 7 
Astondoa Carlos      Carolina 6 
Arroyo Luis          Yabucoa  5 
Kaan Hassan          Bayamón  5 
Cabral Miguel        Bayamón  4 
Rivera Alexis        Carolina 4 
Ortiz Raphel         Carolina 4 
Jaza Carretero José  Arecibo  3 
Barajas Camilo       Caguas   3 



Author: Hans Schöggl
(hans.schoeggl@sbg.ac.at)

Last updated: 7 Jun 2005

(C) Copyright Hans Schöggl and RSSSF 2003/05

INFORMACIÓN

La Puerto Rico Soccer League o PRSL es la liga de máximo nivel del fútbol en Puerto Rico, utilizando el sistema de Apertura y Clausura. Es la primera Liga unificada en la historia de la isla, establecida en 2008. Tiene un total de 9 equipos y se espera un equipo de expansión para el 2010. En agosto de 2010 va a comenzar el torneo Apertura, y Clausura en febrero de 2011. La liga es un intento de desarrollar el fútbol en la isla. Se espera que para el 2011 la liga utilice el sistema de ascenso y descenso con la segunda división (Liga Nacional de Fútbol de Puerto Rico).[cita requerida] Varios de los equipos están afiliados con equipos como Sevilla FC de España, River Plate de Argentina, Pachuca de México. El campeón del torneo tiene un pase directo a la Copa de Campeones de la CFU.

  USO DE MEMORIA  
4,271,320 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6560
Total Execution Time  0.6580
  CADENA URL  
/liga_prsl_puerto_rico2003
  GET DATOS  
$_GET['/liga_prsl_puerto_rico2003']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0147  SELECT type FROM routes WHERE alias = 'liga_prsl_puerto_rico2003'
0.0301  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_prsl_puerto_rico' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=218 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 218 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0147  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1131434,1129325,1037852,920732,856358) ORDER BY n.cover_points DESC, update_date DESC
0.0147  SELECT text_es as historical_text FROM leagues_text WHERE id=1060
0.0145  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 29378 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2003' WHERE c.parentId=218 GROUP BY c.id ORDER BY c.order_id ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 01:24:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 01:24:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 01:24:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 01:24:27' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0151  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'liga_prsl_puerto_rico' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2003 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (29378) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29378) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (29378) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29378) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (29378) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0145  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29378) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0146  SELECT e.action, count(e.action) as total, e.player_id FROM events2003 e WHERE e.league_id IN (29378) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0147  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (29378) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN () ORDER BY rp.in_squad = 1 DESC
0.0145  SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29378 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20
0.0144  SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 29378 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20
0.0149  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=29378 AND rel.round=18
0.0146  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29378 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0146  SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 29378 AND esl.points > 0
0.0146  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 29378 ORDER BY creation_date DESC LIMIT 0, 10
0.0149  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-03-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 29378
0.0146  SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2003` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 29378 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 200
0.0144  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2003` e INNER JOIN calendars2003 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 18 AND e.real_date IS NOT NULL AND e.league_id = 29378 ORDER BY total DESC LIMIT 40
0.0147  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2003` e INNER JOIN calendars2003 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 29378 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0147  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 29378 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2003` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 29378 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-04-27 00:00:00' AND c.`shedule` < '2024-05-01 23:59:59' AND l.id = 29378 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0147  SELECT data1, data2 FROM services_tags WHERE categoryId=218
0.0147  SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 218 AND l.year = 2003 ORDER BY l.group_code ASC
0.0147  SELECT group_code, extraName from `leagues` WHERE categoryId=218 AND year=2003