French Second Division

CM0102 Release

Competition
11Reputation
—League games
20Clubs
—Total squad value

Competition

Code
D2
Nation
France
Confederation
Europe
Type
—
Level
—
Reputation
11
Status
—
Season
— – —
Colours
—
Short name
Second Division
Parent competition
—
Crowd tendencies
—

Format

Partial export
Teams
20
League games
—
Promoted in
—
Relegated
—
Champions League
—
Europa League
—
Conference League
—
Play-offs
—
Maximum games
—
Joined and left
—

Squad rules

Partial export
Registered squad
—
Home-grown
—
Club-trained
—
Foreign players
—
Under-21
—
Loans
—

Most titles

61 recorded titlesFMDB calculation

Counted over every recorded season of this competition, not the page of the roll of honour below. Placings point at teams rather than clubs, because international tournaments are won by national teams. Every recorded season in this version. It records no cancelled, abandoned or joint-winner flags, so none are excluded.

Season table

In the export

No season table recorded

This version records no league table for this competition.

League strength

FMDB calculation
Member clubs with the figures that size them up
Ajaccio AC7———————106602500
Amiens SC10———————120005500
AS Beauvais-Oise8———————105004000
AS Nancy-Lorraine12———————231169500
AS Saint-Etienne11———————3600018000
Berrichonne de Châteauroux9———————170005500
Chamois Niortais10———————108385500
ES Wasquehal8———————230003000
FC Gueugnon10———————138723500
FC Istres7———————112001800
FC Martigues7———————11500800
Grenoble Foot 389———————150009500
Le Havre Athletic Club10———————2035611000
Le Mans Union Club 729———————120004500
Nîmes Olympique10———————184823500
OGC Nice11———————185003500
Racing Club Strasbourg11———————2900012000
Stade Lavallois9———————200006400
Stade Malherbe de Caen9———————2150010500
US Créteil8———————51801000

Every club naming this competition as its current division, with the squad of the team that shares the club uid. Average ability, CA16, PA16, average age, squad value and wage bill are the FMDB's own figures over each club's whole squad; hover one for the population it was computed from. CA16 and PA16 are the means of the sixteen highest abilities and potentials, a coded potential counted at its band midpoint as on the club page. Balance is the club's authored club_finance_detail.cash; reputation, capacity and attendance are stored club figures.

Best in the league

FMDB calculation
# Player Club Pos CA
—————

Roll of honour

Placings point at teams, not clubs
One row per season: winner, runner-up and third, from comp_history
Season Winner Runner-up Third Top scorer Not in this export Player of the season See awards
2001FC Sochaux-MontbéliardFC LorientMontpellier Hérault SC——
2000Lille Olympique SCEn Avant GuingampToulouse FC——
1999AS Saint-EtienneCS Sedan-ArdennesEs.Troyes Aube Champagne——
1998AS Nancy-LorraineFC LorientFC Sochaux-Montbéliard——
1997Berrichonne de ChâteaurouxToulouse FCFC Martigues——
1996Stade Malherbe de CaenOlympique MarseilleAS Nancy-Lorraine——
1995Olympique MarseilleEn Avant GuingampFC Gueugnon——
1994OGC NiceStade RennaisSporting Club Bastia——
1993FC MartiguesSCO AngersAS Cannes——
1992Girondins de BordeauxValenciennes FCRacing Club Strasbourg——
1991Le Havre Athletic ClubNîmes OlympiqueRacing Club Lens——
1990AS Nancy-LorraineStade RennaisRacing Club Strasbourg——
1989Olympique LyonnaisFC MulhouseStade Brestois 29——
1988Racing Club StrasbourgFC Sochaux-MontbéliardStade Malherbe de Caen——
1987Montpellier Hérault SCChamois NiortaisAS Cannes——
1986—AS Saint-EtienneOlympique Alès Cévennes——
1985Le Havre Athletic ClubOGC NiceStade Rennais——
1984Tours FCOlympique Marseille———
1983Stade RennaisSporting Club Toulon 83Nîmes Olympique——
1982Toulouse FCOlympique Grand RouenFC Mulhouse——
1981Stade Brestois 29Montpellier Hérault SCToulouse FC——
1980AJ AuxerreTours FCStade Rennais——
1979FC GueugnonStade Brestois 29Racing Club Lens——
1978Lille Olympique SCSCO AngersParis FC——
1977Racing Club StrasbourgAS MonacoOlympique Grand Rouen——

