SELECT football_player.name,MAX(football_player_comm.dater),football_player_comm.id_comm
FROM football_player, football_player_comm
WHERE 
football_player.id IN(SELECT football_player_comm.id_player
FROM football_player_comm
WHERE football_player_comm.id_comm='14' AND football_player_comm.dater<'2014-10-20' ) 
AND football_player_comm.id_player=football_player.id
GROUP BY football_player.name,football_player_comm.id_comm
ORDER BY football_player.name

SELECT igrol.name FROM igrok,com_igrok,(select com_igrok.id_igrok as a,max(com_igrok.dater) as b from com_igrok group by com_igrok.id_igrok ) as ass WHERE com_igrok.id_igrok=igrok.id AND com_igrok.id_com='$com' AND com_igrok.dater<'$date' AND ass.a = igrok.id AND ass.b = com_igrok.dater;