Código:
SELECT C.Id, C.name, count(*) as total
FROM (packages P
LEFT JOIN (`ref_package_to_category` PC
INNER JOIN Categories C
ON PC.Category_Id = C.Id )
ON P.Id = PC.Package_Id )
INNER JOIN
(SELECT VTP.VulnPack_Id
FROM ref_vuln_to_vulnpack VTP
INNER JOIN vulnerability V
ON VTP.VulnPack_Id = V.Id
WHERE PublishedDateTime > 2008-01-01) as VP
ON VP.VulnPack_Id = P.Id
GROUP BY C.Id, C.name
PublishedDateTime de que tabla viene?
Código:
SELECT C.Id, C.name, count(*) as total
FROM (packages P
LEFT JOIN
(`ref_package_to_category` PC
INNER JOIN Categories C
ON PC.Category_Id = C.Id )
ON P.Id = PC.Package_Id )
WHERE P.Id in (SELECT VTP.VulnPack_Id
FROM ref_vuln_to_vulnpack VTP
INNER JOIN vulnerability V
ON VTP.VulnPack_Id = V.Id
WHERE PublishedDateTime > 2008-01-01)
GROUP BY C.Id, C.name
No se ... nos das poca info.... por que el LEFT JOIN? hay pakages sin categoria??...
Quim