Cargo query

Jump to navigation Jump to search
Modify query
  
  
  
  
  
  
    
    
  
  

View wikitext
{{#cargo_query:
tables=Items,Opinions
|fields=Items.Summary,Opinions.Position_link,Opinions.Stance
|where=Opinions.Topic="Syrian civil war"
|join on=Items._pageName=Opinions._pageName
|order by=CONCAT(CASE Stance
         WHEN 'for' THEN 1
         WHEN 'against' THEN 2
         WHEN 'mixed' THEN 3
         END) , `Date` DESC 
|format=ddb outline
|offset=100
|limit=100
|outline fields=Position_link,Stance
}}