VbzCart/queries/qryCbx Items opt

Details

 * Purpose: An abbreviated version of qryCbx_Items for contexts where the Title is already known
 * Requires: cat_items, cat_ioptns

SQL
CREATE OR REPLACE VIEW qryCbx_Items_opt AS SELECT i.ID, CAST(   CONCAT( if(i.isPulled,       '*P* ',        ''      ), if(i.ID_ItOpt IS NULL,       CONCAT('#',i.ID,' (no opt)')        ,io.CatKey), if(i.isForSale,'',' *n/a*') ) AS CHAR ) AS Descr,

i.CatNum FROM cat_items AS i LEFT JOIN cat_ioptns AS io ON i.ID_ItOpt=io.ID;