| 0.0252 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera-rfef-ascenso' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1 |
| 0.0125 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2618 AND type_rel = 3 |
| 0.0128 | SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=2470 ORDER BY l.group_code ASC |
| 0.0124 | SELECT type,rule FROM rules WHERE categoryId = 2618 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 16:10:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0126 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 16:10:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 16:10:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0126 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 16:10:22' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0132 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'tercera-rfef-ascenso' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0126 | SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 71489 AND esl.points > 0 |
| 0.0137 | SELECT c.isVideo, c.id,c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.betId,c.betId_wh,c.betId_bwin,c.betId_marca,c.betId_888, c.betId_sportium, c.betId_marathon, c.finished, c.penaltis1, c.penaltis2, c.prorroga, c.status, c.minute, dt1.stadium as stadium_name FROM `calendars2023` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 71489 AND c.`round` = 3 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200 |
| 0.0145 | SELECT ev.match_id,dp.alias,ev.minute,ev.action,ev.player_id,e.name,e.classf,dp.nick,rel.squadNumber,rel.player_id as playerId,rel.team_id,rel.teamId FROM events2023 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2023 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 71489 AND (ev.team1id=rel.team_id OR ev.team2id=rel.team_id) INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE ev.match_id IN (841134,841135,841088,841089,841086,841087,841090,841131,841136,841137,841138,841139,841140,841141,841084,841085,841132,841133) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC |
| 0.0128 | SELECT distinct(shedule), round FROM `calendars2023` as c WHERE c.`league_id` = 71489 AND shedule >= '2023/05/01' AND shedule < '2023/06/01' ORDER BY shedule ASC |
| 0.0124 | SELECT data1, data2 FROM services_tags WHERE categoryId=2618 |
| 0.0125 | SELECT group_code, extraName from `leagues` WHERE categoryId=2618 AND year=2023 |
GolPlus TV
Arkaitz
Real Jaén
UE Sant Andreu
L´Hospitalet
CD Basconia
Poblense
Arosa
At. Malagueño
Peña Sport
Real Ávila
Manacor
Sporting Atlético
Ejea
Las Palmas At.
Atl. Astorga
Moralo
Salamanca UDS
Lanzarote
Tropezón
UM Escobedo
CD Varea
Jerez
At. Levante
Rápido de Bouzas
Torrent
L´Entregu CF
CD Praviano
El Palo FC
CD Quintanar del Rey
Deusto
Paracuellos Antamira
Leioa
Santanyi
Getafe B
Olivenza
CF Peralada
CF Vimenor
CD Azuaga
Córdoba CF B
Lorca Deportiva
Villa Santa Brígida
CD Móstoles
Anguiano
Atlético Albericia
At. Pulpileño
Atlético Tordesillas
CD Itaroa Huarte
CD Illescas
Ciudad de Lucena
Villarrubia CF
CD Vitoria