daily pastebin goal
83%
SHARE
TWEET

Untitled

a guest Jan 12th, 2018 51 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
Top