SQL ERROR

Column 'source' in order clause is ambiguous

SELECT translationlinewords.translationline AS id, IF(translations.video>0 AND youtubevideos.active=1,1,0) AS hasvideo FROM translationlinewords INNER JOIN translationlines ON translationlines.id=translationlinewords.translationline INNER JOIN translations ON translationlines.translation=translations.id LEFT JOIN youtubevideos ON youtubevideos.video=translations.video AND translations.video>0 WHERE translationlinewords.dictionary=68588 AND english!='' AND (youtubevideos.active=1 OR translations.video=0) ORDER BY hasvideo DESC, isphrase DESC, isgood DESC, speed ASC, source DESC, difficulty ASC LIMIT 0, 50

Error Table ID: 34529


Go Back ⇒
Go Home ⇒