User:Cody/sandbox/Query: Difference between revisions
From Absit Omen Lexicon
(Created page with "{{#ask: Category:Characters | ?gender is | ?Birth date | format=csv }}") |
mNo edit summary |
||
| (30 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{# | <nowiki>{{#cargo_query: | ||
| | tables=Events | ||
| | |fields=IFNULL(title, summary), CONCAT_WS( ' ', event_date, STR_TO_DATE( event_time, '%H%i' ) )=start, summary | ||
| format= | |format=timeline | ||
}}</nowiki> | |||
{{#cargo_query: | |||
tables=Occupations | |||
|fields=CONCAT(_pageName, ': ', title), date_started=start, date_ended=end | |||
|where=date_started IS NOT NULL and date_ended IS NOT NULL and type="Hogwarts" | |||
|format=timeline | |||
}} | }} | ||
Latest revision as of 07:16, 20 June 2016
{{#cargo_query: tables=Events |fields=IFNULL(title, summary), CONCAT_WS( ' ', event_date, STR_TO_DATE( event_time, '%H%i' ) )=start, summary |format=timeline }}
