Changes between Version 17 and Version 18 of AdvancedReports

Timestamp:

07/10/23 18:31:06 (18 months ago)

Author:

201144

Comment:

--

AdvancedReports

@@ -78 +78 @@
 * Преференца на студентот за број на цимери според неговите објави
 {{{
-select  au.userid,au.ime, au.prezime,p.number_of_roommates,count(p.number_of_roommates) as kolku_pati from post as p
-join student_post sp on sp.student_postid = p.postid 
+select  au.userid,au.ime, au.prezime,p.numberofroommates,count(p.numberofroommates) as kolku_pati from post as p
+join student_post sp on sp.studentpostid = p.postid 
 join student stud on stud.studentid = sp.studentid 
 join appuser au on stud.studentid = au.userid