
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()