SELECT DISTINCT BINARY artist.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist WHERE 1 AND ( 0 OR ( 0 OR album.name LIKE '%marshall%' ESCAPE '/' OR artist.name LIKE '%marshall%' ESCAPE '/' OR tags.title LIKE '%marshall%' ESCAPE '/' ) ) AND tags.sampler = 0 AND tags.deviceid IN (1,2,3,-1) ORDER BY LOWER( artist.name ) ;SELECT DISTINCT BINARY artist.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist WHERE 1 AND ( 0 OR ( 0 OR album.name LIKE '%marshall%' ESCAPE '/' OR artist.name LIKE '%marshall%' ESCAPE '/' OR tags.title LIKE '%marshall%' ESCAPE '/' ) ) AND tags.sampler = 1 AND tags.deviceid IN (1,2,3,-1) LIMIT 1 OFFSET 0 ;SELECT DISTINCT BINARY album.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist WHERE 1 AND tags.sampler = 1 AND ( 0 OR ( 0 OR album.name LIKE '%marshall%' ESCAPE '/' OR artist.name LIKE '%marshall%' ESCAPE '/' OR tags.title LIKE '%marshall%' ESCAPE '/' ) ) AND tags.deviceid IN (1,2,3,-1) ORDER BY LOWER( album.name ) ;SELECT DISTINCT BINARY tags.title,tags.url,tags.deviceid,BINARY artist.name FROM tags LEFT JOIN album ON album.id=tags.album LEFT JOIN artist ON artist.id=tags.artist WHERE 1 AND tags.sampler = 1 AND ( 0 OR album.name = BINARY 'Metal Blade 15th Anniversary Disc 1' ) AND ( 0 OR ( 0 OR album.name LIKE '%marshall%' ESCAPE '/' OR artist.name LIKE '%marshall%' ESCAPE '/' OR tags.title LIKE '%marshall%' ESCAPE '/' ) ) AND tags.deviceid IN (1,2,3,-1) ORDER BY tags.discnumber,tags.track,LOWER( artist.name ) ,LOWER( tags.title ) ,LOWER( tags.url ) ;SELECT images.deviceid,images.path FROM images, artist, tags WHERE images.artist = artist.name AND artist.id = tags.artist AND tags.sampler = 1 AND images.album LIKE 'Metal Blade 15th Anniversary Disc 1' ESCAPE '/' AND images.deviceid IN (1,2,3,-1)SELECT embed.hash, embed.deviceid, embed.url FROM tags INNER JOIN embed ON tags.url = embed.url INNER JOIN album ON tags.album = album.id WHERE album.name = 'Metal Blade 15th Anniversary Disc 1' AND tags.sampler = 1 ORDER BY modifydate DESC LIMIT 1;