Guest User

Untitled

a guest
Dec 11th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.40 KB | None | 0 0
  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%'
Add Comment
Please, Sign In to add comment