VbzCart/docs/queries/qryImgs byTitle: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (requirement correction; more info) |
m (Woozle moved page VbzCart/VbzCart/queries/qryImgs byTitle to VbzCart/docs/queries/qryImgs byTitle without leaving a redirect: part 2) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
[[category:VbzCart/obsolete]] | |||
==About== | ==About== | ||
* '''Purpose''': returns image information grouped by ID_Title | * '''Purpose''': returns image information grouped by ID_Title | ||
* '''Requires''': {{vbzcart|table|cat_images}} | * '''Requires''': {{vbzcart|table|cat_images}} | ||
* '''Used by''': {{vbzcart/query|qryTitles_Imageless}} | * '''Used by''': <s>{{vbzcart/query|qryTitles_Imageless}}</s> - no longer needed | ||
* '''History''': | * '''History''': | ||
** '''2012-01-10''' created for listing of Imageless Titles | ** '''2012-01-10''' created for listing of Imageless Titles | ||
** '''2012-03-11''' it would appear that this query is no longer needed | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryImgs_byTitle AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryImgs_byTitle AS | ||
Latest revision as of 01:55, 25 February 2024
About
- Purpose: returns image information grouped by ID_Title
- Requires: Template:Vbzcart
- Used by:
Template:Vbzcart/query- no longer needed - History:
- 2012-01-10 created for listing of Imageless Titles
- 2012-03-11 it would appear that this query is no longer needed
SQL
<section begin=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> <section end=sql />