SELECT d.id,d.id_x,d.id_o,d.navrsti,d.velikost,d.lastmove,d.lmove,d.tocke,d.remi,d.zacel,u.user_id AS p_user_id, u.username AS p_username, u.user_session_time AS p_user_session_time
FROM xogame_users u
INNER JOIN xo_igra d ON
(d.id_o=2 AND u.user_id=d.id_x AND d.del!='o') OR (d.id_x=2 AND u.user_id=d.id_o AND d.del!='x')
ORDER BY d.lastmove DESC;