VbzCart/docs/queries/qryCarts info

From Woozle Writes Code

< VbzCart‎ | docs‎ | queries

Revision as of 01:28, 9 September 2009 by imported>Woozle (Created page with '==Details== * '''Requires''': {{vbzcart|table|shop_cart}}, {{vbzcart/query|qrySub_Carts_info_items}}, {{vbzcart/query|qrySub_Carts_info_data}} * '''History''': ** '''2009-09-08''…')

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

Details

Requires: Template:Vbzcart, Template:Vbzcart/query, Template:Vbzcart/query
History:
- 2009-09-08 Created for Special:VbzAdmin

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCarts_info AS SELECT

 c.*,
 ItemCount,
 DataCount

FROM (shop_cart AS c

 LEFT JOIN qrySub_Carts_info_items AS ci ON ci.ID_Cart=c.ID)
 LEFT JOIN qrySub_Carts_info_data as cd ON cd.ID_Cart=c.ID;</mysql>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryCarts_info&oldid=5173"