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-07%' or b.toDate like '2020-07%' or (b.fromDate <= '2020-07-31' and b.todate >= '2020-07-31') ) and (b.fromDate >= '2020-07-05' or b.toDate >= '2020-07-05') 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

AFSSI Connexions 2020

Lyon, Franc

07-8 July, 2020

The annual meetings of preclinical research.

5th Annual Inhalation Congress

London, UK

08-9 July, 2020

Annual Inhalation & Respiratory Drug Delivery Congress

6th Formulation & Drug Delivery

Online Event

08-9 July, 2020

Covers topics such as: Biologics Drug Delivery, Small Molecule Drug Formulation

IFT Annual Expo

Chicago, United States of America

12-15 July, 2020

Experience the newest products, latest trends, and cutting-edge innovations

Chemspec USA 2020

United States

15-17 July, 2020

The Fine & Specialty Chemicals Exhibition

INTERPHEX 2020

New York, United States of America

15-17 July, 2020

The event for pharma, bio, device development and manufacturing.

Cosmo Tech Expo 2020

Pragati Maidan, Delhi

16-17 July, 2020

India's Biggest Manufacturing Solutions Trade Show

Bio Asia- Taiwan

Taipei, Taiwan

22-26 July, 2020

One of the most iconic bio-themed gatherings in Asia.

Pharmaceutical Formulations

Zurich, Switzerland

27-28 July, 2020

Insights on recent developments in the field of Pharmaceutical Formulations.