|
|
|
@@ -2,9 +2,10 @@
|
|
2
|
2
|
|
|
3
|
3
|
PAI2_HOME_API = (
|
|
4
|
4
|
r"select "
|
|
5
|
|
- r"T1.group_id, T2.group_name, T2.group_default_avatar, T2.group_avatar, T2.group_from, T3.id, T3.photo_path, T3.photo_w, "
|
|
6
|
|
- r"T3.photo_h, T3.photo_thumbnail_path, T3.photo_thumbnail_w, T3.photo_thumbnail_h, T3.user_id, T3.nickname, "
|
|
7
|
|
- r"T3.avatar, T3.comment_num, T3.thumbup_num, T3.photo_from, T3.created_at "
|
|
|
5
|
+ r"T1.group_id, T2.group_name, T2.group_default_avatar, T2.group_avatar, T2.group_from, T3.id, T3.photo_path, "
|
|
|
6
|
+ r"T3.photo_w, T3.photo_h, T3.photo_thumbnail_path, T3.photo_thumbnail_w, T3.photo_thumbnail_h, "
|
|
|
7
|
+ r"T3.photo_thumbnail2_path, T3.photo_thumbnail2_w, T3.photo_thumbnail2_h, T3.user_id, T3.nickname, T3.avatar, "
|
|
|
8
|
+ r"T3.comment_num, T3.thumbup_num, T3.photo_from, T3.created_at "
|
|
8
|
9
|
r"from (select * from group_groupuserinfo where user_id='{user_id}' and user_status=1) as T1 "
|
|
9
|
10
|
r"left outer join group_groupinfo as T2 on T1.group_id = T2.group_id "
|
|
10
|
11
|
r"left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id "
|