Changeset 20609 for events/phpframework/plain_php/trunk/model/phwittr/FriendshipService.php

Timestamp:

10/03/08 17:44:10 (3 months ago)

Author:

anatoo

Message:

サブクエリ使ってるとこを失くした

Files:

• events/phpframework/plain_php/trunk/model/phwittr/FriendshipService.php (modified) (2 diffs)

events/phpframework/plain_php/trunk/model/phwittr/FriendshipService.php

@@ -15 +15 @@
         $count = $this->fetchFollowerCount($user_id);
         
-        $smt = $this->pdo->prepare('
+        /*$smt = $this->pdo->prepare('
             select 
                 user_followers.*,
@@ -33 +33 @@
              )user_followings 
              on user_followers.id = user_followings.follow_id
+            ');*/
+        
+        $smt = $this->pdo->prepare('
+            select 
+                *,
+                users.id as user_id
+            from 
+                followers left join users 
+                on followers.user_id = users.id
+            where followers.follow_id = :user_id
+            limit :offset, :limit
             ');
-        
 
         $smt->bindValue(':user_id', $user_id, PDO::PARAM_INT);