Архив / Вестник избиркома

select archive.*, entities.name author_name, entities.options options from archive, entities where author_id=entities.id and author_id=974 and year>0 order by year, month, day limit 20 offset 0