vola.plus solicita su permiso para obtener datos estadísticos de su navegación en esta web, en cumplimiento del Real Decreto-ley 13/2012.
Si continúa navegando consideramos que acepta el uso de cookies.
OK
select*from `players` where `slug` ='alvaro-trigo-279383'and `players`.`deleted_at` isnull limit 13.93mspadelmanager_db
Metadata
Bindings
0. alvaro-trigo-279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `sports` where `sports`.`id` =1and `sports`.`deleted_at` isnull limit 1630μspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `player_sports` where `player_id` =2793832.5mspadelmanager_db
Metadata
Bindings
0. 279383
Hints
Use SELECT * only if you need all columns from table
select*from `player_sports` where `player_id` =279383and `sport_id` =1 limit 11.35mspadelmanager_db
Metadata
Bindings
0. 279383
1. 1
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select
(SELECTCOUNT(DISTINCT a_m_w_p.competition_id)) AS played_competitions,
COUNT(m.id) asmatches,
if(SUM(CASEWHEN team =1and winner =1AND team2_presented <>2THEN1WHEN team =2and winner =2AND team1_presented <>2THEN1WHEN team =1AND winner =2THEN0WHEN team =2AND winner =1THEN0END) >0, SUM(CASEWHEN team =1and winner =1AND team2_presented <>2THEN1WHEN team =2and winner =2AND team1_presented <>2THEN1WHEN team =1AND winner =2THEN0WHEN team =2AND winner =1THEN0END), 0) AS wins,
if(SUM(CASEWHEN team =1AND winner =1THEN0WHEN team =2AND winner =2THEN0WHEN team =1AND winner =2AND team1_presented <>2THEN1WHEN team =2AND winner =1AND team2_presented <>2THEN1END) >0, SUM(CASEWHEN team =1AND winner =1THEN0WHEN team =2AND winner =2THEN0WHEN team =1AND winner =2AND team1_presented <>2THEN1WHEN team =2AND winner =1AND team2_presented <>2THEN1END), 0) AS loose,
if(SUM(CASEWHEN team =1THEN r1
WHEN team =2THEN r2
END) >0, SUM(CASEWHEN team =1THEN r1
WHEN team =2THEN r2
END), 0) AS win_sets,
if(SUM(CASEWHEN team =1THEN r2
WHEN team =2THEN r1
END) >0, SUM(CASEWHEN team =1THEN r2
WHEN team =2THEN r1
END), 0) AS loose_sets,
if(SUM(if(real_round_number =1, 1, 0)) >0, SUM(if(real_round_number =1, 1, 0)), 0) AS finals,
if(SUM(if(real_round_number =2, 1, 0)) >0, SUM(if(real_round_number =2, 1, 0)), 0) AS semifinals,
if(SUM(if(real_round_number =3, 1, 0)) >0, SUM(if(real_round_number =3, 1, 0)), 0) AS quarters
FROM all_matches_with_players a_m_w_p
INNERJOIN competition_matches m ON a_m_w_p.competition_matches_id = m.id
INNERJOIN competitions c ON c.id = m.competition_id
WHERE m.status =2and m.team1_presented <>2and m.team2_presented <>2and a_m_w_p.player_id =279383and c.sport_id =112mspadelmanager_db
Metadata
Bindings
0. 279383
1. 1
SELECT ranking.*FROM (
SELECT player_id as id
, name
, surname
, cache_image
, position_country as position
, rating
, country_code
FROM player_ranking_calculated
WHERE sport_id =1AND country_id =1
) as ranking
WHERE ranking.id =2793831.59mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 279383
Hints
Use SELECT * only if you need all columns from table
SELECT ranking.*FROM (
SELECT player_id as id
, name
, surname
, position_city as position
, rating
, country_code
, cache_image
FROM player_ranking_calculated
WHERE sport_id =1AND city_id =25
) as ranking
WHERE ranking.id =279383840μspadelmanager_db
Metadata
Bindings
0. 1
1. 25
2. 279383
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` =279383andexists (select*from `competitions` where `team_players`.`competition_id` = `competitions`.`id` and `competitions`.`visible` =1and `competitions`.`deleted_at` isnull) andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 17.16mspadelmanager_db
Metadata
Bindings
0. 279383
1. 1
2. 1
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` <>279383andexists (select*from `competitions` where `team_players`.`competition_id` = `competitions`.`id` and `competitions`.`visible` =1and `sport_id` =1and `competitions`.`deleted_at` isnull) and `competition_team_id` =533061andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 17.4mspadelmanager_db
Metadata
Bindings
0. 279383
1. 1
2. 1
3. 533061
4. 1
Hints
Use SELECT * only if you need all columns from table
select `id`, `name`, `surname`, `slug` from `players` where `players`.`id` in (278892) and `players`.`deleted_at` isnull810μspadelmanager_db
Metadata
select*from `cities` where `cities`.`id` =25 limit 11.11mspadelmanager_db
Metadata
Bindings
0. 25
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `competition_teams` innerjoin `team_players` on `competition_team_id` = `competition_teams`.`id` innerjoin `competitions` on `competition_teams`.`competition_id` = `competitions`.`id` where `competitions`.`confirmed` =1and `competitions`.`sport_id` =1and `team_players`.`player_id` =279383orderby `start_date` desc, `status` desc8.11mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 279383
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` in (4964, 4965, 4966, 4967, 5887, 6176, 6177, 6179, 7960, 8567, 9201, 10154) and `competitions`.`deleted_at` isnull1.33mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `clubs` where `clubs`.`id` in (168)1.06mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_categories` where `competition_categories`.`id` in (29021, 29030, 29039, 29048, 34872, 36786, 36794, 36813, 47802, 52032, 56585, 62435)1.06mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `categories` where `categories`.`id` in (3, 4)1.6mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =533061and `player_id` <>279383 limit 11.14mspadelmanager_db
Metadata
Bindings
0. 533061
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (278892) and `players`.`deleted_at` isnull2.17mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =533061or `team2_id` =533061orderby `competition_matches`.`id` desc3.57mspadelmanager_db
Metadata
Bindings
0. 533061
1. 533061
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =482242and `player_id` <>279383 limit 11.82mspadelmanager_db
Metadata
Bindings
0. 482242
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (291626) and `players`.`deleted_at` isnull1.98mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =482242or `team2_id` =482242orderby `competition_matches`.`id` desc2.68mspadelmanager_db
Metadata
Bindings
0. 482242
1. 482242
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =473226and `player_id` <>279383 limit 11.62mspadelmanager_db
Metadata
Bindings
0. 473226
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (279028) and `players`.`deleted_at` isnull1.93mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =473226or `team2_id` =473226orderby `competition_matches`.`id` desc3.37mspadelmanager_db
Metadata
Bindings
0. 473226
1. 473226
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =412128and `player_id` <>279383 limit 11.65mspadelmanager_db
Metadata
Bindings
0. 412128
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (376086) and `players`.`deleted_at` isnull1.56mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =412128or `team2_id` =412128orderby `competition_matches`.`id` desc2.85mspadelmanager_db
Metadata
Bindings
0. 412128
1. 412128
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =398605and `player_id` <>279383 limit 12.65mspadelmanager_db
Metadata
Bindings
0. 398605
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (279221) and `players`.`deleted_at` isnull2.56mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =398605or `team2_id` =398605orderby `competition_matches`.`id` desc2.24mspadelmanager_db
Metadata
Bindings
0. 398605
1. 398605
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =372087and `player_id` <>279383 limit 11.84mspadelmanager_db
Metadata
Bindings
0. 372087
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (291626) and `players`.`deleted_at` isnull810μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =372087or `team2_id` =372087orderby `competition_matches`.`id` desc3.05mspadelmanager_db
Metadata
Bindings
0. 372087
1. 372087
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =338373and `player_id` <>279383 limit 1810μspadelmanager_db
Metadata
Bindings
0. 338373
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (279136) and `players`.`deleted_at` isnull1.92mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =338373or `team2_id` =338373orderby `competition_matches`.`id` desc2.73mspadelmanager_db
Metadata
Bindings
0. 338373
1. 338373
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =299583and `player_id` <>279383 limit 11.21mspadelmanager_db
Metadata
Bindings
0. 299583
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (279028) and `players`.`deleted_at` isnull900μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =299583or `team2_id` =299583orderby `competition_matches`.`id` desc2.11mspadelmanager_db
Metadata
Bindings
0. 299583
1. 299583
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =286454and `player_id` <>279383 limit 1930μspadelmanager_db
Metadata
Bindings
0. 286454
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (287790) and `players`.`deleted_at` isnull2.54mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =286454or `team2_id` =286454orderby `competition_matches`.`id` desc2.19mspadelmanager_db
Metadata
Bindings
0. 286454
1. 286454
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =274004and `player_id` <>279383 limit 11.89mspadelmanager_db
Metadata
Bindings
0. 274004
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (287790) and `players`.`deleted_at` isnull1mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =274004or `team2_id` =274004orderby `competition_matches`.`id` desc4.29mspadelmanager_db
Metadata
Bindings
0. 274004
1. 274004
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =268333and `player_id` <>279383 limit 11.72mspadelmanager_db
Metadata
Bindings
0. 268333
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (287790) and `players`.`deleted_at` isnull920μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =268333or `team2_id` =268333orderby `competition_matches`.`id` desc3.41mspadelmanager_db
Metadata
Bindings
0. 268333
1. 268333
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =256121and `player_id` <>279383 limit 1880μspadelmanager_db
Metadata
Bindings
0. 256121
1. 279383
Hints
Use SELECT * only if you need all columns from table
LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
select*from `players` where `players`.`id` in (279378) and `players`.`deleted_at` isnull1.81mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_matches` innerjoin `competition_stages` on `stage_id` = `competition_stages`.`id` where `team1_id` =256121or `team2_id` =256121orderby `competition_matches`.`id` desc2.65mspadelmanager_db
Metadata
Bindings
0. 256121
1. 256121
Hints
Use SELECT * only if you need all columns from table
select*from `countries` where `active` =1950μspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table