Hello I am trying to convert the following PG query to Diesel but sadly I am still am not able to do it. Can someone please point me to some direction ?
select p.id,name, gender, p.email, phone, age, photo , industry, tags, country , area, twitter, user_list_id from people
as p left join
(
select * from list_people lp
inner join user_list ul on lp.user_list_id = ul.id
inner join users u on ul.user_id = u.id
where u.id = 1
) g on p.id = g.people_id