Calendario de Amistosos Clubes Femenino - Temporada 2023/2024

Ver jornada

Jornada 3

07 Jul 23

Twente Fem

4 - 2

Zwolle

...

Ver jornada

Jornada 4

08 Jul 23

Leverkusen

4 - 0

Utrecht

...

Ver jornada

Jornada 5

09 Jul 23

Notts

0 - 6

Milton

...

Ver jornada

Jornada 6

15 Jul 23	PSV Fem	PSV Fem - Eindhoven 2023-07-15T13:00:00 No disponible 2 - 0	Eindhoven	...
15 Jul 23	Leverkusen	Leverkusen - Twente Fem 2023-07-15T17:00:00 No disponible 0 - 2	Twente Fem	...

Ver jornada

Jornada 7

19 Jul 23

Medyk Konin

6 - 0

Bydgoszcz

...

Ver jornada

Jornada 8

21 Jul 23

Ružomberok

10 - 2

Žilina

...

Ver jornada

Jornada 11

25 Jul 23

Luzern Fem

0 - 5

Freiburg

...

Ver jornada

Jornada 13

28 Jul 23

Feyenoord

3 - 2

Genk Fem

...

Ver jornada

Jornada 17

02 Ago 23

Kraków

1 - 0

Skra

...

Ver jornada

Jornada 18

19 Ago 23	Real	Real - Costa Adeje 2023-08-19T12:00:00 Zubieta 1 - 0	Costa Adeje	...
19 Ago 23	Barcelona	Barcelona - Montpellier 2023-08-19T19:00:00 Estadio Johan Cruyff 2 - 0	Montpellier	...

Ver jornada

Jornada 19

23 Ago 23	Racing Fem	Racing Fem - Athletic 2023-08-23T12:00:00 No disponible 0 - 3	Athletic	...
23 Ago 23	Lille Fem	Lille Fem - Lens Fem 2023-08-23T16:00:00 No disponible 3 - 0	Lens Fem	...
23 Ago 23	PSV Fem	PSV Fem - Duisburg 2023-08-23T17:00:00 No disponible 3 - 0	Duisburg	...
23 Ago 23	Uppsala	Uppsala - Hammarby 2023-08-23T17:30:00 No disponible 1 - 2	Hammarby	...
23 Ago 23	Milan Fem	Milan Fem - América 2023-08-23T18:00:00 No disponible 2 - 0	América	4
23 Ago 23	Bayern	Bayern - Hoffenheim 2023-08-23T18:00:00 No disponible 2 - 2	Hoffenheim	...
23 Ago 23	Thonon	Thonon - Grenoble 2023-08-23T18:00:00 No disponible 1 - 0	Grenoble	...
23 Ago 23	Athletic	Athletic - Madrid 2023-08-23T18:30:00 Instalaciones de Lezama 2 - 1	Madrid	...
23 Ago 23	Atlético	Atlético - River Plate 2023-08-23T21:00:00 Centro Deportivo Wanda Alcalá de Henares 6 - 0	River Plate	...

Ver jornada

Jornada 20

24 Ago 23	Leipzig	Leipzig - Rosenborg 2023-08-24T15:30:00 No disponible 2 - 0	Rosenborg	...
24 Ago 23	Eibar Fem	Eibar Fem - Costa Adeje 2023-08-24T18:30:00 No disponible 0 - 0	Costa Adeje	...
24 Ago 23	Barcelona	Barcelona - Juventus 2023-08-24T19:00:00 Estadio Johan Cruyff 5 - 0	Juventus	12
24 Ago 23	Real	Real - Sporting 2023-08-24T18:00:00 Zubieta 3 - 1	Sporting	...

Ver jornada

Jornada 21

25 Ago 23	Havre	Havre - Olympique 2023-08-25T14:00:00 No disponible 3 - 1	Olympique	...
25 Ago 23	Excelsior	Excelsior - Saestum 2023-08-25T14:00:00 No disponible 0 - 0	Saestum	...
25 Ago 23	Montpellier	Montpellier - PSG Fem 2023-08-25T15:00:00 No disponible 0 - 0	PSG Fem	...
25 Ago 23	Guingamp	Guingamp - Fleury-Mero 2023-08-25T21:00:00 No disponible 0 - 1	Fleury-Mero	...

Ver jornada

Jornada 22

Ver jornada

Jornada 23

27 Ago 23	Olympique	Olympique - Fleury-Mero 2023-08-27T11:00:00 No disponible 1 - 1	Fleury-Mero	...
27 Ago 23	Örebro	Örebro - Djurgården 2023-08-27T13:00:00 No disponible 0 - 0	Djurgården	...
27 Ago 23	Guingamp	Guingamp - Stade Reims 2023-08-27T14:00:00 No disponible 0 - 3	Stade Reims	...
27 Ago 23	Paris Fem	Paris Fem - Havre 2023-08-27T17:00:00 No disponible 0 - 2	Havre	...

Ver jornada

Jornada 24

