photowall/database
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
database/migrations/000.595.sql
T
Arwid ThornströmandGitHub fbe3bb77fc migrations for the roomtypes (#513) 
* migrations for the roomtypes

* rename files

* updated types

* Correct migration numbers and cleanup
2025-12-16 10:40:30 +01:00

444 lines
28 KiB
SQL
Raw Permalink Blame History

-- Truncate room_roomtypes table to start fresh
TRUNCATE TABLE room_roomtypes;
-- Insert room to roomtype mappings based on roomtypes.csv
-- Each room gets mapped to its primary room type, and some rooms also get a secondary type
-- Only insert for rooms that actually exist in the rooms table
INSERT INTO room_roomtypes (room_id, roomtype_id)
SELECT t.room_id, t.roomtype_id
FROM (VALUES
(1, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(2, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(3, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(4, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(5, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(6, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(7, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(8, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(9, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(10, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(11, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(12, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(13, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(14, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(15, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(16, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(17, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(18, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(19, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(20, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(21, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(22, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(23, (SELECT id FROM roomtypes WHERE name = 'office')),
(24, (SELECT id FROM roomtypes WHERE name = 'office')),
(25, (SELECT id FROM roomtypes WHERE name = 'office')),
(26, (SELECT id FROM roomtypes WHERE name = 'office')),
(27, (SELECT id FROM roomtypes WHERE name = 'office')),
(28, (SELECT id FROM roomtypes WHERE name = 'office')),
(29, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(30, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(31, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(32, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(33, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(34, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(35, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(36, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(37, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(38, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(39, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(40, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(41, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(42, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(43, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(44, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(45, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(46, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(47, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(48, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(49, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(50, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(51, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(52, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(53, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(54, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(55, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(56, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(57, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(58, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(59, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(60, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(61, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(62, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(63, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(64, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(65, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(66, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(67, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(68, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(69, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(70, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(71, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(72, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(73, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(74, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(75, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(76, (SELECT id FROM roomtypes WHERE name = 'office')),
(77, (SELECT id FROM roomtypes WHERE name = 'office')),
(78, (SELECT id FROM roomtypes WHERE name = 'office')),
(79, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(80, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(81, (SELECT id FROM roomtypes WHERE name = 'office')),
(82, (SELECT id FROM roomtypes WHERE name = 'office')),
(83, (SELECT id FROM roomtypes WHERE name = 'office')),
(84, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(85, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(86, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(87, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(88, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(89, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(90, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(91, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(92, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(93, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(94, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(95, (SELECT id FROM roomtypes WHERE name = 'office')),
(96, (SELECT id FROM roomtypes WHERE name = 'office')),
(97, (SELECT id FROM roomtypes WHERE name = 'office')),
(98, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(99, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(100, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(101, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(102, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(103, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(104, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(105, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(106, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(107, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(108, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(109, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(110, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(111, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(112, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(113, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(114, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(115, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(116, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(117, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(118, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(119, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(120, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(121, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(122, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(123, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(124, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(125, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(126, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(127, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(128, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(129, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(130, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(131, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(132, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(133, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(134, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(135, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(136, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(137, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(138, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(139, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(140, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(141, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(142, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(143, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(144, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(145, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(146, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(147, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(148, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(149, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(150, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(151, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(152, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(153, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(154, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(155, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(156, (SELECT id FROM roomtypes WHERE name = 'office')),
(157, (SELECT id FROM roomtypes WHERE name = 'office')),
(158, (SELECT id FROM roomtypes WHERE name = 'office')),
(159, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(160, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(161, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(162, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(163, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(164, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(165, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(166, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(167, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(168, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(169, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(170, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(171, (SELECT id FROM roomtypes WHERE name = 'office')),
(172, (SELECT id FROM roomtypes WHERE name = 'office')),
(173, (SELECT id FROM roomtypes WHERE name = 'office')),
(174, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(175, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(176, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(177, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(178, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(179, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(180, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(181, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(182, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(183, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(184, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(185, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(186, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(187, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(188, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(189, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(190, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(191, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(192, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(193, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(194, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(195, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(196, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(197, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(198, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(199, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(200, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(201, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(202, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(203, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(204, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(205, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(206, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(207, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(208, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(209, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(210, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(211, (SELECT id FROM roomtypes WHERE name = 'office')),
(212, (SELECT id FROM roomtypes WHERE name = 'office')),
(213, (SELECT id FROM roomtypes WHERE name = 'office')),
(214, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(215, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(216, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(217, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(218, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(219, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(220, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(221, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(222, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(223, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(224, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(225, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(226, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(227, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(228, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(229, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(230, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(231, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(232, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(233, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(234, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(235, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(236, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(237, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(238, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(239, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(240, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(241, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(242, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(243, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(244, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(245, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(246, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(247, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(248, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(249, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(250, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(251, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(252, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(253, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(254, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(255, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(256, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(257, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(258, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(259, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(260, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(261, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(262, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(263, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(264, (SELECT id FROM roomtypes WHERE name = 'office')),
(265, (SELECT id FROM roomtypes WHERE name = 'office')),
(266, (SELECT id FROM roomtypes WHERE name = 'office')),
(267, (SELECT id FROM roomtypes WHERE name = 'office')),
(268, (SELECT id FROM roomtypes WHERE name = 'office')),
(269, (SELECT id FROM roomtypes WHERE name = 'office')),
(270, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(271, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(272, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(273, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(274, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(275, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(276, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(277, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(278, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(279, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(280, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(281, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(282, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(283, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(283, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(284, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(284, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(285, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(285, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(286, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(286, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(287, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(287, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(288, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(288, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(289, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(289, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(290, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(290, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(291, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(291, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(292, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(292, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(293, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(293, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(294, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(294, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(295, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(296, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(297, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(298, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(299, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(300, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(301, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(302, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(303, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(304, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(305, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(306, (SELECT id FROM roomtypes WHERE name = 'baby-room')),
(307, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(308, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(309, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(310, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(311, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(312, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(312, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(313, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(314, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(315, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(316, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(317, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(318, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(319, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(320, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(321, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(322, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(322, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(323, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(323, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(324, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(324, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(325, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(325, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(326, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(326, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(327, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(327, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(328, (SELECT id FROM roomtypes WHERE name = 'hallway')),
(329, (SELECT id FROM roomtypes WHERE name = 'office')),
(330, (SELECT id FROM roomtypes WHERE name = 'office')),
(330, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(331, (SELECT id FROM roomtypes WHERE name = 'office')),
(332, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(333, (SELECT id FROM roomtypes WHERE name = 'kitchen')),
(333, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(334, (SELECT id FROM roomtypes WHERE name = 'kitchen')),
(334, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(335, (SELECT id FROM roomtypes WHERE name = 'teen-room')),
(336, (SELECT id FROM roomtypes WHERE name = 'teen-room')),
(337, (SELECT id FROM roomtypes WHERE name = 'teen-room')),
(338, (SELECT id FROM roomtypes WHERE name = 'teen-room')),
(339, (SELECT id FROM roomtypes WHERE name = 'teen-room')),
(340, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(341, (SELECT id FROM roomtypes WHERE name = 'teen-room')),
(342, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(343, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(344, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(345, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(346, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(347, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(348, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(349, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(350, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(350, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(351, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(351, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(352, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(352, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(353, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(353, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(354, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(354, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(355, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(355, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(356, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(356, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(357, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(357, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(358, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(358, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(359, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(359, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(360, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(361, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(362, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(363, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(364, (SELECT id FROM roomtypes WHERE name = 'kids-room')),
(365, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(366, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(367, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(367, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(368, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(368, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(369, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(370, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(371, (SELECT id FROM roomtypes WHERE name = 'kitchen')),
(371, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(372, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(373, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(374, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(375, (SELECT id FROM roomtypes WHERE name = 'living-room')),
(376, (SELECT id FROM roomtypes WHERE name = 'dining-room')),
(377, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(378, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(379, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(379, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(380, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(380, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(381, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(381, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(382, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(382, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(383, (SELECT id FROM roomtypes WHERE name = 'bedroom')),
(383, (SELECT id FROM roomtypes WHERE name = 'close-up')),
(384, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(385, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(386, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(387, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(388, (SELECT id FROM roomtypes WHERE name = 'bathroom')),
(389, (SELECT id FROM roomtypes WHERE name = 'ceiling')),
(390, (SELECT id FROM roomtypes WHERE name = 'ceiling')),
(391, (SELECT id FROM roomtypes WHERE name = 'ceiling')),
(392, (SELECT id FROM roomtypes WHERE name = 'ceiling'))
) AS t(room_id, roomtype_id)
WHERE EXISTS (SELECT 1 FROM rooms WHERE rooms.id = t.room_id);
Reference in New Issue View Git Blame Copy Permalink