Publicidad 600x120.gif
FA Cup
 
19 Ago 23
16:00 Finalizado
West Allotment Celtic West Allotment Celtic 0-2 Tadcaster Albion Tadcaster Albion más información ...
 
19 Ago 23
16:00 Finalizado
Bishop Auckland Bishop Auckland 7-0 Seaham Red Star Seaham Red Star más información 1
 
19 Ago 23
16:00 Finalizado
West Auckland Town West Auckland Town 4-0 Shildon AFC Shildon AFC más información 1
 
18 Ago 23
20:30 Finalizado
Whickham Whickham 1-1 Whitley Bay Whitley Bay más información 1
 
22 Ago 23
20:30 Finalizado
Whitley Bay Whitley Bay 0-3 Whickham Whickham más información 1
Global
Whickham 4 - 1 Whitley Bay
 
19 Ago 23
16:00 Finalizado
Pontefract Collieries Pontefract Collieries 1-3 Guisborough Town Guisborough Town más información 1
 
19 Ago 23
16:00 Finalizado
Penrith AFC Penrith AFC 0-3 Consett AFC Consett AFC más información 1
 
19 Ago 23
16:00 Finalizado
Irlam Irlam 3-3 Goole Goole más información 1
 
22 Ago 23
20:45 Finalizado
Goole Goole 1-0 Irlam Irlam más información 1
Global
Irlam 3 - 4 Goole
 
19 Ago 23
16:00 Finalizado
Burscough Burscough 0-1 Albion Sports Albion Sports más información 1
 
08 Ago 23
20:45 Finalizado
Chadderton Chadderton 0-3 Albion Sports Albion Sports más información 1
 
19 Ago 23
16:00 Finalizado
Widnes Widnes 2-1 Trafford Trafford más información 1
 
19 Ago 23
16:00 Finalizado
Ossett United Ossett United 2-0 Wythenshawe Amateurs Wythenshawe Amateurs más información 1
 
23 Ago 23
21:00 Finalizado
Lower Breck Lower Breck 1-5 AFC Emley AFC Emley más información 1
 
19 Ago 23
16:00 Finalizado
Atherstone Town Atherstone Town 2-0 Gresley Gresley más información ...
 
19 Ago 23
16:00 Finalizado
Penistone Church Penistone Church 0-2 Prestwich Heys Prestwich Heys más información 1
 
19 Ago 23
16:00 Finalizado
West Didsbury Chorlton West Didsbury Chorlton 0-3 Prescot Cables Prescot Cables más información 1
 
19 Ago 23
16:00 Finalizado
Whitchurch Alport Whitchurch Alport 1-1 Barnoldswick Town Barnoldswick Town más información 1
 
22 Ago 23
21:00 Finalizado
Barnoldswick Town Barnoldswick Town 5-0 Whitchurch Alport Whitchurch Alport más información 1
Global
Whitchurch 1 - 6 Barnoldswick
 
19 Ago 23
16:00 Finalizado
Rugby Town Rugby Town 5-1 Newcastle Town Newcastle Town más información 1
 
19 Ago 23
16:00 Finalizado
Hanley Town Hanley Town 2-2 Stourport Swifts Stourport Swifts más información 1
 
22 Ago 23
20:45 Finalizado
Stourport Swifts Stourport Swifts 1-2 Hanley Town Hanley Town más información 1
Global
Hanley Town 4 - 3 Stourport
 
19 Ago 23
16:00 Finalizado
Kidsgrove Athletic Kidsgrove Athletic 2-0 Sutton Coldfield Town Sutton Coldfield Town más información 1
 
19 Ago 23
16:00 Finalizado
Westfields Westfields 1-2 Worcester City Worcester City más información 1
 
19 Ago 23
16:00 Finalizado
Shifnal Town Shifnal Town 4-1 Worcester Raiders Worcester Raiders más información ...
 
