https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2Fdiscarded%2FqryCbx_Restocks 2026-07-26T09:35:56Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/discarded/qryCbx_Restocks&diff=21731&oldid=prev 2016-03-02T21:57:58Z

<p>extracted from &quot;discarded&quot; page</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Status&#039;&#039;&#039;: deleted (ultimately depends on old restock table, so doesn&#039;t work anymore)<br /> * &#039;&#039;&#039;Notes&#039;&#039;&#039;: MySQL gives a &quot;query cancelled&quot; error when running this SQL to create the view, but actually it creates it just fine.<br /> ==SQL==<br /> &lt;mysql&gt;CREATE OR REPLACE VIEW qryCbx_Restocks AS<br /> SELECT * FROM qryCbx_Restocks_byStatus<br /> UNION<br /> SELECT * FROM qryCbx_Restocks_byPurchOrd;&lt;/mysql&gt;</div>

Woozle