select eventcategories.* from (eventcategories inner join releventcategories on eventcategories.ideventcategory=releventcategories.ideventcategory) inner join releases on releases.idEvent=releventcategories.idEvent where eventcategories.active=1 and releases.active=1 and releases.idSpace=3 and (releases.publishStart<=STR_TO_DATE('28/06/2022','%d/%m/%Y') AND releases.publishEnd>=STR_TO_DATE('28/06/2022','%d/%m/%Y')) group by eventcategories.ideventcategory order by categoryOrder
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.customDateText_102, releases.promotion, promotion_102, releases.promoStart, releases.promoEnd, releases.promoInhome, releases.code, releases.code_102, releases.externalSale_100, releases.externalSale_102 FROM events INNER JOIN releases ON events.idEvent=releases.idEvent INNER JOIN pictures ON events.idEvent=pictures.idEvent WHERE events.active=1 AND releases.active=1 AND releases.idSpace=3 AND (releases.publishStart<=STR_TO_DATE('28/06/2022','%d/%m/%Y') AND releases.publishEnd>=STR_TO_DATE('28/06/2022','%d/%m/%Y')) GROUP BY events.idEvent ORDER BY releases.showStart
Del 1 al 3 de julio de 2022
El pecado de Eva
Del 6 al 17 de julio de 2022
Las Wot presentan su nuevo espectáculo
20% dto. Venta anticipada
12 de julio de 2022
Premio Desplante Femenino 2021 a Mejor Bailaora
Del 25 de agosto al 11 de septiembre de 2022
Se canta pero no se toca-Live
Del 14 al 25 de septiembre de 2022
De Ramon Madaula
20 de septiembre de 2022
Mediterranean Festival Tour 2022
21 y 22 de octubre de 2022
Del deporte también se sale
Del 16 al 20 de noviembre de 2022