1 files changed, 4 insertions, 1 deletions
diff --git a/public/app/models/Content_model.php b/public/app/models/Content_model.php
index 1f145a0..cfe418f 100644
--- a/public/app/models/Content_model.php
+++ b/public/app/models/Content_model.php
@@ -91,7 +91,10 @@ class Content_model {
     public static function all_petitions()
     {
         return Registry::use('database')->runQuery(
-            "SELECT * FROM petition",
+            "SELECT petition.*,
+            CONCAT(user.last_name, ' ', user.first_name) as UserName
+            FROM petition
+            LEFT JOIN user ON user.id = petition.user_id",
             []
         );
     }