SELECT Min(`news`.`DATA_PUB`) As minim, day(Max(`news`.`DATA_PUB`)) As dMax,year(Max(`news`.`DATA_PUB`)) As yMax,month(Max(`news`.`DATA_PUB`)) As mMax , day(min(`news`.`DATA_PUB`)) As dMin,year(Min(`news`.`DATA_PUB`)) As yMin,month(Min(`news`.`DATA_PUB`))as mMin FROM `news` inner join `gazeta` on `news`.ID_GAZETA = `gazeta`.ID_GAZETA where (`news`.`DATA_PUB` < (select Max(`news`.`DATA_PUB`) from news)) and (gazeta.DOMEN ='redural') and del is null and visible is not null order by `news`.`DATA_PUB` DESC, `news`.`id_news`