API di Pointersoft, Web Agency a Verona API di Pointersoft, Web Agency a Verona
SELECT a.idNews as id, a.intro as titolo, a.data as data, a.alias as alias, a.tipologia as tipologia, "news" as pagina FROM tblnews as a join tblrelnewstags as b on a.idNews=b.idNews join tbltags as c on b.idTag=c.idTag where a.visibile=1 and c.alias="seo-sem" union SELECT a.idContenuto as id, a.titolo, "" as data, a.alias as alisa, "" as tipo, "contenuti" as pagina FROM tblcontenuti as a join tblrelcontenutitags as b on a.idContenuto=b.idContenuto join tbltags as c on b.idTag=c.idTag where a.visibile=1 and c.alias="seo-sem"