Size 22

 Prom 2014 Dresses In Stock Ships Today!


Upgraded processing on all "SHIPS TODAY DRESSES". Your dress will ship out the day your order is processed as long as your dress is ordered on our website before 12 pm EST. Any questions or concerns then please call us at +1 856-428-8181 or email us at info@jansboutique.com



Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'sums.catSort' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

ERRORSQL: select sum(invqty) as invqty, sum(diinvqty) as diinvqty, catSort, CurrencyType,custPhotoVersion,ProdId,ProdNum,ProdPrice,ProdSalePrice, ManufPrice, ProdImage,ManufProd,ManufColId,LinkPrefix,manufSeqId, CatId,ProdShortDesc,prodURLOverride,colNameForTitles,productType,manufId,releaseDate,sort from ( SELECT sum(i.qty) as invqty, null as diinvqty, b.catSort, CurrencyType,custPhotoVersion,a.ProdId,ProdNum,ProdPrice,ProdSalePrice, ManufPrice, ProdImage,ManufProd,c.ManufColId,LinkPrefix,manufSeqId, CatId,ProdShortDesc,prodURLOverride,colNameForTitles,productType,c.manufId,releaseDate,a.sort FROM efashion_products AS a left join efashion_inventory as i on i.prodId=a.ProdId and i.qty>0 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 b.CatId=65084 group by a.prodid UNION ALL SELECT null as invqty, sum(di.qty) as diinvqty, b.catSort, CurrencyType,custPhotoVersion,a.ProdId,ProdNum,ProdPrice,ProdSalePrice, ManufPrice, ProdImage,ManufProd,c.ManufColId,LinkPrefix,manufSeqId, CatId,ProdShortDesc,prodURLOverride,colNameForTitles,productType,c.manufId,releaseDate,a.sort FROM efashion_products AS a join efashion_inv_manuf_dedicated as di on a.ManufSeqId=di.seq 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 b.CatId=65084 and (di.arrivalDate IS NULL OR di.arrivalDate < '2017-04-11') group by a.prodid ) as sums group by prodid order by catSort DESC, invqty desc, diinvqty desc, ProdId DESC Limit 0,64