create database test;

use test;

CREATE TABLE `books` (
  `id` int(16) NOT NULL AUTO_INCREMENT,
  `library_id` int(16) NOT NULL DEFAULT 0,
  `wings_id` int(12) NOT NULL DEFAULT 0,
  `scheduled_for_removal` int(1) DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `library_idx` (`library_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;


INSERT INTO `books` VALUES (32625,8663,707,0),(32624,8663,505,1);

CREATE TABLE `wings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `department_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

INSERT INTO `wings` VALUES (505,11745),(707,11768);

SELECT wings.id as wing_id, wings.department_id FROM wings WHERE wings.id IN ( SELECT books.wings_id FROM books  WHERE books.library_id = 8663 AND books.scheduled_for_removal=0 ) ORDER BY wings.id;

