Deadlock found when trying to get lock; try restarting transaction 
SELECT distinct 'tp51il71kjfkrs4v1q68s9leb1' SID, o.CNR, now() UD
FROM obj o, obj_pikto op, geo g, tipkat tk, obj_email oe
WHERE op.PIKTO in (00006) 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='tp51il71kjfkrs4v1q68s9leb1')
AND o.V_U=g.V_U AND g.REGIO_LINK_M='balaton_regio'
ORDER BY tk.FONTOSSAG_REGIO DESC, o.CEGNEV
LIMIT 8