https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2Fdiscarded%2FqryRstkReq_wItem_infoVbzCart/queries/discarded/qryRstkReq wItem info - Revision history2026-07-08T04:34:31ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/discarded/qryRstkReq_wItem_info&diff=21730&oldid=prevWoozle: extracted from "discarded" page2016-03-02T21:54:31Z<p>extracted from "discarded" page</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Status''': not being used<br />
* '''History''':<br />
** '''2008-11-21''' Created for new restock process<br />
** '''2008-12-03''' officially abandoned<br />
==SQL==<br />
<mysql>CREATE OR REPLACE VIEW qryRstkReq_wItem_info AS<br />
SELECT<br />
rqi.*,<br />
i.ID_Title,<br />
r.WhenCreated,<br />
r.WhenOrdered<br />
FROM<br />
(rstk_req_item AS rqi<br />
LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)<br />
LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql></div>Woozle