SELECT * FROM logs
    INNER JOIN logdetail ON logdetail.logID = logs.id
    INNER JOIN clients ON clients.id = logs.clientID
    INNER JOIN records ON records.id = logdetail.id
    WHERE logs.userID=1