added left join for fetching images in guide list