https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCtg_Items_updates_joinableVbzCart/queries/qryCtg Items updates joinable - Revision history2026-06-25T17:49:15ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_Items_updates_joinable&diff=10897&oldid=prevWoozle: moved from single-page listing2008-11-30T19:30:07Z<p>moved from single-page listing</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Requires''': [[../qryCtg_Items_updates|qryCtg_Items_updates]], [[../qryCat_Titles|qryCat_Titles]]<br />
* '''Used by''':<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Items_updates_joinable AS<br />
SELECT<br />
CONCAT_WS('-',u.ID_Title,u.CatSfx) AS IDS_Item,<br />
CONCAT_WS('-',t.CatNum,u.CatSfx) AS CatNum,<br />
u.*<br />
FROM qryCtg_Items_updates AS u LEFT JOIN qryCat_Titles AS t ON u.ID_Title=t.ID;</mysql><br />
<section end=sql /></div>Woozle