Connection to sql... 818 us

SELECT old,new FROM redirect WHERE old = 'historico'
1 387 us config/routes_file.php

TOTAL TIME 3.2 ms QUERIES 2 FILE config/routes_file.php

SELECT dt.*,cou.Name as Name,cou.Continent as Continent,cou.Region,dp.latitude,dp.longitude,dp.name as geo_location, ds.header_color as color1 FROM datateams AS dt LEFT JOIN country AS cou ON LOWER(cou.Code2) = dt.CountryCode LEFT JOIN dataplaces dp on dp.geonameid=dt.geonameid LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE dt.basealias='hercules' LIMIT 1
2 2.9 ms controllers/home.php

SELECT dp.id, dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1311 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
3 423 us controllers/home.php

SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=1311 AND role_id=2 ORDER BY rp.date_ini DESC LIMIT 1
4 311 us controllers/home.php

SELECT rs.teamId, ds.id AS stadiumId, ds.name, ds.seats, ds.yearBuilt, ds.typefield, ds.city, ds.address, ds.size, ds.fans, ds.phone, ds.fax FROM rel_stadiums AS rs INNER JOIN datastadiums AS ds ON ds.id = rs.stadium_id WHERE rs.teamId = 1311 AND active = 1
5 1.6 ms controllers/home.php

SELECT c.troncal, t.conference, c.id AS category_id, t.id as team_id,t.league_id,c.name as cat_name, c.name_english as cat_name_en,l.year,l.tables,l.current_round,l.group_code,l.total_group,c.active_year,c.alias, l.table_suffix, c.logo as league_logo FROM teams AS t INNER JOIN leagues_besoccer l ON l.id = t.league_id INNER JOIN categories_besoccer c ON c.id = l.categoryId WHERE t.teamId = 1311 AND c.ctype != 12 ORDER BY c.troncal DESC, l.year DESC, l.end_prev ASC, c.parentId ASC, c.coefficient DESC, l.group_code = 0 ASC, l.group_code ASC LIMIT 2
6 2.4 ms controllers/home.php

SELECT ct.id FROM categories_besoccer AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=1311 AND ct.ctype!=12 AND ct.status=1 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC
7 1.5 ms controllers/home.php

SELECT ct.id, ct.alias, ct.name AS name, ct.logo, ct.CountryCode, ct.active_year, ct.location, ct.continent, ct.competition_type, ct.troncal, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_teams, l.current_round, l.total_rounds, l.total_group, l.group_code, l.legend, l.legendExtra, l.playoff, l.end_prev, l.end_date, t.id as team_id, t.name as team_name FROM categories_besoccer AS ct INNER JOIN leagues_besoccer AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams t on t.teamId=1311 and l.id=t.league_id WHERE ct.id IN (2468,129,1919) ORDER BY ct.coefficient DESC, ct.id ASC, l.group_code ASC
8 1.2 ms controllers/home.php

SELECT dt.nameShow,(cast(tab.gf as signed) - cast(tab.ga as signed) + 100) as diff,tab.*,t.teamId FROM teams AS t INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN tables2025 as tab ON tab.league_id = t.league_id AND tab.team = t.id INNER JOIN datateams dt ON dt.id = t.teamId WHERE c.troncal = 1 AND t.league_id = 76667 AND tab.round = 27 ORDER BY tab.points DESC, diff DESC, tab.ga DESC, dt.nameShow ASC
9 834 us controllers/home.php

SELECT dp.id, dp.birthplace, dp.nick,dp.name,dp.last_name,dp.alias,dp.birthdate,dp.height,dp.weight,dp.foot,dp.side, dp.role, 2025 AS year, rp.squadNumber,'' as num,'' as pos,'' as idplayer,'' as goals,'' as reds,'' as yellows,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode, '' as gender FROM futbol.rel_players as rp INNER JOIN futbol.dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.year=2025 and rp.team_id=6648404 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC
10 1.1 ms controllers/home.php

SELECT total FROM bs_rel_resume_items WHERE itemId=1311 AND type_rel=2 AND ln='es'
11 301 us controllers/home.php

SELECT rb.id FROM rel_budgets AS rb WHERE (rb.official_budget = 1 or rb.official_budget = 2 or rb.official_budget = 0) AND (rb.origin_team_id IN (1311) OR rb.destination_team_id IN (1311)) AND rb.year = 2025 AND rb.active = 1 LIMIT 1
12 1.3 ms controllers/home.php

