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 a.award_year_name, a.award_url, a.award_year, a.region_sort_order, a.region, CONCAT_WS('-', IF(a.country_type = 1, 1, 2), IF(a.country_type = 2, a.country, a.parent_country), a.country_type, a.country) AS country_sort, a.hide_subregion, a.category 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 WHERE n.company_id = '2495' AND n.deleted = 0 AND n.winner = 'Y' AND n.award_year <= r.winner_announce_year UNION # check for any child companies where we should show nominations on this parent profile SELECT DISTINCT a.award_year_name, a.award_url, a.award_year, a.region_sort_order, a.region, CONCAT_WS('-', IF(a.country_type = 1, 1, 2), IF(a.country_type = 2, a.country, a.parent_country), a.country_type, a.country) AS country_sort, a.hide_subregion, a.category FROM wta_companies_parents cp JOIN wta_nominations n ON n.company_id = cp.company_id AND n.deleted = 0 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 AND n.deleted = 0 WHERE cp.parent_company_id = '2495' AND cp.show_noms_on_parent_profile = 1 AND cp.deleted = 0 AND n.winner = 'Y' AND n.award_year <= r.winner_announce_year ORDER BY award_year DESC, region_sort_order, region, country_sort, hide_subregion, category