28 Ago 23	Como Fem	Como Fem - Juventus 2023-08-28T19:30:00 No disponible 1 - 2	Juventus	...
28 Ago 23	PSG Fem	PSG Fem - Liverpool 2023-08-28T21:00:00 Stade Sébastien Charléty 1 - 1	Liverpool	...

Ver jornada

Jornada 25

29 Ago 23	Quick	Quick - Twente Fem 2023-08-29T14:00:00 No disponible 1 - 5	Twente Fem	...
29 Ago 23	Excelsior	Excelsior - Feyenoord 2023-08-29T14:00:00 No disponible 0 - 2	Feyenoord	...
29 Ago 23	Osasuna	Osasuna - Villarreal 2023-08-29T18:00:00 Tajonar 2 - 0	Villarreal	1
29 Ago 23	Villarreal	Villarreal - Real 2023-08-29T19:00:00 Ciudad Deportiva del Villarreal "Campo 5 1 - 0	Real	...
29 Ago 23	Osasuna	Osasuna - Real 2023-08-29T20:00:00 Tajonar 0 - 0	Real	...

Ver jornada

Jornada 26

30 Ago 23	Tigres UANL	Tigres UANL - Real Madrid 2023-08-30T04:00:00 No disponible 1 - 3	Real Madrid	13
30 Ago 23	América	América - Barcelona 2023-08-30T04:00:00 No disponible 0 - 2	Barcelona	18
30 Ago 23	Madrid	Madrid - Eibar Fem 2023-08-30T19:00:00 Estadio Matapiñonera 3 - 0	Eibar Fem	...
30 Ago 23	Dijon Fem	Dijon Fem - Metz 2023-08-30T17:30:00 No disponible 1 - 0	Metz	...
30 Ago 23	Montpellier	Montpellier - Saint-Étie 2023-08-30T16:00:00 No disponible 5 - 1	Saint-Étie	1
30 Ago 23	Sporting	Sporting - Brighton 2023-08-30T11:00:00 Campo Federativo de la Orden 1 - 2	Brighton	...
30 Ago 23	Real	Real - Nantes Fem 2023-08-30T16:30:00 Zubieta 1 - 2	Nantes Fem	1
30 Ago 23	Pauli	Pauli - Werder 2023-08-30T19:00:00 No disponible 0 - 10	Werder	...
30 Ago 23	Tours Fem	Tours Fem - Orleans 2023-08-30T19:00:00 No disponible 0 - 8	Orleans	...

Ver jornada

Jornada 27

31 Ago 23	Atlético	Atlético - Liverpool 2023-08-31T18:00:00 Centro Deportivo Wanda Alcalá de Henares 2 - 1	Liverpool	...
31 Ago 23	Milan Fem	Milan Fem - PSG Fem 2023-08-31T21:00:00 No disponible 1 - 2	PSG Fem	1

Ver jornada

Jornada 28

01 Sep 23	Paris Fem	Paris Fem - Saint-Étie 2023-09-01T16:00:00 No disponible 6 - 2	Saint-Étie	...
01 Sep 23	Telstar	Telstar - Excelsior 2023-09-01T14:00:00 No disponible 4 - 2	Excelsior	...
01 Sep 23	Bayern	Bayern - Fortuna 2023-09-01T18:00:00 No disponible 3 - 0	Fortuna	...
01 Sep 23	Alhama CF	Alhama CF - Málaga 2023-09-01T19:00:00 No disponible 2 - 0	Málaga	...
01 Sep 23	Villarreal	Villarreal - Aston Villa 2023-09-01T18:00:00 Ciudad Deportiva del Villarreal "Campo 5 3 - 3	Aston Villa	...
01 Sep 23	Valencia	Valencia - Zaragoza 2023-09-01T19:30:00 Antonio Puchades 6 - 1	Zaragoza	...

Ver jornada

Jornada 29

02 Sep 23	Costa Adeje	Costa Adeje - Sporting 2023-09-02T19:30:00 Estadio La Palmera 3 - 1	Sporting	...
02 Sep 23	Tigres UANL	Tigres UANL - Barcelona 2023-09-02T04:00:00 No disponible 0 - 1	Barcelona	9
02 Sep 23	Sevilla	Sevilla - Brighton 2023-09-02T11:00:00 Jesús Navas 0 - 1	Brighton	...
02 Sep 23	Essen	Essen - Haag 2023-09-02T11:00:00 No disponible 2 - 1	Haag	...
02 Sep 23	Eibar Fem	Eibar Fem - Deportivo 2023-09-02T12:00:00 No disponible 5 - 0	Deportivo	...
02 Sep 23	Leverkusen	Leverkusen - Feyenoord 2023-09-02T14:00:00 No disponible 4 - 1	Feyenoord	...
02 Sep 23	Eibar Fem	Eibar Fem - Nantes Fem 2023-09-02T18:45:00 No disponible 0 - 1	Nantes Fem	...
02 Sep 23	Hoffenheim	Hoffenheim - Freiburg 2023-09-02T15:00:00 No disponible 2 - 3	Freiburg	...
02 Sep 23	Zwolle	Zwolle - Köln Fem 2023-09-02T16:00:00 No disponible Apl	Köln Fem	...
02 Sep 23	Stade Reims	Stade Reims - Fleury-Mero 2023-09-02T16:00:00 No disponible 0 - 1	Fleury-Mero	...
02 Sep 23	Lille Fem	Lille Fem - Havre 2023-09-02T16:00:00 No disponible 2 - 1	Havre	...
02 Sep 23	Montpellier	Montpellier - Olympique 2023-09-02T17:00:00 No disponible 5 - 0	Olympique	...
02 Sep 23	Utrecht	Utrecht - Duisburg 2023-09-02T17:00:00 No disponible 4 - 3	Duisburg	...
02 Sep 23	Girondins	Girondins - Rodez Fem 2023-09-02T18:00:00 No disponible 2 - 1	Rodez Fem	...