SELECT ip.id as id, ip.datateamId, site_name as club,ip.json_data FROM club_projects.club_teams ct INNER JOIN club_projects.info_projects ip ON ip.id = ct.project_id WHERE ct.rel_datateamId=1311 LIMIT 1
13 274 us controllers/home.php

SELECT dt.nameShow FROM datateams AS dt WHERE dt.id=1311 LIMIT 1
14 242 us controllers/home.php

SELECT cat.alias, cat.location as cc, cat.logo, cat.name AS category_name, dtm.year, dtm.categoryId,(SUM(dtm.lineup) DIV 11) AS apps, SUM(dtm.goals) AS goals, SUM(dtm.assists) AS assists, SUM(dtm.yellow_cards) AS yellow_cards, SUM(dtm.expulsions) AS expulsions, dtm.league_id, dtm.teamId, cat.troncal,lea.group_code, lea.id as league_id FROM detail_team_match AS dtm INNER JOIN categories_besoccer AS cat ON dtm.categoryId = cat.id LEFT JOIN leagues lea ON lea.id=dtm.league_id WHERE teamId = 1311 AND cat.official = 1 GROUP BY dtm.year, dtm.categoryId ORDER BY dtm.year DESC, dtm.categoryId ASC
15 64.7 ms controllers/home.php

SELECT player_id FROM rel_players rp WHERE rp.category_id=2468 and rp.year=2025 AND rp.in_squad=1 AND teamId=1311
16 1.7 ms controllers/home.php

SELECT id FROM leagues WHERE categoryId=2468 AND `year`=2025 ORDER BY id ASC
17 495 us controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick,dt.id as teamId, dt.nameShow as teamName,dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND (e.action IN (1,2,11,12,13,26)) AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
18 1.6 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (341680,618036,172184,845182,879169,243325,137750,879223,115542,831953,309941,339367,187160,863684,339373,993280,824884,837197,904449,130054,3452410,3184363,3228619,3197019,871435,3638202) GROUP BY d.playerId
19 11.8 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=3 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
20 2.4 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (187160) GROUP BY d.playerId
21 811 us controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=4 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
22 1.9 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (130054) GROUP BY d.playerId
23 2.8 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=5 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
24 2 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (618036,879223,187160,309941,115542,339373,339367,137750,879169,831953,341680,130054,993280,871435,863684,845182,243325,837197,824884,172184) GROUP BY d.playerId
25 9.4 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=22 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
26 10.8 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (187160,863684,845182,879169,837197,309941,201659,115542) GROUP BY d.playerId
27 4 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=2 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
28 4.1 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (339373,863684,339367) GROUP BY d.playerId
29 1.6 ms controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=15 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
30 1.1 ms controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (863684) GROUP BY d.playerId
31 832 us controllers/home.php

SELECT count(*) as total, dp.CountryCode as countryCode, dp.id as player_id, dp.nick, dt.id as teamId, dt.nameShow as teamName, dt.basealias,dt.id as team_id,dp.role,rp.squadNumber FROM events2025 e INNER JOIN dataplayers dp on dp.id= e.player_id INNER JOIN datateams dt on dt.id=e.teamId INNER JOIN rel_players rp ON rp.category_id=2468 and rp.year=2025 and rp.player_id=dp.id WHERE e.league_id in (76666,76667) AND e.action<31 AND e.action=16 AND dt.id=1311 GROUP BY e.player_id ORDER BY total DESC, e.player_id DESC LIMIT 50
32 745 us controllers/home.php