19 Ago 23
16:00 Finalizado
Grimsby Borough Grimsby Borough 4-2 Melton Town Melton Town más información ...
 
19 Ago 23
16:00 Finalizado
Woodbridge Town Woodbridge Town 0-1 Gorleston Gorleston más información 1
 
19 Ago 23
18:30 Finalizado
Sherwood Colliery Sherwood Colliery 3-1 Grantham Town Grantham Town más información ...
 
19 Ago 23
16:00 Finalizado
Carlton Town Carlton Town 3-0 Maltby Main Maltby Main más información 1
 
19 Ago 23
16:00 Finalizado
Bury Town Bury Town 1-2 Wroxham Wroxham más información ...
 
19 Ago 23
16:00 Finalizado
Bottesford Town Bottesford Town 0-4 Lincoln United FC Lincoln United FC más información 1
 
19 Ago 23
16:00 Finalizado
Kirkley & Pakefield Kirkley & Pakefield 2-1 Ely City Ely City más información 1
 
19 Ago 23
16:00 Finalizado
Mildenhall Town FC Mildenhall Town FC 1-0 Lakenheath FC Lakenheath FC más información 1
 
19 Ago 23
16:00 Finalizado
Ashby Ivanhoe Ashby Ivanhoe 1-0 Rossington Main Rossington Main más información 1
 
19 Ago 23
16:00 Finalizado
Newmarket Town Newmarket Town 1-4 Cambridge City Cambridge City más información ...
 
19 Ago 23
16:00 Finalizado
Anstey Nomads Anstey Nomads 2-1 Eastwood Community Eastwood Community más información 1
 
18 Ago 23
20:45 Finalizado
Ipswich Wanderers Ipswich Wanderers 0-0 Dereham Town Dereham Town más información 1
 
22 Ago 23
20:45 Finalizado
Dereham Town Dereham Town 2-1 Ipswich Wanderers Ipswich Wanderers más información 1
Global
Ipswich 1 - 2 Dereham Town
 
19 Ago 23
16:00 Finalizado
Sawbridgeworth Town Sawbridgeworth Town 2-1 Saffron Walden Town FC Saffron Walden Town FC más información 1
 
19 Ago 23
16:00 Finalizado
Witham Town Witham Town 3-0 Stanway Rovers FC Stanway Rovers FC más información 1
 
19 Ago 23
16:00 Finalizado
Colney Heath Colney Heath 2-5 FC Romania FC Romania más información 1
 
19 Ago 23
16:00 Finalizado
Maldon & Tiptree Maldon & Tiptree 0-0 West Essex West Essex más información ...
 
22 Ago 23
20:45 Finalizado
West Essex West Essex 0-3 Maldon & Tiptree Maldon & Tiptree más información 1
Global
Maldon 3 - 0 West Essex
 
19 Ago 23
16:00 Finalizado
Hullbridge Sports Hullbridge Sports 3-1 Waltham Abbey Waltham Abbey más información 1
 
19 Ago 23
16:00 Finalizado
East Thurrock United FC East Thurrock United FC 1-1 Barton Rovers Barton Rovers más información 1
 
23 Ago 23
20:45 Finalizado
Barton Rovers Barton Rovers 3-2 East Thurrock United FC East Thurrock United FC más información 1
Global
East 3 - 4 Barton
 
19 Ago 23
16:00 Finalizado
Leighton Town Leighton Town 1-0 Enfield FC Enfield FC más información 1
 
19 Ago 23
16:00 Finalizado
Ascot United Ascot United 5-1 Mangotsfield United Mangotsfield United más información ...
 
19 Ago 23
16:00 Finalizado
Hinckley LR Hinckley LR 2-1 Bewdley Town Bewdley Town más información 1
 
19 Ago 23
16:00 Finalizado
Bristol Manor Farm Bristol Manor Farm 4-1 Roman Glass St. George Roman Glass St. George más información 1
 
