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