=== 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-04-12 00:00:00 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 42.44
  - 2026-04-10 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 42.55
  - 2026-04-10 08:32:18 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 42.44
  - 2026-04-10 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 42.58
  - 2026-04-09 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 0.00
  - 2026-04-09 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 44.50
  - 2026-04-08 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 44.30
  - 2026-04-07 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 51.52
  - 2026-04-03 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 0.00
  - 2026-04-02 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 49.20

=== 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-04-12 00:00:00 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 42.44
  - 2026-04-10 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 42.55
  - 2026-04-10 08:32:18 | zone: PEGWE                | pays: FR | product: PEGWE | prix: 42.44
  - 2026-04-10 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 42.58
  - 2026-04-09 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 0.00
  - 2026-04-09 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 44.50
  - 2026-04-08 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 44.30
  - 2026-04-07 08:32:14 | zone: PEGDA                | pays: FR | product: PEGDA | prix: 51.52
  - 2026-04-03 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 0.00
  - 2026-04-02 12:00:00 | zone: #E.PEG_GWE           | pays: FR | product: E.PEG_GWE1 | prix: 49.20