https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCtg_Items_updates 2026-07-01T12:49:04Z Revision history for this page on the wiki MediaWiki 1.45.3 https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_Items_updates&diff=10896&oldid=prev 2008-11-30T19:29:54Z

<p>moved from single-page listing</p> <p><b>New page</b></p><div>==Details==<br /> * &#039;&#039;&#039;Requires&#039;&#039;&#039;: [[../../tables/ctg_titles|ctg_titles]], [[../../tables/ctg_groups|ctg_groups]], [[../qryCtg_Sources_active|qryCtg_Sources_active]], [[../../tables/ctg_items|ctg_items]], [[../../tables/cat_ioptns|cat_ioptns]]<br /> ==SQL==<br /> &lt;section begin=sql /&gt;&lt;mysql&gt;CREATE OR REPLACE VIEW qryCtg_Items_updates AS<br /> SELECT<br /> NULLIF(CONCAT_WS(&#039;/&#039;,g.Code,gt.GroupCode,o.CatKey),&#039;&#039;) AS CatSfx,<br /> gt.ID_Title,<br /> g.ID AS ID_TGroup,<br /> gt.ID AS ID_TGTitle,<br /> gi.ID AS ID_TGItem,<br /> gt.ID_Source AS ID_TGSource,<br /> gi.ID_ItTyp, gi.ID_ItOpt<br /> FROM<br /> (<br /> (<br /> (<br /> ctg_titles AS gt LEFT JOIN ctg_groups AS g ON g.ID=gt.ID_Group<br /> ) LEFT JOIN qryCtg_Sources_active AS c ON gt.ID_Source=c.ID<br /> ) LEFT JOIN ctg_items AS gi ON gi.ID_Group=g.ID<br /> ) LEFT JOIN cat_ioptns AS o ON gi.ID_ItOpt=o.ID<br /> WHERE<br /> (c.ID IS NOT NULL)<br /> AND g.isActive<br /> AND gt.isActive<br /> AND ((gt.WhenDiscont IS NULL) OR (gt.WhenDiscont&gt;NOW()))<br /> AND gi.isActive;&lt;/mysql&gt;<br /> &lt;section end=sql /&gt;</div>

Woozle