# -*- coding: utf-8 -*-

PAI2_HOME_API = r"select " \
                r"T1.group_id, T2.group_name, T2.group_default_avatar, T2.group_avatar, T3.id, T3.photo_path, T3.photo_w, T3.photo_h, T3.photo_thumbnail_path, T3.photo_thumbnail_w, T3.photo_thumbnail_h, T3.user_id, T3.nickname, T3.avatar, T3.comment_num, T3.thumbup_num, T3.created_at " \
                r"from (select * from group_groupuserinfo where user_id='{user_id}' and user_status=1) as T1 " \
                r"left outer join group_groupinfo as T2 on T1.group_id = T2.group_id " \
                r"left outer join group_groupphotoinfo as T3 on T1.group_id = T3.group_id and T3.id > T1.current_id " \
                r"where T3.status = 1 " \
                r"order by DATE(T3.created_at) desc, T3.thumbup_num desc " \
                r"limit {offset}, {rows};"