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` ='manel-150396'and `players`.`deleted_at` isnull limit 13.34mspadelmanager_db
Metadata
Bindings
0. manel-150396
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 1550μ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` =1503961.67mspadelmanager_db
Metadata
Bindings
0. 150396
Hints
Use SELECT * only if you need all columns from table
select*from `player_sports` where `player_id` =150396and `sport_id` =1 limit 1810μspadelmanager_db
Metadata
Bindings
0. 150396
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 =150396and c.sport_id =110.53mspadelmanager_db
Metadata
Bindings
0. 150396
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 =150396810μspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 150396
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 =150396880μspadelmanager_db
Metadata
Bindings
0. 1
1. 33
2. 150396
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` =150396andexists (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.93mspadelmanager_db
Metadata
Bindings
0. 150396
1. 1
2. 1
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `player_id` <>150396andexists (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` =331593andexists (select*from `players` where `team_players`.`player_id` = `players`.`id` and `players`.`visible` =1and `players`.`deleted_at` isnull) orderby `created_at` desc limit 14.35mspadelmanager_db
Metadata
Bindings
0. 150396
1. 1
2. 1
3. 331593
4. 1
Hints
Use SELECT * only if you need all columns from table
select `id`, `name`, `surname`, `slug` from `players` where `players`.`id` in (39202) and `players`.`deleted_at` isnull610μspadelmanager_db
Metadata
select*from `cities` where `cities`.`id` =33 limit 1650μ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` =150396orderby `start_date` desc, `status` desc5.05mspadelmanager_db
Metadata
Bindings
0. 1
1. 1
2. 150396
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` in (2681, 3074, 3694, 4604, 4697, 4699, 5151, 5612, 5752, 6090, 6732) and `competitions`.`deleted_at` isnull1.21mspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `clubs` where `clubs`.`id` in (1522)890μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `competition_categories` where `competition_categories`.`id` in (16835, 18289, 21867, 26541, 27208, 27217, 30279, 33260, 34185, 36137, 40313)960μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `categories` where `categories`.`id` in (443, 1196, 1197, 1533, 1534)790μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =331593and `player_id` <>150396 limit 1870μspadelmanager_db
Metadata
Bindings
0. 331593
1. 150396
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 (39202) and `players`.`deleted_at` isnull2.37mspadelmanager_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` =331593or `team2_id` =331593orderby `competition_matches`.`id` desc2.67mspadelmanager_db
Metadata
Bindings
0. 331593
1. 331593
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =304913and `player_id` <>150396 limit 11.48mspadelmanager_db
Metadata
Bindings
0. 304913
1. 150396
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 (310614) and `players`.`deleted_at` isnull1.34mspadelmanager_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` =304913or `team2_id` =304913orderby `competition_matches`.`id` desc3.22mspadelmanager_db
Metadata
Bindings
0. 304913
1. 304913
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =289458and `player_id` <>150396 limit 1680μspadelmanager_db
Metadata
Bindings
0. 289458
1. 150396
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 (295864) 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` =289458or `team2_id` =289458orderby `competition_matches`.`id` desc1.24mspadelmanager_db
Metadata
Bindings
0. 289458
1. 289458
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =282243and `player_id` <>150396 limit 1740μspadelmanager_db
Metadata
Bindings
0. 282243
1. 150396
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 (295864) 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` =282243or `team2_id` =282243orderby `competition_matches`.`id` desc1.94mspadelmanager_db
Metadata
Bindings
0. 282243
1. 282243
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =251455and `player_id` <>150396 limit 1710μspadelmanager_db
Metadata
Bindings
0. 251455
1. 150396
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 (275958) and `players`.`deleted_at` isnull1.32mspadelmanager_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` =251455or `team2_id` =251455orderby `competition_matches`.`id` desc1.92mspadelmanager_db
Metadata
Bindings
0. 251455
1. 251455
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =228245and `player_id` <>150396 limit 11.34mspadelmanager_db
Metadata
Bindings
0. 228245
1. 150396
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 (39202) 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` =228245or `team2_id` =228245orderby `competition_matches`.`id` desc2.26mspadelmanager_db
Metadata
Bindings
0. 228245
1. 228245
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =228242and `player_id` <>150396 limit 1800μspadelmanager_db
Metadata
Bindings
0. 228242
1. 150396
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 (39202) and `players`.`deleted_at` isnull860μ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` =228242or `team2_id` =228242orderby `competition_matches`.`id` desc1.23mspadelmanager_db
Metadata
Bindings
0. 228242
1. 228242
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =221825and `player_id` <>150396 limit 1960μspadelmanager_db
Metadata
Bindings
0. 221825
1. 150396
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 (39202) 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` =221825or `team2_id` =221825orderby `competition_matches`.`id` desc1.86mspadelmanager_db
Metadata
Bindings
0. 221825
1. 221825
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =171381and `player_id` <>150396 limit 1640μspadelmanager_db
Metadata
Bindings
0. 171381
1. 150396
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 (55476) and `players`.`deleted_at` isnull2.3mspadelmanager_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` =171381or `team2_id` =171381orderby `competition_matches`.`id` desc1.03mspadelmanager_db
Metadata
Bindings
0. 171381
1. 171381
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =144377and `player_id` <>150396 limit 11.93mspadelmanager_db
Metadata
Bindings
0. 144377
1. 150396
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 (155773) 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` =144377or `team2_id` =144377orderby `competition_matches`.`id` desc3.08mspadelmanager_db
Metadata
Bindings
0. 144377
1. 144377
Hints
Use SELECT * only if you need all columns from table
select*from `competitions` where `competitions`.`id` =3074and `competitions`.`deleted_at` isnull limit 11.11mspadelmanager_db
Metadata
Bindings
0. 3074
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_groups` where `competition_category_id` =18289orderby `index` asc720μspadelmanager_db
Metadata
Bindings
0. 18289
Hints
Use SELECT * only if you need all columns from table
select*from `competition_standings` where `stage_idx` isnulland `competition_standings`.`group_id` in (33507) orderby `position` asc660μspadelmanager_db
Metadata
Hints
Use SELECT * only if you need all columns from table
select*from `team_players` where `competition_team_id` =134365and `player_id` <>150396 limit 1910μspadelmanager_db
Metadata
Bindings
0. 134365
1. 150396
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 (55476) and `players`.`deleted_at` isnull1.18mspadelmanager_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` =134365or `team2_id` =134365orderby `competition_matches`.`id` desc1.26mspadelmanager_db
Metadata
Bindings
0. 134365
1. 134365
Hints
Use SELECT * only if you need all columns from table
select*from `countries` where `active` =11.06mspadelmanager_db
Metadata
Bindings
0. 1
Hints
Use SELECT * only if you need all columns from table