VbzCart/docs/queries/qrySub Carts info items: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (corrected table name in SQL; changed count field name for disambiguation in combined results) |
m (Woozle moved page VbzCart/VbzCart/queries/qrySub Carts info items to VbzCart/docs/queries/qrySub Carts info items without leaving a redirect: part 3/5) |
(No difference)
|
Latest revision as of 01:56, 25 February 2024
Details
- Requires: Template:Vbzcart/table
- History:
- 2009-09-08 Created for Special:VbzAdmin
SQL
<section begin=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> <section end=sql />