=== Test filtre pays FR ===
WHERE clause: WHERE 1=1 AND mc.country_code = ?
Params: ["FR"]

SQL:

    SELECT 
        gs.*,
        MAX(mc.country_code) as country_code,
        MAX(mc.country_name) as country_name,
        MAX(mc.product_code) as product_code
    FROM dm_eex_gas_spot gs
    LEFT JOIN dm_mega_catalog mc ON mc.api_symbol LIKE CONCAT(gs.zone_livraison, '%')
    WHERE 1=1 AND mc.country_code = ? 
    GROUP BY gs.id
    ORDER BY gs.date_heure DESC 
    LIMIT 10


Résultats: 10 lignes

  - 2026-01-26 21:27:27 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 38.81
  - 2026-01-26 12:00:00 | zone: #E.PEG_GND           | pays: FR | product: E.PEG_GND1_SU | prix: 39.78
  - 2026-01-25 21:27:31 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 39.69
  - 2026-01-25 00:00:00 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 39.69
  - 2026-01-23 21:27:31 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 39.69
  - 2026-01-23 21:27:27 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 39.93
  - 2026-01-23 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 39.12
  - 2026-01-23 12:00:00 | zone: #E.PEG_GND           | pays: FR | product: E.PEG_GND1_SU | prix: 39.20
  - 2026-01-22 21:27:27 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 38.21
  - 2026-01-22 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 39.15

=== Test filtre produit PEG ===
WHERE clause: WHERE 1=1 AND (gs.zone_livraison LIKE ? OR mc.product_code LIKE ? OR mc.product_name LIKE ?)
Params: ["%PEG%","%PEG%","%PEG%"]

Résultats: 10 lignes

  - 2026-01-26 21:27:27 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 38.81
  - 2026-01-26 12:00:00 | zone: #E.PEG_GND           | pays: FR | product: E.PEG_GND1_SU | prix: 39.78
  - 2026-01-25 21:27:31 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 39.69
  - 2026-01-25 00:00:00 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 39.69
  - 2026-01-23 21:27:31 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 39.69
  - 2026-01-23 21:27:27 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 39.93
  - 2026-01-23 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 39.12
  - 2026-01-23 12:00:00 | zone: #E.PEG_GND           | pays: FR | product: E.PEG_GND1_SU | prix: 39.20
  - 2026-01-22 21:27:27 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 38.21
  - 2026-01-22 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 39.15