Short Prom Dresses

464
Array ( [CatId] => 105419 [page] => 6 [Page] => CatOv [sType] => sStyle [attNarrow] => 1 [atCh] => Array ( [0] => 169 [1] => 197 ) [sz] => Array ( ) [sStyle] => ) /* s5 */ SELECT count(distinct att.attId) as numAttsMatched, group_concat(distinct att.attId) as idsMatched, 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.MerchandisingFlags, a.ManufPrice, a.ProdImage, a.customImage1Primary, 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 left join efashion_manuf_styles as ms ON a.ManufSeqId=ms.seq LEFT JOIN efashion_manuf_att_style_new att ON ms.gpc=att.gpc WHERE a.ProductStatus=1 AND a.EfId=107 AND b.EfId=107 and att.attId in('169','197') group by a.prodid order by numAttsMatched desc, idsMatched asc, invQty DESC, c.releaseDate desc, diinvQty DESC