Deadlock found when trying to get lock; try restarting transaction 
SELECT distinct '3uncu5shd7nj62dbnca9sfi0ch' 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='3uncu5shd7nj62dbnca9sfi0ch')
AND o.V_U=g.V_U AND g.REGIO_LINK_M='budapest_kornyeke_regio'
ORDER BY tk.FONTOSSAG_REGIO DESC, o.CEGNEV
LIMIT 6