gistfile1.txt

 clocks: shift_id
 shifts: employee_id
 employee: name
 hierarchies: inferior_id, superior_id (both link to employee)
  
 Want to only return clocks whose associated employee has a hierarchy
    where their id matches the inferior_id and the superior_id matches 4
          or the associated employee's id is 4
 
SELECT clocks.* FROM clocks
  INNER JOIN shifts ON shifts.id = clocks.shift_id
  INNER JOIN employees ON employees.id = shifts.employee_id
  INNER JOIN hierarchies ON hierarchies.inferior_id = employees.id
  WHERE (hierarchies.superior_id = 4 OR employees.id = 4)