"select distinct p, count(ol) " +
"from Order d " +
"join d.lines ol " +
"join ol.referenceProduct p " +
"join p.options o " +
"join p.catalogs c " +
"join p.parentBrand b " +
"where o.stockAvailable > 0 " +
"and d.creationDate > :date " +
filter +
"group by p.id, p.regularPrice, p.reference, p.buyPrice, " +
"p.creationDate, p.lastModification, p.bargain, p.referenceNumber,  "  + "p.promoPrice, p.stockAvailable, p.imageUsed, p.parentBrand.id " +
"order by count(ol) desc";