find fg without category

SELECT
  mp.NAME mo_ref,
  mp.CREATE_DATE,
  pt.DEFAULT_CODE part_num,
  pt.NAME part_name,
  mp.X_QTY_BUILT qty_built
  --mp.STATE
FROM
  BIZ.DBT_STG.STG_ODOO_PROD__MRP_PRODUCTION mp
  JOIN BIZ.DBT_STG.STG_ODOO_PROD__PRODUCT_PRODUCT pp ON pp.id = mp.PRODUCT_ID
  JOIN BIZ.DBT_STG.STG_ODOO_PROD__PRODUCT_TEMPLATE pt ON pt.id = pp.PRODUCT_TMPL_ID
WHERE
  pt.CATEG_ID in (1,9)
  and mp.STATE = 'done'
ORDER BY 2 DESC