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` ='rodrigo-martinez-36192'and `players`.`deleted_at` isnull limit 14.44mspadelmanager_db
Metadata
Bindings
0. rodrigo-martinez-36192
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 1710μ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` =361921.52mspadelmanager_db
Metadata
Bindings
0. 36192
Hints
Use SELECT * only if you need all columns from table
select*from `player_sports` where `player_id` =36192and `sport_id` =1 limit 1970μspadelmanager_db
Metadata
Bindings
0. 36192
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 =36192and c.sport_id =111.4mspadelmanager_db
Metadata
Bindings
0. 36192
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 =36192850μspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 36192
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 =8
) as ranking
WHERE ranking.id =36192660μspadelmanager_db
Metadata
Bindings
0. 1
1. 8
2. 36192
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` =36192andexists (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 13.8mspadelmanager_db
Metadata
Bindings
0. 36192
1. 1
2. 1
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` <>36192andexists (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` =177606andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 128.96mspadelmanager_db
Metadata
Bindings
0. 36192
1. 1
2. 1
3. 177606
4. 1
Hints
Use SELECT * only if you need all columns from table
select `id`, `name`, `surname`, `slug` from `players` where `players`.`id` in (12369) and `players`.`deleted_at` isnull860μspadelmanager_db
Metadata
select*from `cities` where `cities`.`id` =8 limit 1750μspadelmanager_db
Metadata
Bindings
0. 8
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` =36192orderby `start_date` desc, `status` desc5.56mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 36192
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` in (948, 1035, 1036, 1037, 2150, 2151, 2152, 2153, 3850) and `competitions`.`deleted_at` isnull1.64mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `clubs` where `clubs`.`id` in (1028)1.53mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_categories` where `competition_categories`.`id` in (6473, 7066, 7071, 7079, 14225, 14232, 14237, 14243, 22637)2.32mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `categories` where `categories`.`id` in (3, 152, 153)1.32mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =177606and `player_id` <>36192 limit 1730μspadelmanager_db
Metadata
Bindings
0. 177606
1. 36192
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 (12369) and `players`.`deleted_at` isnull1.06mspadelmanager_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` =177606or `team2_id` =177606orderby `competition_matches`.`id` desc2.74mspadelmanager_db
Metadata
Bindings
0. 177606
1. 177606
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =122785and `player_id` <>36192 limit 11.42mspadelmanager_db
Metadata
Bindings
0. 122785
1. 36192
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 (39697) and `players`.`deleted_at` isnull1.47mspadelmanager_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` =122785or `team2_id` =122785orderby `competition_matches`.`id` desc3.62mspadelmanager_db
Metadata
Bindings
0. 122785
1. 122785
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =116965and `player_id` <>36192 limit 11.45mspadelmanager_db
Metadata
Bindings
0. 116965
1. 36192
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 (39697) and `players`.`deleted_at` isnull1.2mspadelmanager_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` =116965or `team2_id` =116965orderby `competition_matches`.`id` desc2.08mspadelmanager_db
Metadata
Bindings
0. 116965
1. 116965
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =111759and `player_id` <>36192 limit 1740μspadelmanager_db
Metadata
Bindings
0. 111759
1. 36192
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 (36647) and `players`.`deleted_at` isnull1.49mspadelmanager_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` =111759or `team2_id` =111759orderby `competition_matches`.`id` desc2.64mspadelmanager_db
Metadata
Bindings
0. 111759
1. 111759
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =106648and `player_id` <>36192 limit 11.01mspadelmanager_db
Metadata
Bindings
0. 106648
1. 36192
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 (12369) and `players`.`deleted_at` isnull960μ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` =106648or `team2_id` =106648orderby `competition_matches`.`id` desc3.35mspadelmanager_db
Metadata
Bindings
0. 106648
1. 106648
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =62948and `player_id` <>36192 limit 1800μspadelmanager_db
Metadata
Bindings
0. 62948
1. 36192
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 (36647) and `players`.`deleted_at` isnull820μ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` =62948or `team2_id` =62948orderby `competition_matches`.`id` desc2.17mspadelmanager_db
Metadata
Bindings
0. 62948
1. 62948
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =59216and `player_id` <>36192 limit 11.53mspadelmanager_db
Metadata
Bindings
0. 59216
1. 36192
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 (35840) and `players`.`deleted_at` isnull3.39mspadelmanager_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` =59216or `team2_id` =59216orderby `competition_matches`.`id` desc3.44mspadelmanager_db
Metadata
Bindings
0. 59216
1. 59216
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =55337and `player_id` <>36192 limit 1880μspadelmanager_db
Metadata
Bindings
0. 55337
1. 36192
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 (41353) and `players`.`deleted_at` isnull2.53mspadelmanager_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` =55337or `team2_id` =55337orderby `competition_matches`.`id` desc1.83mspadelmanager_db
Metadata
Bindings
0. 55337
1. 55337
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =47033and `player_id` <>36192 limit 11.54mspadelmanager_db
Metadata
Bindings
0. 47033
1. 36192
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 (36193) and `players`.`deleted_at` isnull1.64mspadelmanager_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` =47033or `team2_id` =47033orderby `competition_matches`.`id` desc1.05mspadelmanager_db
Metadata
Bindings
0. 47033
1. 47033
Hints
Use SELECT * only if you need all columns from table
select*from `countries` where `active` =11.26mspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table