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

Drug Discovery Chemistry

California, United States of America

13-17 April, 2020

Dynamic conference for medicinal chemists working in pharma and biotech.

Cophex 2020

Seoul, Korea

14-17 April, 2020

Cosmetic and Pharmaceutical Machinery and Equipment Exhibition

IPhEB Russia

St. Petersburg, Russia

15-17 April, 2020

International Exhibition of Pharmaceuticals, Engineering, and Biotechnology.

PMCA

Pennsylvania, United States of America

20-22 April, 2020

Enhances the companies and careers of confectionery and snack professionals

IP Counsels Committee Conference

Palm Springs, CA

22-24 April, 2020

Event about latest issues in the biotech intellectual property sector.

CIDPEX2020

Jiangsu, China

22-24 April, 2020

The largest exhibition for tissue paper & disposable hygiene products industry.

AACR

California, United States of America

24-29 April, 2020

Covers the latest discoveries across the spectrum of cancer research

RDD 2020

California, United States of America

26 April, 2020

Founded on the selection of internationally renowned speakers, lively audience.