Deadlock found when trying to get lock; try restarting transaction 
SELECT distinct 'rnol2lejn5p8vo381fqdjn9hmm' SID, o.CNR, now() UD
FROM obj o, obj_pikto op, geo g, tipkat tk, obj_email oe
WHERE op.PIKTO in (00022) AND op.AKTIV=1 AND op.CNR=oe.CNR AND oe.AK=1 AND oe.FRISSUL=1 AND tk.tipus='10001'
AND op.CNR=o.CNR AND o.CNR=tk.CNR and o.CNR not in (SELECT CNR FROM ak1 ak WHERE ak.SID='rnol2lejn5p8vo381fqdjn9hmm')
AND o.V_U=g.V_U AND g.REGIO_LINK_M='budapest_kornyeke_regio'
ORDER BY tk.FONTOSSAG_REGIO DESC, o.CEGNEV
LIMIT 8