Search Results

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