1054: Unknown column 'banner.ID' in 'on clause'

---

select banner.ID, banner.bannerURL, banner.maxImpressionPerDay, banner.maxClickPerDay, bannerLog.impressionCounter, bannerLog.clickCounter, bannerLog.conversionCounter from banner, banner_to_bannerPosition left join bannerLog on bannerLog.banner_ID = banner.ID and bannerLog.date = date_format(NOW(),'%Y-%m-%d') where banner.ID = banner_to_bannerPosition.banner and banner_to_bannerPosition.bannerPosition = 2 order by rand()

---