19 Ago 23
16:00 Finalizado
Charnock Richard Charnock Richard 3-2 Bury Bury más información ...
 
20 Ago 23
16:00 Finalizado
Virginia Water Virginia Water 1-5 Cribbs Cribbs más información 1
 
18 Ago 23
20:45 Finalizado
Aylesbury United Aylesbury United 0-2 Clevedon Town Clevedon Town más información 1
 
19 Ago 23
16:00 Finalizado
Easington Sports Easington Sports 2-2 Reading City Reading City más información 1
 
21 Ago 23
20:45 Finalizado
Reading City Reading City 4-0 Easington Sports Easington Sports más información 1
Global
Easington 2 - 6 Reading City
 
19 Ago 23
16:00 Finalizado
Walsall Wood Walsall Wood 0-1 Rugby Borough Rugby Borough más información 1
 
15 Ago 23
Finalizado
Aylesbury Aylesbury 0-3 Tuffley Rovers Tuffley Rovers más información 1
 
19 Ago 23
13:30 Finalizado
Horley Town Horley Town 0-1 Croydon Athletic Croydon Athletic más información 1
 
19 Ago 23
16:00 Finalizado
Erith & Belvedere Erith & Belvedere 2-0 Stansfeld Stansfeld más información 1
 
19 Ago 23
16:00 Finalizado
Newhaven Newhaven 7-1 Spelthorne Sports Spelthorne Sports más información 1
 
19 Ago 23
16:00 Finalizado
Eastbourne United Eastbourne United 3-0 Sheerwater Sheerwater más información 1
 
19 Ago 23
16:00 Finalizado
Faversham Town Faversham Town 2-1 Merstham Merstham más información 1
 
19 Ago 23
16:00 Finalizado
Steyning Town Steyning Town 3-0 Peacehaven & Telscombe Peacehaven & Telscombe más información ...
 
19 Ago 23
16:00 Finalizado
Jersey Bulls FC Jersey Bulls FC 1-1 Knaphill Knaphill más información 1
 
22 Ago 23
20:45 Finalizado
Knaphill Knaphill 1-0 Jersey Bulls FC Jersey Bulls FC más información 1
Global
Jersey Bulls 1 - 2 Knaphill
 
19 Ago 23
16:00 Finalizado
Burgess Hill Town Burgess Hill Town 0-0 Erith Town Erith Town más información 1
 
22 Ago 23
20:45 Finalizado
Erith Town Erith Town 1-2 Burgess Hill Town Burgess Hill Town más información 1
Global
Burgess Hill 2 - 1 Erith Town
 
19 Ago 23
16:00 Finalizado
Cobham FC Cobham FC 0-4 Kennington Kennington más información 1
 
19 Ago 23
16:00 Finalizado
Redhill Redhill 1-0 Ashford Town Ashford Town más información 1
 
19 Ago 23
16:00 Finalizado
Badshot Lea FC Badshot Lea FC 2-3 Lancing Lancing más información 1
 
19 Ago 23
16:00 Finalizado
Sevenoaks Town Sevenoaks Town 3-0 Colliers Wood United Colliers Wood United más información 1
 
19 Ago 23
16:00 Finalizado
Bearsted Bearsted 1-2 Southall Southall más información ...
 
19 Ago 23
16:00 Finalizado
Nailsea and Tickenham Nailsea and Tickenham 0-3 Highworth Town Highworth Town más información 1
 
19 Ago 23
16:00 Finalizado
VCD Athletic VCD Athletic 0-2 Whitstable Town Whitstable Town más información 1
 
19 Ago 23
16:00 Finalizado
Real Bedford Real Bedford 3-4 Milton Keynes Irish Milton Keynes Irish más información 1
 
19 Ago 23
16:00 Finalizado
Petersfield Town Petersfield Town 1-1 Bemerton Heath Bemerton Heath más información 1
 
