VbzCart/docs/queries/qryCtgCk dup keys

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search

About

  • Purpose: Verification of ctg build
  • Requires: Template:Vbzcart, Template:Vbzcart
  • Used by: catalog building - verification stage
  • Returns: any duplicate IDS_Items (ID_Title + CatSfx) found in currently active titles in Template:Vbzcart. When this happens, it is probably due to old records whose CatSfx fields weren't set (or weren't set properly) being (re)activated by being found in stock

SQL

<mysql>CREATE OR REPLACE VIEW qryCtgCk_dup_keys AS SELECT 

 i.CatNum,
 i.isInPrint,
 u.*

FROM ctg_upd2 AS u LEFT JOIN cat_items AS i ON u.ID_Item=i.ID WHERE cntDups and u.isForSale;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryCtgCk_dup_keys&oldid=6752"