Fix profile wrong DISTINCT + ORDER BY

[friendica.git] / mod / profile.php

diff --git a/mod/profile.php b/mod/profile.php
index 93f2602e23f6b8b4ef1c40be6818f246bedf3c5c..a83cb076f26b883a04504be31e9a5974e95ed64d 100644 (file)
--- a/mod/profile.php
+++ b/mod/profile.php
@@ -210,7 +210,7 @@ function profile_content(App $a, $update = 0) {
 
        if ($update) {
 
-               $r = q("SELECT distinct(parent) AS `item_id`, `item`.`network` AS `item_network`
+               $r = q("SELECT distinct(parent) AS `item_id`, `item`.`network` AS `item_network`, `item`.`created`
                        FROM `item` INNER JOIN `contact` ON `contact`.`id` = `item`.`contact-id`
                        AND `contact`.`blocked` = 0 AND `contact`.`pending` = 0
                        WHERE `item`.`uid` = %d AND `item`.`visible` = 1 AND
@@ -318,10 +318,10 @@ function profile_content(App $a, $update = 0) {
                );
        }
 
-       $o .= conversation($a,$items,'profile',$update);
+       $o .= conversation($a, $items, 'profile', $update);
 
        if (!$update) {
-               $o .= alt_pager($a,count($items));
+               $o .= alt_pager($a, count($items));
        }
 
        return $o;