I have following sql JOIN query:

```
public function exportAll($date) {
    $sql = "SELECT CONCAT(u.firstname, u.lastname) as fullname, c.early_checkout_remarks, c.delayed_checkin_remarks, DATE(c.checkin_time) as checkin_date, DATE(c.checkout_time) as checkout_date, TIME(c.checkin_time) as checkin_time, TIME(c.checkout_time) as checkout_time 
    FROM users u
    LEFT JOIN checkin_checkout c 
    ON u.id=c.users_id 
    AND (DATE(c.checkin_time) = '%s' OR DATE(c.checkout_time) = '%s') 
    AND u.deleted IS NULL
    ORDER BY fullname,checkin_date";
    $records = $this->db->exec(sprintf($sql,$date,$date));
    return $records;

```

I only want records of users who are not deleted. But this query is also returning users with values in 'deleted' column.