SELECT n.userid, o.*
FROM orders o INNER JOIN orders_notes n ON n.orderid = o.id
WHERE n.id = (SELECT MAX(id) FROM orders_notes WHERE o.id=orderid)