Ver jornada

Jornada 30

03 Sep 23	América	América - Real Madrid 2023-09-03T22:00:00 No disponible 3 - 2	Real Madrid	10
03 Sep 23	Real	Real - Athletic 2023-09-03T16:00:00 Zubieta 2 - 4	Athletic	5
03 Sep 23	Wolfsburg	Wolfsburg - PSV Fem 2023-09-03T16:00:00 AOK Stadion 4 - 1	PSV Fem	...
03 Sep 23	Chelsea	Chelsea - Roma Fem 2023-09-03T21:00:00 Wheatsheaf Park 3 - 2	Roma Fem	...

Ver jornada

Jornada 31

09 Sep 23	Lille Fem	Lille Fem - Stade Reims 2023-09-09T14:00:00 No disponible 1 - 1	Stade Reims	...
09 Sep 23	Nice Fem	Nice Fem - Saint-Étie 2023-09-09T14:00:00 No disponible 1 - 1	Saint-Étie	...
09 Sep 23	Dijon Fem	Dijon Fem - Olympique 2023-09-09T17:00:00 No disponible 4 - 1	Olympique	...
09 Sep 23	Girondins	Girondins - Merignac 2023-09-09T18:30:00 No disponible 11 - 0	Merignac	...

Ver jornada

Jornada 32

10 Sep 23

ASPTT Albi

1 - 4

Rodez Fem

...

Ver jornada

Jornada 33

13 Sep 23

Man.

3 - 1

Liverpool

...

Ver jornada

Jornada 34

17 Sep 23

Leicester

1 - 3

Liverpool

...

Ver jornada

Jornada 35

21 Sep 23

Leipzig

2 - 2

Turbine

...

Ver jornada

Jornada 36

22 Sep 23

Leverkusen

4 - 0

Borussia

...

Ver jornada

Jornada 37

27 Oct 23

Leverkusen

2 - 1

Heerenveen

...

Ver jornada

Jornada 38

05 Ene 24

Man.

2 - 1

PSV Fem

1

Ver jornada

Jornada 39

05 Ene 24	Roubaix	Roubaix - Fleury-Mero 2024-01-05T19:30:00 No disponible 1 - 6	Fleury-Mero	...
06 Ene 24	Girondins	Girondins - Roche-sur-Y 2024-01-06T15:00:00 No disponible 3 - 2	Roche-sur-Y	...

Ver jornada

Jornada 40

07 Ene 24

Feyenoord

0 - 3

Arsenal

...

Ver jornada

Jornada 41

08 Ene 24

Feyenoord

1 - 3

Eintracht

...

Ver jornada

Jornada 42

09 Ene 24

Wolfsburg

2 - 0

Hoffenheim

...

Ver jornada

Jornada 43

12 Ene 24	Häcken	Häcken - Hoffenheim 2024-01-12T15:00:00 No disponible 1 - 0	Hoffenheim	...
12 Ene 24	Bayern	Bayern - Granada 2024-01-12T16:00:00 No disponible 4 - 0	Granada	...
12 Ene 24	Haag	Haag - Eintracht 2024-01-12T16:00:00 No disponible 0 - 0	Eintracht	...

Ver jornada

Jornada 44

13 Ene 24	Werder	Werder - Twente Fem 2024-01-13T13:00:00 No disponible 1 - 0	Twente Fem	...
13 Ene 24	Fortuna	Fortuna - Freiburg 2024-01-13T15:00:00 No disponible 3 - 3	Freiburg	...
13 Ene 24	Ajax Fem	Ajax Fem - Wolfsburg 2024-01-13T16:00:00 No disponible 0 - 3	Wolfsburg	...
13 Ene 24	Telstar	Telstar - Duisburg 2024-01-13T14:30:00 No disponible 1 - 3	Duisburg	...
13 Ene 24	Katowice	Katowice - Łódź 2024-01-13T12:00:00 No disponible 0 - 0	Łódź	...
13 Ene 24	Nürnberg	Nürnberg - Sparta 2024-01-13T15:00:00 No disponible 4 - 3	Sparta	...
13 Ene 24	Utrecht	Utrecht - Köln Fem 2024-01-13T13:00:00 No disponible 1 - 1	Köln Fem	...

Ver jornada

