Guest User

Untitled

a guest
Jan 12th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. SELECT artist.artistName AS artist, album.albumName AS album, album.albumYear AS year, quality.qualityName AS quality, users.username AS user, owner.accurateScan AS accurate, owner.ownerID AS userID
  2. FROM $nameAlbenDB.albenDB_album album, $nameAlbenDB.albenDB_artist artist, $nameAlbenDB.albenDB_owner owner, $nameAlbenDB.albenDB_quality quality, $namephpBB.phpbb3_users users
  3. WHERE album.albumID = owner.albumID
  4. AND owner.qualityID = quality.qualityID
  5. AND album.albumArtistID = artist.artistID
  6. AND users.user_id = owner.ownerID
  7. AND artist.artistName LIKE '" . $iFilter . "'
  8. AND album.albumYear LIKE '" . $jFilter . "'
  9. AND quality.qualityName LIKE '" . $qFilter . "'
  10. AND users.username LIKE '" . $bFilter . "'
  11. ORDER BY artist.artistName, album.albumYear ASC
Add Comment
Please, Sign In to add comment