VbzCart/queries/qryTitles Item info

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 19:19, 7 November 2010 by Woozle (talk | contribs) (Created page with '==About== * '''Purpose''': Lists titles with some additional item-oriented info * '''Used by''': titles AdminList() (replaces {{vbzcart/query|qryCat_Titles_Item_stats}} * '''Hist…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: Lists titles with some additional item-oriented info
  • Used by: titles AdminList() (replaces
  1. REDIRECT Template:l/vc/query
  • History:
    • 2010-11-07 Created for titles AdminList(): qryCat_Titles_Item_stats was not showing titles that didn't have any Item records

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>

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