https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCarts_info 2026-07-07T09:08:14Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryCarts_info&diff=12282&oldid=prev 2009-09-09T01:28:26Z

<p>Created page with &#039;==Details== * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart|table|shop_cart}}, {{vbzcart/query|qrySub_Carts_info_items}}, {{vbzcart/query|qrySub_Carts_info_data}} * &#039;&#039;&#039;History&#039;&#039;&#039;: ** &#039;&#039;&#039;2009-09-08&#039;&#039;…&#039;</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: {{vbzcart|table|shop_cart}}, {{vbzcart/query|qrySub_Carts_info_items}}, {{vbzcart/query|qrySub_Carts_info_data}}<br /> * &#039;&#039;&#039;History&#039;&#039;&#039;:<br /> ** &#039;&#039;&#039;2009-09-08&#039;&#039;&#039; Created for Special:VbzAdmin<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryCarts_info AS<br /> SELECT<br /> c.*,<br /> ItemCount,<br /> DataCount<br /> FROM (shop_cart AS c<br /> LEFT JOIN qrySub_Carts_info_items AS ci ON ci.ID_Cart=c.ID)<br /> LEFT JOIN qrySub_Carts_info_data as cd ON cd.ID_Cart=c.ID;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle