Template:Todaypage: Difference between revisions

@@ Line 1: / Line 1: @@
-<includeonly>{{#ask: [[:+]]
+<includeonly>{{#get_db_data:
-  |format=embedded
+ db=mydb
-  |limit=1
+ |from=recentchanges
-  |offset=0
+ |where=rc_timestamp > (CURRENT_DATE - INTERVAL '30 days') AND rc_new_len > 0
+  |order by=rc_title
+  |group by=rc_title
+  |data= title=rc_title
+ |suppress error
+}}
+Changes in the last 30 days:
+{| class="wikitable"
+    ! title
+{{#for_external_table:<nowiki/>
+      {{!}}-
+      {{!}} {{{title}}}
+}}
+|}
+Or as a simple list:
+{{#for_external_table:&nbsp;
+* [[{{{title}}}]]
 }}</includeonly>

Anonymous