VbzCart/procs/Upd Titles fr CatItems

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: sets some fields in _titles after that has been filled in by Upd_Titles_fr_Depts

[edit] SQL

CREATE PROCEDURE Upd_Titles_fr_CatItems()
    UPDATE _titles AS t LEFT JOIN (
      SELECT
        ID_Title,
        SUM(IF(i.isForSale,1,0)) AS cntForSale,
        SUM(IF(i.isInPrint,1,0)) AS cntInPrint,
        SUM(i.qtyInStock) AS qtyInStock,
        MIN(i.PriceSell) AS currMinSell,
        MAX(i.PriceSell) AS currMaxSell
       FROM cat_items AS i GROUP BY ID_Title
      ) AS ig ON ig.ID_Title=t.ID
      SET
        t.cntForSale = ig.cntForSale,
        t.cntInPrint = ig.cntInPrint,
        t.qtyInStock = ig.qtyInStock;