select
count(distinct sallebean8_.SAL_ID) as y0_,
schemainst3_.SIM_DATEDEBUT as y1_
from
LIGNEOFFRE_LIO this_
inner join
LIGNEOFFRECOMPOSANTPRODUIT listecompo14_
on this_.LIO_ID=listecompo14_.LIO_ID
inner join
COMPOSANTPRODUIT_COP composantp1_
on listecompo14_.COP_ID=composantp1_.COP_ID
left outer join
COMPOSANTBACS_CBA composantb6_
on composantp1_.COP_ID=composantb6_.COP_COMPOSANTPRODUIT_ID
left outer join
BAC_BAC bac10_
on composantb6_.BAC_BAC_ID=bac10_.BAC_ID
left outer join
COMPOSANTCOMPLEXES_CCO composantc5_
on composantp1_.COP_ID=composantc5_.COP_COMPOSANTPRODUIT_ID
left outer join
COMMUNE_COM communes11_
on bac10_.BAC_ID=communes11_.BAC_BAC_ID
left outer join
COMPLEXE_CPX complexe7_
on complexe7_.COM_COMMUNE_ID = communes11_.COM_ID OR composantc5_.CPX_COMPLEXE_ID = complexe7_.CPX_ID
left outer join
COMPOSANTSALLES_CSA composants4_
on composantp1_.COP_ID=composants4_.COP_COMPOSANTPRODUIT_ID
inner join
SALLE_SAL sallebean8_
on complexe7_.CPX_ID=sallebean8_.CPX_COMPLEXE_ID OR composants4_.SAL_SALLE_ID = sallebean8_.SAL_ID
inner join
SCHEMAINSTALLATIONGROUPEDIFFUSION_SGD schemainst2_
on this_.LIO_ID=schemainst2_.LIO_LIGNEOFFRE_ID
inner join
SCHEMAINSTALLATIONMAILLE_SIM schemainst3_
on schemainst2_.SGD_ID=schemainst3_.SGD_SCHEMAINSTALLATIONGROUPEDIFFUSION_ID
where
this_.LIO_ID=14528
group by
schemainst3_.SIM_DATEDEBUT
Partager