| | |
|---|
| | | UNION ALL |
|---|
| | | select id,cover,publish_at as show_time,5 as type,jump_url,jump_type from com_pb_dyn where status =2 and cover is not null and community_id =#{communityId} |
|---|
| | | UNION ALL |
|---|
| | | select id,img_url,publish_time as show_time,6 as type,"" as jump_url,"" as jump_type from com_act_reserve where status =2 and community_id =#{communityId} |
|---|
| | | select id,img_url as cover,publish_time as show_time,6 as type,"" as jump_url,"" as jump_type from com_act_reserve where status =2 and community_id =#{communityId} |
|---|
| | | UNION ALL |
|---|
| | | select id,photo_path_list,examine_at as show_time,7 as type,"" as jump_url,"" as jump_type from com_act_easy_photo where status =2 and community_id =#{communityId} |
|---|
| | | select id,logo as cover,release_at as show_time,7 as type,"" as jump_url,"" as jump_type from com_act_easy_photo_activity where status =2 and community_id =#{communityId} |
|---|
| | | order by show_time desc limit 30 |
|---|
| | | </select> |
|---|
| | | |
|---|
