Cacher is the code snippet organizer for pro developers

Select
  projects.project_code,
  tasklists.name,
  users.username,
  timelogs.date,
  timelogs.time
From
  timelogs Inner Join
  tasks On timelogs.task_id = tasks.id Inner Join
  projects On tasks.project_id = projects.id Inner Join
  tasklists On tasks.tasklist_id = tasklists.id Inner Join
  users On users.id = timelogs.user_id
Where
  projects.client_id = ## And
  timelogs.user_id = ##
Order By
  timelogs.date Desc