Changes between Version 15 and Version 16 of AdvancedReports

Timestamp:

01/09/23 22:32:11 (2 years ago)

Author:

201063

Comment:

--

AdvancedReports

@@ -6 +6 @@
 {{{#!sql
 select 
-    sh.id_shelter,
-    sh.name_shelter,
-    sh.email_shelter,
-    sh.telephone_shelter,
-    org.name_organisation,
+    q2.id_shelter,
+    q2.name_shelter,
+    q2.email_shelter,
+    q2.telephone_shelter,
+    org.name_organisation as name_of_organisation,
     q2.average_verified_adopters
 from
@@ -16 +16 @@
                 select 
                         shelter.id_shelter,
+                        shelter.name_shelter,
+                        shelter.email_shelter,
+                        shelter.telephone_shelter,
                         avg(adopters_verified) as average_verified_adopters
                 from 
@@ -35 +38 @@
                 group by 
                         shelter.id_shelter
-                order by 
-                        average_verified_adopters desc
-        ) as q2
-                
-join shelter as sh
-        on sh.id_shelter = q2.id_shelter
-
-join organisation as org
-        on org.id_organisation = sh.id_organisation
+        ) as q2              
+left join shelter as sh
+        on sh.id_shelter = q2.id_shelter
+left join organisation as org
+        on org.id_organisation = sh.id_organisation
 }}}