ho un problema con questa stringa sql in pratica devo caricare i commenti e voti in questo modo:
15,prova,Andrea,Up,prova,1,1,1,prova,1,1,1
,aa,io,io,aa,aa,16/04/2008,GamesNet
17,prova,Andrea,Up,prova,1,1,1,prova,1,0,0
,aa,io,io,aa,aa,16/04/2008,GamesNet
ho messo nel code i due valori, come ho scritto non funziona se faccio solo un count senza where mi da i valori uguali su tutte e due le righe..come faccio?
ms.id_shard as id_shard,
ms.nome AS [Shard Name],
mu.nome AS Owner,
ms.stato AS Stato,
ms.stile AS Tipologia,
ms.maxPg AS MaxPg,
ms.medPg AS MedPg,
ms.MinPg AS MinPg,
ms.emulatore as Emulatore,
ms.tot As Tot,
(SELECT ms.id_shard,COUNT(co.id_shard) FROM Commenti AS co
RIGHT OUTER JOIN Manager_Shard AS ms ON ms.id_shard = co.id_shard
group by ms.id_shard) AS Commenti,
(SELECT ms.id_shard,COUNT(vo.id_shard) FROM voti AS vo
RIGHT OUTER JOIN Manager_Shard AS ms ON ms.id_shard = vo.id_shard
group by ms.id_shard) AS Voti,
ms.descrizione As Descrizione,
ms.mail as Mail,
ms.ip AS Ip,
ms.statusWeb AS [Status Web],
ms.siteWeb AS [Site Web],
ms.dataRegistrazione AS [Data Reg.],
ms.Hosting
FROM Manager_Shard AS ms
INNER JOIN Manager_Utenti AS mu ON mu.id_Utente = ms.id_utente
GROUP BY
ms.id_shard,
ms.nome,
mu.nome,
ms.stato,
ms.stile,
ms.maxPg,
ms.medPg,
ms.minPg,
ms.tot,
ms.voto,
ms.descrizione,
ms.mail,
ms.ip,
ms.statusWeb,
ms.siteWeb,
ms.dataRegistrazione,
ms.emulatore,
ms.hosting
ORDER BY Voti DESC