GET ORDER WITHOUT BASKETS

SELECT
  c.ID,
  COUNT(e.id)
FROM
  b_sale_order c
  LEFT JOIN b_sale_basket e ON c.ID = e.ORDER_ID
WHERE
  c.PAYED = 'Y'
GROUP BY
  c.ID
HAVING
  COUNT(e.id) = 0;