-- ----------------------------
-- Table structure for `cats`
-- ----------------------------
DROP TABLE IF EXISTS `cats`;
CREATE TABLE `cats` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  `age` int(11) NOT NULL,
  `price` int(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cats
-- ----------------------------
INSERT INTO `cats` VALUES ('1', 'Leo', '1', '1000');
INSERT INTO `cats` VALUES ('2', 'Mona', '2', '1100');

-- ----------------------------
-- Table structure for `cats_images`
-- ----------------------------
DROP TABLE IF EXISTS `cats_images`;
CREATE TABLE `cats_images` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `cat_id` bigint(20) NOT NULL,
  `image_id` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cats_cat_id_fk` (`cat_id`),
  KEY `images_image_id_fk` (`image_id`),
  CONSTRAINT `images_image_id_fk` FOREIGN KEY (`image_id`) REFERENCES `images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cats_cat_id_fk` FOREIGN KEY (`cat_id`) REFERENCES `cats` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cats_images
-- ----------------------------
INSERT INTO `cats_images` VALUES ('1', '2', '1');


-- ----------------------------
-- Table structure for `images`
-- ----------------------------
DROP TABLE IF EXISTS `images`;
CREATE TABLE `images` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `url` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of images
-- ----------------------------
INSERT INTO `images` VALUES ('1', '/Mona.jpg');

SELECT cat.*
FROM cats cat 
LEFT JOIN cats_images catImg ON catImg.cat_id=cat.id
LEFT JOIN images img ON img.id = catImg.image_id
WHERE catImg.id IS NULL--WHERE catImg.id IS NOT NULL

SELECT cat.*, img.url
FROM cats cat 
LEFT JOIN cats_images catImg ON catImg.cat_id=cat.id
LEFT JOIN images img ON img.id = catImg.image_id