5,478
edits
No edit summary |
No edit summary |
||
Line 33: | Line 33: | ||
local escaped = string.gsub(songName, "'", "\\'") | local escaped = string.gsub(songName, "'", "\\'") | ||
local query = { | local query = { | ||
join = "Setlist_Event._pageID=Setlist_Songs._pageID", | |||
where = "song_page='" .. escaped .. "'", | where = "song_page='" .. escaped .. "'", | ||
} | } | ||
local fields = {'event_page', 'leg_name', 'day', 'cast'} | local fields = {'event_page', 'leg_name', 'day', 'cast'} | ||
local events = cargo.query('Setlist_Songs', | local events = cargo.query('Setlist_Event, Setlist_Songs', | ||
table.concat(fields, ','), query) | table.concat(fields, ','), query) | ||