VbzCart/queries/qryImgs byTitle
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
About
- Purpose: returns image information grouped by ID_Title
- Requires: cat_images
- Used by: qryTitles_Imageless
- History:
- 2012-01-10 created for listing of Imageless Titles
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 />
