Difference between revisions of "VbzCart/queries/qryTitles Imageless"
Jump to navigation
Jump to search
(Created page with "==About== * '''Requires''': {{vbzcart/query|qryTitles_Item_info}}, {{vbzcart/query|qryImgs_byTitle}} * '''Note''': this is a rather slow query (10-50 seconds) * '''History''': **...") |
(simplified) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Requires''': {{vbzcart/query|qryTitles_Item_info}}, {{vbzcart/query|qryImgs_byTitle}} | + | * '''Requires''': {{vbzcart/query|qryTitles_Item_info}}, {{vbzcart|table|cat_images}} <s>{{vbzcart/query|qryImgs_byTitle}}</s> |
| − | * ''' | + | * '''Used by''': VbzAdmin |
* '''History''': | * '''History''': | ||
** '''2012-01-10''' created for listing of Imageless Titles | ** '''2012-01-10''' created for listing of Imageless Titles | ||
| + | ** '''2012-03-11''' simpler query returns the same results in under 8 seconds (previous version took 10-50 seconds) | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_Imageless AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW qryTitles_Imageless AS | ||
| + | SELECT | ||
| + | t.* | ||
| + | FROM qryTitles_Item_info AS t | ||
| + | LEFT JOIN cat_images AS i | ||
| + | ON t.ID=i.ID_Title | ||
| + | WHERE (i.ID IS NULL) AND (t.cntForSale > 0);</mysql><section end=sql /> | ||
| + | ===old=== | ||
| + | <mysql>CREATE OR REPLACE VIEW qryTitles_Imageless AS | ||
SELECT | SELECT | ||
t.* | t.* | ||
| Line 11: | Line 20: | ||
LEFT JOIN `qryImgs_byTitle` AS i | LEFT JOIN `qryImgs_byTitle` AS i | ||
ON t.ID=i.ID_Title | ON t.ID=i.ID_Title | ||
| − | WHERE ((i.ID_Title IS NULL) OR (i.cntActive=0)) AND (t.cntForSale > 0);</mysql | + | WHERE ((i.ID_Title IS NULL) OR (i.cntActive=0)) AND (t.cntForSale > 0);</mysql> |
Latest revision as of 14:56, 11 March 2012
About
- Requires:
- REDIRECT Template:l/vc/query, cat_images
qryImgs_byTitle
- Used by: VbzAdmin
- History:
- 2012-01-10 created for listing of Imageless Titles
- 2012-03-11 simpler query returns the same results in under 8 seconds (previous version took 10-50 seconds)
SQL
<mysql>CREATE OR REPLACE VIEW qryTitles_Imageless AS SELECT
t.*
FROM qryTitles_Item_info AS t LEFT JOIN cat_images AS i ON t.ID=i.ID_Title WHERE (i.ID IS NULL) AND (t.cntForSale > 0);</mysql>
old
<mysql>CREATE OR REPLACE VIEW qryTitles_Imageless AS SELECT
t.*
FROM `qryTitles_Item_info` AS t LEFT JOIN `qryImgs_byTitle` AS i ON t.ID=i.ID_Title WHERE ((i.ID_Title IS NULL) OR (i.cntActive=0)) AND (t.cntForSale > 0);</mysql>