SELECT
  (SELECT COUNT(*) FROM information_schema.TABLES
    WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='mdp_trans_type_map') = 1
  AND (SELECT COUNT(*) FROM mdp_trans_type_map WHERE tenant_id=0) > 0
  AND (SELECT COUNT(*) FROM mdp_trans_type_map
        WHERE stage_code IS NOT NULL
          AND stage_code NOT IN (
            'MAT_RECEIPT','MAT_IQC_RELEASE','MAT_PUTAWAY','MAT_PICK','MAT_ISSUE','MAT_LINE',
            'FG_RECEIPT','FG_PUTAWAY','FG_PICK','FG_SHIP','FG_PROD_RECEIPT','FG_FQC_RELEASE')) = 0;