A season links to its league table only where team_league_history records one. The top scorer is the rank-1 winner of the one award of type “Most goals scored” scoped to this competition, with the goals it records; no single award can be identified as the player of the season, so that column points to the Awards panel.

Across versions

Recorded
French Second Division reputation across versions0100200 CM0102 RFM06 RFM10 RFM13 RFM16 RFM19 RFM22 RFM26 UReputation, CM0102 Release: 11 Reputation, CM0203 Release: 11 Reputation, CM0304 Release: 11 Reputation, CM0304 Update: 11 Reputation, FM05 Release: 110 Reputation, FM05 Update: 110 Reputation, FM06 Release: 110 Reputation, FM07 Release: 110 Reputation, FM07 Update: 110 Reputation, FM08 Release: 110 Reputation, FM09 Release: 110 Reputation, FM09 Update: 110 Reputation, FM10 Release: 110 Reputation, FM10 Update: 110 Reputation, FM11 Release: 115 Reputation, FM11 Update: 115 Reputation, FM12 Release: 115 Reputation, FM12 Update: 115 Reputation, FM13 Release: 115 Reputation, FM13 Update: 115 Reputation, FM14 Release: 115 Reputation, FM14 Update: 118 Reputation, FM15 Release: 118 Reputation, FM15 Update: 118 Reputation, FM16 Release: 118 Reputation, FM16 Update: 118 Reputation, FM17 Release: 118 Reputation, FM17 Update: 118 Reputation, FM18 Release: 118 Reputation, FM18 Update: 118 Reputation, FM19 Release: 117 Reputation, FM19 Update: 117 Reputation, FM20 Release: 118 Reputation, FM20 Update: 118 Reputation, FM21 Release: 118 Reputation, FM21 Update: 118 Reputation, FM22 Release: 116 Reputation, FM23 Release: 117 Reputation, FM24 Release: 117 Reputation, FM26 Release: 121 Reputation, FM26 Update: 121
Recorded reputation in each database where this uid resolves. Missing values remain gaps. Raw export scales may differ between versions.
Version Name as recorded
CM0102 ReleaseFrench Second Division
CM0203 ReleaseFrench Second Division
CM0304 ReleaseFrench Second League
CM0304 UpdateFrench Second League
FM05 ReleaseFrench Second League
FM05 UpdateFrench Second League
FM06 ReleaseFrench Second League
FM07 ReleaseLigue 2 Orange
FM07 UpdateLigue 2 Orange
FM08 ReleaseLigue 2 Orange
FM09 ReleaseLigue 2
FM09 UpdateLigue 2
FM10 ReleaseLigue 2
FM10 UpdateLigue 2
FM11 ReleaseLigue 2
FM11 UpdateLigue 2
FM12 ReleaseLigue 2
FM12 UpdateLigue 2
FM13 ReleaseLigue 2
FM13 UpdateLigue 2
FM14 ReleaseLigue 2
FM14 UpdateLigue 2
FM15 ReleaseLigue 2
FM15 UpdateLigue 2
FM16 ReleaseLigue 2
FM16 UpdateLigue 2
FM17 ReleaseDomino's Ligue 2
FM17 UpdateDomino's Ligue 2
FM18 ReleaseDomino's Ligue 2
FM18 UpdateDomino's Ligue 2
FM19 ReleaseDomino's Ligue 2
FM19 UpdateDomino's Ligue 2
FM20 ReleaseDomino's Ligue 2
FM20 UpdateDomino's Ligue 2
FM21 ReleaseDomino's Ligue 2
FM21 UpdateLigue 2 BKT
FM22 ReleaseLigue 2 BKT
FM23 ReleaseLigue 2 BKT
FM24 ReleaseLigue 2 BKT
FM26 ReleaseLigue 2 BKT
FM26 UpdateLigue 2 BKT

Recorded competition names are shown for each version where the identity resolves.

Awards

Not in this export

No award scope in this export

Only the modern exports record which competition an award belongs to (award_scope). Sharing a nation with a competition does not make an award that competition's, so none is listed.

Awards whose award_scope names this competition. Editions flagged as having no data or not taking place are not counted. “Latest” is the award's stored season year; where that season has several editions — one per slot of a team of the year — the award page lists them.

Media prediction

Not in this export

No media predictions in this export

club_media_expectation is part of the modern exports only.

The predicted finish is the authored club_media_expectation.expected_league_finish. Last position is club_team.last_position as stored, in whatever competition the team last played, so for a club that has just joined it is not a place in this division.

Derbies in this division

