Gets all Prices Stored at DCS_PRICE, and checks if it is the one -- pointing to the publishing schema.

compareCATPUB.sql

SELECT 
  *
    FROM
      (
        SELECT PRICE_LIST, SKU_ID, COUNT(*)
          FROM WLM_PROD_CATA.DCS_PRICE
            GROUP BY 
              PRICE_LIST, SKU_ID
            HAVING 
              COUNT(*) > 1
      ) CATA_PRICE
      
    LEFT JOIN
      (
        SELECT 
          IS_HEAD, 
          VERSION_DELETED, 
          CHECKIN_DATE,
          PRICE_ID,
          PRICE_LIST,
          SKU_ID
            FROM WLM_PROD_PUB.DCS_PRICE  
      ) PUB_PRICE
      
    ON 
      CATA_PRICE.PRICE_LIST = PUB_PRICE.PRICE_LIST
        AND CATA_PRICE.SKU_ID = PUB_PRICE.SKU_ID;