(select u.username,u.sesso,'concerti' as prefisso,p.regione,e.titolo as titolo_commento,cc.concerti_commenti_id as id_commento,cc.concerti_id as id_entita,DATE_FORMAT(cc.concerti_commenti_data,'%Y-%m-%d') as data_commento,u.nome as nome_utente,LEFT(cc.concerti_commenti_descrizione,80) as commento,u.id as id_sender from ((concerti_commenti cc inner join users u on u.username=cc.concerti_commenti_nome) inner join Eventi e on e.id=cc.concerti_id) inner join Province p on p.sigla=e.provincia where u.abilitato=1 and e.abilitato=1 and cc.concerti_commenti_stato=1 and cc.id_rif=0) UNION (select u.username,u.sesso,'locali' as prefisso,p.regione,l.locali_nome as titolo_commento,lc.locali_commenti_id as id_commento,lc.locali_id as id_entita,DATE_FORMAT(lc.locali_commenti_data,'%Y-%m-%d') as data_commento,u.nome as nome_utente,LEFT(lc.locali_commenti_descrizione,80) as commento,u.id as id_sender from ((locali_commenti lc inner join users u on u.username=lc.locali_commenti_nome) inner join locali l on l.locali_id=lc.locali_id) inner join Province p on p.provincia=l.locali_provincia where u.abilitato=1 and l.abilitato=1 and lc.locali_commenti_stato=1 and lc.id_rif=0) UNION (select u.username,u.sesso,'utenti' as prefisso,p.regione,u.nome as titolo_commento,u.id as id_commento,u.id as id_entita,DATE_FORMAT(u.data_registrazione,'%Y-%m-%d') as data_commento,u.nome as nome_utente,'Anche io mi sono iscritt[[[!!####!!]]] su In-Giro.net!' as commento,u.id as id_sender from users u inner join Province p on p.sigla=u.provincia where u.abilitato=1) UNION (select u.username,u.sesso,'concerti2' as prefisso,p.regione,e.titolo as titolo_commento,e.id as id_commento,e.id as id_entita,DATE_FORMAT(e.data_ins,'%Y-%m-%d') as data_commento,u.nome as nome_utente,LEFT(e.descrizione,80) as commento,u.id as id_sender from (users u inner join Eventi e on e.id_utente=u.id) inner join Province p on p.sigla=e.provincia where u.abilitato=1 and e.abilitato=1) UNION (select u.username,u.sesso,'locali2' as prefisso,p.regione,l.locali_nome as titolo_commento,l.locali_id as id_commento,l.locali_id as id_entita,DATE_FORMAT(l.data_ins,'%Y-%m-%d') as data_commento,u.nome as nome_utente,LEFT(l.locali_descrizione,80) as commento,u.id as id_sender from (locali l inner join users u on u.id=l.id_utente) inner join Province p on p.provincia=l.locali_provincia where u.abilitato=1 and l.abilitato=1) UNION (select '' as username,'' as sesso,'news' as prefisso,n.foto as regione,n.titolo as titolo_commento,n.id as id_commento,n.id as id_entita,DATE_FORMAT(n.data_ins,'%Y-%m-%d') as data_commento,n.titolo as nome_utente,n.descrizione as commento,0 as id_sender from news n where n.abilitato=1) UNION (select u.username,u.sesso,'news2' as prefisso,'' as regione,n.titolo as titolo_commento,nc.news_commenti_id as id_commento,nc.news_id as id_entita,DATE_FORMAT(nc.news_commenti_data,'%Y-%m-%d') as data_commento,u.nome as nome_utente,LEFT(nc.news_commenti_descrizione,80) as commento,u.id as id_sender from (news_commenti nc inner join users u on u.username=nc.news_commenti_nome) inner join news n on n.id=nc.news_id where u.abilitato=1 and n.abilitato=1 and nc.news_commenti_stato=1 and nc.id_rif=0) order by data_commento desc,RAND() LIMIT 14