972
社区成员




select m.*,n.imageName from (
select * from Product where userid=119 order by id desc limit 100 offset 0
) m left join ( select pid,imageName from (select id,pid,imageName from images where userid=119 ) t where t.id=(select min(id) from (select id,pid,imageName from images where userid=119 ) u where pid=t.pid) ) n on m.id=n.pid order by m.id desc
select pid,imageName from (select id,pid,imageName from images where userid=119 ) t
where t.id=(select min(id) from (select id,pid,imageName from images where userid=119 ) u where pid=t.pid)