SELECT `id`,`category`,`intro-text`,`pg-rating`,`image`,`url`,`name`,`views`,`public`,`public-date`,`public-update`,`public-user`,`event-start-date`,`event-start-time`,`event-end-date`,`event-end-time`,`event-calendar`,`admin-checked` FROM `#__content_articles` WHERE ( (`public`=1) AND (`parent`=0 OR `parent`!=0) AND (`category`=9 OR ( `id` IN ( SELECT DISTINCT `value-id` FROM `#__content_articles_categories` WHERE `category-id`=9 ) ) ) AND ( ( `event-start-date`>='2021-06-14' OR `event-end-date`>='2021-06-14' OR `event-calendar` LIKE '%"date-start":"2021-06-14"%' ) OR ( `event-end-date`='2021-06-14' OR `event-calendar` LIKE '%"date-end":"2021-06-14"%' OR `event-end-date`='2021-06-15' OR `event-calendar` LIKE '%"date-end":"2021-06-15"%' OR `event-end-date`='2021-06-16' OR `event-calendar` LIKE '%"date-end":"2021-06-16"%' OR `event-end-date`='2021-06-17' OR `event-calendar` LIKE '%"date-end":"2021-06-17"%' OR `event-end-date`='2021-06-18' OR `event-calendar` LIKE '%"date-end":"2021-06-18"%' OR `event-end-date`='2021-06-19' OR `event-calendar` LIKE '%"date-end":"2021-06-19"%' OR `event-end-date`='2021-06-20' OR `event-calendar` LIKE '%"date-end":"2021-06-20"%' ) ) ) AND `event-feed`=1 ORDER BY id DESC LIMIT 12 OFFSET 0