VbzCart/queries/qryCat Titles web

Details

 * Requires: qryCat_Titles_Item_stats
 * Used by: as of 2008-05-23, used only for generating old-style titles.lst file, but it may eventually be used by active code in the rewrite.

SQL
CREATE OR REPLACE VIEW qryCat_Titles_web AS SELECT *, CAST(CONCAT("&ldquo;",Name,"&ldquo;: ",currMinSell,IF(currMinSell=currMaxSell,"",CONCAT(" – ",currMaxSell))) AS CHAR) AS ImgText FROM qryCat_Titles_Item_stats;