3,726
edits
Module:Tour stats: Difference between revisions
no edit summary
MusikAnimal (talk | contribs) No edit summary |
MusikAnimal (talk | contribs) No edit summary |
||
| Line 245: | Line 245: | ||
'shows.location=location', | 'shows.location=location', | ||
'shows.festival=festival', | 'shows.festival=festival', | ||
"IF(live_show_photos._pageName IS NULL AND shows.poster IS NULL, NULL, '1')=photos", | "IF(live_show_photos._pageName IS NULL AND shows.poster IS NULL, NULL, '1')=photos", | ||
"IF(live_show_videos._pageName IS NULL, NULL, '1')=video", | "IF(live_show_videos._pageName IS NULL, NULL, '1')=video", | ||
} | } | ||
if options['group_by'] == 'song' then | |||
table.insert(fields, "live_songs.name=song") | |||
table.insert(fields, "live_songs.acoustic=acoustic") | |||
table.insert(fields, "live_songs.piano=piano") | |||
table.insert(fields, "live_songs.tease=tease") | |||
table.insert(fields, "live_songs.abandoned=abandoned") | |||
table.insert(fields, "live_songs.length=length") | |||
table.insert(fields, "live_songs.vip=vip") | |||
table.insert(fields, "live_songs.soundcheck=soundcheck") | |||
end | |||
local wheres = {} | local wheres = {} | ||
local joins = { | local joins = { | ||
| Line 373: | Line 375: | ||
date_before = false, | date_before = false, | ||
offset = false, | offset = false, | ||
group_by = false, | |||
} | } | ||