VbzCart/queries/qryCtg Items forUpdJoin

About

 * Requires:
 * Used by: catalog building process (details to be documented)
 * Note: QtyInStock has been deprecated; reference will need to be removed
 * History:
 * 2008-03-15 Building sequence completely rewritten, so presumably this query was created then

SQL
CREATE OR REPLACE VIEW qryCtg_Items_forUpdJoin AS SELECT ID AS ID_Item, CONCAT_WS('-',ID_Title,CatSfx) AS IDS_Item, FALSE AS isForSale, 0 AS QtyInStock,  /* this will be calculated shortly */ Supp_CatNum,      /* PRESERVE */ QtyMin_Stk        /* PRESERVE */ FROM cat_items WHERE (NOT isDumped) AND (ID_Title IS NOT NULL);