VbzCart/queries/qryCbx Items data

Details

 * Requires: qryCat_Items
 * Used by:

SQL
CREATE OR REPLACE VIEW qryCbx_Items_data AS SELECT i.ID, CAST(   CONCAT( if(i.isPulled,       '*P* ',        ''      ), if(i.CatNum IS NULL,       CONCAT('#',i.ID,' (no cat#)')        ,i.CatNum), if(i.Supp_CatNum IS NULL,       '',        CONCAT(' [',i.Supp_CatNum,']')      ), if(i.isForSale,'',' *n/a*'), ' ',     if(i.Descr IS NULL,'no description',i.Descr) ) AS CHAR ) AS Descr, i.isPulled, i.isForSale, i.ID_Title, i.CatNum, i.Supp_CatNum, i.PriceSell, i.QtyMin_Stk FROM qryCat_Items AS i ORDER BY NOT i.isPulled, i.isForSale, i.CatNum;