22 Ago 23
20:45 Finalizado
Bemerton Heath Bemerton Heath 2-3 Petersfield Town Petersfield Town más información 1
Global
Petersfield 4 - 3 Bemerton
 
19 Ago 23
16:00 Finalizado
Shaftesbury Town Shaftesbury Town 5-2 Hamble Club Hamble Club más información 1
 
19 Ago 23
16:00 Finalizado
Athletic Newham Athletic Newham 0-3 Westfield (Surrey) Westfield (Surrey) más información 2
 
19 Ago 23
16:00 Finalizado
United Services Portsmouth United Services Portsmo. 0-2 Larkhall Athletic Larkhall Athletic más información 1
 
19 Ago 23
16:00 Finalizado
Horndean Horndean 3-0 Brockenhurst Brockenhurst más información 1
 
19 Ago 23
16:00 Finalizado
Blackfield & Langley Blackfield & Langley 0-5 Laverstock Ford Laverstock Ford más información 1
 
19 Ago 23
16:00 Finalizado
Stoneham Stoneham 5-1 Melksham Town Melksham Town más información 1
 
19 Ago 23
16:00 Finalizado
Tadley Calleva Tadley Calleva 1-8 AFC Portchester AFC Portchester más información 1
 
19 Ago 23
16:00 Finalizado
Farnham Town Farnham Town 2-0 Crowborough Athletic Crowborough Athletic más información ...
 
28 Ago 23
16:00 Finalizado
Lydd Town FC Lydd Town FC 4-2 Deal Town Deal Town más información 3
 
19 Ago 23
16:00 Finalizado
Bideford Bideford 4-0 Helston Athletic Helston Athletic más información 1
 
18 Ago 23
20:45 Finalizado
Bridgwater Town Bridgwater Town 4-0 Street FC Street FC más información 1
 
19 Ago 23
16:00 Finalizado
St Blazey St Blazey 1-5 Mousehole AFC Mousehole AFC más información 1
 
19 Ago 23
16:00 Finalizado
Belper Town FC Belper Town FC 2-5 Leek Town Leek Town más información 2
 
19 Ago 23
16:00 Finalizado
Brentwood Town Brentwood Town 2-1 Kings Langley Kings Langley más información ...
 
19 Ago 23
16:00 Finalizado
Corby Town Corby Town 0-4 Lowestoft Town Lowestoft Town más información ...
 
19 Ago 23
16:00 Finalizado
Runcorn Linnets Runcorn Linnets 3-2 Stalybridge Celtic Stalybridge Celtic más información 1
 
19 Ago 23
16:00 Finalizado
Buckland Athletic Buckland Athletic 1-1 Okehampton Argyle Okehampton Argyle más información 1
 
22 Ago 23
20:30 Finalizado
Okehampton Argyle Okehampton Argyle 2-1 Buckland Athletic Buckland Athletic más información 1
Global
Buckland 2 - 3 Okehampton
 
19 Ago 23
16:00 Finalizado
South Park FC South Park FC 1-1 Leatherhead Leatherhead más información 1
 
22 Ago 23
20:45 Finalizado
Leatherhead Leatherhead 2-1 South Park FC South Park FC más información 2
Global
South Park 2 - 3 Leatherhead
 
18 Ago 23
20:45 Finalizado
Hebburn Town Hebburn Town 0-2 Heaton Stannington Heaton Stannington más información 1
 
19 Ago 23
16:00 Finalizado
Knaresborough Town Knaresborough Town 1-3 Dunston UTS Dunston UTS más información 1
 
19 Ago 23
16:00 Finalizado
Stockton Town Stockton Town 2-1 Ashington AFC Ashington AFC más información 1
 
19 Ago 23
16:00 Finalizado
Liversedge Liversedge 0-1 North Ferriby United North Ferriby United más información ...
 
19 Ago 23
16:00 Finalizado
Colne FC Colne FC 1-3 Brighouse Town Brighouse Town más información ...
 
