VbzCart/queries/qryCtg Items updates

Details

 * Requires: ctg_titles, ctg_groups, qryCtg_Sources_active, ctg_items, cat_ioptns

SQL
CREATE OR REPLACE VIEW qryCtg_Items_updates AS SELECT NULLIF(CONCAT_WS('/',g.Code,gt.GroupCode,o.CatKey),'') AS CatSfx, gt.ID_Title, g.ID AS ID_TGroup, gt.ID AS ID_TGTitle, gi.ID AS ID_TGItem, gt.ID_Source AS ID_TGSource, gi.ID_ItTyp, gi.ID_ItOpt FROM (   (      (        ctg_titles AS gt LEFT JOIN ctg_groups AS g ON g.ID=gt.ID_Group       ) LEFT JOIN qryCtg_Sources_active AS c ON gt.ID_Source=c.ID     ) LEFT JOIN ctg_items AS gi ON gi.ID_Group=g.ID   ) LEFT JOIN cat_ioptns AS o ON gi.ID_ItOpt=o.ID  WHERE (c.ID IS NOT NULL) AND g.isActive AND gt.isActive AND ((gt.WhenDiscont IS NULL) OR (gt.WhenDiscont>NOW)) AND gi.isActive;