VbzCart/docs/queries/qryTitleTopic Title avail: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (Created page with "==About== * '''Returns''': list of topics with title availability stats * '''Used by''': anywhere a list of topics is displayed * '''Requires''': {{vbzcart|table|brs_titles_x_top...") |
(No difference)
|
Revision as of 17:30, 25 February 2011
About
- Returns: list of topics with title availability stats
- Used by: anywhere a list of topics is displayed
- Requires: Template:Vbzcart, Template:Vbzcart
- History:
- 2011-02-25 created for Topic listings everywhere
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitleTopic_Title_avail AS SELECT
tt.ID_Topic, SUM(ti.cntForSale) AS cntForSale, SUM(ti.cntInPrint) AS cntInPrint, SUM(ti.qtyInStock) AS qtyInStock
FROM brs_titles_x_topics AS tt LEFT JOIN _titles AS ti ON tt.ID_Title=ti.ID WHERE ti.cntForSale>0 GROUP BY tt.ID_Topic;</mysql> <section end=sql />