https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2Fv_stk_titles_remaining 2026-07-08T02:28:42Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/v_stk_titles_remaining&diff=10944&oldid=prev 2008-12-04T01:56:30Z

<p>New page: ==Details== * &#039;&#039;&#039;Returns&#039;&#039;&#039;: Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Title * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/query|cat_it...</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Returns&#039;&#039;&#039;: Same records as {{vbzcart/query|v_stk_lines_remaining}}, but grouped by Title<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart/query|v_stk_lines_remaining}}, {{vbzcart/query|cat_items}}<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;:<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW v_stk_titles_remaining AS<br /> SELECT<br /> ID_Title,<br /> SUM(QtyForSale) AS QtyForSale,<br /> SUM(QtyForShip) AS QtyForShip,<br /> SUM(QtyExisting) AS QtyExisting<br /> FROM v_stk_lines_remaining AS s LEFT JOIN cat_items AS i ON s.ID_Item=i.ID<br /> GROUP BY i.ID_Title;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle