SELECT id_company,MAX(date) FROM table GROUP BY id_company ORDER BY MAX(date) DESC>>> import itertools
>>> print(list(itertools.ifilter(lambda x:x%2==0,[2,4,6,7,9,8])))
[2, 4, 6, 8]
>>> print(list(itertools.ifilterfalse(lambda x:x%2,[2,4,6,7,9,8])))
[2, 4, 6, 8]