SELECT dp.id as player_id, SUM(d.minutes) as minutes, sum(d.lineup) as lineup, sum(d.reserved) as reserved, sum(d.in) as inside, sum(d.out) as outside FROM futbol.detail_player_match d INNER JOIN datateams dt on dt.id=d.teamId INNER JOIN dataplayers dp on dp.id=d.playerId WHERE d.categoryId = 2468 and d.year=2025 AND dp.id in (243325) GROUP BY d.playerId
33 5.2 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2468 or sonId=2468 LIMIT 1
34 308 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2468 AND l.year=2025 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
35 386 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2025 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 76667 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
36 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2025 WHERE league_id=76667 AND round=26 ORDER BY team ASC;
37 286 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
38 365 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
39 290 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2469 or sonId=2469 LIMIT 1
40 205 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2469 AND l.year=2024 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
41 378 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2024 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 72364 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
42 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2024 WHERE league_id=72364 AND round=33 ORDER BY team ASC;
43 357 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 72364 LIMIT 1
44 10.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
45 292 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
46 387 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
47 347 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2469 or sonId=2469 LIMIT 1
48 257 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2469 AND l.year=2023 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
49 392 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2023 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 67967 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
50 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2023 WHERE league_id=67967 AND round=33 ORDER BY team ASC;
51 316 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 67967 LIMIT 1
52 12.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
53 350 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
54 279 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
55 259 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2469 or sonId=2469 LIMIT 1
56 209 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2469 AND l.year=2022 AND l.group_code>=1 AND l.group_code = 5 ORDER BY l.group_code ASC
57 405 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2022 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 62384 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
58 1.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2022 WHERE league_id=62384 AND round=33 ORDER BY team ASC;
59 265 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 62384 LIMIT 1
60 9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
61 332 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
62 200 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
63 198 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
64 275 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2021 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
65 410 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2021 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 58610 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
66 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2021 WHERE league_id=58610 AND round=21 ORDER BY team ASC;
67 227 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 58610 LIMIT 1
68 6.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='674bb194410ce60f317f3d5dd1db4305'
69 251 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
70 208 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
71 151 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2020 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
72 257 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2020 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 50267 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
73 744 us controllers/home.php

SELECT team, position, round FROM futbol.tables2020 WHERE league_id=50267 AND round=27 ORDER BY team ASC;
74 182 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 50267 LIMIT 1
75 5.9 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
76 156 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2019 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
77 283 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2019 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 44097 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
78 729 us controllers/home.php

SELECT team, position, round FROM futbol.tables2019 WHERE league_id=44097 AND round=37 ORDER BY team ASC;
79 205 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 44097 LIMIT 1
80 6.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
81 263 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
82 230 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
83 200 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2018 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
84 316 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2018 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 38808 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
85 870 us controllers/home.php

SELECT team, position, round FROM futbol.tables2018 WHERE league_id=38808 AND round=37 ORDER BY team ASC;
86 243 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 38808 LIMIT 1
87 6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
88 174 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
89 150 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
90 158 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2017 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
91 245 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2017 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 33380 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
92 904 us controllers/home.php

SELECT team, position, round FROM futbol.tables2017 WHERE league_id=33380 AND round=37 ORDER BY team ASC;
93 211 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 33380 LIMIT 1
94 5.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
95 230 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
96 209 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
97 153 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2016 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
98 237 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2016 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 15377 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
99 988 us controllers/home.php

SELECT team, position, round FROM futbol.tables2016 WHERE league_id=15377 AND round=37 ORDER BY team ASC;
100 297 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 15377 LIMIT 1
101 6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
102 174 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
103 151 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
104 118 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2015 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
105 244 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2015 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 3864 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
106 890 us controllers/home.php

SELECT team, position, round FROM futbol.tables2015 WHERE league_id=3864 AND round=37 ORDER BY team ASC;
107 258 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 3864 LIMIT 1
108 5.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
109 207 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
110 197 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
111 185 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2014 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
112 232 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2014 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 2434 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
113 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2014 WHERE league_id=2434 AND round=41 ORDER BY team ASC;
114 257 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 2434 LIMIT 1
115 5.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
116 217 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
117 154 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
118 121 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2013 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
119 231 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2013 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 1901 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
120 977 us controllers/home.php

SELECT team, position, round FROM futbol.tables2013 WHERE league_id=1901 AND round=41 ORDER BY team ASC;
121 244 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 1901 LIMIT 1
122 6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
123 242 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
124 222 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
125 190 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2012 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
126 276 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2012 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 1335 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
127 932 us controllers/home.php

