Multiple Joins in Diesel

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

This topic was automatically closed 90 days after the last reply. We invite you to open a new topic if you have further questions or comments.