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-06%' or b.toDate like '2021-06%' or (b.fromDate <= '2021-06-30' and b.todate >= '2021-06-30') ) and (b.fromDate >= '2021-06-25' or b.toDate >= '2021-06-25') 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

Sweets & Snacks Expo 2021

Indiana Convention Center, IN

23-25 June, 2021

Business-to-business event for the confectionery and snack industries.

BOS Basel 2021

Virtual

29-30 June, 2021

Discovery Outsourcing, Small Molecule CMC & Biologics CMC Outsourcing.

euroPLX 76 Noordwijk

Virtual

31 May-29 June, 2021

This 76th Marketplace is an exchange for licenses, products, assets, etc.

RauCon

Virtual Innovation Day

Virtual

10 June-31 July, 2021

Smart Innovation through Hybrid and 505(b)(2) Regulatory Pathways

Lonza Capsugel

DIA 2021

Virtual

27 June-1 July, 2021

The DIA 2021 Global Annual Meeting pushes beyond walls and borders.

Polymorphism & Crystallization

Virtual

28-29 June, 2021

Online conference with industry leading process chemists and engineers.

Scientific Update

Taste Masking Optimization

Virtual

28 June, 2021

To Optimize Taste and Improve Patient Outcomes

Adare Pharma Solutions

Continuous Chromatography of Peptides

Virtual

29 June, 2021

An innovative process for large-scale GMP purification, MCSGP, etc.

Bachem