19 Ago 23
16:00 Finalizado
Mossley Mossley 1-0 Ramsbottom United Ramsbottom United más información 1
 
19 Ago 23
16:00 Finalizado
Congleton Town FC Congleton Town FC 1-2 Witton Albion Witton Albion más información 1
 
19 Ago 23
16:00 Finalizado
Padiham Padiham 2-5 Clitheroe Clitheroe más información 1
 
18 Ago 23
20:45 Finalizado
Skelmersdale United Skelmersdale United 0-6 Nantwich Town Nantwich Town más información 1
 
19 Ago 23
16:00 Finalizado
Boldmere St. Michaels Boldmere St. Michaels 1-0 Chasetown Chasetown más información 1
 
19 Ago 23
16:00 Finalizado
Darlaston Town Darlaston Town 3-0 Hednesford Town Hednesford Town más información 1
 
19 Ago 23
16:00 Finalizado
Sporting Khalsa Sporting Khalsa 6-1 Heanor Town FC Heanor Town FC más información ...
 
18 Ago 23
21:00 Finalizado
Studley FC Studley FC 0-1 Coleshill Town FC Coleshill Town FC más información 1
 
19 Ago 23
16:00 Finalizado
Mulbarton Wanderers Mulbarton Wanderers 1-5 Bedford Town Bedford Town más información 1
 
19 Ago 23
16:00 Finalizado
Wellingborough Town Wellingborough Town 1-4 Felixstowe & Walton Utd Felixstowe & Walton Utd más información ...
 
19 Ago 23
16:00 Finalizado
Brightlingsea Regent Brightlingsea Regent 5-0 Stansted Stansted más información 1
 
19 Ago 23
16:00 Finalizado
Bowers and Pitsea Bowers and Pitsea 2-2 Woodford Town Woodford Town más información 1
 
23 Ago 23
20:45 Finalizado
Woodford Town Woodford Town 4-3 Bowers and Pitsea Bowers and Pitsea más información 1
Global
Bowers 5 - 6 Woodford
 
19 Ago 23
16:00 Finalizado
Heybridge Swifts Heybridge Swifts 2-0 Barking Barking más información 1
 
19 Ago 23
16:00 Finalizado
Wisbech Town Wisbech Town 1-5 Biggleswade Town Biggleswade Town más información 1
 
19 Ago 23
16:00 Finalizado
Ware Ware 2-1 AFC Dunstable AFC Dunstable más información 1
 
19 Ago 23
16:00 Finalizado
Romford Romford 1-3 Welwyn Garden City Welwyn Garden City más información 1
 
19 Ago 23
16:00 Finalizado
Walthamstow Walthamstow 3-1 Leverstock Green Leverstock Green más información 1
 
19 Ago 23
16:00 Finalizado
Flackwell Heath Flackwell Heath 2-0 Cirencester Town Cirencester Town más información 1
 
19 Ago 23
16:00 Finalizado
Holyport Holyport 0-1 Yate Town Yate Town más información 1
 
19 Ago 23
16:00 Finalizado
Corinthian-Casuals Corinthian-Casuals 2-2 Uxbridge Uxbridge más información 1
 
23 Ago 23
20:45 Finalizado
Uxbridge Uxbridge 5-1 Corinthian-Casuals Corinthian-Casuals más información 2
Global
Corinthian-C 3 - 7 Uxbridge
 
19 Ago 23
16:00 Finalizado
Lordswood FC Lordswood FC 1-1 Cray Valley PM Cray Valley PM más información ...
 
22 Ago 23
20:45 Finalizado
Cray Valley PM Cray Valley PM 4-1 Lordswood FC Lordswood FC más información 1
Global
Lordswood 2 - 5 Cray Valley
 
19 Ago 23
16:00 Finalizado
East Grinstead Town East Grinstead Town 1-3 Hythe Town Hythe Town más información 1
 
19 Ago 23
16:00 Finalizado
Bedfont Sports Bedfont Sports 1-1 Herne Bay Herne Bay más información 1
 
