=== REFACTORISATION MEGA CATALOGUE EEX === Date: 2026-01-27 09:16:44 ÉTAPE 1: Ajout des nouvelles colonnes... ℹ️ Colonne has_month_variants existe déjà ℹ️ Colonne has_quarter_variants existe déjà ÉTAPE 2: Analyse des produits avec variants d'années... Produits avec variants d'années trouvés: 102 --- Analyse: O2FY (ID: 2748) --- ❓ Type: Inconnu, garder tel quel --- Analyse: O7FY (ID: 2745) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ODFY (ID: 2751) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 1DBY (ID: 1578) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 1NBY (ID: 2245) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 1SBY (ID: 2624) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 2DBY (ID: 1625) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 2NBY (ID: 2253) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 2SBY (ID: 2632) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 3NBY (ID: 2256) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 3SBY (ID: 2640) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 4NBY (ID: 2260) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 4SBY (ID: 2648) --- ❓ Type: Inconnu, garder tel quel --- Analyse: 5NBY (ID: 2263) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ATBY (ID: 1481) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ATPY (ID: 1528) --- ❓ Type: Inconnu, garder tel quel --- Analyse: CRBY (ID: 2279) --- ❓ Type: Inconnu, garder tel quel --- Analyse: CRPY (ID: 2287) --- ❓ Type: Inconnu, garder tel quel --- Analyse: DEBY (ID: 1920) --- ❓ Type: Inconnu, garder tel quel --- Analyse: DEPY (ID: 1967) --- ❓ Type: Inconnu, garder tel quel --- Analyse: EGOS (ID: 2759) --- ❓ Type: Inconnu, garder tel quel --- Analyse: OEFY (ID: 2756) --- ❓ Type: Inconnu, garder tel quel --- Analyse: EEX Norwegian NO4 Power Futures (ID: 2257) --- ❓ Type: Inconnu, garder tel quel --- Analyse: ESPY (ID: 2621) --- ❓ Type: Inconnu, garder tel quel --- Analyse: F7BY (ID: 1766) --- ❓ Type: Inconnu, garder tel quel --- Analyse: F7PY (ID: 1813) --- ❓ Type: Inconnu, garder tel quel --- Analyse: F9BY (ID: 2428) --- ❓ Type: Inconnu, garder tel quel --- Analyse: F9PY (ID: 2475) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FBBY (ID: 2237) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FCBY (ID: 2695) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FCPY (ID: 2742) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FDBY (ID: 2061) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FDPY (ID: 2108) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FEBY (ID: 2574) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FFBY (ID: 2014) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FHBY (ID: 2489) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FKBY (ID: 2271) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FNBY (ID: 1816) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOBF (ID: 2180) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOBS (ID: 2178) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOBY (ID: 2179) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOPF (ID: 2229) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOPS (ID: 2227) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FOPY (ID: 2228) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FPBY (ID: 2478) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FPPY (ID: 2481) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQBF (ID: 2121) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQBS (ID: 2119) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQBY (ID: 2120) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQPF (ID: 2131) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQPS (ID: 2129) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FQPY (ID: 2130) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FRPY (ID: 2497) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FUBS (ID: 1863) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FUBY (ID: 1864) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FUPS (ID: 1872) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FUPY (ID: 1873) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FVBY (ID: 2519) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FVPY (ID: 2527) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FXBY (ID: 2334) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FXPY (ID: 2381) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FYBY (ID: 2508) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FYPY (ID: 2511) --- ❓ Type: Inconnu, garder tel quel --- Analyse: FZBY (ID: 2505) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G0BS (ID: 1363) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G0BY (ID: 1364) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G1BS (ID: 1242) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G1BY (ID: 1243) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3BS (ID: 1427) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3BY (ID: 1428) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3FS (ID: 1423) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G3FY (ID: 1424) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G5BS (ID: 1367) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G5BY (ID: 1368) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8BS (ID: 1238) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8BY (ID: 1239) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8FS (ID: 1234) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G8FY (ID: 1235) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9BS (ID: 1311) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9BY (ID: 1312) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9FS (ID: 1307) --- ❓ Type: Inconnu, garder tel quel --- Analyse: G9FY (ID: 1308) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GBBS (ID: 1432) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GBBY (ID: 1433) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GCBS (ID: 1371) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GCBY (ID: 1372) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GDBS (ID: 1246) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GDBY (ID: 1247) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GEBS (ID: 1375) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GEBY (ID: 1376) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GFBS (ID: 1250) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GFBY (ID: 1251) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GGFS (ID: 1359) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GGFY (ID: 1360) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GLBS (ID: 1255) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GLBY (ID: 1256) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GTBS (ID: 1259) --- ❓ Type: Inconnu, garder tel quel --- Analyse: GTBY (ID: 1260) --- ❓ Type: Inconnu, garder tel quel --- Analyse: IRBY (ID: 2111) --- ❓ Type: Inconnu, garder tel quel --- Analyse: Q0BY (ID: 1672) --- ❓ Type: Inconnu, garder tel quel --- Analyse: Q0PY (ID: 1719) --- ❓ Type: Inconnu, garder tel quel --- Analyse: Q1BY (ID: 1531) --- ❓ Type: Inconnu, garder tel quel ÉTAPE 4: Application des modifications... ✅ ID 2748: O2FY → O2FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2745: O7FY → O7FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2751: ODFY → ODFY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1578: 1DBY → 1DBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2245: 1NBY → 1NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2624: 1SBY → 1SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1625: 2DBY → 2DBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2253: 2NBY → 2NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2632: 2SBY → 2SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2256: 3NBY → 3NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2640: 3SBY → 3SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2260: 4NBY → 4NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2648: 4SBY → 4SBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2263: 5NBY → 5NBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1481: ATBY → ATBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1528: ATPY → ATPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2279: CRBY → CRBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2287: CRPY → CRPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1920: DEBY → DEBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1967: DEPY → DEPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2759: EGOS → EGOS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2756: OEFY → OEFY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2257: EEX Norwegian NO4 Power Futures → EEX Norwegian NO4 Power Futures Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2621: ESPY → ESPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1766: F7BY → F7BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1813: F7PY → F7PY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2428: F9BY → F9BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2475: F9PY → F9PY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2237: FBBY → FBBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2695: FCBY → FCBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2742: FCPY → FCPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2061: FDBY → FDBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2108: FDPY → FDPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2574: FEBY → FEBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2014: FFBY → FFBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2489: FHBY → FHBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2271: FKBY → FKBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1816: FNBY → FNBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2180: FOBF → FOBF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2178: FOBS → FOBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2179: FOBY → FOBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2229: FOPF → FOPF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2227: FOPS → FOPS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2228: FOPY → FOPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2478: FPBY → FPBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2481: FPPY → FPPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2121: FQBF → FQBF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2119: FQBS → FQBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2120: FQBY → FQBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2131: FQPF → FQPF Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2129: FQPS → FQPS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2130: FQPY → FQPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2497: FRPY → FRPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1863: FUBS → FUBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1864: FUBY → FUBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1872: FUPS → FUPS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1873: FUPY → FUPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2519: FVBY → FVBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2527: FVPY → FVPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2334: FXBY → FXBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2381: FXPY → FXPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2508: FYBY → FYBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2511: FYPY → FYPY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2505: FZBY → FZBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1363: G0BS → G0BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1364: G0BY → G0BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1242: G1BS → G1BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1243: G1BY → G1BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1427: G3BS → G3BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1428: G3BY → G3BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1423: G3FS → G3FS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1424: G3FY → G3FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1367: G5BS → G5BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1368: G5BY → G5BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1238: G8BS → G8BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1239: G8BY → G8BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1234: G8FS → G8FS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1235: G8FY → G8FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1311: G9BS → G9BS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1312: G9BY → G9BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1307: G9FS → G9FS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1308: G9FY → G9FY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1432: GBBS → GBBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1433: GBBY → GBBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1371: GCBS → GCBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1372: GCBY → GCBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1246: GDBS → GDBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1247: GDBY → GDBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1375: GEBS → GEBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1376: GEBY → GEBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1250: GFBS → GFBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1251: GFBY → GFBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1359: GGFS → GGFS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1360: GGFY → GGFY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1255: GLBS → GLBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1256: GLBY → GLBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1259: GTBS → GTBS Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1260: GTBY → GTBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 2111: IRBY → IRBY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1672: Q0BY → Q0BY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1719: Q0PY → Q0PY Flags: Month=NO, Quarter=NO, Year=YES ✅ ID 1531: Q1BY → Q1BY Flags: Month=NO, Quarter=NO, Year=YES === RÉSUMÉ FINAL === ✅ Produits mis à jour: 102 ⚠️ Doublons détectés: 0 ÉTAPE 5: Vérification finale... 📊 Statistiques finales: Total produits EEX: 561 Avec variants année: 102 Avec variants mois: 112 Avec variants trimestre: 73 🎉 REFACTORISATION TERMINÉE !