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;