950
社区成员
发帖
与我相关
我的任务
分享
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)