0 between member clubs
Derbies whose two clubs both name this competition as their division
Derby Clubs W–D–L National reputation
No derby in this version is between two of this competition's clubs.

Derbies between two clubs that both name this competition as their current division. derby.competition_uid is empty in every loaded export, so this is the only way a derby belongs to a league. W–D–L is the first-named club's record as stored.

All-time records

FMDB calculation

Most goals and appearances in this division, summed from the playing history of every person this database records.

It counts only the people the export carries, it can include seasons the source files under this competition from before it took its current form, and some players are listed by uid because their person record is missing. The page states each of these.

See the all-time records

Member teams

Current members from club.division_uid; no comp_membership rows are recorded.

Last position is club_team.last_position as stored. The manager is the current staff_history spell at the club — the one whose end date is absent or in the future, most recent join first — never club_team.manager_index, which is a raw internal index that joins to nothing.

Teams recorded as members of this competition
Team Membership Last position Manager
Ajaccio ACCurrent division12—
Amiens SCCurrent division2—
AS Beauvais-OiseCurrent division11—
AS Nancy-LorraineCurrent division5—
AS Saint-EtienneCurrent division16—
Berrichonne de ChâteaurouxCurrent division6—
Chamois NiortaisCurrent division4—
ES WasquehalCurrent division13—
FC GueugnonCurrent division10—
FC IstresCurrent division3—
FC MartiguesCurrent division18—
Grenoble Foot 38Current division1—
Le Havre Athletic ClubCurrent division7—
Le Mans Union Club 72Current division14—
Nîmes OlympiqueCurrent division8—
OGC NiceCurrent division15—
Racing Club StrasbourgCurrent division18—
Stade LavalloisCurrent division9—
Stade Malherbe de CaenCurrent division17—
US CréteilCurrent division16—

Data wishlist for this page

13 data pointsWhole site
  • club_media_expectation, club_finance_detail Media prediction and club balances across the division Now liveThe predicted finish of every member club and each club's authored cash balance, where the version exports them.
  • player_history.division_uid All-time goals and appearances in the division Now liveAn FMDB sum over the people this database records, on its own page. Players with no person record are listed by uid; seasons the source files under this competition before it took its current form are included and dated.
  • derby, club.division_uid Derbies between member clubs Now livederby.competition_uid is empty in every export, so a derby belongs to a division when both its clubs name that division.
  • comps_competition, comps_stage and stage promotion, relegation and play-off tables Format, promotion, relegation, play-offs and qualification Needs source dataThe comps.dbc archive tables are empty in every loaded export. The format panel shows the clubs that joined and left since the latest recorded season table as an FMDB comparison, which is not a count of promotion places.
  • competition rules, nation_foreign_rule, nation_agreement Registration size, home-grown quotas, foreign-player limits and age rules Partial exportNation foreign/non-foreign definitions and agreements are exported, but do not supply the complete competition registration rules.
  • competition income and prize schedules Prize money, television distributions and sponsor Needs source dataThe current catalog does not provide these competition-level schedules and contracts.
  • competition.champions_club_uid, parent_division_uid, league_body_club_uid Current champions, parent division and organising body Needs source dataThe parent division is displayed. The champions and organising-body columns are empty in all 41 loaded databases.
  • team_league_history Recorded season tables Now liveSeason links are offered only where rows exist; stored points and missing results are preserved.
  • club.division_uid, stadium and primary-team squads League strength and leading players Now liveStrength and ability rankings use clubs naming this division, with a 100-club cap. League totals are withheld on overflow.
  • person.date_of_birth, export_meta.game_start_year Best young players in the league Now liveUnder-21s at 1 July of the exported game start year, ranked on recorded potential. Versions without a start year say so; coded potential bands are not ranked.
  • award_scope, award_type, award_history_winner Top scorer and player-of-season awards by season Now liveScoped awards are listed with their latest winner and the top scorer fills the roll of honour where exactly one most-goals award is scoped. No award type identifies a single player of the season, so that column stays empty. CSV-era exports have no award scope.
  • comp_history and Honours Titles per team over recorded history Now liveCounts use the bounded history query, not just the displayed page, and apply available edition and stage flags. Coverage is stated.
  • competition across versions, export_value_scale Recorded names and reputation across versions Now liveThese are real version records. Reputation is shown against its stated 1–200 scale where the export records one; the cross-version chart still plots raw values.

Reviewed 30 September 2026 against the current schema and page implementation. “Now live” means implemented where data is recorded; “Exported; UI pending” means the schema has data this page does not yet use. Tables and coverage vary by version. Missing values stay blank.