SELECT TSTL.lngTL_ID, TSTL.strTSTL_Score
FROM TournamentSquadTopList AS TSTL, TournamentSquad AS TS, TournamentLicense AS TL
WHERE TSTL.lngTOU_ID = 1896
AND TSTL.lngTL_ID = 279899
AND TSTL.blnTSTL_IsVerified = 1
AND TSTL.lngTS_ID = TS.lngTS_ID
AND TS.blnTS_ShowResults = 1
AND TS.blnTS_QualifyingGame = 1
AND TS.dtmTS_SquadDate >= ''
AND TS.dtmTS_SquadDate <= ''
AND TSTL.lngTL_ID = TL.lngTL_ID
ORDER BY TSTL.strTSTL_Score DESC;