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('21/11/2024','%d/%m/%Y') AND releases.publishEnd>=STR_TO_DATE('21/11/2024','%d/%m/%Y')) AND releases.idSpace=5
SELECT * FROM (SELECT events.idEvent,events.name_100,events.brief_100,events.content_100,events.active,events.link,events.video,events.duration,events.break,pictures.name as picture, releases.showStart, releases.showEnd, releases.customDateText, releases.promotion, releases.promoStart, releases.promoEnd, releases.promoInhome, releases.code, releases.code_102,spaces.name as spaceName, spaces.code as SpaceCode, releases.externalSpace FROM events INNER JOIN releases ON events.idEvent=releases.idEvent INNER JOIN pictures ON events.idEvent=pictures.idEvent INNER JOIN spaces ON releases.idSpace=spaces.idSpace WHERE events.active=1 AND releases.active=1 AND releases.idSpace=5 AND (releases.publishStart<=STR_TO_DATE('21/11/2024','%d/%m/%Y') AND releases.publishEnd>=STR_TO_DATE('21/11/2024','%d/%m/%Y')) GROUP BY events.idEvent,events.name_100,events.brief_100,events.content_100,events.active,events.link,events.video,events.duration,events.break,releases.showStart,releases.showEnd,releases.customDateText, releases.promotion, releases.promoStart, releases.promoEnd, releases.promoInhome, releases.code, releases.code_102, spaceName, SpaceCode, releases.externalSpace) AS table1 INNER JOIN (SELECT events.idEvent,releases.idRelease as idReleaseTVLC FROM events INNER JOIN releases ON events.idEvent=releases.idEvent INNER JOIN pictures ON events.idEvent=pictures.idEvent INNER JOIN spaces ON releases.idSpace=spaces.idSpace WHERE events.active=1 AND releases.active=1 AND releases.idSpace=1 AND (releases.publishStart<=STR_TO_DATE('21/11/2024','%d/%m/%Y') AND releases.publishEnd>=STR_TO_DATE('21/11/2024','%d/%m/%Y')) GROUP BY events.idEvent, idReleaseTVLC) AS table2 ON table1.idEvent=table2.idEvent ORDER BY table1.showStart
Busca la estrella para beneficiarte de promos especiales