https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Fqueries%2FqryCtg_Items_active
VbzCart/queries/qryCtg Items active - Revision history
2026-07-01T12:49:03Z
Revision history for this page on the wiki
MediaWiki 1.45.3
https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_Items_active&diff=11731&oldid=prev
Woozle: used by qryCtg_src_sub
2009-05-03T23:58:05Z
<p>used by qryCtg_src_sub</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 23:58, 3 May 2009</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l2">Line 2:</td>
<td colspan="2" class="diff-lineno">Line 2:</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>* '''Purpose''': Brings up ''only'' [[../../tables/ctg_items|ctg_items]] records which are active, simplifying the final massive JOIN query a bit and hopefully avoiding any errors similar to the one mentioned above.</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>* '''Purpose''': Brings up ''only'' [[../../tables/ctg_items|ctg_items]] records which are active, simplifying the final massive JOIN query a bit and hopefully avoiding any errors similar to the one mentioned above.</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_items|ctg_items]]</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_items|ctg_items]]</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''': </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''': <ins style="font-weight: bold; text-decoration: none;">{{vbzcart/query|qryCtg_src_sub}}</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_Items_active 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_Items_active AS</div></td></tr>
</table>
Woozle
https://htyp.org/mw/index.php?title=VbzCart/queries/qryCtg_Items_active&diff=10898&oldid=prev
Woozle: moved from single-page listing
2008-11-30T19:55:29Z
<p>moved from single-page listing</p>
<p><b>New page</b></p><div>==Details==<br />
* '''Purpose''': Brings up ''only'' [[../../tables/ctg_items|ctg_items]] records which are active, simplifying the final massive JOIN query a bit and hopefully avoiding any errors similar to the one mentioned above.<br />
* '''Requires''': [[../../tables/ctg_items|ctg_items]]<br />
* '''Used by''': <br />
==SQL==<br />
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryCtg_Items_active AS<br />
SELECT<br />
*<br />
FROM ctg_items AS tgi<br />
WHERE tgi.isActive AND (tgi.PriceSell IS NOT NULL) AND (tgi.ID_ShipCost IS NOT NULL);</mysql><br />
<section end=sql /></div>
Woozle