|
Unknown column 'diinvqty' in 'order clause'
ERRORSQL: /* s5 */ SELECT i.size,i.color, i.qty, sum(i.qty) as invQty, CurrencyType, custPhotoVersion, a.ProdId, a.ProdNum, a.ProdPrice, a.ProdSalePrice, a.ManufPrice, a.ProdImage, a.manufSeqId,
a.ManufProd, a.ManufColId, c.LinkPrefix, a.ProdShortDesc, a.ProdDesc, b.CatId, c.manufId, c.releaseDate, c.productType,
c.colNameForTitles, prodURLOverride
FROM efashion_products AS a
left join efashion_inventory as i on i.prodId=a.ProdId
LEFT JOIN efashion_prod_cat AS b ON a.ProdId=b.ProdId
LEFT JOIN efashion_manuf_cols AS c ON c.ManufColId=a.ManufColId
WHERE a.ProductStatus=1 AND a.EfId=167 AND b.EfId=167
AND ( (a.ProdPrice BETWEEN '400' AND '500' AND a.ProdPrice NOT IN('0','0.00')) OR (a.ProdSalePrice BETWEEN '400' AND '500' AND a.ProdSalePrice NOT IN('0','0.00') ) )
group by a.prodid
order by invQty DESC, diinvqty desc, c.releaseDate
Limit 0,64 |
|
