Optimized query action (Use left join)