Index: events/phpframework/piece_framework/trunk/config/orm/mappers/Statuses.yaml
===================================================================
--- events/phpframework/piece_framework/trunk/config/orm/mappers/Statuses.yaml (revision 12645)
+++ events/phpframework/piece_framework/trunk/config/orm/mappers/Statuses.yaml (revision 12946)
@@ -0,0 +1,42 @@
+# $Id:$
+
+- name: findAllByUserIdForListFollowersStatus
+  query: >
+    SELECT
+      statuses.user_id,
+      users.user_name,
+      statuses.comment
+    FROM
+      statuses
+      JOIN users ON users.id = statuses.user_id
+    WHERE EXISTS
+      (SELECT *
+       FROM followers
+       WHERE followers.user_id = $userId and followers.follow_id = statuses.user_id
+       )
+      OR statuses.user_id = $userId
+
+- name: findAllByReplyUserIdForListReplies
+  query: >
+    SELECT
+      statuses.user_id,
+      users.user_name,
+      statuses.comment
+    FROM
+      statuses
+      JOIN users ON users.id = statuses.user_id
+    WHERE 
+      statuses.reply_user_id = $replyUserId
+
+- name: findAllByUserIdForListArchives
+  query: >
+    SELECT
+      statuses.user_id,
+      users.user_name,
+      statuses.comment
+    FROM
+      statuses
+      JOIN users ON users.id = statuses.user_id
+    WHERE 
+      statuses.user_id = $userId
+