Programación

Todo
select * from (select eventcategories.* from (eventcategories inner join releventcategories on eventcategories.ideventcategory=releventcategories.ideventcategory) inner join releases on releases.idEvent=releventcategories.idEvent inner join events on releases.idEvent=events.idEvent and events.active=1 where eventcategories.active=1 and releases.active=1 and (releases.publishStart<=STR_TO_DATE('18/05/2026','%d/%m/%Y') AND releases.publishEnd>=STR_TO_DATE('18/05/2026','%d/%m/%Y')) AND releases.idSpace=4