https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCat_Titles_web VbzCart/queries/qryCat Titles web - Revision history 2026-07-01T12:48:55Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryCat_Titles_web&diff=10882&oldid=prev Woozle: moved from single-page listing 2008-11-30T18:47:41Z <p>moved from single-page listing</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: [[../qryCat_Titles_Item_stats|qryCat_Titles_Item_stats]]<br /> * &#039;&#039;&#039;Used by&#039;&#039;&#039;: 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.<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryCat_Titles_web AS<br /> SELECT<br /> *,<br /> CAST(CONCAT(&quot;&amp;ldquo;&quot;,Name,&quot;&amp;ldquo;: &quot;,currMinSell,IF(currMinSell=currMaxSell,&quot;&quot;,CONCAT(&quot; &amp;ndash; &quot;,currMaxSell))) AS CHAR) AS ImgText<br /> FROM qryCat_Titles_Item_stats;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div> Woozle