METTITI ALLA PROVA

SELECT TOP 1 m.mod_id FROM FAD.dbo.ModuliSiti ms INNER JOIN FAD.dbo.Siti s ON ms.sito_id = s.sito_id INNER JOIN FAD.dbo.Moduli m ON m.mod_id = ms.mod_id WHERE s.sito_id =35 AND m.mod_id <> 153 AND s.sito_status = 1 AND m.mod_status = 1 AND ms.mod_status = 1 ORDER BY NEWID()