Jornada 45

14 Ene 24

Leverkusen

Apl

Haag

...

Ver jornada

Jornada 46

17 Ene 24

Baník

1 - 3

Slask

...

Ver jornada

Jornada 47

18 Ene 24

Brann Fem

11 - 0

Viking Fem

...

Ver jornada

Jornada 48

19 Ene 24	Leipzig	Leipzig - Turbine 2024-01-19T15:00:00 No disponible 3 - 1	Turbine	...
19 Ene 24	Gütersloh	Gütersloh - Werder 2024-01-19T19:00:00 No disponible 0 - 5	Werder	...
19 Ene 24	Wolfsburg	Wolfsburg - Sparta 2024-01-19T00:00:00 AOK Stadion 10 - 0	Sparta	...

Ver jornada

Jornada 49

20 Ene 24	Gütersloh	Gütersloh - Essen 2024-01-20T16:00:00 No disponible 1 - 5	Essen	...
20 Ene 24	Hammarby	Hammarby - Åland 2024-01-20T16:00:00 No disponible Apl	Åland	...
20 Ene 24	Brøndby	Brøndby - Rosengård 2024-01-20T00:00:00 No disponible 5 - 2	Rosengård	...

Ver jornada

Jornada 50

21 Ene 24	Spartak	Spartak - Slovácko 2024-01-21T14:00:00 No disponible Apl	Slovácko	...
21 Ene 24	Borussia	Borussia - Duisburg 2024-01-21T15:00:00 No disponible 0 - 5	Duisburg	...
21 Ene 24	Sparta	Sparta - Katowice 2024-01-21T14:00:00 No disponible Apl	Katowice	...
21 Ene 24	Odds Fem	Odds Fem - Kolbotn 2024-01-21T15:00:00 No disponible Apl	Kolbotn	...
21 Ene 24	Vikingur	Vikingur - Reykjavik 2024-01-21T19:30:00 No disponible 7 - 0	Reykjavik	...
21 Ene 24	Meppen	Meppen - Köln Fem 2024-01-21T14:00:00 No disponible 0 - 1	Köln Fem	...

Ver jornada

Jornada 51

24 Ene 24	Wolfsburg	Wolfsburg - Hannover 2024-01-24T19:30:00 AOK Stadion 10 - 0	Hannover	...
24 Ene 24	Diósgyőr	Diósgyőr - Lokomotiva 2024-01-24T18:00:00 No disponible 4 - 2	Lokomotiva	...
24 Ene 24	Spar Gran.	Spar Gran. - Solna 2024-01-24T20:00:00 Arguineguin 1 - 6	Solna	...

Ver jornada

Jornada 52

25 Ene 24

Stabæk

3 - 0

Honefoss

...

Ver jornada

Jornada 53

26 Ene 24

Sparta

6 - 0

Puskás

...

Ver jornada

Jornada 54

27 Ene 24	Fotball	Fotball - Vålerenga 2024-01-27T13:00:00 No disponible 2 - 2	Vålerenga	...
27 Ene 24	Austria	Austria - Slovácko 2024-01-27T14:00:00 No disponible 3 - 1	Slovácko	...
27 Ene 24	Baník	Baník - Žilina 2024-01-27T12:00:00 No disponible 6 - 1	Žilina	...
27 Ene 24	Trelleborgs	Trelleborgs - Kristiansta 2024-01-27T15:00:00 No disponible 1 - 4	Kristiansta	...
27 Ene 24	Hammarby	Hammarby - Örebro 2024-01-27T13:00:00 No disponible 2 - 2	Örebro	...
28 Ene 24	Brøndby	Brøndby - Djurgården 2024-01-28T13:00:00 No disponible 1 - 0	Djurgården	...
27 Ene 24	Koge Fem	Koge Fem - Naestved 2024-01-27T12:00:00 No disponible 6 - 0	Naestved	...
27 Ene 24	Asane Fem	Asane Fem - Fyllingsdal 2024-01-27T15:00:00 No disponible 6 - 0	Fyllingsdal	...
31 Ene 24	Røa	Røa - Honefoss 2024-01-31T18:00:00 No disponible 5 - 1	Honefoss	4
30 Ene 24	Brøndby	Brøndby - Naestved 2024-01-30T17:00:00 No disponible 4 - 0	Naestved	...

Ver jornada

Jornada 55

Ver jornada

Jornada 56

Ver jornada

Jornada 57

