Difference between revisions of "VbzCart/queries/qryImgs byTitle"
Jump to navigation
Jump to search
(Created page with "==About== * '''Requires''': {{vbzcart/table|cat_depts}}, {{vbzcart/table|cat_supp}} * '''History''': ** '''2012-01-10''' created for listing of Imageless Titles ==SQL== <section ...") |
(requirement correction; more info) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Requires''': {{vbzcart | + | * '''Purpose''': returns image information grouped by ID_Title |
| + | * '''Requires''': {{vbzcart|table|cat_images}} | ||
| + | * '''Used by''': {{vbzcart/query|qryTitles_Imageless}} | ||
* '''History''': | * '''History''': | ||
** '''2012-01-10''' created for listing of Imageless Titles | ** '''2012-01-10''' created for listing of Imageless Titles | ||
Revision as of 02:02, 11 January 2012
About
- Purpose: returns image information grouped by ID_Title
- Requires: cat_images
- Used by:
- REDIRECT Template:l/vc/query
- History:
- 2012-01-10 created for listing of Imageless Titles
SQL
<mysql>CREATE OR REPLACE VIEW qryImgs_byTitle AS SELECT
ID_Title, SUM(ABS(isActive)) AS cntActive, SUM(NOT isActive) AS cntInactive
FROM cat_images GROUP BY ID_Title; </mysql>