https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryItems_pricesVbzCart/queries/qryItems prices - Revision history2026-07-08T03:31:54ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/qryItems_prices&diff=10893&oldid=prevWoozle: moved from single-page listing2008-11-30T19:13:38Z<p>moved from single-page listing</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Requires''': [[../../tables/cat_items|cat_items]], [[../../tables/cat_ittyps|cat_ittyps]]<br />
* '''Used by''': <br />
* '''Future''': This will eventually contain shipping prices as well, but the shipping costs table hasn't been migrated as of this writing. It also needs to build a description from it.NameSng and i.ItOpt_Descr -- or perhaps there is a better way to do it (haven't we solved this problem elsewhere in a view?)<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryItems_prices AS<br />
SELECT<br />
i.ID,<br />
i.CatNum,<br />
i.ID_Title,<br />
i.ID_ItTyp,<br />
i.ID_ShipCost,<br />
i.PriceSell,<br />
i.PriceList,<br />
i.ItOpt_Descr,<br />
i.isInPrint,<br />
it.NameSng,<br />
it.NamePlr,<br />
it.Descr as ItTyp_Descr<br />
FROM (cat_items AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID)<br />
WHERE i.isForSale AND (NULLIF(i.isPulled,0) IS NULL) AND (i.ID_ShipCost IS NOT NULL) AND (i.PriceSell IS NOT NULL)<br />
ORDER BY i.CatNum;</mysql><br />
<section end=sql /></div>Woozle