Difference between revisions of "User:AsahiKaen/Sandbox3"
From A3! Wiki
m |
m |
||
Line 8: | Line 8: | ||
}} | }} | ||
+ | vs w/o <code>group by=</code>: | ||
+ | (note Itaru's duplicate posts, 26 May 20) | ||
{{#cargo_query: tables=Blog_List, Blog_Content | {{#cargo_query: tables=Blog_List, Blog_Content | ||
|join on=Blog_List.number = Blog_Content.number | |join on=Blog_List.number = Blog_Content.number | ||
− | |fields=Blog_List.startdate = Date, CONCAT('[[File:',Blog_List.chara, ' SD Icon Round.png|33px|middle]] [[', Blog_List.chara,']]') = Author, CONCAT('[[ | + | |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 | + | |where=(Blog_Content.type = 'Blog' AND Blog_Content.number > 155) |
− | | | + | |order by=Blog_List.number asc |
|format=dynamic table | |format=dynamic table | ||
+ | |limit=500 | ||
}} | }} |
Revision as of 08:50, 26 May 2020
vs w/o group by=
:
(note Itaru's duplicate posts, 26 May 20)