SELECT id, ordine as ordinex, titolo_it as titolo, immagine , dettaglio_testo_it as testo , immagine , video_it as video , (select permalink_it from news where ordine = (select min(ordine) from news where ordine > ordinex) AND attivo = 'on' AND titolo_it != '') as prevpermalink , (select titolo_it from news where ordine = (select min(ordine) from news where ordine > ordinex) AND attivo = 'on' AND titolo_it != '') as prevtitle , (select permalink_it from news where ordine = (select max(ordine) from news where ordine < ordinex) AND attivo = 'on' AND titolo_it != '') as nextpermalink , (select titolo_it from news where ordine = (select max(ordine) from news where ordine < ordinex) AND attivo = 'on' AND titolo_it != '') as nexttitle FROM news WHERE permalink_it = 'winestories' LIMIT 1
Deadlock found when trying to get lock; try restarting transaction