bug fix:    INNER JOIN --->  LEFT JOIN