VbzCart/docs/queries/qryTitles Item info
Jump to navigation
Jump to search
About
- Purpose: Lists titles with some additional item-oriented info
- Used by: titles AdminList() (replaces Template:Vbzcart/query
- History:
- 2010-11-07 Created for titles AdminList(): Template:Vbzcart/query was not showing titles that didn't have any Item records
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_Item_info AS SELECT
t.*, COUNT(i.ID) AS Count_Items, SUM(s.QtyForSale) AS QtyForSale
FROM (cat_titles AS t
LEFT JOIN cat_items AS i ON i.ID_Title=t.ID) LEFT JOIN qryStk_items_remaining AS s ON i.ID=s.ID_Item
GROUP BY t.ID; </mysql> <section end=sql />