Search Results

455
Array ( [sStyle] => [submit] => Search [CatId] => 66104 [priceFilterOn] => 1 [priceRange] => $400 - $600 [sType] => sStyle [Page] => Search [sz] => Array ( ) ) /* s5 */ SELECT i.size,i.color, i.qty, sum(i.qty) as invQty, sum(mi.qty) as diinvqty, 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, c.masterColId, StoreStyleNum FROM efashion_products AS a left join efashion_inventory as i on i.prodId=a.ProdId left join efashion_inv_manuf_dedicated as mi on mi.seq=a.ManufSeqId 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=107 AND b.EfId=107 AND ( (a.ProdPrice BETWEEN '400' AND '600' AND a.ProdPrice NOT IN('0','0.00')) OR (a.ProdSalePrice BETWEEN '400' AND '600' AND a.ProdSalePrice NOT IN('0','0.00') ) ) group by a.prodid order by invQty DESC, diinvqty desc, c.releaseDate