SELECT team, position, round FROM futbol.tables2012 WHERE league_id=1335 AND round=41 ORDER BY team ASC;
128 243 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 1335 LIMIT 1
129 8.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
130 280 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
131 190 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
132 134 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=2011 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
133 244 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2011 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 1099 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
134 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2011 WHERE league_id=1099 AND round=37 ORDER BY team ASC;
135 325 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 1099 LIMIT 1
136 9.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='b65ade46a8682033da0b91234c86a4d5'
137 349 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6b03dfdcdc2d4f6856e7acfd478c0259'
138 339 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='170b8f5bbfb20f2860eb660058c9f7c9'
139 457 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='78dbb5b38c755771d22c79435fdbb2f8'
140 436 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
141 468 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
142 182 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2010 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
143 327 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2010 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 812 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
144 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2010 WHERE league_id=812 AND round=41 ORDER BY team ASC;
145 395 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 812 LIMIT 1
146 13.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
147 354 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
148 313 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
149 185 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2009 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
150 269 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2009 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 105 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
151 1.6 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2009 WHERE league_id=105 AND round=41 ORDER BY team ASC;
152 382 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 105 LIMIT 1
153 16.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
154 377 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
155 338 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
156 247 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2008 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
157 381 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2008 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 3 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
158 1.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2008 WHERE league_id=3 AND round=41 ORDER BY team ASC;
159 377 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 3 LIMIT 1
160 9.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
161 316 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
162 279 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
163 246 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2007 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
164 401 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2007 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 81 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
165 1.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2007 WHERE league_id=81 AND round=41 ORDER BY team ASC;
166 406 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 81 LIMIT 1
167 10.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
168 355 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
169 346 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
170 299 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=2006 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
171 311 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2006 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 534 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
172 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2006 WHERE league_id=534 AND round=41 ORDER BY team ASC;
173 396 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 534 LIMIT 1
174 7.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
175 341 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
176 265 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
177 163 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2005 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
178 316 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2005 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 174 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
179 1.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2005 WHERE league_id=174 AND round=37 ORDER BY team ASC;
180 349 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 174 LIMIT 1
181 8.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
182 254 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
183 278 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
184 239 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2004 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
185 355 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2004 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 178 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
186 979 us controllers/home.php

SELECT team, position, round FROM futbol.tables2004 WHERE league_id=178 AND round=37 ORDER BY team ASC;
187 296 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 178 LIMIT 1
188 12.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
189 311 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
190 184 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
191 118 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2003 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
192 202 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2003 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5515 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
193 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2003 WHERE league_id=5515 AND round=37 ORDER BY team ASC;
194 305 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5515 LIMIT 1
195 10.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
196 208 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
197 258 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
198 124 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2002 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
199 227 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2002 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5514 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
200 1.5 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2002 WHERE league_id=5514 AND round=37 ORDER BY team ASC;
201 442 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5514 LIMIT 1
202 10.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
203 193 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
204 167 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
205 159 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2001 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
206 375 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2001 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5513 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
207 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables2001 WHERE league_id=5513 AND round=37 ORDER BY team ASC;
208 277 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5513 LIMIT 1
209 9.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
210 295 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
211 202 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
212 165 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=2000 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
213 222 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2000 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5512 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
214 919 us controllers/home.php

SELECT team, position, round FROM futbol.tables2000 WHERE league_id=5512 AND round=37 ORDER BY team ASC;
215 309 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5512 LIMIT 1
216 9.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
217 188 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
218 161 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
219 118 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1999 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
220 243 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1999 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 577 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
221 794 us controllers/home.php

SELECT team, position, round FROM futbol.tables1999 WHERE league_id=577 AND round=41 ORDER BY team ASC;
222 227 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 577 LIMIT 1
223 7.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
224 263 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
225 157 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
226 118 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1998 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
227 222 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1998 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5494 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
228 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1998 WHERE league_id=5494 AND round=41 ORDER BY team ASC;
229 244 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5494 LIMIT 1
230 10 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
231 252 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
232 167 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
233 112 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1997 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
234 200 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1997 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 163 AND t.round = 42 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
235 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1997 WHERE league_id=163 AND round=41 ORDER BY team ASC;
236 232 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 163 LIMIT 1
237 7.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='b65ade46a8682033da0b91234c86a4d5'
238 179 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6b03dfdcdc2d4f6856e7acfd478c0259'
239 169 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
240 212 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
241 171 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
242 165 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
243 146 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
244 119 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1996 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
245 219 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1996 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5492 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
246 911 us controllers/home.php

SELECT team, position, round FROM futbol.tables1996 WHERE league_id=5492 AND round=37 ORDER BY team ASC;
247 232 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5492 LIMIT 1
248 7.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
249 189 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
250 160 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
251 118 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1995 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
252 211 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1995 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5491 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
253 973 us controllers/home.php

SELECT team, position, round FROM futbol.tables1995 WHERE league_id=5491 AND round=37 ORDER BY team ASC;
254 249 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5491 LIMIT 1
255 7.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
256 173 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
257 152 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
258 122 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1994 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
259 206 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1994 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5490 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
260 902 us controllers/home.php

SELECT team, position, round FROM futbol.tables1994 WHERE league_id=5490 AND round=37 ORDER BY team ASC;
261 220 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5490 LIMIT 1
262 7.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
263 182 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
264 150 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
265 122 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=1993 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
266 189 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1993 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 22254 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
267 874 us controllers/home.php

