1054 - Unknown column 'event_date1' in 'where clause'

select a.*,b.cityname,c.statename,c.statelink,d.cat_name,d.cat_link,e.slug,f.subcat_name,f.subcat_link from tbl_directory a, tbl_city b, tbl_state c,tbl_directory_category d,tbl_individual_urls e,tbl_directory_subcategory f where a.city_id=b.cityid and b.stateid=c.stateid and a.cat_id=d.cat_id and a.id=e.type_id and a.subcat_id=f.subcat_id and e.type='directory' and b.stateid=41 and a.status='Active' and (DATE(NOW()) between event_date1 and event_date2) order by views desc

[MySql Error]