Woozle: source table renamed

2011-09-28T23:57:37Z

source table renamed

← Older revision		Revision as of 23:57, 28 September 2011
Line 2:		Line 2:
	* '''Returns''': list of topics with title availability stats		* '''Returns''': list of topics with title availability stats
	* '''Used by''': anywhere a list of topics is displayed		* '''Used by''': anywhere a list of topics is displayed
	* '''Requires''': {{vbzcart\|table\|~~brs_titles_x_topics~~}}, {{vbzcart\|table\|_titles}}		* '''Requires''': {{vbzcart\|table\|cat_title_x_topic}}, {{vbzcart\|table\|_titles}}
	* '''History''':		* '''History''':
	** '''2011-02-25''' created for Topic listings everywhere		** '''2011-02-25''' created for Topic listings everywhere
			** '''2011-09-28''' Topic tables renamed
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitleTopic_Title_avail AS		<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitleTopic_Title_avail AS
Line 12:		Line 13:
	SUM(ti.cntInPrint) AS cntInPrint,		SUM(ti.cntInPrint) AS cntInPrint,
	SUM(ti.qtyInStock) AS qtyInStock		SUM(ti.qtyInStock) AS qtyInStock
	FROM ~~brs_titles_x_topics~~ AS tt		FROM cat_title_x_topic AS tt
	LEFT JOIN _titles AS ti		LEFT JOIN _titles AS ti
	ON tt.ID_Title=ti.ID		ON tt.ID_Title=ti.ID

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..."

2011-02-25T17:30:20Z

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..."

New page

==About==
* '''Returns''': list of topics with title availability stats
* '''Used by''': anywhere a list of topics is displayed
* '''Requires''': {{vbzcart|table|brs_titles_x_topics}}, {{vbzcart|table|_titles}}
* '''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 />

VbzCart/queries/qryTitleTopic Title avail - Revision history

Woozle: source table renamed

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..."