SELECT team, position, round FROM futbol.tables1993 WHERE league_id=22254 AND round=37 ORDER BY team ASC;
268 243 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 22254 LIMIT 1
269 7.3 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
270 119 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=1992 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
271 219 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1992 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 22251 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
272 1.6 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1992 WHERE league_id=22251 AND round=37 ORDER BY team ASC;
273 280 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 22251 LIMIT 1
274 13.7 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
275 122 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=1991 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
276 437 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1991 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 22249 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
277 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1991 WHERE league_id=22249 AND round=37 ORDER BY team ASC;
278 447 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 22249 LIMIT 1
279 22.3 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
280 184 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=1990 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
281 316 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1990 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 22246 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
282 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1990 WHERE league_id=22246 AND round=37 ORDER BY team ASC;
283 233 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 22246 LIMIT 1
284 16.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=3 or sonId=3 LIMIT 1
285 201 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 3 AND l.year=1989 AND l.group_code>=1 AND l.group_code = 4 ORDER BY l.group_code ASC
286 371 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1989 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 22243 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
287 1.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1989 WHERE league_id=22243 AND round=37 ORDER BY team ASC;
288 217 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 22243 LIMIT 1
289 10.4 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
290 271 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1988 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
291 425 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1988 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5484 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
292 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1988 WHERE league_id=5484 AND round=37 ORDER BY team ASC;
293 431 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5484 LIMIT 1
294 11.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
295 382 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
296 317 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
297 258 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1987 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
298 390 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1987 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5483 AND t.round = 44 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
299 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1987 WHERE league_id=5483 AND round=43 ORDER BY team ASC;
300 360 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5483 LIMIT 1
301 10.9 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
302 267 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1986 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
303 269 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1986 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5411 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
304 982 us controllers/home.php

SELECT team, position, round FROM futbol.tables1986 WHERE league_id=5411 AND round=33 ORDER BY team ASC;
305 296 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5411 LIMIT 1
306 7.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
307 303 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
308 287 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
309 389 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
310 301 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
311 148 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1985 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
312 266 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1985 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5410 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
313 841 us controllers/home.php

SELECT team, position, round FROM futbol.tables1985 WHERE league_id=5410 AND round=33 ORDER BY team ASC;
314 345 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5410 LIMIT 1
315 8.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
316 337 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
317 313 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
318 206 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
319 396 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
320 293 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1984 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
321 416 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1984 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5480 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
322 1.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1984 WHERE league_id=5480 AND round=37 ORDER BY team ASC;
323 374 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5480 LIMIT 1
324 7.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
325 327 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
326 193 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
327 141 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1983 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
328 381 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1983 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5479 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
329 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1983 WHERE league_id=5479 AND round=37 ORDER BY team ASC;
330 405 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5479 LIMIT 1
331 11 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
332 351 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
333 229 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
334 270 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1982 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
335 403 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1982 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5407 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
336 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1982 WHERE league_id=5407 AND round=33 ORDER BY team ASC;
337 357 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5407 LIMIT 1
338 8.9 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
339 329 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
340 309 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
341 302 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
342 379 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
343 306 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1981 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
344 407 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1981 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5406 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
345 995 us controllers/home.php

SELECT team, position, round FROM futbol.tables1981 WHERE league_id=5406 AND round=33 ORDER BY team ASC;
346 373 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5406 LIMIT 1
347 7.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
348 334 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
349 302 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
350 341 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
351 343 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
352 221 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1980 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
353 297 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1980 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5405 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
354 954 us controllers/home.php

SELECT team, position, round FROM futbol.tables1980 WHERE league_id=5405 AND round=33 ORDER BY team ASC;
355 395 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5405 LIMIT 1
356 10.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
357 303 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
358 296 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
359 224 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
360 236 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
361 183 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1979 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
362 284 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1979 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5404 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
363 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1979 WHERE league_id=5404 AND round=33 ORDER BY team ASC;
364 369 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5404 LIMIT 1
365 11.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
366 475 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
367 592 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
368 277 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
369 459 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
370 266 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1978 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
371 469 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1978 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5403 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
372 2.3 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1978 WHERE league_id=5403 AND round=33 ORDER BY team ASC;
373 361 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5403 LIMIT 1
374 13.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
375 355 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
376 332 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
377 376 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
378 615 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
379 164 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1977 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
380 274 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1977 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5402 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
381 1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1977 WHERE league_id=5402 AND round=33 ORDER BY team ASC;
382 245 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5402 LIMIT 1
383 9.7 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
384 317 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
385 304 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
386 294 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
387 319 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
388 208 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1976 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
389 398 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1976 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5401 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
390 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1976 WHERE league_id=5401 AND round=33 ORDER BY team ASC;
391 348 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5401 LIMIT 1
392 8.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
393 332 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
394 221 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
395 188 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
396 232 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
397 197 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1975 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
398 339 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1975 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5400 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
399 820 us controllers/home.php

