VbzCart/queries/qryCarts info
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Details
- Requires: shop_cart,
- REDIRECT Template:l/vc/query, qrySub_Carts_info_data
- History:
- 2009-09-08 Created for Special:VbzAdmin
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>