Difference between revisions of "User:AsahiKaen/Sandbox3"
From A3! Wiki
m |
|||
Line 3: | Line 3: | ||
|fields=Blog_List.startdate = Date, CONCAT('[[File:',Blog_List.chara, ' SD Icon Round.png|33px|middle]] [[', Blog_List.chara,']]') = Author, CONCAT('[[Troupe Member Blog#Blog-',Blog_Content.number,'|',Blog_Content.title,']]') = Title, Blog_Content.translator = Translator | |fields=Blog_List.startdate = Date, CONCAT('[[File:',Blog_List.chara, ' SD Icon Round.png|33px|middle]] [[', Blog_List.chara,']]') = Author, CONCAT('[[Troupe Member Blog#Blog-',Blog_Content.number,'|',Blog_Content.title,']]') = Title, Blog_Content.translator = Translator | ||
|where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155) | |where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155) | ||
− | |group by=Blog_List.startdate | + | |group by=Blog_List.startdate desc |
− | |||
|format=dynamic table | |format=dynamic table | ||
|limit=500 | |limit=500 | ||
}} | }} |
Revision as of 08:16, 26 May 2020