SELECT team, position, round FROM futbol.tables1975 WHERE league_id=5400 AND round=33 ORDER BY team ASC;
400 182 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5400 LIMIT 1
401 8.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
402 317 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
403 322 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='2c764899a2d9574fab1e8fb5d9277e8d'
404 320 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
405 343 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
406 227 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1974 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
407 357 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1974 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5470 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
408 925 us controllers/home.php

SELECT team, position, round FROM futbol.tables1974 WHERE league_id=5470 AND round=37 ORDER BY team ASC;
409 385 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5470 LIMIT 1
410 17.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
411 338 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
412 485 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
413 318 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
414 221 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1973 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
415 267 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1973 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5469 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
416 1.4 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1973 WHERE league_id=5469 AND round=37 ORDER BY team ASC;
417 450 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5469 LIMIT 1
418 11.3 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
419 504 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
420 302 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
421 309 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
422 162 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1972 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
423 401 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1972 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5468 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
424 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1972 WHERE league_id=5468 AND round=37 ORDER BY team ASC;
425 347 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5468 LIMIT 1
426 12.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
427 203 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
428 172 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
429 156 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
430 150 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1971 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
431 335 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1971 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5467 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
432 927 us controllers/home.php

SELECT team, position, round FROM futbol.tables1971 WHERE league_id=5467 AND round=37 ORDER BY team ASC;
433 215 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5467 LIMIT 1
434 8.1 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
435 221 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
436 171 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
437 262 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
438 151 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1968 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
439 260 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1968 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11738 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
440 981 us controllers/home.php

SELECT team, position, round FROM futbol.tables1968 WHERE league_id=11738 AND round=29 ORDER BY team ASC;
441 184 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11738 LIMIT 1
442 6 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
443 270 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1967 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
444 241 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1967 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5392 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
445 984 us controllers/home.php

SELECT team, position, round FROM futbol.tables1967 WHERE league_id=5392 AND round=29 ORDER BY team ASC;
446 235 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5392 LIMIT 1
447 6.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
448 315 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='0e0561b6393cfdcc32a5940652461ce1'
449 332 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='c305ee7efe7900212b40bfaab63fae6d'
450 299 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='731f3222d5f00c116376fec2d09c3339'
451 382 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
452 243 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
453 305 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1966 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
454 435 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1966 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11734 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
455 791 us controllers/home.php

SELECT team, position, round FROM futbol.tables1966 WHERE league_id=11734 AND round=29 ORDER BY team ASC;
456 264 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11734 LIMIT 1
457 5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
458 362 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1965 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
459 425 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1965 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11720 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
460 1.2 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1965 WHERE league_id=11720 AND round=29 ORDER BY team ASC;
461 285 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11720 LIMIT 1
462 6.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
463 155 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1964 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
464 252 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1964 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11718 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
465 652 us controllers/home.php

SELECT team, position, round FROM futbol.tables1964 WHERE league_id=11718 AND round=29 ORDER BY team ASC;
466 203 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11718 LIMIT 1
467 5.7 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
468 241 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1963 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
469 352 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1963 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11713 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
470 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1963 WHERE league_id=11713 AND round=29 ORDER BY team ASC;
471 309 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11713 LIMIT 1
472 7.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
473 321 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1962 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
474 379 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1962 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11708 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
475 905 us controllers/home.php

SELECT team, position, round FROM futbol.tables1962 WHERE league_id=11708 AND round=29 ORDER BY team ASC;
476 337 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11708 LIMIT 1
477 6.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
478 255 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1961 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
479 340 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1961 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11706 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
480 752 us controllers/home.php

SELECT team, position, round FROM futbol.tables1961 WHERE league_id=11706 AND round=29 ORDER BY team ASC;
481 329 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11706 LIMIT 1
482 5.4 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
483 186 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1959 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
484 282 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1959 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 11702 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
485 802 us controllers/home.php

SELECT team, position, round FROM futbol.tables1959 WHERE league_id=11702 AND round=29 ORDER BY team ASC;
486 324 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 11702 LIMIT 1
487 5.2 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
488 284 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1958 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
489 292 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1958 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21446 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
490 748 us controllers/home.php

