lib/CrashTest/Plugin/Storage/Sql/Model/CrashReport.pm
changeset 94 c5fcb00c7261
parent 93 31013a09b483
child 95 fcf3a68002e6
--- a/lib/CrashTest/Plugin/Storage/Sql/Model/CrashReport.pm	Sun Feb 14 20:12:49 2016 +0100
+++ b/lib/CrashTest/Plugin/Storage/Sql/Model/CrashReport.pm	Sun Feb 14 20:15:25 2016 +0100
@@ -65,9 +65,9 @@
 
     my $count = $self->db->query("
         SELECT count(crash_reports.id) AS total FROM crash_reports
-        JOIN crash_users AS crash_user ON crash_reports.crash_user_id = crash_user.id
-        JOIN products AS product ON crash_reports.product_id = product.id
-        JOIN crash_groups AS crash_group ON crash_reports.crash_group_id = crash_group.id
+        LEFT JOIN crash_users AS crash_user ON crash_reports.crash_user_id = crash_user.id
+        LEFT JOIN products AS product ON crash_reports.product_id = product.id
+        LEFT JOIN crash_groups AS crash_group ON crash_reports.crash_group_id = crash_group.id
         $where
         ", @values)->hash;
 
@@ -88,9 +88,9 @@
                 crash_user.os AS u_os, crash_user.cpu_arch AS u_cpu_arch, crash_user.cpu_count AS u_cpu_count, crash_user.extra_info AS u_extra_info,
                 $extra_columns
         FROM crash_reports
-        JOIN crash_users AS crash_user ON crash_reports.crash_user_id = crash_user.id
-        JOIN products AS product ON crash_reports.product_id = product.id
-        JOIN crash_groups AS crash_group ON crash_reports.crash_group_id = crash_group.id
+        LEFT JOIN crash_users AS crash_user ON crash_reports.crash_user_id = crash_user.id
+        LEFT JOIN products AS product ON crash_reports.product_id = product.id
+        LEFT JOIN crash_groups AS crash_group ON crash_reports.crash_group_id = crash_group.id
         $where
         ORDER BY crash_time DESC
         OFFSET (?) ROWS