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` ='jennifer-martin-ortega-9706'and `players`.`deleted_at` isnull limit 11.2mspadelmanager_db
Metadata
Bindings
0. jennifer-martin-ortega-9706
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 1910μ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` =9706680μspadelmanager_db
Metadata
Bindings
0. 9706
Hints
Use SELECT * only if you need all columns from table
select*from `player_sports` where `player_id` =9706and `sport_id` =1 limit 1630μspadelmanager_db
Metadata
Bindings
0. 9706
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 =9706and c.sport_id =12.97mspadelmanager_db
Metadata
Bindings
0. 9706
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 =9706720μspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 9706
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 =9706720μspadelmanager_db
Metadata
Bindings
0. 1
1. 19
2. 9706
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` =9706andexists (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.45mspadelmanager_db
Metadata
Bindings
0. 9706
1. 1
2. 1
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` <>9706andexists (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` =389223andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 11.36mspadelmanager_db
Metadata
Bindings
0. 9706
1. 1
2. 1
3. 389223
4. 1
Hints
Use SELECT * only if you need all columns from table
select `id`, `name`, `surname`, `slug` from `players` where `players`.`id` in (156295) and `players`.`deleted_at` isnull510μspadelmanager_db
Metadata
select*from `cities` where `cities`.`id` =19 limit 1650μspadelmanager_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` =9706orderby `start_date` desc, `status` desc1.98mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 9706
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` in (462, 534, 558, 700, 772, 802, 971, 1397, 1951, 7739) and `competitions`.`deleted_at` isnull1.15mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `clubs` where `clubs`.`id` in (908, 925, 1342, 1366, 1440, 1503)1.21mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_categories` where `competition_categories`.`id` in (3071, 3555, 3557, 3748, 3750, 4762, 5265, 5483, 6634, 9357, 12998, 46488)820μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `categories` where `categories`.`id` in (9, 11, 35, 1646)620μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =389223and `player_id` <>9706 limit 1820μspadelmanager_db
Metadata
Bindings
0. 389223
1. 9706
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 (156295) and `players`.`deleted_at` isnull880μ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` =389223or `team2_id` =389223orderby `competition_matches`.`id` desc1.48mspadelmanager_db
Metadata
Bindings
0. 389223
1. 389223
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =93758and `player_id` <>9706 limit 1770μspadelmanager_db
Metadata
Bindings
0. 93758
1. 9706
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 (42738) and `players`.`deleted_at` isnull890μ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` =93758or `team2_id` =93758orderby `competition_matches`.`id` desc1.86mspadelmanager_db
Metadata
Bindings
0. 93758
1. 93758
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =64801and `player_id` <>9706 limit 1970μspadelmanager_db
Metadata
Bindings
0. 64801
1. 9706
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 (5626) and `players`.`deleted_at` isnull650μ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` =64801or `team2_id` =64801orderby `competition_matches`.`id` desc1.2mspadelmanager_db
Metadata
Bindings
0. 64801
1. 64801
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =49217and `player_id` <>9706 limit 1740μspadelmanager_db
Metadata
Bindings
0. 49217
1. 9706
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 (16016) and `players`.`deleted_at` isnull790μ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` =49217or `team2_id` =49217orderby `competition_matches`.`id` desc1.5mspadelmanager_db
Metadata
Bindings
0. 49217
1. 49217
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =43745and `player_id` <>9706 limit 1830μspadelmanager_db
Metadata
Bindings
0. 43745
1. 9706
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 (21158) 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` =43745or `team2_id` =43745orderby `competition_matches`.`id` desc1.35mspadelmanager_db
Metadata
Bindings
0. 43745
1. 43745
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =37818and `player_id` <>9706 limit 1730μspadelmanager_db
Metadata
Bindings
0. 37818
1. 9706
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 (8915) and `players`.`deleted_at` isnull710μ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` =37818or `team2_id` =37818orderby `competition_matches`.`id` desc1.13mspadelmanager_db
Metadata
Bindings
0. 37818
1. 37818
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =35610and `player_id` <>9706 limit 1770μspadelmanager_db
Metadata
Bindings
0. 35610
1. 9706
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 (25999) and `players`.`deleted_at` isnull840μ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` =35610or `team2_id` =35610orderby `competition_matches`.`id` desc1.55mspadelmanager_db
Metadata
Bindings
0. 35610
1. 35610
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =30778and `player_id` <>9706 limit 1950μspadelmanager_db
Metadata
Bindings
0. 30778
1. 9706
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 (24396) and `players`.`deleted_at` isnull880μ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` =30778or `team2_id` =30778orderby `competition_matches`.`id` desc1.29mspadelmanager_db
Metadata
Bindings
0. 30778
1. 30778
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =31068and `player_id` <>9706 limit 1690μspadelmanager_db
Metadata
Bindings
0. 31068
1. 9706
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 (26072) 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` =31068or `team2_id` =31068orderby `competition_matches`.`id` desc1.62mspadelmanager_db
Metadata
Bindings
0. 31068
1. 31068
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =28460and `player_id` <>9706 limit 11.08mspadelmanager_db
Metadata
Bindings
0. 28460
1. 9706
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 (24396) and `players`.`deleted_at` isnull690μ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` =28460or `team2_id` =28460orderby `competition_matches`.`id` desc1.08mspadelmanager_db
Metadata
Bindings
0. 28460
1. 28460
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =28480and `player_id` <>9706 limit 11.01mspadelmanager_db
Metadata
Bindings
0. 28480
1. 9706
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 (17631) and `players`.`deleted_at` isnull1.04mspadelmanager_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` =28480or `team2_id` =28480orderby `competition_matches`.`id` desc1.18mspadelmanager_db
Metadata
Bindings
0. 28480
1. 28480
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =26843and `player_id` <>9706 limit 1860μspadelmanager_db
Metadata
Bindings
0. 26843
1. 9706
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 (8076) and `players`.`deleted_at` isnull880μ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` =26843or `team2_id` =26843orderby `competition_matches`.`id` desc1.16mspadelmanager_db
Metadata
Bindings
0. 26843
1. 26843
Hints
Use SELECT * only if you need all columns from table
select*from `countries` where `active` =11.21mspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table