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