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