SELECT team, position, round FROM futbol.tables1958 WHERE league_id=21446 AND round=33 ORDER BY team ASC;
491 245 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21446 LIMIT 1
492 5.1 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
493 294 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1957 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
494 381 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1957 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21445 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
495 869 us controllers/home.php

SELECT team, position, round FROM futbol.tables1957 WHERE league_id=21445 AND round=37 ORDER BY team ASC;
496 368 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21445 LIMIT 1
497 5.3 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
498 169 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1956 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
499 245 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1956 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5381 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
500 690 us controllers/home.php

SELECT team, position, round FROM futbol.tables1956 WHERE league_id=5381 AND round=29 ORDER BY team ASC;
501 201 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5381 LIMIT 1
502 5.2 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
503 340 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
504 310 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
505 261 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1955 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
506 399 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1955 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5380 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
507 780 us controllers/home.php

SELECT team, position, round FROM futbol.tables1955 WHERE league_id=5380 AND round=29 ORDER BY team ASC;
508 282 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5380 LIMIT 1
509 5.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='6ee5a10a0f52b12f32cf71e1961e7be5'
510 307 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='ef0095110bfe432d6c13b7366e7f3004'
511 326 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
512 196 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
513 287 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1954 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
514 389 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1954 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21410 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
515 842 us controllers/home.php

SELECT team, position, round FROM futbol.tables1954 WHERE league_id=21410 AND round=29 ORDER BY team ASC;
516 339 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21410 LIMIT 1
517 5.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
518 273 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1953 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
519 246 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1953 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21396 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
520 1.7 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1953 WHERE league_id=21396 AND round=29 ORDER BY team ASC;
521 262 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21396 LIMIT 1
522 5.3 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
523 182 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1952 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
524 309 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1952 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21390 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
525 781 us controllers/home.php

SELECT team, position, round FROM futbol.tables1952 WHERE league_id=21390 AND round=29 ORDER BY team ASC;
526 316 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21390 LIMIT 1
527 5.6 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
528 272 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1951 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
529 395 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1951 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21384 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
530 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1951 WHERE league_id=21384 AND round=29 ORDER BY team ASC;
531 306 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21384 LIMIT 1
532 5.1 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
533 279 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1950 AND l.group_code>=1 AND l.group_code = 2 ORDER BY l.group_code ASC
534 255 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1950 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21379 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
535 767 us controllers/home.php

SELECT team, position, round FROM futbol.tables1950 WHERE league_id=21379 AND round=29 ORDER BY team ASC;
536 328 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21379 LIMIT 1
537 6.4 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
538 256 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1949 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
539 482 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1949 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 10376 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
540 737 us controllers/home.php

SELECT team, position, round FROM futbol.tables1949 WHERE league_id=10376 AND round=25 ORDER BY team ASC;
541 351 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 10376 LIMIT 1
542 6 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
543 263 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1948 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
544 239 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1948 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 10377 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
545 670 us controllers/home.php

SELECT team, position, round FROM futbol.tables1948 WHERE league_id=10377 AND round=25 ORDER BY team ASC;
546 270 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 10377 LIMIT 1
547 6.7 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
548 283 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1947 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
549 366 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1947 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 10378 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
550 632 us controllers/home.php

SELECT team, position, round FROM futbol.tables1947 WHERE league_id=10378 AND round=25 ORDER BY team ASC;
551 204 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 10378 LIMIT 1
552 5.8 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
553 291 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1946 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
554 400 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1946 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5371 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
555 1.4 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1946 WHERE league_id=5371 AND round=25 ORDER BY team ASC;
556 379 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5371 LIMIT 1
557 9.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
558 218 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
559 132 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1945 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
560 229 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1945 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 10380 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
561 724 us controllers/home.php

SELECT team, position, round FROM futbol.tables1945 WHERE league_id=10380 AND round=25 ORDER BY team ASC;
562 189 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 10380 LIMIT 1
563 5.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
564 283 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1944 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
565 387 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1944 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 10392 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
566 738 us controllers/home.php

SELECT team, position, round FROM futbol.tables1944 WHERE league_id=10392 AND round=25 ORDER BY team ASC;
567 321 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 10392 LIMIT 1
568 5.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
569 270 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1943 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
570 248 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1943 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21319 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
571 607 us controllers/home.php

