VbzCart/docs/queries/qryCat Depts

About

• Requires: Template:Vbzcart/table, Template:Vbzcart/table
• History:
  • 2008-12-11 Added isActive field (from Template:Vbzcart/table) so that Template:Vbzcart/query can show only active depts

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCat_Depts AS

 SELECT
   d.ID,
   d.Name,
   d.Sort,
   d.CatKey,
   UPPER(IFNULL(d.PageKey,d.CatKey)) AS CatKey_def,
   d.isActive,
   d.ID_Supplier,
   UPPER(CONCAT_WS('-',s.CatKey,d.CatKey)) AS CatNum,
   LOWER(CONCAT_WS("/",s.CatKey,IFNULL(d.PageKey,d.CatKey))) AS CatWeb_Dept,
   LOWER(CONCAT_WS("/",s.CatKey,d.CatKey)) AS CatWeb_Title
 FROM cat_depts AS d LEFT JOIN cat_supp AS s ON d.ID_Supplier=s.ID;</mysql>

<section end=sql />