sprawdzenie czy istnieje id w innej tabeli

SELECT o.id FROM  `order` o 
WHERE o.payment_id = 112
AND NOT EXISTS (SELECT 1 FROM payment_santander_status WHERE payment_santander_status.order_id = o.id)
limit 1000