Miscellany

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_timeFROM xogame_users uINNER 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;