Rss generator started....
Community in esame: Demo Community
RSSActive: #vERZAHKm0X#
Feed inizializzato....
Titolo:
Intestazione feed in Italiano
Data Limite calcolata:20130522000000
All'inizio feed contiente:
Step 1 - Articles
Query per la ricerca:SELECT
art.CodiceCommunity as CodiceCommunity,
art.UserID as UserID,
art.Codice as CodiceAnnuncio,
art.Data as Data,
art.Ora as Ora,
art.Titolo as TitoloAnnuncio,
art.Messaggio as MessaggioAnnuncio,
art.Url as UrlAnnuncio,
art.Cancellato as AnnuncioCancellato,
art.Inappropriato as Inappropriato,
ana.Cognome as Cognome,
ana.Nome as Nome
FROM articoli as art
INNER JOIN anagrafica as ana
ON (art.CodiceCommunity=ana.CodiceCommunity AND art.UserID=ana.UserID)
WHERE art.Inappropriato < 2
AND art.Cancellato = 'N'
AND art.Convalidato = '1'
AND art.CodiceCommunity='vERZAHKm0X'
AND art.Data>='20130522000000'
ORDER BY art.Data DESC
Step 2 - News
Query per la ricerca:SELECT
new.CodiceCommunity as CodiceCommunity,
new.UserID as UserID,
new.Codice as CodiceAnnuncio,
new.Data as Data,
new.Titolo as TitoloAnnuncio,
new.Messaggio as MessaggioAnnuncio,
new.Url as UrlAnnuncio,
new.Cancellato as AnnuncioCancellato,
ana.Cognome as Cognome,
ana.Nome as Nome
FROM annunci as new
INNER JOIN anagrafica as ana
ON (new.CodiceCommunity=ana.CodiceCommunity AND new.UserID=ana.UserID)
WHERE new.Inappropriato < 2
AND new.Cancellato = 'N'
AND new.Convalidato = '1'
AND new.CodiceCommunity='vERZAHKm0X'
AND new.Data>='20130522000000'
ORDER BY new.Data DESC
Step 3 - Blog
Query per la ricerca:SELECT
blog.CodiceCommunity as CodiceCommunity,
blog.UserID as UserID,
blog.Codice as CodiceAnnuncio,
blog.CodiceSezione as Codice1,
blog.Data as Data,
blog.Ora as Ora,
blog.Titolo as TitoloAnnuncio,
blog.Messaggio as MessaggioAnnuncio,
blog.Url as UrlAnnuncio,
blog.Cancellato as AnnuncioCancellato,
ana.Cognome as Cognome,
ana.Nome as Nome
FROM blognotizie as blog
INNER JOIN anagrafica as ana
ON (blog.CodiceCommunity=ana.CodiceCommunity AND blog.UserID=ana.UserID)
WHERE blog.Inappropriato < 2
AND blog.Cancellato = 'N'
AND blog.Convalidato = '1'
AND blog.CodiceCommunity='vERZAHKm0X'
AND blog.Data>='20130522000000'
ORDER BY blog.Data DESC
Step 4 - Forum
Query per la ricerca:SELECT
msg.ID as CodiceAnnuncio,
msg.CodiceCommunity as CodiceCommunity,
msg.CodiceArgomento as CodiceArgomento,
msg.CodiceMessaggio as CodiceMessaggio,
msg.FromID as UserID,
msg.DataInvio as Data,
msg.Oggetto as TitoloAnnuncio,
msg.Testo as MessaggioAnnuncio,
msg.Cancellato as AnnuncioCancellato,
ana.Cognome as Cognome,
ana.Nome as Nome
FROM forummessaggi as msg
INNER JOIN anagrafica as ana
ON (msg.CodiceCommunity=ana.CodiceCommunity AND msg.FromID=ana.UserID)
WHERE msg.Inappropriato < 2
AND msg.Cancellato = 'N'
AND msg.Convalidato = '1'
AND msg.CodiceCommunity='vERZAHKm0X'
AND msg.DataInvio>='20130522000000'
ORDER BY msg.DataInvio DESC
Step 5 - Knowledge Base
Query per la ricerca:SELECT
kb.CodiceArticolo as CodiceAnnuncio,
kb.CodiceCommunity as CodiceCommunity,
kb.Autore as UserID,
kb.DataInserimento as Data,
kb.Titolo as TitoloAnnuncio,
kb.Abstract as MessaggioAnnuncio,
ana.Cognome as Cognome,
ana.Nome as Nome,
kb.CodiceArea as CodiceArea,
karea.Titolo as TitoloArea,
kb.CodiceSubArea as CodiceSubArea,
ksub.Titolo as TitoloSubArea,
kb.Url as UrlAnnuncio,
kb.Cancellato as Cancellato
FROM knowledgebase as kb
LEFT JOIN knowledgearea as karea
ON (kb.CodiceCommunity=karea.CodiceCommunity AND kb.CodiceArea=karea.CodiceArea )
LEFT JOIN knowledgesubarea as ksub
ON (kb.CodiceCommunity=ksub.CodiceCommunity AND kb.CodiceArea=ksub.CodiceArea AND kb.CodiceSubArea=ksub.CodiceSubArea )
INNER JOIN anagrafica as ana
ON (kb.CodiceCommunity=ana.CodiceCommunity AND kb.Autore=ana.UserID)
WHERE kb.Inappropriato < 2
AND kb.Cancellato = 'N'
AND kb.Convalidato = '1'
AND kb.CodiceCommunity='vERZAHKm0X'
AND kb.DataInserimento>='20130522000000'
ORDER BY kb.DataInserimento DESC
Step 6 - Media Gallery
Query per la ricerca:SELECT
med.MediaID as CodiceAnnuncio,
med.CodiceCommunity as CodiceCommunity,
med.Autore as UserID,
med.DataCreazione as Data,
med.Titolo as TitoloAnnuncio,
med.Descrizione as MessaggioAnnuncio,
ana.Cognome as Cognome,
ana.Nome as Nome,
med.Tipo as TipoMedia,
med.NomeFile as NomeFile,
med.Cancellato as Cancellato
FROM mediagallery as med
INNER JOIN anagrafica as ana
ON (med.CodiceCommunity=ana.CodiceCommunity AND med.Autore=ana.UserID)
WHERE med.Inappropriato < 2
AND med.Cancellato = 'N'
AND med.Convalidato = '1'
AND med.CodiceCommunity='vERZAHKm0X'
AND med.DataCreazione>='20130522000000'
ORDER BY med.DataCreazione DESC
Step 7 - Files
Query per la ricerca:SELECT
fi.ID as CodiceAnnuncio,
fi.CodiceCommunity as CodiceCommunity,
fi.Autore as UserID,
fi.DataCreazione as Data,
fi.Titolo as TitoloAnnuncio,
fi.Descrizione as MessaggioAnnuncio,
ana.Cognome as Cognome,
ana.Nome as Nome,
fi.Tipo as Tipo,
fi.NomeFile as NomeFile,
fi.Cancellato as Cancellato
FROM files as fi
INNER JOIN anagrafica as ana
ON (fi.CodiceCommunity=ana.CodiceCommunity AND fi.Autore=ana.UserID)
WHERE fi.Tipo='1'
AND fi.Inappropriato < 2
AND fi.Cancellato = 'N'
AND fi.Convalidato = '1'
AND fi.CodiceCommunity='vERZAHKm0X'
AND fi.DataCreazione>='20130522000000'
ORDER BY fi.DataCreazione DESC
Chiude e output del feed...
Fine procedura corretta!