Database Error In Script Needs Fixing

Database Error In Script Needs Fixing I need the database error fixed so the Earnings Area page works The error: Database error: Invalid SQL: SELECT count(id) as total FROM ads WHERE NOT EXISTS (SELECT * FROM click_history WHERE click_history.type='ptc' AND click_history.username='admin' AND click_history.ad_id=[login to view URL]) and credits>=1 and (country='' or country='') and (daily_limit>views_today or daily_limit=0) and (upgrade='0' ) MySQL Error: 1054 (Unknown column 'click_history.ad_id' in 'where clause') Session halted To see the error login to the site here as member [login to view URL] user: admin password: admin then on the left click the Earnings Area You can see what the earning page looks like on this older version of the script [login to view URL] user: mdr1463 password: 041463