(SELECT Article_it as articolo, Panoramica_it as testo FROM magazine WHERE Line LIKE '%top%' OR Category LIKE '%top%' OR Article_it LIKE '%top%' OR Description_it LIKE '%top%' OR Panoramica_it LIKE '%top%') UNION (SELECT Object_it as articolo, Text_it as testo FROM news WHERE Object_it LIKE '%top%' OR Text_it LIKE '%top%')

togli la virgola prima del FROM