LinguaLibre
Difference between revisions of "Stats/Time"
< LinguaLibre:Stats
WikiLucas00 (talk | contribs) (Marked this version for translation) |
WikiLucas00 (talk | contribs) m (max 10 results per page, order by desc) |
||
| Line 20: | Line 20: | ||
== Monthly activity == <!--T:1--> | == Monthly activity == <!--T:1--> | ||
</translate> | </translate> | ||
| − | <query yearmonth="<translate><!--T:2--> Date</translate>" records="<translate><!--T:3--> New records</translate>" speakers="<translate><!--T:4--> Active speakers</translate>" languages="<translate><!--T:5--> Active languages</translate>"> | + | <query _pagination="10" yearmonth="<translate><!--T:2--> Date</translate>" records="<translate><!--T:3--> New records</translate>" speakers="<translate><!--T:4--> Active speakers</translate>" languages="<translate><!--T:5--> Active languages</translate>"> |
SELECT | SELECT | ||
?yearmonth | ?yearmonth | ||
| Line 34: | Line 34: | ||
} | } | ||
GROUP BY ?yearmonth | GROUP BY ?yearmonth | ||
| − | ORDER BY ?yearmonth | + | ORDER BY DESC(?yearmonth) |
</query> | </query> | ||
