Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- FROM $nameAlbenDB.albenDB_album album, $nameAlbenDB.albenDB_artist artist, $nameAlbenDB.albenDB_owner owner, $nameAlbenDB.albenDB_quality quality, $namephpBB.phpbb3_users users
- WHERE album.albumID = owner.albumID
- AND owner.qualityID = quality.qualityID
- AND album.albumArtistID = artist.artistID
- AND users.user_id = owner.ownerID
- AND artist.artistName LIKE '" . $iFilter . "'
- AND album.albumYear LIKE '" . $jFilter . "'
- AND quality.qualityName LIKE '" . $qFilter . "'
- AND users.username LIKE '" . $bFilter . "'
- ORDER BY artist.artistName, album.albumYear ASC
Add Comment
Please, Sign In to add comment