06 Abr 24	Häcken	Häcken - Vittsjö 2024-04-06T15:00:00 No disponible 1 - 0	Vittsjö	...
06 Abr 24	Norrkoping	Norrkoping - Gamla 2024-04-06T13:00:00 No disponible 6 - 1	Gamla	...
06 Abr 24	Brommapojka	Brommapojka - Örebro 2024-04-06T13:00:00 No disponible 0 - 0	Örebro	...
07 Abr 24	Trelleborgs	Trelleborgs - Växjö 2024-04-07T15:00:00 No disponible 0 - 2	Växjö	...
06 Abr 24	Uppsala	Uppsala - Bollstanas 2024-04-06T15:00:00 No disponible 4 - 3	Bollstanas	...
06 Abr 24	Solna	Solna - Linköping 2024-04-06T15:00:00 No disponible 1 - 1	Linköping	...
06 Abr 24	Piteå Fem	Piteå Fem - Djurgården 2024-04-06T18:00:00 No disponible 1 - 1	Djurgården	...
04 Abr 24	Utrecht	Utrecht - Telstar 2024-04-04T00:00:00 No disponible 2 - 2	Telstar	...
12 Abr 24	Alkmaar	Alkmaar - Utrecht 2024-04-12T00:00:00 No disponible 2 - 1	Utrecht	...
25 Abr 24	Köln Fem	Köln Fem - PSV Fem 2024-04-25T12:30:00 No disponible 3 - 2	PSV Fem	...

Ver jornada

Jornada 58

08 May 24

Loading Time Base Classes	0.0030
Controller Execution Time ( Home / Category )	0.1811
Total Execution Time	0.1842