22 Ago 23
20:45 Finalizado
Herne Bay Herne Bay 3-0 Bedfont Sports Bedfont Sports más información 1
Global
Bedfont 1 - 4 Herne Bay
 
19 Ago 23
16:00 Finalizado
Sheppey United Sheppey United 3-0 Midhurst & Easebourne Midhurst & Easebourne más información 1
 
18 Ago 23
20:45 Finalizado
Epsom & Ewell Epsom & Ewell 0-0 Metropolitan Police Metropolitan Police más información 1
 
22 Ago 23
20:45 Finalizado
Metropolitan Police Metropolitan Police 0-2 Epsom & Ewell Epsom & Ewell más información 1
Global
Epsom Ewell 2 - 0 Metropolitan
 
19 Ago 23
16:00 Finalizado
Ashford United Ashford United 2-3 Beckenham Town Beckenham Town más información ...
 
19 Ago 23
16:00 Finalizado
Fareham Town Fareham Town 2-3 Bashley Bashley más información ...
 
19 Ago 23
16:00 Finalizado
Hamworthy United Hamworthy United 1-2 Moneyfields Moneyfields más información 1
 
19 Ago 23
16:00 Finalizado
Wimborne Town Wimborne Town 0-0 Paulton Rovers Paulton Rovers más información 1
 
22 Ago 23
20:30 Finalizado
Paulton Rovers Paulton Rovers 0-2 Wimborne Town Wimborne Town más información 1
Global
Wimborne 2 - 0 Paulton
 
19 Ago 23
16:00 Finalizado
Falmouth Town Falmouth Town 2-6 Frome Town Frome Town más información 1
 
19 Ago 23
16:00 Finalizado
Tavistock Tavistock 3-5 Barnstaple Town Barnstaple Town más información 1
 
19 Ago 23
16:00 Finalizado
Snodland Town Snodland Town 1-3 Chertsey Town Chertsey Town más información ...
 
19 Ago 23
16:00 Finalizado
Wallingford & Crowmarsh Wallingford & Crowmarsh 0-1 Marlow FC Marlow FC más información 1
 
19 Ago 23
16:00 Finalizado
Spalding United Spalding United 1-1 Shepshed Shepshed más información 1
 
22 Ago 23
20:45 Finalizado
Shepshed Shepshed 2-3 Spalding United Spalding United más información 1
Global
Spalding 4 - 3 Shepshed
 
19 Ago 23
16:00 Finalizado
Kempston Rovers Kempston Rovers 1-3 Biggleswade Biggleswade más información 1
 
19 Ago 23
16:00 Finalizado
Stocksbridge Park Steels Stocksbridge Park Steels 0-1 Cleethorpes Town Cleethorpes Town más información ...
 
19 Ago 23
16:00 Finalizado
Fakenham Town Fakenham Town 1-0 Rushden & Diamonds Rushden & Diamonds más información ...
 
19 Ago 23
16:00 Finalizado
Stowmarket Town Stowmarket Town 2-1 Potton United Potton United más información ...
 
19 Ago 23
16:00 Finalizado
Hadley Hadley 6-2 Little Oakley Little Oakley más información ...
 
19 Ago 23
16:00 Finalizado
Buckhurst Hill Buckhurst Hill 0-1 Northwood Northwood más información 1
 
19 Ago 23
16:00 Finalizado
North Leigh North Leigh 1-2 Bishop's Cleeve Bishop's Cleeve más información 1
 
18 Ago 23
20:45 Finalizado
Wokingham and Emmbrook Wokingham and Emmbrook 0-2 Binfield Binfield más información 1
 
19 Ago 23
16:00 Finalizado
Ramsgate Ramsgate 4-1 Bexhill United Bexhill United más información 1
 
19 Ago 23
16:00 Finalizado
Crawley Down Gatwick Crawley Down Gatwick 3-6 Hanworth Villa FC Hanworth Villa FC más información 1
 
