VbzCart/queries/qryImgs byTitle
Jump to navigation
Jump to search
About
- Requires:
- REDIRECT Template:l/vc/table, cat_supp
- 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>