| |||||||||||||||
1146 : SELECT type_evene, SUM(Nb) FROM (SELECT b.type_evene,COUNT(*) AS Nb FROM got__source a INNER JOIN got__even_sour b ON (a.id_sour = b.id_sour) WHERE b.type_sourc = "SOUR" GROUP BY b.type_evene UNION SELECT type_evene, COUNT(*) FROM got__evenement WHERE note_evene != "" AND type_evene NOT IN ("NOTE","FILE","OCCU","CHAN","RFN","RIN") GROUP BY type_evene UNION SELECT "INDI",COUNT(*) FROM got__individu WHERE note_indi != "" ) AS Requete GROUP BY type_evene ORDER BY 2 DESC | |||||||||||||||
|
|