View 'wtaweb.awards' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them: SELECT DISTINCT concat_ws(' ', a.award_name, a.award_year) as award_name, a.region_id, n.award_year, a.award_url from wta_nominations n join awards a on n.award_id = a.award_id and n.award_year = a.award_year join wta_regions r on a.region_id = r.region_id # check for any child companies where we should show nominations on this parent profile LEFT JOIN wta_companies_parents cp ON cp.parent_company_id = '33622' AND cp.show_noms_on_parent_profile = 1 AND cp.deleted = 0 WHERE (n.company_id = '33622' OR n.company_id = cp.company_id) and n.deleted = 0 and ((n.winner = 'N' and n.award_year <= r.nominee_announce_year) OR (n.winner = 'Y' and n.award_year > r.winner_announce_year)) order by n.award_year desc