https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCtg_build_sub
VbzCart/queries/qryCtg build sub - Revision history
2026-07-06T13:43:40Z
Revision history for this page on the wiki
MediaWiki 1.45.3
https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_build_sub&diff=14417&oldid=prev
Woozle: appears to be unused
2010-11-10T01:57:44Z
<p>appears to be unused</p>
<table style="background-color: #fff; color: #202122;" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 01:57, 10 November 2010</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Details==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Details==</div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''Status''': appears to be unused - not found in database</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Requires''': [[../../tables/ctg_updates|ctg_updates]], [[../../tables/ctg_groups|ctg_groups]], [[../qry_ctg_titles_active|qry_ctg_titles_active]], [[../../tables/ctg_items|ctg_items]], [[../../tables/ctg_sources|ctg_sources]], [[../../tables/cat_ioptns|cat_ioptns]], [[../../tables/cat_ittyps|cat_ittyps]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>* '''Requires''': [[../../tables/ctg_updates|ctg_updates]], [[../../tables/ctg_groups|ctg_groups]], [[../qry_ctg_titles_active|qry_ctg_titles_active]], [[../../tables/ctg_items|ctg_items]], [[../../tables/ctg_sources|ctg_sources]], [[../../tables/cat_ioptns|cat_ioptns]], [[../../tables/cat_ittyps|cat_ittyps]]</div></td></tr>
<tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>* '''Used by''': [[../qryCtg build|qryCtg build]]</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>* '''Used by''': [[../qryCtg build|qryCtg build]] <ins style="font-weight: bold; text-decoration: none;">(also unused)</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">* '''History''':</ins></div></td></tr>
<tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">** '''2010-11-09''' marked as unused</ins></div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==SQL==</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==SQL==</div></td></tr>
<tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build_sub AS</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div><section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build_sub AS</div></td></tr>
</table>
Woozle
https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_build_sub&diff=10900&oldid=prev
Woozle: moved from single-page listing
2008-11-30T19:55:55Z
<p>moved from single-page listing</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Requires''': [[../../tables/ctg_updates|ctg_updates]], [[../../tables/ctg_groups|ctg_groups]], [[../qry_ctg_titles_active|qry_ctg_titles_active]], [[../../tables/ctg_items|ctg_items]], [[../../tables/ctg_sources|ctg_sources]], [[../../tables/cat_ioptns|cat_ioptns]], [[../../tables/cat_ittyps|cat_ittyps]]<br />
* '''Used by''': [[../qryCtg build|qryCtg build]]<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_build_sub AS<br />
SELECT<br />
s.ID_Item,<br />
s.CatNum,<br />
(<br />
s.isActive <br />
AND tg.isActive<br />
AND tgi.isActive<br />
AND (c.ID_Supercede Is Null)<br />
) AS isForSale,<br />
c.isCloseOut,<br />
s.isActive,<br />
s.ID_Title,<br />
tgi.ID_ItTyp,<br />
tgi.ID_ItOpt,<br />
tgi.ID_ShipCost,<br />
tgi.PriceBuy,<br />
tgi.PriceSell,<br />
tgi.PriceList,<br />
IFNULL(tgi.Descr,CONCAT_WS(' / ',tgt.GroupDescr,o.Descr)) AS ItOpt_Descr_part,<br />
it.NameSng,<br />
s.ID_CTG_Title,<br />
s.ID_CTG_Item,<br />
tgi.Descr AS GrpItmDescr,<br />
tgt.GroupDescr AS TitleGroupDescr,<br />
o.Descr AS OptionDescr,<br />
s.CatSfx,<br />
CONCAT(tg.Sort,it.Sort,o.Sort) AS ItOpt_Sort,<br />
tgt.GroupCode AS GrpCode,<br />
tgt.GroupDescr AS GrpDescr,<br />
tgt.GroupSort AS GrpSort<br />
FROM<br />
( ( ( ( (ctg_updates AS s LEFT JOIN ctg_groups AS tg ON s.ID_CTG_Group = tg.ID<br />
) LEFT JOIN qry_ctg_titles_active AS tgt ON s.ID_CTG_Title = tgt.ID<br />
) LEFT JOIN ctg_items AS tgi ON s.ID_CTG_Item = tgi.ID<br />
) LEFT JOIN ctg_sources AS c ON tgt.ID_Source = c.ID<br />
) LEFT JOIN cat_ioptns AS o ON tgi.ID_ItOpt = o.ID<br />
) LEFT JOIN cat_ittyps AS it ON tgi.ID_ItTyp = it.ID;</mysql><br />
<section end=sql /></div>
Woozle