VbzCart/queries/qryTitles ItTyps ItTyps

About

 * Returns: list of available titles for each item type
 * This query provides some of the same information as, but (a) broken down by Item and (b) using live data.
 * Requires: ,
 * Used by: can be used by catalog pages in place of cat_items to provide realtime data (instead of relying on some cached fields in cat_items), but this is very slow; currently no known uses.
 * History:
 * 2009-04-13 had to recreate because qryTitles_ItTyps_grpItems changed
 * 2011-01-24 For consistency with :
 * ItTyp_Sort &rarr; ItTypSort
 * ItTyp_Sng &rarr; ItTypNameSng
 * ItTyp_Plr &rarr; ItTypNamePlr

SQL
CREATE OR REPLACE VIEW qryTitles_ItTyps_ItTyps AS SELECT i.*, it.Sort                      AS ItTypSort, it.NameSng                   AS ItTypNameSng, IFNULL(it.NamePlr,it.NameSng) AS ItTypNamePlr FROM qryTitles_ItTyps_grpItems AS i LEFT JOIN cat_ittyps AS it ON i.ID_ItTyp=it.ID;