Difference between revisions of "User:AsahiKaen/Sandbox3"

From A3! Wiki
(Created page with "{{#cargo_query: tables=Blog_List, Blog_Content |join on=Blog_List.number = Blog_Content.number |fields=DISTINCT Blog_List.startdate = Date, CONCAT('File:',Blog_List.chara, '...")
 
m
Line 1: Line 1:
 
{{#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=DISTINCT 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=(group by=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)
 
|order by=Blog_List.number asc
 
|order by=Blog_List.number asc

Revision as of 08:07, 26 May 2020

Error: No field named "(group by=Blog_List.startdate)" found for any of the specified database tables.