Our Programmes:

SELECT * FROM `bss_events` e
                    WHERE `programId`='0' AND `activeUntil` > '2020-10-31 10:00:43' AND (`lastId`<`limit` OR `limit`=-1) AND `settings` NOT LIKE '%_ministry%' AND `invitation_only`=0 AND e.`activeUntil`>='2020-10-31 10:00:43'  ORDER BY `order` ASC

我们的活动:

SELECT * FROM `bss_events` e
                    WHERE `programId`='0' AND `activeUntil` > '2020-10-31 10:00:43' AND (`lastId`<`limit` OR `limit`=-1) AND `settings` LIKE '%chinese_ministry%' AND `invitation_only`=0 AND e.`activeUntil`>='2020-10-31 10:00:43'  ORDER BY `order` ASC
线上课程 线下课程