19 Ago 23
16:00 Finalizado
Newark Flowserve Newark Flowserve 0-4 Harborough Town Harborough Town más información ...
 
19 Ago 23
16:00 Finalizado
Sheffield FC Sheffield FC 2-1 Skegness Skegness más información 1
 
19 Ago 23
16:00 Finalizado
Grays Athletic Grays Athletic 1-1 New Salamis New Salamis más información ...
 
23 Ago 23
20:45 Finalizado
New Salamis New Salamis 3-1 Grays Athletic Grays Athletic más información 1
Global
Grays 2 - 4 New Salamis
 
19 Ago 23
16:00 Finalizado
Evesham United Evesham United 2-0 Tuffley Rovers Tuffley Rovers más información ...
 
19 Ago 23
16:00 Finalizado
Hartley Wintney Hartley Wintney 3-1 Sherborne Town Sherborne Town más información ...

INFORMACIÓN
La FA Cup (Football Association Challenge Cup), o la Copa de Inglaterra es una competición anual de fútbol de Inglaterra, en la que participan actualmente más de 700 equipos. Es considerada como la copa doméstica más prestigiosa del mundo. La primera vez que se disputó la FA Cup fue en 1871. Es la competición futbolística más antigua del mundo.
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
7,795,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.7944
Total Execution Time  0.7964
  CADENA URL  
/fa_cup/grupo0/jornada2
  GET DATOS  
