select b.*,pi.ec,ifnull(pi.ec,0) as piec from ( SELECT b.id,b.type,b.title,b.organizer,date_format(b.fromDate,'%Y-%m-%d') as fromDate,date_format(b.toDate,'%Y-%m-%d') as toDate,b.location,b.description,b.img,b.imgThumb,b.link,b.bannerRank,b.bgColor FROM `banner` as b where b.type in ('event','event-monthly') and (b.fromDate like '2020-11%' or b.toDate like '2020-11%' or (b.fromDate <= '2020-11-30' and b.todate >= '2020-11-30') ) and (b.fromDate >= '2020-11-30' or b.toDate >= '2020-11-30') and b.status = '1' order by b.bannerRank=0,b.bannerRank,b.fromDate asc ) as b left join `party_events` as pe on b.id = pe.event and pe.attend = 'Y' and pe.status = '1' left join party_info as pi on pe.pim = pi.pim group by b.id order by b.bgColor = '8DD2FE' desc,piec = '1' desc,b.bannerRank=0,b.bannerRank,b.bgColor desc,b.fromDate asc

FCG/YCP Webinar Series II

Virtual

6 October-1 December, 2020

Support learning and development for chemists in industry and academia

SCI’s Fine Chemicals Group

Scaling global biologics production

Virtual

3 November-3 December, 2020

Scaling global biologics production : partnerships across the value chain

GGBa