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` ='lidia-55626'and `players`.`deleted_at` isnull limit 11.39mspadelmanager_db
Metadata
Bindings
0. lidia-55626
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 1750μ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` =55626580μspadelmanager_db
Metadata
Bindings
0. 55626
Hints
Use SELECT * only if you need all columns from table
select*from `player_sports` where `player_id` =55626and `sport_id` =1 limit 1560μspadelmanager_db
Metadata
Bindings
0. 55626
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 =55626and c.sport_id =110.12mspadelmanager_db
Metadata
Bindings
0. 55626
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 =55626740μspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 55626
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 =33
) as ranking
WHERE ranking.id =55626480μspadelmanager_db
Metadata
Bindings
0. 1
1. 33
2. 55626
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` =55626andexists (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 11.03mspadelmanager_db
Metadata
Bindings
0. 55626
1. 1
2. 1
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` <>55626andexists (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` =300729andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 13.04mspadelmanager_db
Metadata
Bindings
0. 55626
1. 1
2. 1
3. 300729
4. 1
Hints
Use SELECT * only if you need all columns from table
select `id`, `name`, `surname`, `slug` from `players` where `players`.`id` in (283002) and `players`.`deleted_at` isnull620μspadelmanager_db
Metadata
select*from `cities` where `cities`.`id` =33 limit 1800μspadelmanager_db
Metadata
Bindings
0. 33
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` =55626orderby `start_date` desc, `status` desc6.89mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 55626
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` in (1541, 1697, 1981, 2291, 2915, 3268, 3696, 4193, 4568, 4697, 5339, 5612, 6006) and `competitions`.`deleted_at` isnull1.28mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `clubs` where `clubs`.`id` in (1522)840μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_categories` where `competition_categories`.`id` in (10319, 11395, 13160, 15026, 17442, 19976, 21818, 24302, 26345, 27210, 32058, 33263, 35628)760μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `categories` where `categories`.`id` in (76, 77, 1200, 1219, 1355, 1356)930μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =300729and `player_id` <>55626 limit 1810μspadelmanager_db
Metadata
Bindings
0. 300729
1. 55626
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 (283002) and `players`.`deleted_at` isnull770μ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` =300729or `team2_id` =300729orderby `competition_matches`.`id` desc1.25mspadelmanager_db
Metadata
Bindings
0. 300729
1. 300729
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =279209and `player_id` <>55626 limit 1810μspadelmanager_db
Metadata
Bindings
0. 279209
1. 55626
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 (283002) and `players`.`deleted_at` isnull680μ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` =279209or `team2_id` =279209orderby `competition_matches`.`id` desc1.1mspadelmanager_db
Metadata
Bindings
0. 279209
1. 279209
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =266784and `player_id` <>55626 limit 1760μspadelmanager_db
Metadata
Bindings
0. 266784
1. 55626
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 (55627) and `players`.`deleted_at` isnull640μ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` =266784or `team2_id` =266784orderby `competition_matches`.`id` desc2.87mspadelmanager_db
Metadata
Bindings
0. 266784
1. 266784
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =228244and `player_id` <>55626 limit 1740μspadelmanager_db
Metadata
Bindings
0. 228244
1. 55626
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 (51050) and `players`.`deleted_at` isnull1.58mspadelmanager_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` =228244or `team2_id` =228244orderby `competition_matches`.`id` desc1.2mspadelmanager_db
Metadata
Bindings
0. 228244
1. 228244
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =217553and `player_id` <>55626 limit 1810μspadelmanager_db
Metadata
Bindings
0. 217553
1. 55626
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 (51050) and `players`.`deleted_at` isnull830μ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` =217553or `team2_id` =217553orderby `competition_matches`.`id` desc1.43mspadelmanager_db
Metadata
Bindings
0. 217553
1. 217553
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =190262and `player_id` <>55626 limit 1820μspadelmanager_db
Metadata
Bindings
0. 190262
1. 55626
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 (55627) and `players`.`deleted_at` isnull600μ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` =190262or `team2_id` =190262orderby `competition_matches`.`id` desc1.45mspadelmanager_db
Metadata
Bindings
0. 190262
1. 190262
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =177958and `player_id` <>55626 limit 1750μspadelmanager_db
Metadata
Bindings
0. 177958
1. 55626
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 (55627) and `players`.`deleted_at` isnull740μ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` =177958or `team2_id` =177958orderby `competition_matches`.`id` desc1.17mspadelmanager_db
Metadata
Bindings
0. 177958
1. 177958
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =152194and `player_id` <>55626 limit 1880μspadelmanager_db
Metadata
Bindings
0. 152194
1. 55626
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 (55627) and `players`.`deleted_at` isnull830μ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` =152194or `team2_id` =152194orderby `competition_matches`.`id` desc3.05mspadelmanager_db
Metadata
Bindings
0. 152194
1. 152194
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =136387and `player_id` <>55626 limit 1740μspadelmanager_db
Metadata
Bindings
0. 136387
1. 55626
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 (55627) and `players`.`deleted_at` isnull660μ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` =136387or `team2_id` =136387orderby `competition_matches`.`id` desc1.12mspadelmanager_db
Metadata
Bindings
0. 136387
1. 136387
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =116655and `player_id` <>55626 limit 1650μspadelmanager_db
Metadata
Bindings
0. 116655
1. 55626
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 (78284) and `players`.`deleted_at` isnull730μ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` =116655or `team2_id` =116655orderby `competition_matches`.`id` desc1.38mspadelmanager_db
Metadata
Bindings
0. 116655
1. 116655
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =98956and `player_id` <>55626 limit 1670μspadelmanager_db
Metadata
Bindings
0. 98956
1. 55626
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 (55627) and `players`.`deleted_at` isnull590μ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` =98956or `team2_id` =98956orderby `competition_matches`.`id` desc1.16mspadelmanager_db
Metadata
Bindings
0. 98956
1. 98956
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =86480and `player_id` <>55626 limit 1700μspadelmanager_db
Metadata
Bindings
0. 86480
1. 55626
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 (55627) and `players`.`deleted_at` isnull620μ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` =86480or `team2_id` =86480orderby `competition_matches`.`id` desc1.96mspadelmanager_db
Metadata
Bindings
0. 86480
1. 86480
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =76409and `player_id` <>55626 limit 1770μspadelmanager_db
Metadata
Bindings
0. 76409
1. 55626
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 (55627) and `players`.`deleted_at` isnull580μ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` =76409or `team2_id` =76409orderby `competition_matches`.`id` desc970μspadelmanager_db
Metadata
Bindings
0. 76409
1. 76409
Hints
Use SELECT * only if you need all columns from table
select*from `countries` where `active` =1850μspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table