Problema con registro anterior y siguiente

[gnzsoloyo]

Probemos cone sto:

Código SQL:

SELECT * FROM 
    (SELECT * 
    FROM articulos 
    WHERE id < 1432 AND activo=1 
    ORDER BY id DESC
    LIMIT 1)T1
UNION 
SELECT * FROM
    (SELECT * 
    FROM articulos 
    WHERE id > 1432 AND activo=1 
    ORDER BY id ASC
    LIMIT 1) T2
ORDER BY orden DESC, fecha DESC, id DESC