https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCbx_Items_data VbzCart/queries/qryCbx Items data - Revision history 2026-07-08T03:30:41Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryCbx_Items_data&diff=10888&oldid=prev Woozle: moved from single-page listing 2008-11-30T19:09:34Z <p>moved from single-page listing</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: [[../qryCat_Items|qryCat_Items]]<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: <br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryCbx_Items_data AS<br /> SELECT<br /> i.ID,<br /> CAST(<br /> CONCAT(<br /> if(i.isPulled,<br /> &#039;*P* &#039;,<br /> &#039;&#039;<br /> ),<br /> if(i.CatNum IS NULL,<br /> CONCAT(&#039;#&#039;,i.ID,&#039; (no cat#)&#039;)<br /> ,i.CatNum),<br /> if(i.Supp_CatNum IS NULL,<br /> &#039;&#039;,<br /> CONCAT(&#039; [&#039;,i.Supp_CatNum,&#039;]&#039;)<br /> ),<br /> if(i.isForSale,&#039;&#039;,&#039; *n/a*&#039;),<br /> &#039; &#039;,<br /> if(i.Descr IS NULL,&#039;no description&#039;,i.Descr)<br /> ) AS CHAR<br /> ) AS Descr,<br /> i.isPulled,<br /> i.isForSale,<br /> i.ID_Title,<br /> i.CatNum,<br /> i.Supp_CatNum,<br /> i.PriceSell,<br /> i.QtyMin_Stk<br /> FROM qryCat_Items AS i<br /> ORDER BY NOT i.isPulled, i.isForSale, i.CatNum;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div> Woozle