A Database Error Occurred

Error Number: 1054

Unknown column 'd.parent_key' in 'on clause'

SELECT SUM(d.score) AS score, MAX(d.teaminning) AS inning, MAX(d.hs) AS hs, MAX(d.hs2) AS hs2, e.photo FROM custom_field AS a LEFT JOIN custom_value AS b ON a.id = b.custom_field_id AND b.custom_table_id = '30' LEFT JOIN team_player AS c ON b.value = c.team_id LEFT JOIN player AS e ON b.value = e.id LEFT JOIN match_result AS d ON c.player_id = d.player AND d.parent_key = '30' WHERE a.name = 'ASIA_TEAM'

Filename: models/Competitionmodel.php

Line Number: 714