https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryStkItms_for_sale_wItem_data 2026-07-08T02:30:29Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryStkItms_for_sale_wItem_data&diff=10950&oldid=prev 2008-12-04T02:11:54Z

<p>New page: ==Details== * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|qryStkItms_for_sale}} * &#039;&#039;&#039;Used by&#039;&#039;&#039;: * &#039;&#039;&#039;Status&#039;&#039;&#039;: this one may be redundant; the time when we need the item data is *after* all the sourc...</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|qryStkItms_for_sale}}<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;:<br /> * &#039;&#039;&#039;Status&#039;&#039;&#039;: this one may be redundant; the time when we need the item data is *after* all the sources of items-to-restock have been UNIONed together and GROUPed by item<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2008-11-17&#039;&#039;&#039; Created for revised restocking process<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryStkItms_for_sale_wItem_data AS<br /> SELECT<br /> qsi.*,<br /> i.*<br /> FROM qryStkItms_for_sale AS qsi LEFT JOIN cat_items AS i ON qsi.ID_Item=i.ID;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle