https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryStock_Titles_most_recent 2026-07-08T03:32:37Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryStock_Titles_most_recent&diff=10956&oldid=prev 2008-12-04T02:36:52Z

<p>New page: ==Details== * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_titles_remaining}} * &#039;&#039;&#039;Used by&#039;&#039;&#039;: This defines what the &quot;latest ...</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/table|cat_items}}, {{vbzcart/query|v_stk_titles_remaining}}<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: This defines what the &quot;latest stock&quot; web page shows; as given here, it displays the 100 titles most recently added to stock.<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryStock_Titles_most_recent AS<br /> SELECT<br /> i.ID_Title,<br /> s.QtyForSale AS QtyAdded,<br /> MAX(s.WhenAdded) AS WhenAdded,<br /> st.QtyForSale AS QtyAvail<br /> FROM (v_stk_lines_remaining AS s LEFT JOIN cat_items AS i ON s.ID_Item=i.ID) LEFT JOIN v_stk_titles_remaining AS st ON i.ID_Title=st.ID_Title<br /> GROUP BY i.ID_Title<br /> HAVING QtyAdded<br /> ORDER BY WhenAdded DESC<br /> LIMIT 100;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle