CentralogRayonRepository.php

SELECT TRIM(f.cdfam) as code_famille,
       TRIM(ssf.cdssfam) as code_rayon,
       TRIM(ssf.libssfam) as libelle_rayon,
       NULLIF(f.cdtva,'E') as code_tva
FROM famille f
INNER JOIN sous_famille sf
    ON sf.cdfam = f.cdfam
INNER JOIN sous_sous_famille ssf
    ON ssf.cdsfam = sf.cdsfam
    AND ssf.libssfam IS NOT NULL
    AND ssf.timestamp >= :dateDernierTraitement
WHERE f.dtann IS NULL