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 '2021-03%' or b.toDate like '2021-03%' or (b.fromDate <= '2021-03-31' and b.todate >= '2021-03-31') ) and (b.fromDate >= '2021-03-08' or b.toDate >= '2021-03-08') 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

BIO Asia International Conference

Grand Hyatt Tokyo, Japan

09-10 March, 2021

Exposure to new and exciting companies ready for partnerships and licensing.

2021 Distribution Management Expo

JW Marriott Indianapolis, Indianapolis

14-17 March, 2021

HDA's largest supply chain education event for pharmaceutical distribution.

2021 ISPE Aseptic Conference

North Bethesda, MD

15-16 March, 2021

Evolution of sterile manufacturing processes & technologies in pharma industry

ASPEN 2021 Nutrition Science

Virtual

20-23 March, 2021

ASPEN 2021 Nutrition Science & Practice Conference.

Euro Conference on Pharmaceutics

Marseille, France

22-23 March, 2021

Manufacturing equipment and technologies, Nanomedicines etc.

GCC REGULATORY AFFAIRS SUMMIT

Virtual

22-23 March, 2021

GCC REGULATORY AFFAIRS PHARMA SUMMIT 2021

Role of New Technologies

Virtual

24-25 March, 2021

Drug Discovery, Development and Lead Optimization

2ND EUROPEAN HEALTHTECH CEO FORUM

Virtual

08-9 March, 2021

2ND EUROPEAN HEALTHTECH CEO FORUM

Sachs

Stepping to Advanced-Flow Reactor

Virtual

9 March, 2021

Application in Material Sciences via Nanoparticles Synthesis

CORNING

Stepping to Advanced-Flow Reactor

Virtual

11 March, 2021

Application in Material Sciences via Nanoparticles Synthesis

CORNING

Supply Chain Re-Innovation

Virtual

11-12 March, 2021

Supply Chain Re-Innovation Life Sciences Edition

INVENTU

12th Global DDF Summit 2021

Virtual

15-17 March, 2021

Innovative solutions to the greatest challenges in pharmaceutical development.

Optimization and Seamless Scale-up

Virtual

23 March, 2021

Optimization and Seamless Scale-up in Corning® Advanced-Flow™ Reactors

CORNING

Clinical Trial Supply Europe

Virtual

24-25 March, 2021

An innovative online platform where pharma, large & small, alongside biotechs.

Drug Development for Start-ups-II

Virtual

24 March, 2021

The second of two part series covering the development steps from POC to launch

Optimization and Seamless Scale-up

Virtual

25 March, 2021

Optimization and Seamless Scale-up in Corning® Advanced-Flow™ Reactors

CORNING

AI IN HEALTHCARE & PHARMA

Virtual

25-27 March, 2021

AI IN HEALTHCARE & PHARMA VIRTUAL SUMMIT

Re-Work