select * from spectacles_dates,spectacles where spectacles.ref=spectacles_dates.refSpectacle and Flag_censure=1 and (spectacles_dates.dateSpectacle >= '2026-07-23' or spectacles.noarchiv=1) and spectacles.type_spectacle='7' and spectacles.type_spectacle <> '9' and spectacles.futur=0 group by spectacles_dates.refSpectacle order by spectacles.festival, spectacles_dates.dateSpectacle