0.0029	SELECT type FROM routes WHERE alias = 'amistosos_clubes_femenino2024'
0.0038	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_clubes_femenino' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1993 AND type_rel = 3
0.0023	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1993 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0030	SELECT /53 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1276502,1275794,1275496,1275499,1221941) ORDER BY n.cover_points DESC, update_date DESC
0.0054	SELECT 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, dt1.stadium as stadium_name FROM calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 73659 ORDER BY round ASC
0.0021	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 10:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 10:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0021	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 10:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 10:24:13' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0045	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_clubes_femenino' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0027	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1993 AND l.year = 2024
0.0035	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (73659) AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0051	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (73659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (347728,190731,277918,371273,378958,426462,851383,869789,3158402,3287802) ORDER BY rp.in_squad = 1 DESC
0.0019	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1993 AND l.year = 2024
0.0018	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (73659) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0025	SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (73659) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (591033,742229,3198488) ORDER BY rp.in_squad = 1 DESC
0.0018	SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1993 AND l.year = 2024
0.0019	SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (73659) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10

Amistosos Clubes Femenino 2024

Equipos de esta liga

26 Ago 23	Olympique	Olympique - Ajax Fem 2023-08-26T11:30:00 Plaine de Jeux de Gerland 1 - 2	Ajax Fem	...
26 Ago 23	Duisburg	Duisburg - Telstar 2023-08-26T14:00:00 No disponible 5 - 0	Telstar	...
26 Ago 23	Häcken	Häcken - Norrkoping 2023-08-26T13:00:00 No disponible 4 - 0	Norrkoping	...
26 Ago 23	Athletic	Athletic - Sporting 2023-08-26T14:00:00 Instalaciones de Lezama 2 - 0	Sporting	...
26 Ago 23	Freiburg	Freiburg - Eintracht 2023-08-26T14:00:00 No disponible 1 - 3	Eintracht	...
26 Ago 23	Kristiansta	Kristiansta - Växjö 2023-08-26T14:00:00 No disponible 4 - 1	Växjö	...
26 Ago 23	Metz	Metz - Saint-Étie 2023-08-26T16:00:00 No disponible 0 - 3	Saint-Étie	...
26 Ago 23	Essen	Essen - Twente Fem 2023-08-26T14:00:00 No disponible 1 - 2	Twente Fem	...
26 Ago 23	Leverkusen	Leverkusen - Fortuna 2023-08-26T15:00:00 No disponible 2 - 2	Fortuna	...
26 Ago 23	Piteå Fem	Piteå Fem - Uppsala 2023-08-26T16:30:00 No disponible 2 - 0	Uppsala	...
26 Ago 23	Utrecht	Utrecht - Köln Fem 2023-08-26T17:30:00 No disponible 3 - 3	Köln Fem	...
26 Ago 23	PSV Fem	PSV Fem - Lens Fem 2023-08-26T18:30:00 No disponible 3 - 3	Lens Fem	...
26 Ago 23	Real	Real - Deportivo 2023-08-26T18:30:00 Zubieta 4 - 0	Deportivo	2
26 Ago 23	Girondins	Girondins - Montauban 2023-08-26T20:00:00 No disponible 6 - 4	Montauban	...
26 Ago 23	Lille Fem	Lille Fem - Dijon Fem 2023-08-26T20:00:00 No disponible 0 - 3	Dijon Fem	...
26 Ago 23	Valencia	Valencia - Villarreal 2023-08-26T19:30:00 Antonio Puchades 2 - 0	Villarreal	...
26 Ago 23	Le Puy Fem	Le Puy Fem - Rodez Fem 2023-08-26T15:00:00 No disponible 2 - 5	Rodez Fem	...

17 Feb 24	Sundsvall	Sundsvall - Piteå Fem 2024-02-17T13:00:00 No disponible 1 - 4	Piteå Fem	...
03 Feb 24	Hammarby	Hammarby - Vålerenga 2024-02-03T13:00:00 No disponible 1 - 1	Vålerenga	...
03 Feb 24	Norrkoping	Norrkoping - Uppsala 2024-02-03T13:00:00 No disponible 6 - 0	Uppsala	...
03 Feb 24	Gamla	Gamla - Bollstanas 2024-02-03T13:00:00 No disponible 1 - 1	Bollstanas	...
02 Feb 24	Baník	Baník - Rekord 2024-02-02T17:00:00 No disponible 1 - 1	Rekord	...
03 Feb 24	Linköping	Linköping - Örebro 2024-02-03T15:00:00 No disponible 2 - 1	Örebro	...
03 Feb 24	Eskilstuna	Eskilstuna - Goteborg 2024-02-03T15:00:00 No disponible 2 - 4	Goteborg	...
03 Feb 24	Trelleborgs	Trelleborgs - Deportivo 2024-02-03T15:00:00 No disponible 2 - 1	Deportivo	...
03 Feb 24	Solna	Solna - Brommapojka 2024-02-03T16:00:00 No disponible 1 - 4	Brommapojka	...
10 Feb 24	Eskilstuna	Eskilstuna - Örebro 2024-02-10T13:00:00 No disponible 1 - 4	Örebro	...
10 Feb 24	Brommapojka	Brommapojka - Uppsala 2024-02-10T13:00:00 No disponible 5 - 0	Uppsala	...
10 Feb 24	Kalmar Fem	Kalmar Fem - Växjö 2024-02-10T13:00:00 No disponible 2 - 2	Växjö	...
10 Feb 24	Spartak	Spartak - Baník 2024-02-10T14:00:00 No disponible 2 - 1	Baník	...
09 Feb 24	Vålerenga	Vålerenga - Linköping 2024-02-09T14:30:00 No disponible 1 - 5	Linköping	...
10 Feb 24	Kristiansta	Kristiansta - Malmo Fem 2024-02-10T14:00:00 No disponible 5 - 0	Malmo Fem	...
10 Feb 24	Växjö	Växjö - Norrkoping 2024-02-10T14:00:00 No disponible 3 - 1	Norrkoping	...
10 Feb 24	Trelleborgs	Trelleborgs - Piteå Fem 2024-02-10T15:00:00 No disponible 2 - 3	Piteå Fem	...
10 Feb 24	Örebro	Örebro - Djurgården 2024-02-10T15:00:00 No disponible 0 - 3	Djurgården	...
14 Feb 24	Kristiansta	Kristiansta - Eskilsminne 2024-02-14T19:00:00 No disponible 2 - 1	Eskilsminne	...
15 Feb 24	Brommapojka	Brommapojka - Norrkoping 2024-02-15T15:00:00 No disponible 3 - 1	Norrkoping	...
16 Feb 24	Hammarby	Hammarby - Linköping 2024-02-16T13:00:00 No disponible 4 - 0	Linköping	...
16 Feb 24	Lillestrom	Lillestrom - Vålerenga 2024-02-16T12:00:00 No disponible 1 - 2	Vålerenga	...
16 Feb 24	Växjö	Växjö - Vittsjö 2024-02-16T15:00:00 No disponible 5 - 0	Vittsjö	...
16 Feb 24	Uppsala	Uppsala - Gamla 2024-02-16T19:00:00 No disponible 0 - 2	Gamla	...
17 Feb 24	Spartak	Spartak - Baník 2024-02-17T14:00:00 No disponible 1 - 7	Baník	...
17 Feb 24	Kristiansta	Kristiansta - Koge Fem 2024-02-17T14:00:00 No disponible 0 - 2	Koge Fem	...
17 Feb 24	Häcken	Häcken - Djurgården 2024-02-17T14:30:00 No disponible 3 - 1	Djurgården	...
17 Feb 24	Örebro	Örebro - Solna 2024-02-17T15:00:00 No disponible 1 - 2	Solna	...
17 Feb 24	Brommapojka	Brommapojka - Eskilstuna 2024-02-17T16:30:00 No disponible Apl	Eskilstuna	...
21 Feb 24	Uppsala	Uppsala - Gefle Fem 2024-02-21T19:00:00 No disponible 4 - 0	Gefle Fem	...
24 Feb 24	Norrkoping	Norrkoping - Husqvarna 2024-02-24T13:00:00 No disponible 3 - 2	Husqvarna	...
24 Feb 24	Baník	Baník - Kraków 2024-02-24T12:00:00 No disponible 2 - 2	Kraków	...
24 Feb 24	Trelleborgs	Trelleborgs - Solna 2024-02-24T15:00:00 No disponible 0 - 2	Solna	...
25 Feb 24	Örebro	Örebro - Eskilstuna 2024-02-25T15:00:00 No disponible 2 - 1	Eskilstuna	...
25 Feb 24	Rosengård	Rosengård - Brøndby 2024-02-25T13:00:00 Malmö IP Apl	Brøndby	...
17 Feb 24	Brann Fem	Brann Fem - Arna-Bjorna 2024-02-17T13:00:00 No disponible 2 - 0	Arna-Bjorna	...
24 Feb 24	Asane Fem	Asane Fem - Brann Fem 2024-02-24T13:00:00 No disponible Apl	Brann Fem	...
10 Feb 24	Kolbotn	Kolbotn - Fotball 2024-02-10T14:00:00 No disponible 1 - 0	Fotball	...
23 Feb 24	Sparta	Sparta - Slovan 2024-02-23T17:30:00 No disponible 3 - 2	Slovan	...
25 Feb 24	Kolbotn	Kolbotn - Bodo/Glimt 2024-02-25T16:30:00 No disponible 1 - 2	Bodo/Glimt	...
03 Feb 24	Piteå Fem	Piteå Fem - Umeå Fem 2024-02-03T13:45:00 No disponible Apl	Umeå Fem	...
03 Feb 24	Viking Fem	Viking Fem - Djurgården 2024-02-03T15:00:00 No disponible Apl	Djurgården	...
10 Feb 24	Piteå Fem	Piteå Fem - Sunnanå 2024-02-10T13:45:00 No disponible 2 - 0	Sunnanå	...
10 Feb 24	Åland	Åland - Solna 2024-02-10T13:00:00 No disponible 0 - 3	Solna	...
01 Feb 24	Fotball	Fotball - Odds Fem 2024-02-01T19:00:00 No disponible Apl	Odds Fem	...
02 Feb 24	Stabæk	Stabæk - Ovrevoll 2024-02-02T18:00:00 No disponible 3 - 1	Ovrevoll	...
03 Feb 24	KoldingQ	KoldingQ - Brøndby 2024-02-03T13:00:00 No disponible 0 - 2	Brøndby	...
03 Feb 24	Jitex Fem	Jitex Fem - Växjö 2024-02-03T14:00:00 No disponible 2 - 4	Växjö	...
09 Feb 24	Rosenborg	Rosenborg - Lillestrom 2024-02-09T15:00:00 No disponible 1 - 1	Lillestrom	1
13 Feb 24	Rosenborg	Rosenborg - Stabæk 2024-02-13T15:00:00 No disponible 0 - 0	Stabæk	8
02 Feb 24	Sparta	Sparta - Győri Eto 2024-02-02T17:00:00 No disponible 2 - 0	Győri Eto	...
03 Feb 24	First	First - MTK Fem 2024-02-03T00:00:00 No disponible 1 - 1	MTK Fem	...
03 Feb 24	Saku	Saku - Tabasalu 2024-02-03T00:00:00 No disponible 1 - 0	Tabasalu	...
04 Feb 24	Medyk Konin	Medyk Konin - Katowice 2024-02-04T00:00:00 No disponible 1 - 2	Katowice	...
03 Feb 24	Neulengbach	Neulengbach - Slovácko 2024-02-03T00:00:00 No disponible 1 - 0	Slovácko	...
03 Feb 24	Spartak	Spartak - Czarni 2024-02-03T00:00:00 No disponible 0 - 6	Czarni	...
13 Feb 24	Spartak	Spartak - Slovácko 2024-02-13T18:00:00 No disponible 0 - 4	Slovácko	...
10 Feb 24	Slovácko	Slovácko - Czarni 2024-02-10T16:00:00 No disponible 0 - 5	Czarni	...
17 Feb 24	Sturm Graz	Sturm Graz - Slovácko 2024-02-17T18:00:00 No disponible 2 - 0	Slovácko	...
07 Feb 24	First	First - Puskás 2024-02-07T14:00:00 No disponible 4 - 2	Puskás	...
08 Feb 24	KoldingQ	KoldingQ - Odense Fem 2024-02-08T18:30:00 No disponible 0 - 2	Odense Fem	...
13 Feb 24	Avaldsnes	Avaldsnes - Honefoss 2024-02-13T18:00:00 No disponible 3 - 1	Honefoss	...
16 Feb 24	First	First - Győri Eto 2024-02-16T14:00:00 No disponible 1 - 4	Győri Eto	...
22 Feb 24	Deportivo	Deportivo - Athletic 2024-02-22T16:30:00 No disponible 1 - 0	Athletic	...
23 Feb 24	Ljuboten	Ljuboten - Mašinac 2024-02-23T00:00:00 No disponible 4 - 3	Mašinac	...
27 Feb 24	Deportivo	Deportivo - Gotham FC 2024-02-27T23:00:00 No disponible 0 - 1	Gotham FC	...
28 Feb 24	América	América - Racing 2024-02-28T02:00:00 Pascual Guerrero 0 - 2	Racing	...
28 Feb 24	Sturm Graz	Sturm Graz - Olimpija 2024-02-28T00:00:00 No disponible 3 - 0	Olimpija	...

01 Mar 24	Växjö	Växjö - Linköping 2024-03-01T14:00:00 No disponible 1 - 2	Linköping	...
01 Mar 24	Trelleborgs	Trelleborgs - Örebro 2024-03-01T18:30:00 No disponible 1 - 1	Örebro	...
02 Mar 24	Rosengård	Rosengård - Koge Fem 2024-03-02T13:00:00 Malmö IP 1 - 0	Koge Fem	...
02 Mar 24	Djurgården	Djurgården - Brommapojka 2024-03-02T13:00:00 No disponible 1 - 2	Brommapojka	...
02 Mar 24	Eskilstuna	Eskilstuna - Uppsala 2024-03-02T13:00:00 No disponible 3 - 0	Uppsala	...
02 Mar 24	Norrkoping	Norrkoping - Hammarby 2024-03-02T14:30:00 No disponible 2 - 1	Hammarby	...
02 Mar 24	Kristiansta	Kristiansta - Örebro 2024-03-02T14:00:00 No disponible 4 - 0	Örebro	...
03 Mar 24	Vålerenga	Vålerenga - Fortuna 2024-03-03T14:00:00 No disponible 1 - 0	Fortuna	...
09 Mar 24	Vålerenga	Vålerenga - Norrkoping 2024-03-09T14:00:00 No disponible 6 - 1	Norrkoping	...
16 Mar 24	Trelleborgs	Trelleborgs - Eskilsminne 2024-03-16T15:00:00 No disponible 6 - 1	Eskilsminne	...
16 Mar 24	Eskilstuna	Eskilstuna - Mallbacken 2024-03-16T15:30:00 No disponible Apl	Mallbacken	...
23 Mar 24	Eskilstuna	Eskilstuna - Bollstanas 2024-03-23T12:00:00 No disponible 1 - 2	Bollstanas	...
23 Mar 24	Trelleborgs	Trelleborgs - Malmo Fem 2024-03-23T15:00:00 No disponible 2 - 1	Malmo Fem	...
28 Mar 24	Örebro	Örebro - Norrkoping 2024-03-28T18:00:00 No disponible 1 - 0	Norrkoping	...
29 Mar 24	Trelleborgs	Trelleborgs - Vittsjö 2024-03-29T13:00:00 No disponible 0 - 2	Vittsjö	...
29 Mar 24	Brommapojka	Brommapojka - Gamla 2024-03-29T13:30:00 No disponible 3 - 0	Gamla	...
30 Mar 24	Uppsala	Uppsala - Djurgården 2024-03-30T15:00:00 No disponible 1 - 3	Djurgården	...
24 Feb 24	Kalmar Fem	Kalmar Fem - Växjö 2024-02-24T13:00:00 No disponible 0 - 7	Växjö	...
30 Mar 24	Örebro	Örebro - Solna 2024-03-30T13:00:00 No disponible 0 - 0	Solna	...
01 Mar 24	Stabæk	Stabæk - Kolbotn 2024-03-01T18:00:00 No disponible 2 - 1	Kolbotn	...
02 Mar 24	Malmo Fem	Malmo Fem - Vittsjö 2024-03-02T14:00:00 No disponible 0 - 0	Vittsjö	...
08 Mar 24	Kolbotn	Kolbotn - Honefoss 2024-03-08T19:30:00 No disponible 2 - 1	Honefoss	...
02 Mar 24	Solna	Solna - Helsinki 2024-03-02T13:00:00 No disponible 5 - 1	Helsinki	...
02 Mar 24	Piteå Fem	Piteå Fem - Sunnanå 2024-03-02T13:45:00 No disponible 2 - 0	Sunnanå	...
02 Mar 24	Røa	Røa - Fotball 2024-03-02T14:00:00 No disponible 1 - 0	Fotball	...
08 Mar 24	Stabæk	Stabæk - Rosenborg 2024-03-08T15:00:00 No disponible 0 - 2	Rosenborg	...
09 Mar 24	Fotball	Fotball - Lillestrom 2024-03-09T14:00:00 No disponible 0 - 0	Lillestrom	...
03 Mar 24	Zalgiris	Zalgiris - Flora 2024-03-03T14:00:00 No disponible 0 - 2	Flora	...
09 Mar 24	PK-35	PK-35 - Flora 2024-03-09T13:00:00 No disponible Apl	Flora	...
13 Mar 24	Flora	Flora - Viimsi 2024-03-13T18:00:00 No disponible 4 - 4	Viimsi	...
16 Mar 24	Riga	Riga - Flora 2024-03-16T14:00:00 No disponible 2 - 0	Flora	...
10 Mar 24	Gintra-Univ	Gintra-Univ - Saku 2024-03-10T16:00:00 No disponible Apl	Saku	...
01 Mar 24	América	América - Deportivo 2024-03-01T23:30:00 Pascual Guerrero 1 - 0	Deportivo	...
02 Mar 24	Gotham FC	Gotham FC - Racing 2024-03-02T02:30:00 No disponible 3 - 1	Racing	...
09 Mar 24	Trelleborgs	Trelleborgs - Helsingborg 2024-03-09T15:00:00 No disponible 2 - 0	Helsingborg	...
09 Mar 24	Asane Fem	Asane Fem - Avaldsnes 2024-03-09T13:00:00 No disponible 3 - 0	Avaldsnes	...
17 Mar 24	Norrkoping	Norrkoping - Malmo Fem 2024-03-17T15:00:00 No disponible 1 - 1	Malmo Fem	...