Re: Occurrence-based ranking [solved?]
I managed to figure out a query that does what I want. SELECT listID, COUNT(*) AS Occurrences FROM componentsToLists WHERE componentID = ANY( SELECT components.id FROM components WHERE
Re: Occurrence-based ranking [solved?]
Ben This ranks a set of lists based on the number of named parts the contain in them. anyone either a) know how to rewrite this for version 4.1 or b) make it faster. SELECT l.listID, COUNT(*) AS Occurrences FROM componentsToLists AS l INNER JOIN components AS c ON l.componentID=c.ID