SELECT team, position, round FROM futbol.tables1943 WHERE league_id=21319 AND round=13 ORDER BY team ASC;
572 283 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21319 LIMIT 1
573 5.5 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
574 290 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1942 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
575 355 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1942 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5367 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
576 1.1 ms controllers/home.php

SELECT team, position, round FROM futbol.tables1942 WHERE league_id=5367 AND round=25 ORDER BY team ASC;
577 435 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5367 LIMIT 1
578 5.6 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
579 298 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
580 232 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1941 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
581 351 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1941 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5366 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
582 732 us controllers/home.php

SELECT team, position, round FROM futbol.tables1941 WHERE league_id=5366 AND round=21 ORDER BY team ASC;
583 256 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5366 LIMIT 1
584 4.8 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
585 246 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
586 194 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1940 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
587 268 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1940 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5365 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
588 556 us controllers/home.php

SELECT team, position, round FROM futbol.tables1940 WHERE league_id=5365 AND round=21 ORDER BY team ASC;
589 219 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5365 LIMIT 1
590 4.4 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
591 224 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=1 or sonId=1 LIMIT 1
592 123 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 1 AND l.year=1936 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
593 180 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1936 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 5361 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
594 533 us controllers/home.php

SELECT team, position, round FROM futbol.tables1936 WHERE league_id=5361 AND round=21 ORDER BY team ASC;
595 194 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 5361 LIMIT 1
596 4.5 ms controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
597 291 us controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2 or sonId=2 LIMIT 1
598 261 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2 AND l.year=1935 AND l.group_code>=1 AND l.group_code = 3 ORDER BY l.group_code ASC
599 266 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables1935 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 21256 AND t.round = 14 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
600 528 us controllers/home.php

SELECT team, position, round FROM futbol.tables1935 WHERE league_id=21256 AND round=13 ORDER BY team ASC;
601 178 us controllers/home.php

SELECT league_id, round FROM futbol.tables_coeff WHERE league_id = 21256 LIMIT 1
602 6.6 ms controllers/home.php

SELECT * FROM futbol.categories_coef WHERE parentId=2468 or sonId=2468 LIMIT 1
603 177 us controllers/home.php

SELECT l.id, l.current_table_round, l.current_round, l.total_group, l.penalty, l.legend, l.legendExtra, l.total_teams, l.group_code, l.tables, l.year, l.split_league, c.ctype, c.cat, l.table_suffix, l.extraName FROM futbol.categories AS c INNER JOIN futbol.leagues AS l ON c.id = l.categoryId WHERE l.categoryId = 2468 AND l.year=2025 AND l.group_code>=1 AND l.group_code = 1 ORDER BY l.group_code ASC
604 261 us controllers/home.php

SELECT DISTINCT dt.nameShow as internal_name,dt.id AS id, t.*, dt.nameShow, dt.translate, dt.short_name as abbr, dt.basealias,(cast(t.gf as signed) - cast(t.ga as signed) + 100) AS diff, team.conference, dt.countryCode FROM futbol.tables2025 AS t INNER JOIN teams AS team ON team.id = t.team INNER JOIN datateams AS dt ON team.teamId = dt.id LEFT JOIN club_projects.club_teams ct ON dt.id=ct.rel_datateamId WHERE t.league_id = 76666 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
605 872 us controllers/home.php

SELECT team, position, round FROM futbol.tables2025 WHERE league_id=76666 AND round=26 ORDER BY team ASC;
606 224 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='4e385e8aec65064e7b6b8f7357785c15'
607 281 us controllers/home.php

SELECT `text`, id FROM futbol.common_lang_besoccer_app WHERE lang='es' AND keyone='e82e1c172d123a70eb5cafbcb2780347'
608 226 us controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=129 AND l.year=2025 AND l.group_code=0 ORDER BY l.group_code, dt.nameShow ASC
609 1.3 ms controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=2468 AND l.year=2025 AND l.group_code='2' ORDER BY l.group_code, dt.nameShow ASC
610 640 us controllers/home.php

SELECT dt.id,t.id as id_comp, dt.nameShow, dt.translate, l.group_code, 0 AS favorite,dt.basealias,dt.fullName,t.conference,dt.short_name,ct.ctype,l.year, ds.header_color as color1, dt.countryCode FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON ct.id=l.categoryId LEFT JOIN datateams_shields ds on ds.teamId=dt.id WHERE l.categoryId=1919 AND l.year=2025 AND l.group_code=0 ORDER BY l.group_code, dt.nameShow ASC
611 407 us controllers/home.php

TOTAL TIME 1.038 s QUERIES 609 FILE controllers/home.php