: SELECT SQL_CALC_FOUND_ROWS nev,faj,nem,UNIX_TIMESTAMP(szuletett) AS sz,kep,statusz,meret,szor,telep,leiras,ID,UNIX_TIMESTAMP(bekerult) AS b,descr,beschr FROM allat WHERE statusz=0 AND faj=0 AND (telep=1) AND talalt=0 ORDER BY bekerult DESC LIMIT 50,10