Filter
8 wanted filters
A control is offered only where this version has an index behind it, because fmdb:index-databases indexes one database at a time and a reload drops the indexes with the tables. Nationality, name and position are always available. Age and foot stay unavailable whatever the indexes say: an age needs the in-game date the export does not carry, and the source does not define what counts as two-footed.
Players
Stars are ability out of 200 in half-star steps. Wage is weekly.
Columns
| Name | Position | Age No reference date | Born | Nationality | Club | CA | PA | Contract to | Wage | Value | Reputation | Height |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Marcel Desailly | Defender Central | — | 1968-09-07 | France | Chelsea | 2004-06-30 | £40,000 | — | 175 | — | ||
| Winston Bogarde | Defender Left | — | 1970-10-22 | Holland | Chelsea | — | £12,000 | — | 110 | — | ||
| Filippo Galli | Defender Central | — | 1963-05-19 | Italy | Watford | — | £0 | — | 140 | — | ||
| Jesper Grønkjær | Attacking Midfielder Left | — | 1977-12-08 | Denmark | Chelsea | — | £20,000 | — | 140 | — | ||
| Jari Litmanen | Attacking Midfielder Central | — | 1971-02-20 | Finland | Liverpool | 2003-07-01 | £30,000 | — | 150 | — | ||
| Edwin van der Sar | Goalkeeper | — | 1970-10-29 | Holland | Fulham | — | £0 | — | 150 | — | ||
| Peter Hoekstra | Attacking Midfielder Left | — | 1973-04-04 | Holland | Stoke City | 2002-07-01 | £0 | — | 110 | — | ||
| Nordin Wooter | Attacking Midfielder Right | — | 1976-08-24 | Holland | Watford | 2003-06-01 | £4,000 | — | 95 | — | ||
| Martijn Reuser | Midfielder Left | — | 1975-01-02 | Holland | Ipswich Town | 2005-06-30 | £13,000 | — | 120 | — | ||
| Jordão | Midfielder Central | — | 1971-08-30 | Angola | West Bromwich Albion | 2003-07-31 | £4,200 | — | 80 | — | ||
| Alexandre Bonnot | Defensive Midfielder | — | 1973-07-31 | France | Queens Park Rangers | 2002-06-01 | £0 | — | 85 | — | ||
| Quinton Fortune | Midfielder Left | — | 1977-05-21 | South Africa | Manchester United | 2003-06-30 | £4,000 | — | 115 | — | ||
| Lilian Laslandes | Striker | — | 1971-09-04 | France | Sunderland | 2003-06-14 | £12,000 | — | 124 | — | ||
| Alain Goma | Defender Central | — | 1972-10-05 | France | Fulham | 2005-06-30 | £4,700 | — | 123 | — | ||
| Bernard Diomède | Attacking Midfielder Left | — | 1974-01-23 | France | Liverpool | 2004-06-01 | £15,000 | — | 125 | — | ||
| Steve Marlet | Striker | — | 1974-01-10 | France | Fulham | — | £40,000 | — | 135 | — | ||
| Jean-Louis Valois | Attacking Midfielder Left | — | 1973-10-15 | France | Luton Town | 2002-06-30 | £1,100 | — | 95 | — | ||
| Albert Ferrer | Defender Right | — | 1970-06-06 | Spain | Chelsea | 2003-06-30 | £15,000 | — | 150 | — | ||
| Abel Xavier | Defender Central | — | 1972-11-30 | Portugal | Everton | 2002-07-01 | £0 | — | 120 | — | ||
| Markus Babbel | Defender Central | — | 1972-09-08 | Germany | Liverpool | 2005-07-01 | £0 | — | 150 | — | ||
| Dietmar Hamann | Defensive Midfielder | — | 1973-08-27 | Germany | Liverpool | 2004-06-30 | £25,000 | — | 150 | — | ||
| Martin Pringle | Striker | — | 1970-01-18 | Sweden | Charlton Athletic | — | — | — | 102 | — | ||
| Tahar | Defensive Midfielder | — | 1968-06-16 | Morocco | Southampton | — | £2,500 | — | 120 | — | ||
| Finidi | Attacking Midfielder Right | — | 1971-04-15 | Nigeria | Ipswich Town | 2004-06-30 | £14,000 | — | 145 | — | ||
| Jimmy Floyd Hasselbaink | Striker | — | 1972-03-27 | Holland | Chelsea | 2005-06-30 | £50,000 | — | 175 | — |
Data wishlist for this page
9 data pointsWhole site
-
person.date_of_birth, export_meta.reference_dateAge column and youth presets No reference dateThe base .dat source has no authoritative in-game date. Today, extraction time and game start year are not substitutes. -
player.current_ability, player.potential_abilityAbility and potential stars Now liveRecorded abilities are displayed. Negative potential codes remain codes; ability sorting is not implemented. -
player_positionPosition filter with minimum competency Now liveThe query filters indexed position membership and applies the requested competency floor. -
person_club_contract.club_uid, club.division_uidClub or league name filter Needs UI workThe relationships are recorded, but the combined name lookup is not implemented; this control remains disabled. -
player ability/value and person_club_contract wage/expiryAbility, potential, value, wage and explicit expiry filters Index-dependentThese filters run only where the selected version has their required indexes. An explicit expiry date does not require an in-game date. -
player.left_foot, player.right_foot, person.height_cmFoot and height filters Needs UI workHeight filtering is not implemented. A foot-category filter also needs a documented definition of left-, right- and two-footed. -
player, person_club_contract, person_club_statusFree-agent, bargain, most-valuable and expiring-contract presets Needs UI workPresets are not implemented. Free agency now has an explicit modern source flag, but needs coverage and an indexed query; relative expiry windows still lack a reference date. -
indexed ordering in PersonQueryAdditional server-side sorts Needs UI workCurrent ordering is name or uid. Existing filter indexes do not mean every displayed column is sortable. -
person.common_name, person.full_nameCommon-name display and name-prefix search Now liveNames use the recorded common name where available, with the existing full-name fallback.