select hir_id,cim,cim_en,lead,szoveg,datum_feltolt,kategoria from hir where kategoria=1 and kozzetett and datum_megjelenes<=now() order by datum_feltolt desc limit 597,33