DmitryRyashchentsev
added a comment - 11/Jan/10 1:40 PM We maybe need to split this ticket.
1.Top people participators means:
person.PERSON_ID = person_ceq.PERSON_ID
order by person_ceq.PERSON_PQ
Top people contributors:
person.PERSON_ID = person_ceq.PERSON_ID
order by person_ceq.PERSON_CQ
2. Top countries - the same with COUNTRY_CEQ table
3. For information we have PQ (Participation Equity) and IQ (Information Equity). We count that people CQ(contribution equity) is sum of his infos IQs, i.e. IQ is related to CQ.