CREATE TABLE db.books (
	id INT auto_increment not NULL,
	title varchar(100) NULL,
	category_id INT NULL,
	PRIMARY  key (id)
)
CREATE TABLE db.books_categories (
	id INT auto_increment not NULL,
	category varchar(100) NULL,
	PRIMARY  key (id)
)
CREATE TABLE db.collection (
	id INT auto_increment not NULL,
	title varchar(100) NULL,
	PRIMARY  key (id)
)
CREATE TABLE db.collections_has_books (
	id INT auto_increment not NULL,
	collection_id int not NULL,
	book_id int not NULL,
	PRIMARY  key (id)
)
ENGINE=InnoDB
DEFAULT CHARSET=latin1
COLLATE=latin1_swedish_ci;
INSERT INTO db.books (title,category_id) VALUES
	 ('Harry Potter and the philosopher''s stone',2),
	 ('The lord of the rings',2),
	 ('Moby dick',3),
	 ('Robinson Crusoe',3),
	 ('The Time Machine',1),
	 ('The Great Gatsby',4),
	 ('The Treasure Island',3);
	 
	 
INSERT INTO db.books_categories (category) VALUES
	 ('science_fiction'),
	 ('fanstasy'),
	 ('adventures'),
	 ('other');
	 
INSERT INTO db.collection (title) VALUES
	 ('books for vacations'),
	 ('books for teenagers'),
	 ('first readings'),
	 ('books about adventrues and other stuff');
	 
INSERT INTO db.collections_has_books (collection_id, book_id) VALUES
	 (1,1),
	 (1,4),
	 (1,5),
	 (2,1),
	 (2,2),
	 (2,4),
	 (3,4),
	 (3,5),
	 (4,4),
	 (4,5),
	 (4,6);
	 

SELECT distinct `b`.* FROM `books` `b` 
LEFT JOIN `books_categories` `c` 
ON c.id = b.category_id 
LEFT JOIN `collections_has_books` `chb` 
ON chb.book_id = b.id 
WHERE (chb.collection_id != 2)  

select  *
from    books b
where   not exists (
    select  chb.collection_id
    from    collections_has_books chb
    where   chb.book_id = b.id
    and     chb.collection_id = 2
)

select * 
from books b 
    LEFT JOIN `collections_has_books` `chb` ON chb.book_id = b.id 
</details>