SELECT
E.*,
DATE_FORMAT(E.Validita,'%d/%m/%Y') as DataValidita,
dati.Titolo, dati.Sottotitolo, dati.chiave as chiave_elemento
FROM
tbModello_01_elementi as E,
tbModello_01_elementi_dati as dati,
tbLingue as L
WHERE
E.IdModello1 = '16' AND
(
IdTags = 57 OR
IdTags LIKE '57,%' OR
IdTags LIKE '%,57' OR
IdTags LIKE '%,57,%'
) AND
E.Id = dati.IdElemento AND
E.Online = 1 AND
dati.IdLingua = L.Id AND
L.Predefinita = 1 AND
(E.Validita >= '2026-04-25' || E.Validita = '0000-00-00')
ORDER BY E.Ordine; - Errore di connessione DB