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` ='angel-centeno-canadas-33735'and `players`.`deleted_at` isnull limit 14.42mspadelmanager_db
Metadata
Bindings
0. angel-centeno-canadas-33735
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 1880μ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` =337352.1mspadelmanager_db
Metadata
Bindings
0. 33735
Hints
Use SELECT * only if you need all columns from table
select*from `player_sports` where `player_id` =33735and `sport_id` =1 limit 11.18mspadelmanager_db
Metadata
Bindings
0. 33735
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 =33735and c.sport_id =19.22mspadelmanager_db
Metadata
Bindings
0. 33735
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 =337351.54mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 33735
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 =19
) as ranking
WHERE ranking.id =33735700μspadelmanager_db
Metadata
Bindings
0. 1
1. 19
2. 33735
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` =33735andexists (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 128.45mspadelmanager_db
Metadata
Bindings
0. 33735
1. 1
2. 1
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` <>33735andexists (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` =265581andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 19.98mspadelmanager_db
Metadata
Bindings
0. 33735
1. 1
2. 1
3. 265581
4. 1
Hints
Use SELECT * only if you need all columns from table
select `id`, `name`, `surname`, `slug` from `players` where `players`.`id` in (13032) and `players`.`deleted_at` isnull1.8mspadelmanager_db
Metadata
select*from `cities` where `cities`.`id` =19 limit 11.68mspadelmanager_db
Metadata
Bindings
0. 19
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` =33735orderby `start_date` desc, `status` desc9.85mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 33735
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` in (823, 3252, 3574, 3839, 3880, 4191, 4463, 4472, 4503, 4535, 4595, 5380) and `competitions`.`deleted_at` isnull1.86mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `clubs` where `clubs`.`id` in (525, 880, 881, 1323, 1378, 1405, 1895)1.42mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_categories` where `competition_categories`.`id` in (5582, 19389, 19395, 21200, 22575, 22714, 24284, 25621, 25708, 25945, 26151, 26478, 31829)940μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `categories` where `categories`.`id` in (2, 3, 4, 14, 51)810μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =265581and `player_id` <>33735 limit 11.49mspadelmanager_db
Metadata
Bindings
0. 265581
1. 33735
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 (13032) and `players`.`deleted_at` isnull2.29mspadelmanager_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` =265581or `team2_id` =265581orderby `competition_matches`.`id` desc2.72mspadelmanager_db
Metadata
Bindings
0. 265581
1. 265581
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =219854and `player_id` <>33735 limit 1970μspadelmanager_db
Metadata
Bindings
0. 219854
1. 33735
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 (965) and `players`.`deleted_at` isnull1.73mspadelmanager_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` =219854or `team2_id` =219854orderby `competition_matches`.`id` desc1.61mspadelmanager_db
Metadata
Bindings
0. 219854
1. 219854
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =215614and `player_id` <>33735 limit 11.13mspadelmanager_db
Metadata
Bindings
0. 215614
1. 33735
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 (902) and `players`.`deleted_at` isnull3.22mspadelmanager_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` =215614or `team2_id` =215614orderby `competition_matches`.`id` desc1.85mspadelmanager_db
Metadata
Bindings
0. 215614
1. 215614
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =212519and `player_id` <>33735 limit 11.74mspadelmanager_db
Metadata
Bindings
0. 212519
1. 33735
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 (13032) and `players`.`deleted_at` isnull1.02mspadelmanager_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` =212519or `team2_id` =212519orderby `competition_matches`.`id` desc3.76mspadelmanager_db
Metadata
Bindings
0. 212519
1. 212519
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =210663and `player_id` <>33735 limit 11.04mspadelmanager_db
Metadata
Bindings
0. 210663
1. 33735
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 (13032) and `players`.`deleted_at` isnull950μ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` =210663or `team2_id` =210663orderby `competition_matches`.`id` desc2.21mspadelmanager_db
Metadata
Bindings
0. 210663
1. 210663
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =209802and `player_id` <>33735 limit 1810μspadelmanager_db
Metadata
Bindings
0. 209802
1. 33735
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 (21556) and `players`.`deleted_at` isnull4.38mspadelmanager_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` =209802or `team2_id` =209802orderby `competition_matches`.`id` desc3mspadelmanager_db
Metadata
Bindings
0. 209802
1. 209802
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =192479and `player_id` <>33735 limit 1740μspadelmanager_db
Metadata
Bindings
0. 192479
1. 33735
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 (13032) and `players`.`deleted_at` isnull2.45mspadelmanager_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` =192479or `team2_id` =192479orderby `competition_matches`.`id` desc2.8mspadelmanager_db
Metadata
Bindings
0. 192479
1. 192479
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =182309and `player_id` <>33735 limit 14.74mspadelmanager_db
Metadata
Bindings
0. 182309
1. 33735
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 (46534) and `players`.`deleted_at` isnull2.73mspadelmanager_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` =182309or `team2_id` =182309orderby `competition_matches`.`id` desc2.79mspadelmanager_db
Metadata
Bindings
0. 182309
1. 182309
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =178574and `player_id` <>33735 limit 11.14mspadelmanager_db
Metadata
Bindings
0. 178574
1. 33735
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 (46534) 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` =178574or `team2_id` =178574orderby `competition_matches`.`id` desc2.09mspadelmanager_db
Metadata
Bindings
0. 178574
1. 178574
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =164750and `player_id` <>33735 limit 11.5mspadelmanager_db
Metadata
Bindings
0. 164750
1. 33735
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 (155255) and `players`.`deleted_at` isnull1.31mspadelmanager_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` =164750or `team2_id` =164750orderby `competition_matches`.`id` desc2.84mspadelmanager_db
Metadata
Bindings
0. 164750
1. 164750
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =150320and `player_id` <>33735 limit 11.49mspadelmanager_db
Metadata
Bindings
0. 150320
1. 33735
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 (210506) and `players`.`deleted_at` isnull1.5mspadelmanager_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` =150320or `team2_id` =150320orderby `competition_matches`.`id` desc4mspadelmanager_db
Metadata
Bindings
0. 150320
1. 150320
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =150327and `player_id` <>33735 limit 1770μspadelmanager_db
Metadata
Bindings
0. 150327
1. 33735
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 (210536) 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` =150327or `team2_id` =150327orderby `competition_matches`.`id` desc1.94mspadelmanager_db
Metadata
Bindings
0. 150327
1. 150327
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =43619and `player_id` <>33735 limit 11.17mspadelmanager_db
Metadata
Bindings
0. 43619
1. 33735
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 (33746) 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` =43619or `team2_id` =43619orderby `competition_matches`.`id` desc2.7mspadelmanager_db
Metadata
Bindings
0. 43619
1. 43619
Hints
Use SELECT * only if you need all columns from table
select*from `countries` where `active` =1820μspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table