Or actually I can not use SELECT UNION here, because then I only get 10records of the condition uid = player1 and then nothing would be left forthe other condition uid = player2