: SELECT MID, AVG(Rating) as Average FROM mpr
: WHERE PID in (p1[,p2,...])
: GROUP BY MID
: ORDER BY Average DESC LIMIT 0, 10;
:
: Also I would require to boost the vales based on PIDs (some products have
: more wight than others effectively computing a wighted average)
: To handle
On 3/21/08, Chris Hostetter [EMAIL PROTECTED] wrote:
: I am investigating to implement an aggregate average function for a
document
: and require help for the same.
First off: please don't repost the same email with a different subject
(on either solr list) just because you don't recieve
so i need to compute average rating for each manufacturer for these
products(p1,p2,..) and sort by this average.
solr.search.function package provides some features but cannot be used out
of the box.
Can someone guide me as to how can I achieve this.
so for a query like (p:p1+p:p2+...)
find top
