prefix bsbm:
prefix bsbm-inst:
prefix rev:
prefix dc:
prefix xsd:
Select ?product (xsd:float(?monthCount)/?monthBeforeCount As ?ratio)
{
{ Select ?product (count(?review) As ?monthCount)
{
?review bsbm:reviewFor ?product .
?review dc:date ?date .
Filter(?date >= "%ConsecutiveMonth_1%"^^ && ?date < "%ConsecutiveMonth_2%"^^)
}
Group By ?product
} {
Select ?product (count(?review) As ?monthBeforeCount)
{
?review bsbm:reviewFor ?product .
?review dc:date ?date .
Filter(?date >= "%ConsecutiveMonth_0%"^^ && ?date < "%ConsecutiveMonth_1%"^^) #
}
Group By ?product
Having (count(?review)>0)
}
}
Order By desc(xsd:float(?monthCount) / ?monthBeforeCount) ?product
Limit 10