$_GET['/fa_cup/grupo0/jornada2']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0105  SELECT type FROM routes WHERE alias = 'fa_cup'
0.0212  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'fa_cup' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0134  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72728 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0108  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=10 ORDER BY l.group_code ASC
0.0105  SELECT type,rule FROM rules WHERE categoryId = 139 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC
0.0111  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-03-29 12:48:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0105  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-03-29 12:48:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-03-29 12:48:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-03-29 12:48:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0110  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'fa_cup' 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.0108  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 2024
0.0115  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72728) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (206116,326208,427681,474838,711855,838122,246526,276437,293923,3728,68716,126886,139482,192089,209959,247614,287241,312464,353087,366112) ORDER BY rp.in_squad = 1 DESC
0.0109  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 2024
0.0113  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72728) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0113  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (205025,372642,443554,919213,27125,42921,46887,70617,86046,100786,137949,138775,191340,199600,204722,209557,209897,244140,245174,247614) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 2024
0.0106  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72728) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0112  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (47562,100786,193747,209874,251613,292534,303500,304210,318871,372642,373673,427682,455592,557566,588357,693114,839573,889241,900917,978557) ORDER BY rp.in_squad = 1 DESC
0.0107  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 139 AND l.year = 2024
0.0110  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72728) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20
0.0110  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 (72728) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (69174,106034,191712,274722,335442,346982,428278,518770,878191,879202,30654,38717,44129,67022,70617,118827,205651,206428,214957,243396) ORDER BY rp.in_squad = 1 DESC
0.1127  SELECT SUM(rp.lineup) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 139 AND rp.year = 2024 AND rp.lineup > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.1289  SELECT SUM(rp.events) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.category_id = 139 AND rp.year = 2024 AND rp.events > 0 GROUP BY p.id ORDER BY total DESC,p.pod DESC LIMIT 20
0.0106  SELECT rel.media_id, rel.team1, rel.team2, m.name, m.type, m.lang, m.location, rel.id AS rel_id, m.url FROM rel_media_match AS rel INNER JOIN media AS m ON m.id=rel.media_id WHERE (m.lang='es' OR m.language='spanish') AND rel.active=1 AND rel.league_id=72728 AND rel.round=2
0.0106  SELECT u.id,u.user_name, esl.points,up.name,up.surname,up.nick,u.changeA 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 = 72728 AND esl.points > 0 ORDER BY esl.points DESC LIMIT 3
0.0105  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 = 72728 AND esl.points > 0
0.0105  SELECT fau.user_name, c.*, NOW() as difference_time,creation_date FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id LEFT JOIN fa_user fau ON fau.id = c.author_id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and c.comment_id is null and c.lang = 1 AND l.`id` = 72728 ORDER BY creation_date DESC LIMIT 0, 10
0.0130  SELECT count(c.id) as cuenta FROM (leagues as l) INNER JOIN comments as c ON c.league_id = l.id WHERE c.creation_date > "2024-02-28" AND c.`active`= 1 and comment_id is null and c.lang = 1 AND l.`id` = 72728
0.0115  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 `calendars2024` 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` = 72728 AND c.`round` = 2 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 200
0.0120  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 events2024 ev INNER JOIN events e ON e.id = ev.action INNER JOIN calendars2024 c ON c.id = ev.match_id INNER JOIN rel_players rel ON rel.player_id = ev.player_id AND rel.league_id = 72728 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 (472968,472911,472969,472971,503102,499163,472949,481580,503108,490315,481558,481604,481590,503121,472907,490321,472970,472972,503103,481594,481576,503115,481582,481603,472953,481574,472975,481596,490316,472917,472913,481583,481586,472905,481588,481561,481579,503106,472951,481605,481570,472944,503116,481578,472925,503117,481584,481562,472936,490314,472918,472963,490313,472923,503100,481602,472866,481577,481572,472947,472926,472931,481598,481581,503110,481568,503107,481569,481593,472908,490322,481564,490320,472962,499164,481591,503104,481595,481563,472961,472938,481565,472904,481601,472930,472942,472910,472915,472957,159792,159793,159794,159795,481567,503101,159796,503111,472934,472939,472958,472940,472919,472945,472920,472948,472954,472912,472922,472956,472959,472946,472967,472916,472914,503120,472935,472974,472966,472950,472965,472932,472937,472921,503119,472941,503105,472924,472909,503109,472952,472927,503112,472906,472929,472933,472973,503113,472928,472960,472955,472964,481597,503114,481560,481599,481573,481600,481575,481566,481589,481606,481592,481571,481587,490323,490318,503118,490317,490319) AND ev.action in (1,2,3,4,6,11,12,13,15) ORDER BY ev.minute ASC
0.0126  SELECT (dt1.qod+dt2.qod+dt1.relations+dt2.relations) as total,c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.main_action = 1 AND c.round = 2 AND e.real_date IS NOT NULL AND e.league_id = 72728 ORDER BY total DESC LIMIT 40
0.0117  SELECT c.r1,c.r2,e.action,ev.showName as eventName,ev.largeName,ev.main_action,ev.keyname,ev.classf,e.real_date,e.minute, dp.nick,dp.CountryCode,dp.alias,c.datateam1,c.datateam2,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,e.player_id,e.match_id FROM `events2024` e INNER JOIN calendars2024 c ON c.id = e.match_id INNER JOIN events ev ON ev.id = e.action INNER JOIN dataplayers dp ON dp.id = e.player_id INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE ev.show_on = 1 AND e.real_date IS NOT NULL AND e.league_id = 72728 AND e.real_date > NOW() - INTERVAL 1 MONTH ORDER BY e.real_date DESC LIMIT 30
0.0115  SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72728 AND shedule >= '2023/08/01' AND shedule < '2023/09/01' ORDER BY shedule ASC
0.0105  SELECT c.id, 2024 AS year, IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef FROM `calendars2024` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round WHERE c.`shedule` > '2024-03-29 00:00:00' AND c.`shedule` < '2024-04-02 23:59:59' AND l.id = 72728 ORDER BY c.shedule ASC, fcoef DESC LIMIT 5
0.0107  SELECT data1, data2 FROM services_tags WHERE categoryId=139
0.0107  SELECT group_code, extraName from `leagues` WHERE categoryId=139 AND year=2024