VbzCart/queries/qryCarts info
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Details
- Requires: shop_cart, qrySub_Carts_info_items, qrySub_Carts_info_data
- 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 />
