daily pastebin goal
44%
SHARE
TWEET

Untitled

a guest Dec 11th, 2018 63 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.     *
  3. FROM
  4.     `requests`
  5. WHERE
  6.     `complete` = '0' AND
  7.     (acceptor_account_id IS NULL OR acceptor_account_id = '0')
  8.     AND `book_id` NOT IN (
  9.                 SELECT
  10.                     GROUP_CONCAT(book_id)
  11.                 FROM
  12.                     requests
  13.                 WHERE
  14.                     acceptor_account_id='8'
  15.                 GROUP BY
  16.                     book_id
  17.                 ) AND
  18.     (  
  19.         SELECT
  20.             title
  21.         FROM
  22.             books
  23.         WHERE
  24.             id=requests.book_id
  25.     ) LIKE '%Catch%'
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top