VbzCart/queries/qryTitles Imageless

About

• Requires:

1. REDIRECT Template:l/vc/query, qryImgs_byTitle

• Note: this is a rather slow query (10-50 seconds)
• History:
  • 2012-01-10 created for listing of Imageless Titles

SQL

<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>