VbzCart/queries/qryCarts info

Details

 * Requires:, ,
 * History:
 * 2009-09-08 Created for Special:VbzAdmin

SQL
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;