https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCtgCk_dup_keysVbzCart/queries/qryCtgCk dup keys - Revision history2026-06-26T02:29:59ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtgCk_dup_keys&diff=11726&oldid=prevWoozle: extracted from catalog building page2009-05-03T22:30:53Z<p>extracted from catalog building page</p>
<p><b>New page</b></p><div>==About==<br />
* '''Purpose''': Verification of ctg build<br />
* '''Requires''': {{vbzcart|table|ctg_upd2}}, {{vbzcart|table|cat_items}}<br />
* '''Used by''': [[VbzCart catalog building|catalog building]] - verification stage<br />
* '''Returns''': any duplicate IDS_Items (ID_Title + CatSfx) found in currently active titles in {{vbzcart|table|cat_items}}. 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<br />
==SQL==<br />
<mysql>CREATE OR REPLACE VIEW qryCtgCk_dup_keys AS<br />
SELECT<br />
i.CatNum,<br />
i.isInPrint,<br />
u.*<br />
FROM ctg_upd2 AS u LEFT JOIN cat_items AS i ON u.ID_Item=i.ID WHERE cntDups and u.isForSale;</mysql></div>Woozle