BUG FIXING : Using LEFT JOIN in replacement of implicit inner joins. WARN NOT FULLY...