this is the error i get from debug:
500 - JDatabaseMySQL::query: 1052 - Column 'gameid' in on clause is ambiguous SQL=SELECT score,jos_puarcade.userid,jos_puarcade.gameid,date,username, title as gametitle,reverse_score,imagename,folderid, t.my_score as myscore FROM jos_puarcade LEFT join jos_users on (jos_users.id = jos_puarcade.userid) LEFT JOIN jos_puarcade_games on (jos_puarcade_games.id = gameid) LEFT JOIN (select gameid, score as my_score from jos_puarcade where userid = '63') t on (t.gameid = jos_puarcade.gameid) WHERE jos_puarcade.published = '1' ORDER BY jos_puarcade.date DESC LIMIT 0,10
can anybody help?
j1.5.20
PUA2.3.12
tnx