VbzCart/queries/qryCbx Items opt

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot

< VbzCart‎ | queries

Jump to navigation Jump to search

Details

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

SQL

<mysql>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;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryCbx_Items_opt&oldid=10892"