https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2Fdiscarded%2Fv_itemsVbzCart/queries/discarded/v items - Revision history2026-07-08T04:33:22ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/discarded/v_items&diff=21729&oldid=prevWoozle: extracted from "discarded" page2016-03-02T21:53:26Z<p>extracted from "discarded" page</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Used by''': clsItemsExt (MS Access) -- as of 2008-11-30, this class does not seem to be in use anymore. It probably was not included in the big rescue operation when the old order DB developed some unopenable modules.<br />
==SQL==<br />
<mysql>CREATE OR REPLACE VIEW `v_items` AS<br />
SELECT<br />
i.ID,<br />
i.CatNum,<br />
i.isForSale,<br />
i.isMaster,<br />
i.qtyInStock,<br />
i.isInPrint,<br />
i.isCloseOut,<br />
i.isPulled,<br />
i.isDumped,<br />
i.ID_Title,<br />
i.ID_ItTyp,<br />
i.ID_ItOpt,<br />
i.ItOpt_Descr,<br />
i.ID_ShipCost,<br />
i.PriceBuy,<br />
i.PriceSell,<br />
i.PriceList,<br />
i.Supp_CatNum,<br />
io.Sort AS OptSort<br />
FROM (<br />
`cat_items` AS `i` LEFT JOIN <br />
`cat_ioptns` AS `io` ON<br />
((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql></div>Woozle