Module:Songs: Difference between revisions
no edit summary
No edit summary |
No edit summary |
||
Line 58: | Line 58: | ||
local query = { | local query = { | ||
limit = '1000', | limit = '1000', | ||
where = 'Album_Songs.singers HOLDS "' .. escaped .. '"' | where = 'Album_Songs.singers HOLDS "' .. escaped .. '"', | ||
orderBy = "Album_Songs.song_title ASC" | |||
} | } | ||
local fields = {'song_title', 'album'} | local fields = {'song_title', 'album'} | ||
Line 66: | Line 67: | ||
for _, row in ipairs(results) do | for _, row in ipairs(results) do | ||
if row.song_title and row.song_title ~= "" and not string.find(row.song_title, "%(Game Size%)") and not string.find(row.song_title, "%(PV Size%)") then | |||
table = table .. '|-\n| [[' .. row.song_title .. ']] || [[' .. row.album .. ']]\n' | |||
end | |||
end | end | ||