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