Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- *
- FROM
- `requests`
- WHERE
- `complete` = '0' AND
- (acceptor_account_id IS NULL OR acceptor_account_id = '0')
- AND `book_id` NOT IN (
- SELECT
- GROUP_CONCAT(book_id)
- FROM
- requests
- WHERE
- acceptor_account_id='8'
- GROUP BY
- book_id
- ) AND
- (
- SELECT
- title
- FROM
- books
- WHERE
- id=requests.book_id
- ) LIKE '%Catch%'
Add Comment
Please, Sign In to add comment