VbzCart/queries/qrySub Carts info items

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 01:30, 9 September 2009 by Woozle (talk | contribs) (corrected table name in SQL; changed count field name for disambiguation in combined results)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Requires:
  1. REDIRECT Template:l/vc/table
  • History:
    • 2009-09-08 Created for Special:VbzAdmin

SQL

<mysql>CREATE OR REPLACE VIEW qrySub_Carts_info_items AS SELECT 

 ID_Cart, COUNT(ID_Cart) AS ItemCount

FROM shop_cart_line GROUP BY ID_Cart;</mysql>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qrySub_Carts_info_items&oldid=12283"