-- Script to create database tables for the book 
-- "A Practical Introduction to Databases"
-- in a MySQL database

-- example from introduction

CREATE TABLE fruit_stand
(
    item  TEXT,
    price DECIMAL(10,2),
    unit  TEXT
);

INSERT INTO fruit_stand (item, price, unit) VALUES ('orange', 1.99, 'kg');
INSERT INTO fruit_stand (item, price, unit) VALUES ('apple', 3.49, 'kg');
INSERT INTO fruit_stand (item, price, unit) VALUES ('strawberry', 2.79, 'basket');
INSERT INTO fruit_stand (item, price, unit) VALUES ('blueberry', 2.39, 'basket');
INSERT INTO fruit_stand (item, price, unit) VALUES ('melon', 0.89, 'each');
INSERT INTO fruit_stand (item, price, unit) VALUES ('banana', 1.99, 'bunch');

-- simple books dataset

CREATE TABLE simple_authors
(
    name  TEXT,
    birth DATE,
    death DATE
);

INSERT INTO simple_authors (name, birth, death) VALUES ('Ursula K. Le Guin', '1929-10-21', '2018-01-22');
INSERT INTO simple_authors (name, birth, death) VALUES ('Chinua Achebe', '1930-11-16', '2013-03-21');
INSERT INTO simple_authors (name, birth, death) VALUES ('Isabel Allende', '1942-08-02', null);
INSERT INTO simple_authors (name, birth, death) VALUES ('Ralph Ellison', '1914-03-01', '1994-04-16');
INSERT INTO simple_authors (name, birth, death) VALUES ('Allen Ginsberg', '1926-06-03', '1997-04-05');
INSERT INTO simple_authors (name, birth, death) VALUES ('N. K. Jemisin', '1972-09-19', null);
INSERT INTO simple_authors (name, birth, death) VALUES ('Margaret Atwood', '1939-11-18', null);
INSERT INTO simple_authors (name, birth, death) VALUES ('Jhumpa Lahiri', '1967-07-11', null);
INSERT INTO simple_authors (name, birth, death) VALUES ('Ernesto Quiñonez', null, null);
INSERT INTO simple_authors (name, birth, death) VALUES ('Joy Harjo', '1951-05-09', null);
INSERT INTO simple_authors (name, birth, death) VALUES ('Liu Cixin', '1963-06-23', null);
INSERT INTO simple_authors (name, birth, death) VALUES ('J.R.R. Tolkien', '1892-01-03', '1973-09-02');

CREATE TABLE simple_books
(
    title            TEXT,
    author           TEXT,
    publication_year INTEGER,
    genre            TEXT
);

INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('The House of the Spirits', 'Isabel Allende', 1982, 'magical realism');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('The Handmaid''s Tale', 'Margaret Atwood', 1985, 'science fiction');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('In Mad Love and War', 'Joy Harjo', 1990, 'poetry');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('Invisible Man', 'Ralph Ellison', 1952, 'fiction');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('Howl and Other Poems', 'Allen Ginsberg', 1956, 'poetry');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('Bodega Dreams', 'Ernesto Quiñonez', 2000, 'fiction');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('Things Fall Apart', 'Chinua Achebe', 1958, 'historical fiction');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('The Three-Body Problem', 'Liu Cixin', 2008, 'science fiction');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('A Wizard of Earthsea', 'Ursula K. Le Guin', 1968, 'fantasy');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('The Stone Sky', 'N. K. Jemisin', 2017, 'fantasy');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('The Hobbit', 'J.R.R. Tolkien', 1937, 'fantasy');
INSERT INTO simple_books (title, author, publication_year, genre) VALUES ('Unaccustomed Earth', 'Jhumpa Lahiri', 2008, 'fiction');

-- books dataset

CREATE TABLE authors
(
    author_id INTEGER PRIMARY KEY,
    name      TEXT NOT NULL,
    birth     DATE,
    death     DATE
);

INSERT INTO authors (author_id, name, birth, death) VALUES (1, 'Leslie Marmon Silko', '1948-03-05', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (2, 'David Malouf', '1934-03-20', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (3, 'William Faulkner', '1897-09-25', '1962-07-06');
INSERT INTO authors (author_id, name, birth, death) VALUES (4, 'Clifford Simak', '1904-08-03', '1988-04-25');
INSERT INTO authors (author_id, name, birth, death) VALUES (5, 'J.R.R. Tolkien', '1892-01-03', '1973-09-02');
INSERT INTO authors (author_id, name, birth, death) VALUES (6, 'C. J. Cherryh', '1942-09-01', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (7, 'Gabriel García Márquez', '1927-03-06', '2014-04-17');
INSERT INTO authors (author_id, name, birth, death) VALUES (8, 'Kazuo Ishiguro', '1954-11-08', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (9, 'Tomas Tranströmer', '1931-04-15', '2015-03-26');
INSERT INTO authors (author_id, name, birth, death) VALUES (10, 'Neil Gaiman', '1960-11-10', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (11, 'Olga Tokarczuk', '1962-01-29', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (12, 'Ralph Ellison', '1914-03-01', '1994-04-16');
INSERT INTO authors (author_id, name, birth, death) VALUES (13, 'Joy Harjo', '1951-05-09', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (14, 'Thomas Mann', '1875-06-06', '1955-08-12');
INSERT INTO authors (author_id, name, birth, death) VALUES (15, 'Virginia Woolf', '1882-01-25', '1941-03-28');
INSERT INTO authors (author_id, name, birth, death) VALUES (16, 'Octavia E. Butler', '1947-06-22', '2006-02-24');
INSERT INTO authors (author_id, name, birth, death) VALUES (17, 'Chimamanda Ngozi Adichie', '1977-09-15', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (18, 'Edwidge Danticat', '1969-01-19', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (19, 'Leo Tolstoy', '1828-09-09', '1910-11-20');
INSERT INTO authors (author_id, name, birth, death) VALUES (20, 'Orhan Pamuk', '1952-06-07', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (21, 'Richard Wright', '1908-09-04', '1960-11-28');
INSERT INTO authors (author_id, name, birth, death) VALUES (22, 'Franz Kafka', '1883-07-03', '1924-06-03');
INSERT INTO authors (author_id, name, birth, death) VALUES (23, 'Larissa Lai', null, null);
INSERT INTO authors (author_id, name, birth, death) VALUES (24, 'Alice Munro', '1931-07-10', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (25, 'Jun''ichirō Tanizaki', '1886-07-24', '1965-07-30');
INSERT INTO authors (author_id, name, birth, death) VALUES (26, 'Viet Thanh Nguyen', '1971-03-13', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (27, 'Louise Glück', '1943-04-22', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (28, 'Mario Vargas Llosa', '1936-03-28', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (29, 'Nuruddin Farah', '1945-11-24', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (30, 'Fyodor Dostoevsky', '1821-11-11', '1881-02-09');
INSERT INTO authors (author_id, name, birth, death) VALUES (31, 'V. S. Naipaul', '1932-08-17', '2018-08-11');
INSERT INTO authors (author_id, name, birth, death) VALUES (32, 'Gao Xingjian', '1940-01-04', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (33, 'Douglas Stuart', null, null);
INSERT INTO authors (author_id, name, birth, death) VALUES (34, 'Assia Djebar', '1936-06-30', '2015-02-06');
INSERT INTO authors (author_id, name, birth, death) VALUES (35, 'Mo Yan', '1955-02-17', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (36, 'Henrik Ibsen', '1828-03-20', '1906-05-23');
INSERT INTO authors (author_id, name, birth, death) VALUES (37, 'Toni Morrison', '1931-02-18', '2019-08-05');
INSERT INTO authors (author_id, name, birth, death) VALUES (38, 'Ursula K. Le Guin', '1929-10-21', '2018-01-22');
INSERT INTO authors (author_id, name, birth, death) VALUES (39, 'Margaret Atwood', '1939-11-18', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (40, 'Liu Cixin', '1963-06-21', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (41, 'Mary Shelley', '1797-08-30', '1851-02-01');
INSERT INTO authors (author_id, name, birth, death) VALUES (42, 'Chinua Achebe', '1930-11-16', '2013-03-21');
INSERT INTO authors (author_id, name, birth, death) VALUES (43, 'David Diop', '1966-02-24', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (44, 'Ernesto Quiñonez', null, null);
INSERT INTO authors (author_id, name, birth, death) VALUES (45, 'Nicola Griffith', '1960-09-30', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (46, 'Elie Wiesel', '1928-09-30', '2016-07-02');
INSERT INTO authors (author_id, name, birth, death) VALUES (47, 'Albert Camus', '1913-11-07', '1960-01-04');
INSERT INTO authors (author_id, name, birth, death) VALUES (48, 'Rabindranath Tagore', '1861-05-07', '1941-08-07');
INSERT INTO authors (author_id, name, birth, death) VALUES (49, 'Arundhati Roy', '1961-11-24', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (50, 'Iris Murdoch', '1919-07-15', '1999-02-08');
INSERT INTO authors (author_id, name, birth, death) VALUES (51, 'Ana Castillo', '1953-06-15', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (52, 'Ismail Kadare', '1936-01-28', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (53, 'Michael Ondaatje', '1943-09-12', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (54, 'Doris Lessing', '1919-10-22', '2013-11-17');
INSERT INTO authors (author_id, name, birth, death) VALUES (55, 'Luis Alberto Urrea', '1955-08-20', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (56, 'Nana Kwame Adjei-Brenyah', null, null);
INSERT INTO authors (author_id, name, birth, death) VALUES (57, 'Jhumpa Lahiri', '1967-07-11', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (58, 'Michael Chabon', '1963-05-24', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (59, 'Allen Ginsberg', '1926-06-03', '1997-04-05');
INSERT INTO authors (author_id, name, birth, death) VALUES (60, 'Zeyn Joukhadar', null, null);
INSERT INTO authors (author_id, name, birth, death) VALUES (61, 'J. M. Coetzee', '1940-02-09', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (62, 'Isabel Allende', '1942-08-02', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (63, 'N. Scott Momaday', '1934-02-27', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (64, 'Bessie Head', '1937-07-06', '1986-04-17');
INSERT INTO authors (author_id, name, birth, death) VALUES (65, 'Hoda Barakat', null, null);
INSERT INTO authors (author_id, name, birth, death) VALUES (66, 'James Baldwin', '1924-08-02', '1987-11-30');
INSERT INTO authors (author_id, name, birth, death) VALUES (67, 'Emily Brontë', '1818-07-30', '1848-12-19');
INSERT INTO authors (author_id, name, birth, death) VALUES (68, 'Willa Cather', '1873-12-07', '1947-04-24');
INSERT INTO authors (author_id, name, birth, death) VALUES (69, 'David Grossman', '1954-01-25', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (70, 'Ibrahim Nasrallah', '1954-12-02', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (71, 'Arthur C. Clarke', '1917-12-16', '2008-03-19');
INSERT INTO authors (author_id, name, birth, death) VALUES (72, 'Han Kang', '1970-11-27', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (73, 'Harper Lee', '1926-04-28', '2016-02-19');
INSERT INTO authors (author_id, name, birth, death) VALUES (74, 'N. K. Jemisin', '1972-09-19', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (75, 'Colson Whitehead', '1969-11-06', null);
INSERT INTO authors (author_id, name, birth, death) VALUES (76, 'John Steinbeck', '1902-02-27', '1968-12-20');

CREATE TABLE books
(
    book_id          INTEGER PRIMARY KEY,
    author_id        INTEGER NOT NULL,
    title            TEXT NOT NULL,
    publication_year INTEGER,
    FOREIGN KEY (author_id) REFERENCES authors (author_id)
);

INSERT INTO books (book_id, author_id, title, publication_year) VALUES (1, 41, 'Frankenstein', 1818);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (2, 67, 'Wuthering Heights', 1847);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (3, 30, 'Crime and Punishment', 1866);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (4, 36, 'Peer Gynt', 1867);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (5, 19, 'War and Peace', 1867);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (6, 19, 'Anna Karenina', 1877);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (7, 36, 'A Doll''s House', 1879);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (8, 30, 'The Brothers Karamazov', 1879);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (9, 14, 'Buddenbrooks', 1901);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (10, 48, 'Gitanjali', 1910);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (11, 14, 'Death in Venice', 1912);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (12, 68, 'O Pioneers!', 1913);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (13, 22, 'The Metamorphosis', 1915);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (14, 68, 'The Song of the Lark', 1915);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (15, 68, 'My Antonia', 1918);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (16, 68, 'One of Ours', 1922);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (17, 14, 'The Magic Mountain', 1924);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (18, 25, 'Naomi', 1925);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (19, 15, 'Mrs Dalloway', 1925);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (20, 22, 'The Trial', 1925);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (21, 15, 'To the Lighthouse', 1927);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (22, 15, 'Orlando', 1928);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (23, 3, 'The Sound and the Fury', 1929);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (24, 15, 'A Room of One''s Own', 1929);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (25, 3, 'As I Lay Dying', 1930);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (26, 3, 'Absalom, Absalom!', 1936);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (27, 76, 'Of Mice and Men', 1937);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (28, 5, 'The Hobbit', 1937);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (29, 76, 'The Grapes of Wrath', 1939);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (30, 14, 'Lotte in Weimar', 1939);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (31, 21, 'Native Son', 1940);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (32, 47, 'The Stranger', 1942);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (33, 76, 'Cannery Row', 1945);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (34, 21, 'Black Boy', 1945);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (35, 14, 'Doctor Faustus', 1947);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (36, 54, 'The Grass is Singing', 1950);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (37, 14, 'The Holy Sinner', 1951);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (38, 76, 'East of Eden', 1952);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (39, 12, 'Invisible Man', 1952);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (40, 21, 'The Outsider', 1953);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (41, 66, 'Go Tell It on the Mountain', 1953);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (42, 3, 'A Fable', 1954);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (43, 5, 'The Fellowship of the Ring', 1954);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (44, 5, 'The Two Towers', 1954);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (45, 5, 'The Return of the King', 1955);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (46, 66, 'Notes of a Native Son', 1955);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (47, 59, 'Howl and Other Poems', 1956);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (48, 71, 'The City and the Stars', 1956);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (49, 66, 'Giovanni''s Room', 1956);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (50, 46, 'Night', 1956);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (51, 42, 'Things Fall Apart', 1958);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (52, 42, 'No Longer at Ease', 1960);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (53, 73, 'To Kill a Mockingbird', 1960);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (54, 31, 'A House for Mr. Biswas', 1961);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (55, 66, 'Nobody Knows My Name', 1961);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (56, 59, 'Kaddish and Other Poems', 1961);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (57, 66, 'Another Country', 1962);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (58, 3, 'The Reivers', 1962);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (59, 54, 'The Golden Notebook', 1962);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (60, 34, 'Children of the New World', 1962);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (61, 52, 'The General of the Dead Army', 1963);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (62, 28, 'The Time of the Hero', 1963);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (63, 4, 'Way Station', 1963);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (64, 42, 'Arrow of God', 1964);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (65, 42, 'A Man of the People', 1966);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (66, 7, 'One Hundred Years of Solitude', 1967);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (67, 24, 'Dance of the Happy Shades', 1968);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (68, 63, 'House Made of Dawn', 1968);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (69, 38, 'A Wizard of Earthsea', 1968);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (70, 71, '2001: A Space Odyssey', 1968);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (71, 66, 'Tell Me How Long the Train''s Been Gone', 1968);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (72, 64, 'When Rain Clouds Gather', 1968);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (73, 28, 'Conversation in the Cathedral', 1969);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (74, 63, 'The Way to Rainy Mountain', 1969);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (75, 38, 'The Left Hand of Darkness', 1969);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (76, 29, 'From a Crooked Rib', 1970);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (77, 9, 'Twenty Poems', 1970);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (78, 37, 'The Bluest Eye', 1970);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (79, 38, 'The Tombs of Atuan', 1970);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (80, 52, 'The Siege', 1970);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (81, 31, 'In a Free State', 1971);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (82, 52, 'Chronicle in Stone', 1971);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (83, 64, 'Maru', 1971);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (84, 38, 'The Farthest Shore', 1972);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (85, 59, 'The Fall of America', 1973);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (86, 71, 'Rendezvous with Rama', 1973);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (87, 37, 'Sula', 1973);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (88, 64, 'A Question of Power', 1973);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (89, 38, 'The Dispossessed', 1974);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (90, 9, 'Baltics', 1974);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (91, 66, 'If Beale Street Could Talk', 1974);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (92, 2, 'Johnno', 1975);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (93, 24, 'Who Do You Think You Are?', 1977);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (94, 37, 'Song of Solomon', 1977);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (95, 50, 'The Sea, the Sea', 1978);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (96, 71, 'The Fountains of Paradise', 1979);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (97, 31, 'A Bend in the River', 1979);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (98, 66, 'Just Above My Head', 1979);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (99, 6, 'Downbelow Station', 1981);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (100, 1, 'Storyteller', 1981);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (101, 37, 'Tar Baby', 1981);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (102, 52, 'The File on H.', 1981);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (103, 62, 'The House of the Spirits', 1982);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (104, 54, 'The Good Terrorist', 1985);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (105, 39, 'The Handmaid''s Tale', 1985);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (106, 7, 'Love in the Time of Cholera', 1985);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (107, 51, 'The Mixquiahuala Letters', 1986);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (108, 8, 'An Artist of the Floating World', 1986);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (109, 29, 'Maps', 1986);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (110, 37, 'Beloved', 1987);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (111, 31, 'The Enigma of Arrival', 1987);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (112, 34, 'A Sister to Scheherazade', 1987);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (113, 6, 'Cyteen', 1988);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (114, 8, 'The Remains of the Day', 1989);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (115, 13, 'In Mad Love and War', 1990);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (116, 38, 'Tehanu', 1990);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (117, 65, 'The Stone of Laughter', 1990);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (118, 32, 'Soul Mountain', 1990);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (119, 52, 'The Pyramid', 1992);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (120, 27, 'The Wild Iris', 1992);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (121, 53, 'The English Patient', 1992);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (122, 37, 'Jazz', 1992);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (123, 45, 'Ammonite', 1992);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (124, 35, 'The Republic of Wine', 1992);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (125, 2, 'Remembering Babylon', 1993);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (126, 55, 'Across the Wire', 1993);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (127, 18, 'Breath, Eyes, Memory', 1994);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (128, 18, 'Krik? Krak!', 1995);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (129, 23, 'When Fox Is a Thousand', 1995);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (130, 58, 'Wonder Boys', 1995);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (131, 45, 'Slow River', 1995);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (132, 51, 'My Father Was a Toltec and selected poems, 1973-1988', 1995);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (133, 16, 'Bloodchild', 1995);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (134, 9, 'Sorrow Gondola', 1996);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (135, 34, 'Algerian White', 1996);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (136, 11, 'Primeval and Other Times', 1996);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (137, 49, 'The God of Small Things', 1997);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (138, 10, 'Stardust', 1997);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (139, 24, 'The Love of a Good Woman', 1998);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (140, 16, 'Parable of the Talents', 1998);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (141, 20, 'My Name is Red', 1998);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (142, 61, 'Disgrace', 1999);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (143, 57, 'Interpreter of Maladies', 1999);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (144, 12, 'Juneteenth', 1999);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (145, 44, 'Bodega Dreams', 2000);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (146, 39, 'The Blind Assassin', 2000);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (147, 58, 'The Amazing Adventures of Kavalier and Clay', 2000);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (148, 8, 'When We Were Orphans', 2000);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (149, 10, 'American Gods', 2001);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (150, 65, 'The Tiller of Waters', 2001);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (151, 10, 'Coraline', 2002);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (152, 23, 'Salt Fish Girl', 2002);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (153, 13, 'How We Became Human', 2002);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (154, 20, 'Snow', 2002);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (155, 62, 'City of the Beasts', 2002);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (156, 17, 'Purple Hibiscus', 2003);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (157, 57, 'The Namesake', 2003);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (158, 61, 'Elizabeth Costello', 2003);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (159, 9, 'The Great Enigma', 2004);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (160, 24, 'Runaway', 2004);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (161, 61, 'Slow Man', 2005);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (162, 8, 'Never Let Me Go', 2005);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (163, 10, 'Anansi Boys', 2005);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (164, 17, 'Half of a Yellow Sun', 2006);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (165, 2, 'Every Move You Make', 2007);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (166, 18, 'Brother, I''m dying', 2007);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (167, 72, 'The Vegetarian', 2007);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (168, 11, 'Flights', 2007);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (169, 58, 'The Yiddish Policemen''s Union', 2007);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (170, 57, 'Unaccustomed Earth', 2008);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (171, 37, 'A Mercy', 2008);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (172, 52, 'The Fall of the Stone City', 2008);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (173, 40, 'The Three-Body Problem', 2008);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (174, 10, 'The Graveyard Book', 2008);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (175, 11, 'Drive Your Plow over the Bones of the Dead', 2009);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (176, 74, 'The Broken Kingdoms', 2010);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (177, 74, 'The Hundred Thousand Kingdoms', 2010);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (178, 74, 'The Kingdom Of Gods', 2011);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (179, 58, 'Telegraph Avenue', 2012);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (180, 17, 'Americanah', 2013);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (181, 57, 'The Lowland', 2013);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (182, 27, 'Faithful and Virtuous Night', 2014);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (183, 69, 'A Horse Walks Into a Bar', 2014);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (184, 13, 'Conflict Resolution for Holy Beings', 2015);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (185, 74, 'The Fifth Season', 2015);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (186, 26, 'The Sympathizer', 2015);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (187, 75, 'The Underground Railroad', 2016);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (188, 74, 'The Obelisk Gate', 2016);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (189, 70, 'The Second Dog War', 2016);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (190, 49, 'The Ministry of Utmost Happiness', 2017);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (191, 26, 'The Refugees', 2017);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (192, 74, 'The Stone Sky', 2017);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (193, 56, 'Friday Black', 2018);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (194, 60, 'The Map of Salt and Stars', 2018);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (195, 23, 'The Tiger Flu', 2018);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (196, 43, 'At Night All Blood Is Black', 2018);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (197, 75, 'The Nickel Boys', 2019);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (198, 39, 'The Testaments', 2019);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (199, 33, 'Shuggie Bain', 2020);
INSERT INTO books (book_id, author_id, title, publication_year) VALUES (200, 60, 'The Thirty Names of Night', 2020);

CREATE TABLE awards
(
    award_id INTEGER PRIMARY KEY,
    name     TEXT NOT NULL,
    sponsor  TEXT,
    criteria TEXT
);

INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (1, 'MacArthur Fellowship', 'John D. and Catherine T. MacArthur Foundation', 'Given to extraordinarily talented and creative individuals as an investment in their potential');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (2, 'Neustadt International Prize for Literature', 'University of Oklahoma and World Literature Today', 'In recognition of outstanding achievement in poetry, fiction, or drama');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (3, 'Nobel Prize in Literature', 'Swedish Academy', 'To an author who has produced the most outstanding work in an idealistic direction, for the greatest benefit of mankind');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (4, 'Damon Knight Memorial Grand Master Award', 'Science Fiction and Fantasy Writers of America', 'Excellence in science fiction and fantasy writing');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (5, 'United States Poet Laureate', 'United States Congress', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (6, 'Ruth Lilly Poetry Prize', 'Poetry Foundation', 'A living US poet whose lifetime accomplishments warrant extraordinary recognition');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (7, 'Goethe Prize', 'City of Frankfurt am Main', 'Achievement worthy of honour in memory of Johann Wolfgang von Goethe');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (8, 'Pulitzer Prize for Fiction', 'Columbia University', 'For distinguished fiction published in book form by an American author, preferably dealing with American life');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (10, 'Presidential Medal of Freedom', 'President of the United States', 'Especially meritorious contribution to the security or national interests of the United States, world peace, cultural or other significant public or private endeavors');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (11, 'SFWA Grand Master Award', 'Science Fiction and Fantasy Writers of America', 'Excellence in science fiction and fantasy writing');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (13, 'Robert Frost Medal', 'Poetry Society of America', 'Distinguished lifetime achievement in American poetry');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (14, 'Israel Prize', 'State of Israel', 'Israeli citizens or organizations who have displayed excellence in their field or have contributed strongly to Israeli culture');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (17, 'Governor General’s Award for Fiction', 'Canada Council for the Arts', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (18, 'Booker Prize', 'Man Group', 'Awards the best novel written in English and published in the United Kingdom or Ireland');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (19, 'National Book Award for Poetry', 'National Book Foundation', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (20, 'Nebula Award', 'Science Fiction and Fantasy Writers of America', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (21, 'Hugo Award', 'World Science Fiction Society', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (22, 'Pulitzer Prize for Poetry', 'Columbia University', 'For a distinguished volume of original verse by an American author');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (24, 'Giller Prize', 'Giller Prize Foundation', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (25, 'National Book Critics Circle Award', 'National Book Critics Circle', 'The finest books and reviews published in English');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (26, 'Newbery Medal', 'American Library Association', 'The most distinguished contribution to American literature for children');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (27, 'National Book Award for Fiction', 'National Book Foundation', null);
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (28, 'International Booker Prize', 'Man Group', 'Until 2016, for one author''s continued creativity, development and overall contribution to fiction on the world stage; since 2016, for a single book translated into English');
INSERT INTO awards (award_id, name, sponsor, criteria) VALUES (29, 'International Prize for Arabic Fiction', 'Abu Dhabi Arabic Language Centre', null);

CREATE TABLE authors_awards
(
    author_id INTEGER NOT NULL,
    award_id  INTEGER NOT NULL,
    year      INTEGER,
    PRIMARY KEY (author_id, award_id),
    FOREIGN KEY (author_id) REFERENCES authors (author_id),
    FOREIGN KEY (award_id) REFERENCES awards (award_id)
);

INSERT INTO authors_awards (author_id, award_id, year) VALUES (1, 1, 1981);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (2, 2, 2000);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (3, 3, 1949);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (6, 4, 2016);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (7, 3, 1982);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (7, 2, 1972);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (8, 3, 2017);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (9, 3, 2011);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (11, 3, 2018);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (13, 5, 2019);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (13, 6, 2017);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (14, 7, 1949);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (14, 3, 1929);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (16, 1, 1995);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (17, 1, 2008);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (18, 2, 2017);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (18, 1, 2009);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (20, 3, 2006);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (24, 28, 2009);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (24, 3, 2013);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (26, 1, 2017);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (27, 3, 2020);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (27, 5, 2003);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (28, 3, 2010);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (29, 2, 1998);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (31, 3, 2001);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (32, 3, 2000);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (34, 2, 1996);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (35, 3, 2012);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (37, 3, 1993);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (37, 10, 2012);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (38, 11, 2003);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (42, 28, 2007);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (46, 10, 1992);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (47, 3, 1957);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (48, 3, 1913);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (52, 28, 2005);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (52, 2, 2020);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (54, 3, 2007);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (59, 13, 1986);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (61, 3, 2003);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (62, 10, 2014);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (69, 14, 2018);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (71, 11, 1985);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (74, 1, 2020);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (75, 1, 2002);
INSERT INTO authors_awards (author_id, award_id, year) VALUES (76, 3, 1962);

CREATE TABLE books_awards
(
    book_id  INTEGER NOT NULL,
    award_id INTEGER NOT NULL,
    year     INTEGER,
    PRIMARY KEY (book_id, award_id),
    FOREIGN KEY (book_id) REFERENCES books (book_id),
    FOREIGN KEY (award_id) REFERENCES awards (award_id)
);

INSERT INTO books_awards (book_id, award_id, year) VALUES (16, 8, 1923);
INSERT INTO books_awards (book_id, award_id, year) VALUES (29, 8, 1940);
INSERT INTO books_awards (book_id, award_id, year) VALUES (42, 8, 1955);
INSERT INTO books_awards (book_id, award_id, year) VALUES (42, 27, 1955);
INSERT INTO books_awards (book_id, award_id, year) VALUES (58, 8, 1963);
INSERT INTO books_awards (book_id, award_id, year) VALUES (67, 17, 1968);
INSERT INTO books_awards (book_id, award_id, year) VALUES (68, 8, 1969);
INSERT INTO books_awards (book_id, award_id, year) VALUES (81, 18, 1971);
INSERT INTO books_awards (book_id, award_id, year) VALUES (85, 19, 1974);
INSERT INTO books_awards (book_id, award_id, year) VALUES (86, 21, 1974);
INSERT INTO books_awards (book_id, award_id, year) VALUES (86, 20, 1973);
INSERT INTO books_awards (book_id, award_id, year) VALUES (89, 21, 1975);
INSERT INTO books_awards (book_id, award_id, year) VALUES (89, 20, 1975);
INSERT INTO books_awards (book_id, award_id, year) VALUES (93, 17, 1978);
INSERT INTO books_awards (book_id, award_id, year) VALUES (95, 18, 1978);
INSERT INTO books_awards (book_id, award_id, year) VALUES (96, 21, 1980);
INSERT INTO books_awards (book_id, award_id, year) VALUES (96, 20, 1979);
INSERT INTO books_awards (book_id, award_id, year) VALUES (99, 21, 1982);
INSERT INTO books_awards (book_id, award_id, year) VALUES (113, 21, 1989);
INSERT INTO books_awards (book_id, award_id, year) VALUES (114, 18, 1989);
INSERT INTO books_awards (book_id, award_id, year) VALUES (116, 20, 1991);
INSERT INTO books_awards (book_id, award_id, year) VALUES (120, 22, 1993);
INSERT INTO books_awards (book_id, award_id, year) VALUES (121, 18, 1992);
INSERT INTO books_awards (book_id, award_id, year) VALUES (131, 20, 1997);
INSERT INTO books_awards (book_id, award_id, year) VALUES (133, 20, 1984);
INSERT INTO books_awards (book_id, award_id, year) VALUES (137, 18, 1997);
INSERT INTO books_awards (book_id, award_id, year) VALUES (139, 25, 1998);
INSERT INTO books_awards (book_id, award_id, year) VALUES (139, 24, 1998);
INSERT INTO books_awards (book_id, award_id, year) VALUES (63, 21, 1964);
INSERT INTO books_awards (book_id, award_id, year) VALUES (140, 20, 1999);
INSERT INTO books_awards (book_id, award_id, year) VALUES (142, 18, 1999);
INSERT INTO books_awards (book_id, award_id, year) VALUES (143, 8, 1999);
INSERT INTO books_awards (book_id, award_id, year) VALUES (146, 18, 2000);
INSERT INTO books_awards (book_id, award_id, year) VALUES (147, 8, 2001);
INSERT INTO books_awards (book_id, award_id, year) VALUES (149, 21, 2002);
INSERT INTO books_awards (book_id, award_id, year) VALUES (149, 20, 2002);
INSERT INTO books_awards (book_id, award_id, year) VALUES (151, 20, 2003);
INSERT INTO books_awards (book_id, award_id, year) VALUES (151, 21, 2003);
INSERT INTO books_awards (book_id, award_id, year) VALUES (160, 24, 2004);
INSERT INTO books_awards (book_id, award_id, year) VALUES (173, 21, 2015);
INSERT INTO books_awards (book_id, award_id, year) VALUES (174, 26, 2009);
INSERT INTO books_awards (book_id, award_id, year) VALUES (174, 21, 2009);
INSERT INTO books_awards (book_id, award_id, year) VALUES (167, 28, 2016);
INSERT INTO books_awards (book_id, award_id, year) VALUES (182, 19, 2014);
INSERT INTO books_awards (book_id, award_id, year) VALUES (185, 21, 2016);
INSERT INTO books_awards (book_id, award_id, year) VALUES (186, 8, 2016);
INSERT INTO books_awards (book_id, award_id, year) VALUES (187, 27, 2016);
INSERT INTO books_awards (book_id, award_id, year) VALUES (187, 8, 2017);
INSERT INTO books_awards (book_id, award_id, year) VALUES (188, 21, 2017);
INSERT INTO books_awards (book_id, award_id, year) VALUES (183, 28, 2017);
INSERT INTO books_awards (book_id, award_id, year) VALUES (75, 20, 1970);
INSERT INTO books_awards (book_id, award_id, year) VALUES (75, 21, 1970);
INSERT INTO books_awards (book_id, award_id, year) VALUES (168, 28, 2018);
INSERT INTO books_awards (book_id, award_id, year) VALUES (197, 8, 2020);
INSERT INTO books_awards (book_id, award_id, year) VALUES (198, 18, 2019);
INSERT INTO books_awards (book_id, award_id, year) VALUES (196, 28, 2021);
INSERT INTO books_awards (book_id, award_id, year) VALUES (199, 18, 2020);
INSERT INTO books_awards (book_id, award_id, year) VALUES (189, 29, 2018);
INSERT INTO books_awards (book_id, award_id, year) VALUES (169, 21, 2008);
INSERT INTO books_awards (book_id, award_id, year) VALUES (169, 20, 2007);
INSERT INTO books_awards (book_id, award_id, year) VALUES (192, 21, 2018);
INSERT INTO books_awards (book_id, award_id, year) VALUES (39, 27, 1953);

CREATE TABLE editions
(
    edition_id         INTEGER PRIMARY KEY,
    book_id            INTEGER NOT NULL, 
    publication_year   INTEGER,
    publisher          TEXT,
    publisher_location TEXT,
    title              TEXT,
    pages              INTEGER,
    isbn10             TEXT,
    isbn13             TEXT,
    FOREIGN KEY (book_id) REFERENCES books (book_id)
);

INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (1, 28, 1937, 'G. Allen & Unwin', 'London', 'The  hobbit, or, There and back again', 310, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (2, 28, 1938, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 310, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (3, 28, 1938, 'Houghton Mifflin', null, 'The Hobbit', 320, '395071224', '9780395071229');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (4, 28, 1946, 'Allen & Unwin', 'London', 'The hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (5, 28, 1951, 'Allen and Unwin', 'London', 'The Hobbit, or, There and back again', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (6, 28, 1956, 'Del Rey Books', null, 'The Hobbit', null, null, '9780345339683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (7, 28, 1956, 'G. Allen & Unwin', 'London', 'The hobbit', 315, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (8, 28, 1957, 'Houghton Mifflin', 'Boston', 'The hobbit', 315, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (9, 28, 1965, 'Ballantine Books', 'New York', 'The Hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (10, 28, 1966, 'Allen and Unwin', 'London', 'The Hobbit', 278, '48230707', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (11, 28, 1966, 'Ballantine Books', null, 'The Hobbit', 310, '48230707', '9780048230706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (12, 28, 1966, 'George Allen & Unwin', 'London', 'The Hobbit', 179, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (13, 28, 1966, 'George Allen &Unwin', 'London', 'The hobbit, or, There and back again', 317, '48230693', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (14, 28, 1966, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 317, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (15, 28, 1966, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 255, '395071224', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (16, 28, 1967, 'Random House', 'New York', 'The Hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (17, 28, 1968, 'Longmans', 'Harlow', 'The hobbit', 279, '582186552', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (18, 28, 1969, 'Gyldendal', 'Koebenhavn', 'Hobitten eller Ud og hjem igen', 267, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (19, 28, 1969, 'J''ai lu', 'Paris, France', 'Bilbo le hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (20, 28, 1969, 'Stock', '[Paris]', 'Bilbo le Hobbit', null, '2010147804', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (21, 28, 1971, 'Allen & Unwin', 'London', 'The hobbit', 317, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (22, 28, 1972, 'Allen and Unwin', 'London', 'The hobbit', 303, '48231053', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (23, 28, 1972, 'Ballantine Books', null, 'HOBBIT', 288, '034521532X', '9780345215321');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (24, 28, 1973, 'Ballantine Books', null, 'The Hobbitt', null, '345235126', '9780345235121');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (25, 28, 1973, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 317, '395177111', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (26, 28, 1974, 'Allen & Unwin', 'London', 'The hobbit', 317, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (27, 28, 1974, 'Ballantine', null, 'The Hobbit', null, '345240316', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (28, 28, 1974, 'BBC', 'London', 'The hobbit.', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (29, 28, 1974, 'Deutscher Taschenbuch', 'München', 'Der kleine Hobbit', null, '3423071516', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (30, 28, 1974, 'Deutscher Taschenbuch Verlag', 'München', 'Der kleine Hobbit', 301, '3790301337', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (31, 28, 1975, 'Ballantine Books', null, 'The Hobbit', null, '345248260', '9780345248268');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (32, 28, 1975, 'Gyldendal', 'Koebenhavn', 'Hobitten eller Ud og hjem igen', 267, '8700050210', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (33, 28, 1975, 'Unwin Books', 'London', 'The hobbit, or, There and back again', 255, '48231266', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (34, 28, 1976, 'Allen and Unwin', 'London', 'The hobbit, or, There and back again', 286, '48231274', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (35, 28, 1976, 'Ballantine Books', 'New York, USA', 'The Hobbit or There and Back Again', 287, '345253426', '9780345253422');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (36, 28, 1976, 'Het Spectrum', 'Utrecht [etc.]', 'De hobbit, of Daarheen en weer terug', null, '9027483965', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (37, 28, 1977, 'H. N. Abrams', 'New York', 'The hobbit, or, There and back again', 220, '810910608', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (38, 28, 1977, 'Perfection Learning Prebound', null, 'The Hobbit', null, '812415833', '9780812415834');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (39, 28, 1977, 'Unwin Paperbacks', null, 'The Hobbit: or, There and Back Again', null, '458920304', '9780458920303');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (40, 28, 1977, 'Zmora-Bitan', 'Israel', 'The Hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (41, 28, 1978, 'Allen & Unwin', null, 'The Hobbit', 256, '48231479', '9780048231475');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (42, 28, 1978, 'Ballantine Books', null, 'The Hobbit, or There and Back Again', 220, '345277112', '9780345277114');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (43, 28, 1978, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 255, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (44, 28, 1978, 'Le livre de poche', 'Paris, France', 'Bilbo le hobbit', 315, '2253049417', '9782253049418');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (45, 28, 1979, 'Ballantine Books', 'Texas, USA', 'The Hobbit', 287, '345272579', '9780345272577');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (46, 28, 1979, 'Folio Society', 'London', 'The hobbit, or, There and back again', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (47, 28, 1979, 'Iwanami', 'Tōkyō', 'Hobbito no bōken / J.R.R. Tōrukin saku ', null, '4001120887', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (48, 28, 1979, 'Unwin', null, 'The Hobbit', null, '48231541', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (49, 28, 1979, 'Unwin Hyman', 'London', 'The annotated Hobbit', 335, '44403372', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (50, 28, 1980, 'Hachette', 'Paris', 'Bilbo le hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (51, 28, 1980, 'Stock', 'Paris', 'Bilbo le hobbit', 405, '225303293X', '9782253032939');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (52, 28, 1981, 'Grafton', null, 'The Hobbit', 288, '48231886', '9780048231888');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (53, 28, 1981, 'Tascabili Bompiani', 'Milano', 'Lo hobbit,o, La riconquista del tesoro.', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (54, 28, 1981, 'Unwin Publishers', 'London', 'The hobbit and the Lord of the rings', null, '48232165', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (55, 28, 1982, 'Soundelux Audio Publishing', null, 'The Hobbit', null, '5550277689', '9785550277683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (56, 28, 1982, 'Ulverscroft Large Print', null, 'The Hobbit', 380, '708980651', '9780708980651');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (57, 28, 1983, 'Ballantine Books', 'New York', 'The Hobbit', 287, '345296044', '9780345296047');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (58, 28, 1984, 'Ballantine Books', null, 'The Hobbit', null, '345318587', '9780345318589');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (59, 28, 1984, 'Ballantine Books', null, 'The Hobbit and The Lord of the Rings', null, '345296079', '9780345296078');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (60, 28, 1984, 'Circulo de Lectores', 'Spain', 'El Hobbit', null, '842261586X', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (61, 28, 1984, 'Grafton', null, 'The Hobbit', 299, '48232734', '9780048232731');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (62, 28, 1984, 'Houghton Mifflin', null, 'The Hobbit', 304, '395520215', '9780395520215');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (63, 28, 1984, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 290, '395362903', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (64, 28, 1984, 'Unwin Paperbacks', 'London', 'The Hobbit', 288, '48231886', '9780048231888');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (65, 28, 1985, 'Addison Wesley Publishing Company', null, 'The Hobbit', null, '201111586', '9780201111583');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (66, 28, 1985, 'Ballantine Books', null, 'The Hobbit', null, '345332075', '9780345332073');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (67, 28, 1985, 'Minotauro', 'México, D.F', 'El hobbit', 315, '9684460368', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (68, 28, 1986, 'Ballantine Books', 'New York, USA', 'The Hobbit or There and Back Again', 287, '345339681', '9780345339683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (69, 28, 1986, 'Ballantine Books', null, 'The Hobbit', 320, '345339681', '9780345339683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (70, 28, 1986, 'Del Rey Books', null, 'The Hobbit', 306, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (71, 28, 1986, 'Hotho & Co', null, 'Hobbit/Dc340 Cassette', null, '9997018222', '9789997018229');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (72, 28, 1986, 'Turtleback', 'St. Louis, Missouri', 'The Hobbit', 320, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (73, 28, 1986, 'Unwin Paperbacks', 'London', 'The Hobbit, or There and Back Again', 285, '48231886', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (74, 28, 1987, 'HarperCollins Publishers Ltd', null, 'The Hobbit', null, '48232165', '9780048232168');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (75, 28, 1987, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 317, '395177111', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (76, 28, 1987, 'Houghton Mifflin Company', null, 'The Hobbit', null, '395454026', '9780395454022');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (77, 28, 1987, 'Unwin Hyman', 'London', 'The hobbit, or, There and back again', 256, '48233862', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (78, 28, 1987, 'Unwin Paperbacks', 'London', 'The Hobbit', 290, '48233803', '9780048233806');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (79, 28, 1988, 'Ballantine Books', null, 'The Hobbit', null, '345008618', '9780345008619');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (80, 28, 1988, 'Ballantine Books', 'New York, USA', 'The Hobbit or There and Back Again', 304, '345339681', '9780345339683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (81, 28, 1988, 'French & European Pubns', null, 'Bilbo le Hobbit', null, '785922059', '9780785922056');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (82, 28, 1988, 'Houghton Mifflin', null, 'The Hobbit', null, '395282659', '9780395282656');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (83, 28, 1988, 'Houghton Mifflin Co.', 'Boston, USA', 'The Annotated Hobbit', 335, '395476909', '9780395476901');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (84, 28, 1988, 'Houghton Mifflin Company', null, 'Annotated Hobbit', null, '5552438310', '9785552438310');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (85, 28, 1988, 'Unwin Hyman', 'London', 'The annotated Hobbit', 335, '44403372', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (86, 28, 1989, 'Eclipse Books', null, 'Hobbit or There and Back Again', null, '913035807', '9780913035801');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (87, 28, 1989, 'Tandem Library', null, 'Hobbit', null, '061382735X', '9780613827355');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (88, 28, 1990, 'Easton Press', 'Norwalk, Conn', 'The hobbit, or, There and back again', 317, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (89, 28, 1990, 'Eclipse Books', 'Forestville, Calif', 'The Hobbit, or, There and back again', 133, '345368584', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (90, 28, 1990, 'Eclipse Books', null, 'The Hobbit', 44, '913035815', '9780913035818');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (91, 28, 1990, 'Ediciones Minotauro', 'Barcelona', 'El Hobbit', null, '844507153X', '9788445071533');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (92, 28, 1990, 'Grafton', null, 'The Hobbit', 46, '44408129', '9780044408123');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (93, 28, 1990, 'HarperCollins', null, 'The hobbit or, There and back again.', 290, '261102494', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (94, 28, 1990, 'Random House Value Publishing', null, 'The Annotated Hobbit', null, '517029359', '9780517029350');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (95, 28, 1990, 'Soundelux Audio Pub', null, 'The Hobbit', null, '1559350326', '9781559350327');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (96, 28, 1990, 'World Pubns', null, 'Hobbit', null, '792443489', '9780792443483');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (97, 28, 1991, '"Detskai︠a︡ lit-ra"', 'Leningrad', 'Khobbit, ili, Tuda i obratno', 252, '5080000988', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (98, 28, 1991, 'HarperCollins', null, 'Annotated Hobbit', null, '261102516', '9780261102514');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (99, 28, 1991, 'ISIS Large Print Books', null, 'The Hobbit', 363, '1850898057', '9781850898054');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (100, 28, 1991, 'Iskry', 'Warszawa', 'Hobbit, czyli, Tam i z powrotem', 233, '8320706149', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (101, 28, 1991, 'Minotauro', null, 'El Hobbit', null, '8445070371', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (102, 28, 1991, 'Odeon', 'Praha', 'Hobit', 379, '8020702628', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (103, 28, 1991, 'Prentice Hall', null, 'The Hobbit', null, '137171668', '9780137171668');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (104, 28, 1991, 'Recorded Books, LLC', null, 'The Hobbit, Prequel to the Lord of the Rings Trilogy (The Lord of the Rings Trilogy)', null, '788737279', '9780788737275');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (105, 28, 1992, 'Book Club Association', null, 'The Hobbit.', 288, '261102001', '9780261102002');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (106, 28, 1992, 'Grafton', 'London', 'The illustrated Hobbit', 304, '261102508', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (107, 28, 1992, 'Random House Audio', null, 'The Hobbit', null, '553700251', '9780553700251');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (108, 28, 1992, 'Random House Audio', null, 'The Hobbit', null, '553745050', '9780553745054');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (109, 28, 1993, 'BBS Publishing Corporation', null, 'The Hobbit', 220, '883657465', '9780883657461');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (110, 28, 1993, 'CollinsEducational', 'London', 'The hobbit', 285, '3300900', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (111, 28, 1993, 'HarperCollins', null, 'The Hobbit', 285, '261102214', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (112, 28, 1993, 'HarperCollins Audio', null, 'The Hobbit', null, '1046764', '9780001046764');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (113, 28, 1994, 'DH Audio', null, 'The Hobbit', null, '886463564', '9780886463564');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (114, 28, 1995, 'Minotauro', 'Buenos Aires, Argentina', 'El Hobbit', null, '950547007X', '9789505470075');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (115, 28, 1996, 'Ballantine', 'New York', 'The hobbit', 304, '345339681', '9780345339683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (116, 28, 1996, 'Ted Smart', 'London', 'The Hobbit', 276, '7637705', '9780007637706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (117, 28, 1997, 'Altikirbes Yayin', 'Istanbul', 'Hobbit', 324, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (118, 28, 1997, 'Azbuka', 'Sankt-Peterburg', 'Khobbit, ili Tuda i obratno', 333, '5768404732', '9785768404734');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (119, 28, 1997, 'HarperCollins Publishers Ltd', null, 'The Hobbit', 304, '026110330X', '9780261103306');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (120, 28, 1997, 'Houghton Mifflin Co.', 'Boston', 'The hobbit, or, There and back again', 255, '395071224', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (121, 28, 1997, 'Houghton Mifflin Co.', 'Boston', 'The hobbit, or, There and back again', 288, '395873460', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (122, 28, 1997, 'Houghton Mifflin Company', 'Boston, USA', 'The Hobbit', null, '618002219', '9780618002214');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (123, 28, 1997, 'ISKRY', 'Warszawa', 'Hobbit', null, '8320714745', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (124, 28, 1997, 'Minotauro', null, 'El Hobbit (Ilustrado)', 304, '844507282X', '9788445072820');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (125, 28, 1997, 'Random House Audio', null, 'The Hobbit (J.R.R. Tolkien)', null, '553471074', '9780553471076');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (126, 28, 1998, 'Collins', null, 'The Hobbit (Collins Modern Classics)', 384, '6754023', '9780006754022');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (127, 28, 1998, 'Klett-Cotta', null, 'Der Hobbit oder Hin und zurück.', 310, '3608938052', '9783608938050');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (128, 28, 1998, 'Martin Fontes', 'Sao Paulo, Brasil', 'O Hobbit', null, '8533608810', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (129, 28, 1999, 'Ballantine Books', null, 'The Hobbit', null, '345917421', '9780345917423');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (130, 28, 1999, 'Bard', 'Bulgaria', 'The Hobbit', null, '9545850167', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (131, 28, 1999, 'Casterman', null, 'Bilbo le Hobbit', 10, '2203553936', '9782203553934');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (132, 28, 1999, 'Deutscher Taschenbuch Verlag GmbH & Co.', null, 'Der Kleine Hobbit', 331, '3423202777', '9783423202770');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (133, 28, 1999, 'Harper Collins', null, 'The Hobbit', 288, '261102575', '9780261102576');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (134, 28, 1999, 'HarperCollins Publishers', 'London, England', 'The Hobbit', 400, '261102214', '9780261102217');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (135, 28, 1999, 'HarperFestival', null, 'The Hobbit', 10, '694014362', '9780694014361');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (136, 28, 1999, 'Houghtin Mifflin', 'Boston', 'The Hobbit', null, null, '9781306430715');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (137, 28, 1999, 'Iwanami Shoten', 'Tōkyō', 'Hobitto no bōken', null, '400026463X', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (138, 28, 1999, 'Kedros Publishers', null, 'Chombit - the Hobbit', 378, '9600403082', '9789600403084');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (139, 28, 1999, 'Tandem Library', null, 'Hobbit', null, '613870662', '9780613870665');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (140, 28, 1999, 'The Folio Society', null, 'The Hobbit', 10, '1361287', '9780001361287');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (141, 28, 2000, 'Adelphi', null, 'Lo Hobbit (Gli Adelphi)', 342, '8845906884', '9788845906886');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (142, 28, 2000, 'AST - Terra Fantastica', null, 'Hobbit', null, '5170004060', '9785170004065');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (143, 28, 2000, 'Bompiani', null, 'Lo hobbit ; o, La riconquista del tesoro', 394, '8845290638', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (144, 28, 2000, 'Ediciones Minotauro', 'Barcelona (España)', 'El Hobbit', 368, '8445070371', '9788445070376');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (145, 28, 2000, 'French & European Pubns', null, 'Der Kleine Hobbit (The Hobbit in German)', 400, '828811938', '9780828811934');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (146, 28, 2000, 'French & European Pubns', null, 'El Hobbit (Spanish language version)', null, '320036871', '9780320036873');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (147, 28, 2000, 'Hachette Jeunesse', 'Paris', 'Bilbo, le Hobbit', 405, '2010199073', '9782010199073');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (148, 28, 2000, 'Harper Collins', null, 'The Hobbit', 144, '7611625', '9780261102668');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (149, 28, 2000, 'HarperCollins Audio', null, 'The Hobbit', null, '7106777', '9780007106776');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (150, 28, 2000, 'HarperCollins Publishers Ltd', null, 'The Hobbit', 320, '261103318', '9780261103313');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (151, 28, 2000, 'Houghton Mifflin', null, 'The Hobbit', null, '618087850', '9780618087853');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (152, 28, 2000, 'Listening Library', null, 'The Hobbit', null, '807288837', '9780807288832');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (153, 28, 2000, 'PAN/Rabén & Sjögren', 'Stockholm, Sweden', 'Bilbo', null, '917263071X', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (154, 28, 2000, 'Sezonoj', 'Jekaterinburg', 'La hobito', 223, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (155, 28, 2001, 'Adelphi Edizioni', 'Milano', 'Hobbum, ulu Tuda u obramno.', null, '5170104936', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (156, 28, 2001, 'Arda', null, 'An Hobbit (en breton)', 358, '2911979036', '9782911979033');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (157, 28, 2001, 'Carlsen Comics', 'Hamburg', 'Der Hobbit', 139, '3551761019', '9783551761019');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (158, 28, 2001, 'dtv', 'Munich, Germany', 'Der kleine Hobbit', 478, '3423071516', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (159, 28, 2001, 'Edicions de La Magrana', null, 'Hobbit (T. D)', 352, null, '9788482643526');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (160, 28, 2001, 'Glénat', null, 'Bilbo le Hobbit', 133, '2723436101', '9782723436106');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (161, 28, 2001, 'HarperCollins Publishers', null, 'The Hobbit', null, '7497903', '9780007497904');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (162, 28, 2001, 'HarperCollins Publishers Ltd', null, 'The hobbit', 320, '261103288', '9780261103283');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (163, 28, 2001, 'HarperCollins Publishers Ltd', null, 'The Hobbit', 320, '7105096', '9780007105090');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (164, 28, 2001, 'HarperCollins Publishers Ltd', null, 'The Hobbit', 400, '000711544X', '9780007115440');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (165, 28, 2001, 'Het Spectrum', 'Utrecht, Netherlands', 'De Hobbit, of Daarheen en weer terug', null, '9027473838', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (166, 28, 2001, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 330, '618162216', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (167, 28, 2001, 'Klett', null, 'The Hobbit.', 364, '3125777704', '9783125777705');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (168, 28, 2001, 'Listening Library', null, 'The Hobbit', null, '807205265', '9780807205266');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (169, 28, 2001, 'Martins Fontes', null, 'Hobbit, O', null, '8533608810', '9788533608818');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (170, 28, 2001, 'Minotauro', 'Barcelona, Spain', 'El Hobbit', 313, '8445071416', '9788445071410');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (171, 28, 2001, 'Rabén & Sjögren', 'Stockholm, Sweden', 'Bilbo', null, '9172632224', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (172, 28, 2001, 'Recorded Books', null, 'The Hobbit', null, '788789562', '9780788789564');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (173, 28, 2001, 'Recorded Books', null, 'The Hobbit', null, '788789821', '9780788789823');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (174, 28, 2001, 'Tandem Library', null, 'Hobbit', null, '613881656', '9780613881654');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (175, 28, 2001, 'Tsai Fong Books, Inc', null, 'Mo jie qian zhuan', null, '9570823348', '9789570823349');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (176, 28, 2001, 'Young Readers Paperback Tolkien', null, 'The Hobbit', 333, '061815082X', '9780618150823');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (177, 28, 2002, 'Christian Bourgois', null, 'Bilbo le Hobbit', 300, '2267014149', '9782267014143');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (178, 28, 2002, 'Christian Bourgois', null, 'Bilbo le Hobbit', 314, '2267013177', '9782267013177');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (179, 28, 2002, 'Distribooks', null, 'Der Kleine Hobbit', 381, '3423071516', '9783423071512');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (180, 28, 2002, 'Hachette', null, 'Bilbo, Le Hobbit', null, '2013218818', '9782013218818');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (181, 28, 2002, 'HarperCollins Audio', null, 'The Hobbit', null, '7146906', '9780007146901');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (182, 28, 2002, 'HarperCollins Audio', null, 'The Hobbit', null, '7141823', '9780007141821');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (183, 28, 2002, 'Highbridge Audio', null, 'The Hobbit', null, '1565116720', '9781565116726');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (184, 28, 2002, 'Houghton Mifflin', null, 'The Hobbit', 320, '618260307', '9780618260300');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (185, 28, 2002, 'Houghton Mifflin', 'Boston', 'The annotated hobbit', 398, '618134700', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (186, 28, 2002, 'Houghton Mifflin Company', 'Boston, USA', 'The Annotated Hobbit', 398, '618134700', '9780618134700');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (187, 28, 2002, 'Iwanami Shoten', 'Tōkyō', 'Hobbito no bōken', 330, '4001140586', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (188, 28, 2002, 'Lian jing chu ban shi ye gong si', 'Taipei Shi', '魔戒前傳：哈比人歷險記', 365, '9570823348', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (189, 28, 2002, 'Minotauro', null, 'El Hobbit', 288, '844507380X', '9788445073803');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (190, 28, 2002, 'Nhà xuá̂t bản Hội nhà văn', 'TP Hso Chí MInh', 'Chúa tể của những chiếc nhẫn', 142, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (191, 28, 2002, 'Planeta-De Agostini', 'Barcelona', 'El Hobbit', 360, '843959626X', '9788439596264');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (192, 28, 2002, 'Pocket (FR)', null, 'Bilbo, Le Hobbit', 312, '2253049417', '9782253049418');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (193, 28, 2002, 'Recorded Books', null, 'The Hobbit [UNABRIDGED]', null, '1402536941', '9781402536946');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (194, 28, 2002, 'Turtleback Books Distributed by Demco Media', null, 'El Hobbit / the Hobbit', null, '606244263', '9780606244268');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (195, 28, 2002, 'Turtleback Books Distributed by Demco Media', null, 'The Hobbit', null, '606212345', '9780606212342');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (196, 28, 2002, 'Wydawnictwo Iskry', 'Warszawa', 'Hobbit : czyli tam i z powrotem', null, '8320716810', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (197, 28, 2003, 'Azbuka-klassika', 'Moskva', 'Khobbit, ili, Tuda i obratno', 668, '5699006001', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (198, 28, 2003, 'Collins Audio', null, 'The Hobbit (Modern Classics on Tape)', null, '7158777', '9780007158775');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (199, 28, 2003, 'Grupo Anaya Comercial', 'Madrid', 'O Hobbit', 339, '8483024950', '9788483024959');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (200, 28, 2003, 'HarperCollins Publishers Ltd', null, 'The Hobbit', 656, '7156995', '9780007156993');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (201, 28, 2003, 'HarperCollins Publishers Ltd', null, 'The Hobbit', 400, '7156987', '9780007156986');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (202, 28, 2003, 'HarperCollins Publishers Ltd', null, 'The Annotated Hobbit', 512, '7137273', '9780007137275');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (203, 28, 2003, 'Izd-vo AST', 'Moskva', 'Khobbit, ili, Tuda i obratno', 382, '5170104936', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (204, 28, 2003, 'Large Print Press', null, 'The Hobbit', 483, '1594130051', '9781594130052');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (205, 28, 2003, 'Tandem Library', null, 'Hobbit', null, '613536843', '9780613536844');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (206, 28, 2003, 'Thorndike Press', 'Waterville, Me', 'The hobbit, or, There and back again', 483, '786251778', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (207, 28, 2004, 'AST', null, 'Khobbit (Lyubimoe chtenie)', 382, '517024116X', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (208, 28, 2004, 'Deutscher Taschenbuch Verlag GmbH & Co.', null, 'Der Kleine Hobbit', 331, '3423085592', '9783423085595');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (209, 28, 2004, 'ĖKSMO', 'Moskva', 'Khobbit, ili, Tuda i obratno', 1374, '5699012907', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (210, 28, 2004, 'HarperCollins Publishers Limited', null, 'Hobbit', 400, null, '9780007118359');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (211, 28, 2004, 'Minotauro', null, 'Hobbit, El - Version Infantil', null, '8445075330', '9788445075333');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (212, 28, 2004, 'Minotauro', null, 'El Hobbit / the Hobbit', 360, '8445074857', '9788445074855');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (213, 28, 2004, 'Oniks 21 vek', null, 'Khobbit (Zolotaya biblioteka)', 284, '5329011000', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (214, 28, 2004, 'Public Square Books', null, 'El Hobbit', 136, '1594970718', '9781594970719');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (215, 28, 2005, 'AST', null, 'Khobbit, ili Tuda i obratno', 274, '5170267096', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (216, 28, 2005, 'Minotauro', null, 'El Hobbit / The Hobbit', 309, '9505470630', '9789505470631');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (217, 28, 2005, 'Sezonoj', 'Kaliningrad', 'La hobito', 224, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (218, 28, 2006, 'AST', null, 'The Hobbit', 318, '5170162715', '9785170162710');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (219, 28, 2006, 'Booket', null, 'El Hobbit/ the Hobbit (Señor de los Anilos)', 309, '8445075764', '9788445075760');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (220, 28, 2006, 'Harper', 'London', 'The hobbit', 133, '261102664', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (221, 28, 2006, 'Recorded Books, Inc.', null, 'The Hobbit', null, '142812733X', '9781428127333');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (222, 28, 2007, 'Houghton Mifflin', 'Boston', 'The hobbit, or, There and back again', 300, '618968636', '9780618968633');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (223, 28, 2007, 'Houghton Mifflin', null, 'The Hobbit or There and Back Again', 255, '739410741', '9780739410745');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (224, 28, 2007, 'Minotauro', 'Barcelona', 'El Hobbit', null, '8445076736', '9788445076736');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (225, 28, 2008, 'BBC Audiobooks America', null, 'The Hobbit', null, '1602834547', '9781602834545');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (226, 28, 2008, 'Paw Prints 2008-08-11', null, 'The Hobbit', 320, '1439527261', '9781439527269');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (227, 28, 2009, 'HarperCollins', 'Glasgow', 'The Hobbit', null, null, '9780007322602');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (228, 28, 2009, 'HarperCollins', 'New York', 'The Hobbit', null, null, '9780061917738');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (229, 28, 2009, 'HarperCollins', 'London, England', 'The Hobbit', null, '7322607', '9780007322602');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (230, 28, 2009, 'NXB Văn hóa-Thông tin', 'Hà Nội', 'Hobbit', 440, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (231, 28, 2009, 'Rayo', null, 'El hobbit (Spanish Edition)', 272, '61756261', '9780061756269');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (232, 28, 2010, 'Klett-Cotta', 'Stuttgart, Germany', 'Der Hobbit', null, '3608101381', '9783608101386');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (233, 28, 2010, 'Nhà xuất bản Hội nhà văn', 'Hà Nội', 'Anh chàng Hobbit', 459, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (234, 28, 2011, 'HarperCollins', null, 'The Pocket Hobbit', null, null, '9780007440849');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (235, 28, 2011, 'HarperCollins Publishers', 'London', 'The Hobbit', null, '261103342', '9780261103344');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (236, 28, 2011, 'HarperCollins UK', null, 'The Hobbit', null, '7460449', '9780007460441');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (237, 28, 2011, 'Klett-Cotta', 'Stuttgart, Deutschland', 'Der Hobbit', 382, null, '9783608938180');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (238, 28, 2011, 'Recorded Books', null, 'The Hobbit', null, '1461836174', '9781461836179');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (239, 28, 2011, 'Texto Online', null, 'The Hobbit', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (240, 28, 2012, 'Booket', null, 'El Hobbit', 288, '8445000659', '9788445000656');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (241, 28, 2012, 'Del Rey', null, 'The Hobbit', 320, '345534832', '9780345534835');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (242, 28, 2012, 'Deutscher Taschenbuch Verlag GmbH & Co.', null, 'Der kleine Hobbit', null, '3423715006', '9783423715003');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (243, 28, 2012, 'dtv Verlagsgesellschaft', null, 'Der kleine Hobbit, Veredelte Mini-Ausgabe', null, '3423214139', '9783423214131');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (244, 28, 2012, 'dtv Verlagsgesellschaft', null, 'Der kleine Hobbit', null, '3423214120', '9783423214124');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (245, 28, 2012, 'HarperCollins', 'New York, USA', 'The Hobbit', null, '547951973', '9780547951973');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (246, 28, 2012, 'HarperCollins', null, 'The Hobbit', 400, '7487290', '9780007487295');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (247, 28, 2012, 'HarperCollins Children''s', 'London', 'The hobbit', 44, '7487355', '9780007487356');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (248, 28, 2012, 'HarperCollins Publishers', null, 'The Hobbit', null, '7458428', '9780007458424');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (249, 28, 2012, 'HarperCollins Publishers', 'London', 'The Hobbit', 389, '7487282', '9780007487288');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (250, 28, 2012, 'HarperCollins Publishers Limited', null, 'Hobbit', 168, null, '9780007464463');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (251, 28, 2012, 'Houghton Mifflin Harcourt', 'New York, USA', 'The Hobbit', null, '547951965', '9780547951966');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (252, 28, 2012, 'Houghton Mifflin Harcourt', null, 'The Hobbit: Deluxe Pocket Edition', 320, '544045521', '9780544045521');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (253, 28, 2012, 'Houghton Mifflin Harcourt', null, 'The Hobbit', 320, '547928246', '9780547928241');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (254, 28, 2012, 'Klett-Cotta Verlag', null, 'Der Hobbit', null, '3608939776', '9783608939774');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (255, 28, 2012, 'Lian jing chu ban shi ye gu fen you xian gong si', 'Taibei Shi', 'Habi ren', 340, '9570841036', '9789570841039');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (256, 28, 2012, 'Mariner Books', 'Boston', 'The Hobbit', 300, '054792822X', '9780547928227');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (257, 28, 2012, 'Minotauro', null, 'El Hobbit', null, '9788445074855', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (258, 28, 2012, 'Planeta', null, 'El Hobbit Ne', null, null, '9786070712715');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (259, 28, 2012, 'Recorded Books', null, 'The Hobbit', null, '1461836174', '9781461836179');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (260, 28, 2012, 'Turtleback Books', null, 'The Hobbit', 320, '606262407', '9780606262408');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (261, 28, 2013, 'dtv Verlagsgesellschaft', null, 'Der kleine Hobbit', null, '3423715669', '9783423715669');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (262, 28, 2013, 'HACHETTE ROMANS', null, 'Bilbo le Hobbit - texte intégral', 528, '2012039332', '9782012039339');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (263, 28, 2013, 'Harpercollins', null, 'The Hobbit', null, '7525532', '9780007525539');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (264, 28, 2013, 'Harper Collins Promotion', null, 'The Hobbit', null, '7525508', '9780007525508');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (265, 28, 2013, 'Harper Collins Publishers', 'London', 'The Hobbit', 389, '7525494', '9780007525492');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (266, 28, 2013, 'HarperCollins UK', null, 'Hobbit', null, '7497911', '9780007497911');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (267, 28, 2013, 'Houghton Mifflin Harcourt', 'Boston', 'The Hobbit', null, '544174224', '9780544174221');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (268, 28, 2013, 'Houghton Mifflin Harcourt Publishing Company', null, 'Hobbit', 368, null, '9780544239555');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (269, 28, 2013, 'Le Livre de Poche', 'Paris', 'Bilbo le Hobbit', 384, '2253177105', '9782253177104');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (270, 28, 2013, 'Mariner Books', 'Boston, USA', 'The Hobbit or There and Back Again', null, '544422848', '9780544422841');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (271, 28, 2014, 'Booket', null, 'El Hobbit', 288, '8445001418', '9788445001417');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (272, 28, 2014, 'HarperCollins', null, 'The Hobbit', 368, '8108285', '9780008108281');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (273, 28, 2014, 'HarperCollins Publishers', 'London', 'The Hobbit', 389, '7591853', '9780007591855');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (274, 28, 2014, 'HarperCollins Publishers', null, 'The Hobbit', 400, '7591861', '9780007591862');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (275, 28, 2014, 'Houghton Mifflin Harcourt', 'Boston', 'The Hobbit', 300, '544445791', '9780544445796');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (276, 28, 2015, 'Evertype', null, 'La Hobito, aŭ, Tien kaj Reen', 250, '1782011099', '9781782011095');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (277, 28, 2015, 'LGF', null, 'Le Hobbit', 408, '2253183822', '9782253183822');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (278, 28, 2015, 'Minotauro', null, 'El hobbit', null, null, '9789584242983');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (279, 28, 2016, 'HarperCollins Publishers Limited', null, 'Hobbit', 312, null, '9780007440832');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (280, 28, 2017, 'HarperCollins', null, 'The Colour Illustrated Hobbit', 320, '7497938', '9780007497935');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (281, 28, 2017, 'Iskry', 'Warszawa, Poland', 'Hobbit czyli tam i z powrotem', 315, null, '9788324403875');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (282, 28, 2017, 'Planeta Publishing', null, 'El Hobbit', 288, '6070724143', '9786070724145');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (283, 28, 2019, 'Harper Collins', null, 'O Hobbit + pôster', null, '8595084742', '9788595084742');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (284, 28, 2020, 'HarperCollins Publishers Limited', null, 'Hobbit', 320, null, '9780008376116');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (285, 28, null, 'DTV.', null, 'Der Kleine Hobbit.', 301, '3790301337', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (286, 28, null, 'Hachette', null, 'Bilbo Le Hobbit', null, '2010147804', '9782010147807');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (287, 28, null, 'Harper Collins Publishers  Stock Account', null, 'THE  HOBBIT', 256, '44400918', '9780044400912');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (288, 28, null, 'Harper Collins Publishers  Stock Account', null, 'The Hobbit', 304, '48231274', '9780048231277');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (289, 28, null, 'Longman', null, 'The Hobbit.  50 Anniversary Edition.', 288, '582348889', '9780582348882');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (290, 28, null, null, null, 'J.R.R.Tolkien''s The Hobbit or There and Back Again (The Deluxe Edtion of The World''s Most Beloved Fantasy)', null, '458938807', '9780458938803');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (291, 45, 1950, 'HARPER COLLINS', null, 'The Return of the King', 30, '8108315', '9780008108311');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (292, 45, 1955, 'George Allen & Unwin', 'London, England', 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (293, 45, 1956, 'Houghton Mifflin', 'Boston, USA', 'The Return of the King', 416, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (294, 45, 1956, 'Houghton Mifflin Company', 'Boston', 'The Return of The King', 416, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (295, 45, 1960, 'Readers Union / George Allen & Unwin', 'London, England', 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (296, 45, 1965, 'George Allen & Unwin', null, 'The Return of The King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (297, 45, 1965, 'Houghton Mifflin', 'Boston', 'The return of the king', 440, '395082560', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (298, 45, 1965, 'Houghton Mifflin', 'Boston', 'The return of the king', 440, '039548930X', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (299, 45, 1966, 'Ballantine Books', 'New York, USA', 'The Return of the King', 544, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (300, 45, 1966, 'G. Allen & Unwin', 'London, England', 'The Return of The King', 440, '48230472', '9780048230478');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (301, 45, 1967, 'Houghton Mifflin Company', null, 'The Return of The King', null, '395082560', '9780395082560');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (302, 45, 1969, 'Allen and Unwin', 'London, England', 'The Return of The King', 440, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (303, 45, 1969, 'Ballantine Books', 'New York, USA', 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (304, 45, 1970, 'Ballantine Books', 'New York, USA', 'The Return of the King', 544, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (305, 45, 1972, 'Ballantine Books', 'New York, USA', 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (306, 45, 1972, 'Klett-Cotta', 'Stuttgart, Germany', 'Die Rückkehr des Königs', null, '3608107150', '9783608107159');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (307, 45, 1973, 'Christian Bourgois', 'France', 'Le retour du roi', 569, '2266118021', '9782266118026');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (308, 45, 1973, 'Distribooks', null, 'Le Retour du Roi III', 570, '2266127918', '9782266127912');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (309, 45, 1974, 'Ballantine Books', null, 'The Return of the King (The Lord Of The Rings - The Authorized Edition)', 544, '345235118', '9780345235114');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (310, 45, 1974, 'Ballantine Books', null, 'The Return of the King', null, '345240340', '9780345240347');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (311, 45, 1975, 'Ballantine Books', null, 'The Return of the King', null, '345248295', '9780345248299');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (312, 45, 1976, 'Ballantine Books', 'New York, USA', 'The Return of the King', null, '345253450', '9780345253453');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (313, 45, 1977, 'Folio Society', 'London, England', 'The Return of The King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (314, 45, 1977, 'Le Livre de Poche', null, 'Le seigneur des anneaux, tome 3 - Le Retour du Roi', null, '2253013781', '9782253013785');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (315, 45, 1977, 'The Folio Society', 'London, England', 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (316, 45, 1977, 'Unwin Books', 'London, England', 'The Return of the King', 416, '48231142', '9780048231147');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (317, 45, 1978, 'Ballantine Books', 'New York, USA', 'The Return of the King', null, '345272609', '9780345272607');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (318, 45, 1978, 'Houghton Mifflin Co.', 'Boston, MA, USA', 'The Return of the King', 440, '395272211', '9780395272213');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (319, 45, 1978, 'Perfection Learning', null, 'The Return of the King', null, '812417674', '9780812417678');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (320, 45, 1979, 'Allen & Unwin', null, 'The Return of the King', 560, '48231576', '9780048231574');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (321, 45, 1979, 'Folio Society', 'London, England', 'The Return of The King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (322, 45, 1979, 'Het Spectrum', 'Utrecht, the Netherlands', 'De Terugkeer van de Koning', 1456, '9027401705', '9789027401700');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (323, 45, 1979, 'Hobbit Presse/Klett-Cotta', null, 'Der Herr der Ringe 3. Die Rückkehr des Königs', null, '312908200X', '9783129082003');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (324, 45, 1979, 'Pocket', null, 'Seigneur des anneaux t3', null, '2266026577', '9782266026574');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (325, 45, 1981, 'Ballantine Books', null, 'The Return of the King', null, '345296087', '9780345296085');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (326, 45, 1981, 'Houghton Mifflin', 'Boston, USA', 'The Return of The King', 440, '039531268X', '9780395312681');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (327, 45, 1981, 'Unwin Paperbacks', null, 'The Return of the King', 560, '48231878', '9780048231871');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (328, 45, 1983, 'Ballantine Books', 'New York, USA', 'The Return of The King', null, '345339738', '9780345339737');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (329, 45, 1983, 'Houghton Mifflin', 'Boston, USA', 'The Return of the King', 440, '395272211', '9780395272213');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (330, 45, 1983, 'Houghton Mifflin Company', 'Boston, USA', 'The Return of the King', 1137, '618260285', '9780618260287');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (331, 45, 1984, 'Ballantine Books', 'New York, USA', 'The Return of The King', null, '345296087', '9780345296085');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (332, 45, 1984, 'George Allen and Unwin', null, 'El Retorno del Rey', null, '9684460465', '9789684460461');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (333, 45, 1985, 'Ballantine Books', null, 'The Return of the King', null, '345332091', '9780345332097');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (334, 45, 1988, 'Ballantine Books', null, 'The Return of the King', null, '345008642', '9780345008640');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (335, 45, 1988, 'Editions Gallimard', null, 'Le seigneur des Anneaux Livre V Le retour du Roi', null, '207033483X', '9782070334834');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (336, 45, 1989, 'Ballantine Books', 'New York, USA', 'The Return of The King', 544, '345339738', '9780345339737');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (337, 45, 1990, 'Clio', 'Oxford, England', 'The Return of The King', 544, '1850894248', '9781850894247');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (338, 45, 1990, 'Czytelnik', 'Warszawa, Poland', 'Powrót Króla', null, '8385100083', '9788385100089');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (339, 45, 1990, 'Easton Press', 'Norwalk, CT, USA', 'The Return of The King', 440, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (340, 45, 1990, 'Soundelux Audio Publishing', null, 'The Return of the King', null, '1559350350', '9781559350358');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (341, 45, 1991, 'Christian Bourgois', 'Paris, France', 'Le retour du roi', 511, '2266046519', '9782266046510');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (342, 45, 1991, 'ISIS Large Print Books', null, 'The Return of the King', 544, '1850894248', '9781850894247');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (343, 45, 1992, 'Houghton Mifflin', null, 'The Return of the King', null, '395647401', '9780395647400');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (344, 45, 1993, 'HarperCollins', 'London, England', 'The Return of The King', 556, '261102370', '9780261102378');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (345, 45, 1993, 'Houghton Mifflin Co.', 'Boston, MA, USA', 'The Return of the King', 440, '039548930X', '9780395489307');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (346, 45, 1994, 'Ballantine Books', 'New York, USA', 'The Return of the King', 494, '345339738', '9780345339737');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (347, 45, 1994, 'Gallimard Jeunesse', null, 'Le Retour du Roi', 359, '2070501426', '9782070501427');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (348, 45, 1994, 'Houghton Miffin Harcourt', 'New York, USA', 'The Return of the King', null, '544449746', '9780544449749');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (349, 45, 1994, 'Houghton Mifflin', 'Boston, MA, USA', 'The Return of the King', null, '618002243', '9780618002245');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (350, 45, 1995, 'Minotauro', null, 'El Señor de los Anillos III', 417, '8445070355', '9788445070352');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (351, 45, 1996, 'HarperCollins', 'London, England', 'The Return of the King', 440, '261103407', '9780261103405');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (352, 45, 1996, 'Metis Yayınları', 'Istanbul, Turkey', 'Kralin Dönüsü', null, '9753422024', '9789753422024');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (353, 45, 1997, 'HarperCollins Publishers Ltd', null, 'The Return of the King', 432, '261103598', '9780261103597');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (354, 45, 1997, 'Recorded Books', null, 'The Return of the King', null, '1556903200', '9781556903205');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (355, 45, 1997, 'Ted Smart', null, 'The Return of the King', null, '7637683', '9780007637683');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (356, 45, 1997, 'Zysk i S-ka', null, 'Powrót Króla', 608, '8371502435', '9788371502439');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (357, 45, 1998, 'HarperCollins Publishers Ltd', null, 'The Return of the King', 432, '261102338', '9780261102330');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (358, 45, 1998, 'Pocket', null, 'Le Retour du Roi', 502, '2266070592', '9782266070591');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (359, 45, 1999, 'Ballantine Books', null, 'The Return of the King', null, '345917456', '9780345917454');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (360, 45, 1999, 'ĖKSMO', 'Moscow, Russia', 'Возвращение короля', 475, '5040019017', '9785040019014');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (361, 45, 1999, 'Gallimard Jeunesse', null, 'Le Retour du Roi', null, '2070522695', '9782070522699');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (362, 45, 1999, 'HarperCollins', 'London, England', 'The Return of the King', 554, '71233809', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (363, 45, 1999, 'HarperCollins Publishers', 'London, England', 'The Return of the King', 624, '261102370', '9780261102378');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (364, 45, 1999, 'Tandem Library', null, 'The Return of the King', null, '808520857', '9780808520856');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (365, 45, 2000, 'French & European Publications', null, 'Le Retour du Roi', null, '828816484', '9780828816489');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (366, 45, 2000, 'French & European Pubns', 'New York, USA', 'Il Retorno del Re', null, '828868298', '9780828868297');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (367, 45, 2000, 'Klett-Cotta', 'Stuttgart, Germany', 'Die Wiederkehr des Königs', 380, '3608935436', '9783608935431');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (368, 45, 2000, null, null, 'Die Rückkehr des Königs. Der Herr der Ringe 03.', null, '3608952144', '9783608952148');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (369, 45, 2001, 'Ballantine Books', 'New York, USA', 'The Return of the King', 491, '345339738', '9780345339737');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (370, 45, 2001, 'Collins', null, 'The Return of the King', 432, '7129726', '9780007129720');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (371, 45, 2001, 'Collins', 'London', 'The Return of the King', null, '000768083X', '9780007680832');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (372, 45, 2001, 'Folio Society', 'London, England', 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (373, 45, 2001, 'HarperCollins Publishers', 'London, England', 'The Return of the King', 554, '7123809', '9780007123803');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (374, 45, 2001, 'Houghton Mifflin', 'New York, USA', 'The Return of the King', 406, '618129111', '9780618129119');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (375, 45, 2001, 'Houghton Mifflin Company', 'Boston, MA, USA', 'The Return of the King', 440, '618154000', '9780618154005');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (376, 45, 2001, 'Houghton Mifflin Company', 'Boston', 'The Return of the King', 406, '618129111', '9780618129119');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (377, 45, 2001, 'Klett', null, 'Die Wiederkehr des Konigs III', 705, '3608935436', '9783608935431');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (378, 45, 2001, 'Klett-Cotta', null, 'Der Herr der Ringe Bd. 3', 482, '3608955380', '9783608955385');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (379, 45, 2001, 'Lian jing chu ban shi ye gong si', 'Taipei Shi', '王者再臨', 403, '9570823380', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (380, 45, 2001, 'Martins Fontes', null, 'O Retorno do Rei', null, '8533613393', '9788533613393');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (381, 45, 2001, 'Minotauro', null, 'El retorno del rey', 416, '9505470665', '9789505470662');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (382, 45, 2001, 'Pocket', null, 'Le Retour Du Roi', 326, '2266118021', '9782266118026');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (383, 45, 2001, 'Quality Paperback Book Club', 'New York', 'The Return of the King', 440, '965307794', '9780965307796');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (384, 45, 2001, 'Recorded Books', null, 'The Return of the King', null, '788789554', '9780788789557');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (385, 45, 2001, 'Recorded Books', null, 'The Return of the King', null, '788789848', '9780788789847');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (386, 45, 2001, 'Tsai Fong Books, Inc', null, '王者再臨', null, '9570823380', '9789570823387');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (387, 45, 2001, 'Voyager Classics', 'London, England', 'The Return of the King', null, '7119569', '9780007119561');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (388, 45, 2002, 'Bard', null, 'The Return of the King', null, '9545853484', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (389, 45, 2002, 'Christian Bourgois', 'Paris', 'Le Seigneur des Anneaux', 509, '2266120972', '9782266120975');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (390, 45, 2002, 'Ediciones Minotauro', 'Madrid, España', 'El retorno del Rey', 415, '8439596243', '9788439596240');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (391, 45, 2002, 'Edicións Xerais de Galicia', null, 'O Regreso Do Rei', 385, '8483029162', '9788483029169');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (392, 45, 2002, 'Europa-America', 'Portugal', 'O regresso do rei', null, '9721041548', '9789721041547');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (393, 45, 2002, 'HarperCollins', 'London, England', 'The Return of the King', null, '7149239', '9780007149230');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (394, 45, 2002, 'Houghton Mifflin', 'Boston, MA, USA', 'The Return of The King', 1170, '618260552', '9780618260553');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (395, 45, 2002, 'Houghton Mifflin Company', 'Boston, MA, USA', 'The Return of the King', null, '618260285', '9780618260287');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (396, 45, 2002, 'Klett-Cotta', null, 'Die Rückkehr des Königs', null, '3608955380', '9783608955385');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (397, 45, 2002, 'Klett-Cotta', null, 'Die Wiederkehr des Königs', 384, '3608934030', '9783608934038');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (398, 45, 2002, 'Martins Fontes', null, 'O Retorno do Rei', null, '8533615574', '9788533615571');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (399, 45, 2002, 'Minotauro', null, 'El Retorno del Rey', 413, '8445071777', '9788445071779');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (400, 45, 2002, 'Mladá fronta', null, 'Návrat krále', null, '8020409653', '9788020409652');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (401, 45, 2002, 'Rubikon', 'Beograd, Serbia', 'Povratak kralja', null, '8673480698', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (402, 45, 2002, 'Slovart', null, 'Pán Prsteňov', 430, '807145608X', '9788071456087');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (403, 45, 2002, 'Tascabili Bompiani', null, 'Il ritorno del re', 470, '8845290417', '9788845290411');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (404, 45, 2002, 'Turtleback Books Distributed by Demco Media', null, 'El Retorno del Rey', null, '606244255', '9780606244251');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (405, 45, 2002, 'Uitgeverij M', 'Amsterdam, The Netherlands', 'De terugkeer van de koning', 360, '9022533778', '9789022533772');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (406, 45, 2002, 'Yilin Chu Ban She', null, '魔戒', 428, '7806572678', '9787806572672');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (407, 45, 2003, 'ACT', null, 'Возвращение государя', 411, '5170162650', '9785170162659');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (408, 45, 2003, 'French & European Pubns', null, 'Il Ritorno del Re', null, '078591398X', '9780785913986');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (409, 45, 2003, 'HarperCollins', 'London, England', 'The Return of the King', 554, '7171994', '9780007171996');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (410, 45, 2003, 'Houghton Mifflin', null, 'The Return of the King', null, '618346279', '9780618346271');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (411, 45, 2003, 'Houghton Mifflin Company', null, 'The Return of the King', null, '618346279', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (412, 45, 2003, 'Large Print Press', 'Waterville, Maine, USA', 'The Return of the King', 864, '1594130043', '9781594130045');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (413, 45, 2003, 'Minotauro/Argentina', null, 'El Retorno del Rey', 414, '9706906533', '9789706906533');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (414, 45, 2003, 'Tandem Library', null, 'The Return of the King', null, '141774720X', '9781417747207');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (415, 45, 2003, 'Thorndike Press', 'Waterville, ME, USA', 'The Return of the King', 864, '078625176X', '9780786251766');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (416, 45, 2003, 'Txalaparta', 'Tafalla', 'Erregearen itzulera', null, '8481362611', '9788481362619');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (417, 45, 2004, 'Houghton Mifflin Harcourt', 'New York, USA', 'The Return of the King', null, '054795204X', '9780547952048');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (418, 45, 2004, 'Literackie', 'Warszawa', 'Powrot krola', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (419, 45, 2004, 'Planeta Pub Corp', null, 'El Retorno del Rey', null, '9703701701', '9789703701704');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (420, 45, 2005, 'Algoritam', 'Zagreb, Croatia', 'Povratak kralja', 505, null, '9789532202816');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (421, 45, 2005, 'HarperCollins', null, 'The Return of the King', null, '7228406', '9780007228409');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (422, 45, 2005, 'HarperCollins Publishers', 'London', 'The Return of the King', null, '7203608', '9780007203604');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (423, 45, 2005, 'HarperCollins Publishers Limited', null, 'Return of the King', 464, null, '9780007203567');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (424, 45, 2005, 'Houghton Mifflin', null, 'The Return of the King', 544, '618574972', '9780618574971');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (425, 45, 2005, 'Pocket', null, 'Le Retour du Roi', 569, '2266154125', '9782266154123');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (426, 45, 2006, 'Minotauro', null, 'El Retorno del Rey', 603, '8445075756', '9788445075753');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (427, 45, 2007, 'HarperCollins', 'London, England', 'The Return of the King', 590, '261102370', '9780261102378');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (428, 45, 2007, 'MINOTAURO', null, 'El Retorno Del Rey - Señor De Los Anillos Iii', 528, '9505471165', '9789505471164');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (429, 45, 2008, null, null, 'The Return of the King', null, '1439527318', '9781439527313');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (430, 45, 2009, 'HarperCollins', 'New York', 'The Return of the King', null, null, '9780061917868');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (431, 45, 2009, 'HarperCollins', 'Glasgow', 'The Return of the King', null, null, '9780007322558');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (432, 45, 2009, 'Wydawnictwo Amber', 'Warszawa', 'Powrót Króla', null, null, '9788324133086');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (433, 45, 2010, 'minotauro', 'Barcelona, Spain', 'El Retorno del Rey', null, '8445077937', '9788445077931');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (434, 45, 2011, 'Minotauro', 'Colonia Chapultepec Morales, México', 'El Señor de los Anillos', 606, '8445077511', '9788445077511');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (435, 45, 2011, 'Recorded Books', null, 'The Return of the King', null, '1461836166', '9781461836162');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (436, 45, 2011, 'Texto Online', null, 'The Return of the King', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (437, 45, 2012, 'Del Rey Book', 'New York, USA', 'The Return of the King', 512, '345339738', '9780345339737');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (438, 45, 2012, 'HarperCollins', 'London', 'The Return of the King', 464, '7488351', '9780007488353');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (439, 45, 2012, 'HarperCollins', null, 'The Return of the King', 624, '7488343', '9780007488346');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (440, 45, 2012, 'Klett-Cotta', 'Stuttgart, Germany', 'Die Rückkehr des Königs', 444, '3608939830', '9783608939835');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (441, 45, 2012, 'Lian jing chu ban shi ye gu fen you xian gong si', 'Taipei Shi', 'Mo jie san bu qu', 436, '9570841028', '9789570841022');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (442, 45, 2012, 'Mariner Books', null, 'The Return of the King: Being the Third Part of the Lord of the Rings', 432, '054792819X', '9780547928197');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (443, 45, 2013, 'HarperCollins', null, 'The Return of the King', null, '7522924', '9780007522927');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (444, 45, 2013, 'Martins Fontes / Selo Martins', 'São Paulo, Brazil', 'O retorno do rei', null, '8580631033', '9788580631036');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (445, 45, 2013, 'Nhà xuất bản Văn Học', '[Hà Nội]', 'Chúa tể những chiếc nhẫn', 530, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (446, 45, 2014, 'Minotauro', null, 'El señor de los anillos III : el retorno del rey', null, null, '9789584246820');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (447, 45, 2014, 'Nhà xuất bản Văn Học', '[Hà Nội]', 'Chúa tể những chiếc nhẫn', 454, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (448, 45, 2014, 'Nhà xuất bản Văn Học', '[Hà Nội]', 'Chúa tể những chiếc nhẫn', 505, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (449, 45, 2014, 'Yilin Press', null, 'The Return of the King', 452, '7544730425', '9787544730426');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (450, 45, 2016, 'Christian Bourgois', null, 'Le Retour du Roi', null, '2267032198', '9782267032192');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (451, 45, 2016, 'Createspace', null, 'דער צוריקקער פֿון דעם קיניג', null, '1517654475', '9781517654474');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (452, 45, 2016, 'Gramedia Pustaka Utama', 'Jakarta, Indonesia', 'The Return of the King', null, '6020332284', '9786020332284');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (453, 45, 2020, 'HarperCollins Publishers Limited', null, 'Return of the King', 484, null, '9780008376147');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (454, 45, 2020, 'Houghton Mifflin Harcourt Publishing Company', null, 'Return of the King', 544, null, '9780358380252');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (455, 45, null, null, null, 'The Lord of the Rings', null, '7702752', '9780007702756');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (456, 45, null, null, null, 'The Return of the King', null, '458907707', '9780458907700');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (457, 43, 1954, 'Allen & Unwin', 'London', 'Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (458, 43, 1954, 'Allen & Unwin', 'London, England', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (459, 43, 1954, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (460, 43, 1956, 'George Allen & Unwin', 'London, England', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (461, 43, 1959, 'George Allen & Unwin', 'London, England', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (462, 43, 1965, 'Ace', null, 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (463, 43, 1965, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (464, 43, 1965, 'George Allen and Unwin', 'London, England', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (465, 43, 1965, 'Houghton Mifflin Company', 'Boston', 'The Fellowship of the Ring', 423, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (466, 43, 1966, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (467, 43, 1966, 'George Allen & Unwin', 'London, England', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (468, 43, 1967, 'Houghton Mifflin', null, 'The Fellowship of the Ring', null, '395082544', '9780395082546');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (469, 43, 1967, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (470, 43, 1967, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 423, '395082544', '9780395082546');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (471, 43, 1968, 'Allen and Unwin', null, 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (472, 43, 1969, 'Ballantine Books', 'New York', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (473, 43, 1970, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345020200', '9780345020208');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (474, 43, 1970, 'Ballantine Books', 'New York', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (475, 43, 1972, 'Ballantine Books', 'Boston, USA', 'The Fellowship of the Ring', null, '345015339', '9780345215338');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (476, 43, 1972, 'Christian Bourgois', 'Paris, France', 'La Communauté de l''anneau', 605, '2253011398', '9782253011392');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (477, 43, 1972, 'Klett-Cotta', null, 'Die Gefährten', null, '3608107134', '9783608107135');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (478, 43, 1972, 'Methuen', 'Canada', 'The Fellowship of the Ring', null, '458907502', '9780458907502');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (479, 43, 1973, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345235096', '9780345235091');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (480, 43, 1973, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345015339', '9780345015334');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (481, 43, 1974, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345240324', '9780345240323');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (482, 43, 1974, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345235096', '9780345235091');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (483, 43, 1974, 'George Allen & Unwin', 'London, England', 'The Fellowship of the Ring', null, '48230456', '9780048230454');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (484, 43, 1974, 'Unwin Books', 'London, England', 'The Fellowship of the Ring', 391, '48231126', '9780048231123');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (485, 43, 1975, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345247868', '9780345247865');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (486, 43, 1975, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345248279', '9780345248275');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (487, 43, 1976, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345253434', '9780345253439');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (488, 43, 1977, 'Ballantine Books', 'New York', 'The Fellowship of the Ring', 527, '345272587', '9780345272584');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (489, 43, 1977, 'Ballantine Books', 'New York', 'The Fellowship of the Ring', 527, '345253434', '9780345253439');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (490, 43, 1977, 'Folio Society', 'London, England', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (491, 43, 1977, 'Magnum Books', null, 'The Fellowship of the Ring', null, '458907502', '9780458907502');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (492, 43, 1977, 'Perfection Learning', null, 'The Fellowship of the Ring', null, '812415582', '9780812415582');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (493, 43, 1978, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', null, '395272238', '9780395082546');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (494, 43, 1978, 'Minotauro', 'España', 'El Señor de los Anillos I', 563, '8439596200', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (495, 43, 1979, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345240324', '9780345240323');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (496, 43, 1979, 'Het Spectrum', 'Utrecht, the Netherlands', 'De Reisgenoten', 528, '9027401683', '9789027401687');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (497, 43, 1979, 'Unwin Paperbacks', 'London, England', 'The Fellowship of the Ring', 535, '004823155X', '9780048231550');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (498, 43, 1980, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, null, '345272587');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (499, 43, 1980, 'George Allen & Unwin', 'London, England', 'The Fellowship of the Ring', null, '48230456', '9780048230454');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (500, 43, 1981, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345296052', '9780345296054');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (501, 43, 1981, 'Gondolat', null, 'A Gyuru Szovetsege', null, '9632809637', '9789632809632');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (502, 43, 1981, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 423, '395312671', '9780395312674');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (503, 43, 1981, 'Unwin Paperbacks', 'London, England', 'The Fellowship of the Ring', 536, '48231851', '9780048231857');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (504, 43, 1982, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (505, 43, 1982, 'Ballentine Books', 'New York, USA', 'The Fellowship of the Ring', 527, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (506, 43, 1982, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', null, '395082544', '9780395489314');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (507, 43, 1983, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345296052', '9780345296054');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (508, 43, 1983, 'George Allen & Unwin', null, 'The Fellowship of the Ring', null, '48230456', '9780048230454');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (509, 43, 1984, 'Ballantine Books', 'New York', 'The Fellowship of the Ring', 527, '345296052', '9780345296054');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (510, 43, 1984, 'Easton Press', 'Norwalk, CT, USA', 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (511, 43, 1985, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', 527, '345332083', '9780345332080');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (512, 43, 1986, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (513, 43, 1986, 'Houghton Mifflin Co.', 'Boston, USA', 'The Fellowship of the Ring', 423, '395272238', '9780395082546');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (514, 43, 1986, 'Turtleback Books', null, 'The Fellowship of the Ring', null, null, '9780808520764');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (515, 43, 1987, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (516, 43, 1987, 'Houghton Mifflin', 'Boston, USA', 'The Fellowship of the Ring', null, '395272238', '9780395272237');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (517, 43, 1987, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 423, '395489318', '9780395489314');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (518, 43, 1988, 'Ballantine Books', null, 'The Fellowship of the Ring', null, '345008626', '9780345008626');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (519, 43, 1988, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (520, 43, 1989, 'Ballantine Books', null, 'The Fellowship of The Ring', null, '606006508', '9780606006507');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (521, 43, 1989, 'Ballantine Books', null, 'The Fellowship of the Ring', null, '9993175315', '9789993175315');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (522, 43, 1990, 'Recorded Books', 'Prince Frederick, MD, USA', 'The Fellowship of the Ring', null, '788739573', '9780788739576');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (523, 43, 1990, 'Recorded Books', null, 'The Fellowship of the Ring', null, '1556903219', '9781556903212');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (524, 43, 1990, 'Recorded Books', 'Prince Frederick, MD, USA', 'The Fellowship of the Ring', null, '788789813', '9780788789816');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (525, 43, 1990, 'Soundelux Audio Pub', null, 'The Lord of the Rings', null, '1559350334', '9781559350334');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (526, 43, 1991, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (527, 43, 1991, 'Grafton', 'London, England', 'The Fellowship of the Ring', 529, '261102354', '9780261102354');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (528, 43, 1991, 'Houghton Mifflin', 'Boston, USA', 'The Fellowship of the Ring', null, '039564738X', '9780395647387');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (529, 43, 1991, 'ISIS Large Print Books', null, 'The Fellowship of the Ring', 500, '1850894140', '9781850894148');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (530, 43, 1992, 'HarperCollins', 'London, England', 'The Fellowship of the Ring', null, '261102923', '9780261102927');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (531, 43, 1992, 'unknown', null, '指輪物語 第1部 旅の仲間', null, '4566023508', '9784566023505');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (532, 43, 1993, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (533, 43, 1993, 'Folio', null, 'Le seigneur des anneaux', null, '2070334791', '9782070334797');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (534, 43, 1993, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 423, '395489318', '9780395489314');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (535, 43, 1993, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', null, '395272238', '9780395272237');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (536, 43, 1993, 'Pocket', null, 'La communauté de l''anneau - tome 1', null, '2266026550', '9782266026550');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (537, 43, 1994, 'Del Rey', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (538, 43, 1994, 'Del Rey (Random House)', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (539, 43, 1994, 'Harper-Collins', 'London, England', 'The Fellowship of the Ring', null, '7149212', '9780007149216');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (540, 43, 1994, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 398, '618574948', '9780618574940');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (541, 43, 1994, 'Houghton Mifflin Harcourt', 'New York, USA', 'The Fellowship of the Ring', null, '544448936', '9780544448933');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (542, 43, 1994, 'Houghton Mifflin Harcourt', 'New York, USA', 'The Fellowship of the Ring', null, '547928211', '9780547928210');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (543, 43, 1995, 'Quality Paperback Book Club', null, 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (544, 43, 1996, 'HarperCollins Publishers Limited', null, 'The Fellowship of the Ring', 432, '261103385', '9780261103382');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (545, 43, 1996, 'J.G. Cotta''sche, Buchhandlung Nachfolger GmbH', null, 'Die Gefährten', 491, '3608952128', '9783608952124');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (546, 43, 1996, 'Metis Yayınları', 'Istanbul, Turkey', 'Yüzük Kardeşliği', null, '975342163X', '9789753421638');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (547, 43, 1996, 'Zysk i S-ka', 'Poznan', 'Bractwo pierscienia', null, '8371502419', '9788371502415');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (548, 43, 1997, 'HarperCollins Publishers', 'London, England', 'The Fellowship of the Ring', 416, '261103571', '9780261103573');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (549, 43, 1998, 'Editions Flammarion', null, 'La communauté de l''Anneau', null, '2070339769', '9782070339761');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (550, 43, 1998, 'HarperCollins Publishers Ltd', null, 'The Fellowship of the Ring', 432, '261102311', '9780261102316');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (551, 43, 1999, 'Ballantine Books', null, 'The Fellowship of the Rings', null, '034591743X', '9780345917430');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (552, 43, 1999, 'HarperCollins Publishers', 'London, England', 'The Fellowship of the Ring', 545, '261102354', '9780261102354');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (553, 43, 1999, 'Houghton Mifflin Co.', 'Boston, USA', 'The Fellowship of the Ring', null, '618002227', '9780618002221');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (554, 43, 2000, 'Bompiani', 'Milano, Italia', 'La Compagnia dell''Anello', 512, '8845290409', '9788845290404');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (555, 43, 2000, 'Christian Bourgois', 'Paris', 'Le seigneur des anneaux', 538, '2266107984', '9782266107983');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (556, 43, 2000, 'French & European Pubns', null, 'La Communeaute de l''Anneau', 688, '828810540', '9780828810548');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (557, 43, 2000, 'French & European Pubns', null, 'Comunidad Anillo', null, '828868999', '9780828868990');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (558, 43, 2000, 'French & European Pubns', null, 'Die Gefahrten', 400, '828865655', '9780828865654');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (559, 43, 2000, 'Gallimard Jeunesse', null, 'La Communauté de l''Anneau', 687, '2070515796', '9782070515790');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (560, 43, 2000, 'Klett-Cotta', 'Stuttgart, Germany', 'Die Gefährten', 526, '360893541X', '9783608935417');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (561, 43, 2000, 'xx', null, 'La Communauté de l''Anneau', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (562, 43, 2001, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', 527, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (563, 43, 2001, 'Christian Bourgeois éditeur', 'Paris', 'Le Seigneur des anneaux', 544, '2266070614', '9782266070614');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (564, 43, 2001, 'Christian Bourgois', null, 'La communauté de l''anneau', 691, '2070515796', '9782070515790');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (565, 43, 2001, 'Collins', 'London, England', 'The Fellowship of the Ring', 416, '000712970X', '9780007129706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (566, 43, 2001, 'Collins', 'London', 'The Fellowship of the Ring', null, '7680856', '9780007680856');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (567, 43, 2001, 'Del Rey', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (568, 43, 2001, 'Harper Collins', null, 'The Fellowship of the Ring', 416, '7117116', '9780007117116');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (569, 43, 2001, 'HarperCollins', 'London, England', 'The Fellowship of the Ring', null, '7123825', '9780007123827');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (570, 43, 2001, 'Hobbit Presse', 'Klett-Cotta', 'Die Gefährten', null, '3608955364', '9783608955361');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (571, 43, 2001, 'Houghton Mifflin', 'Boston, USA', 'The Fellowship of the Ring', 423, '618153985', '9780618153985');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (572, 43, 2001, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 407, '618129030', '9780618129034');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (573, 43, 2001, 'Houghton Mifflin Company', null, 'The Fellowship of the Ring', null, '618134697', '9780618134694');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (574, 43, 2001, 'J.G. Cotta''sche, Buchhandlung Nachfolger GmbH', null, 'Die Gefahrten', 526, '3608933514', '9783608933512');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (575, 43, 2001, 'Klett-Cotta', null, 'Die Gefahrten', 526, '3608933514', '9783608933512');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (576, 43, 2001, 'Klett-Cotta', null, 'Die Gefährten', null, '3608934014', '9783608934014');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (577, 43, 2001, 'Klett-Cotta', null, 'Die Gefahrten', 677, '360893541X', '9783608935417');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (578, 43, 2001, 'Lian jing chu ban shi ye gong si', 'Taipei Shi', '魔戒首部曲', 591, '9570823364', '9789570823363');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (579, 43, 2001, 'Martins Fontes', null, 'O a Sociedade do Anel', 450, '8533613377', '9788533613379');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (580, 43, 2001, 'Minotauro', 'Barcelona, Spain', 'La comunidad del anillo', 559, '8445071408', '9788445071403');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (581, 43, 2001, 'Minotauro', null, 'La comunidad del anillo', 547, '9505470673', '9789505470679');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (582, 43, 2001, 'Pocket', null, 'La Communaute de L''Anneaux', 377, '2266115618', '9782266115612');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (583, 43, 2001, 'Quality Paperback Book Club', 'New York, USA', 'The Fellowship of the Ring', 427, '965307751', '9780965307758');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (584, 43, 2001, 'Texto Online', null, 'The Fellowship of the Ring', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (585, 43, 2001, 'Turtleback Books Distributed by Demco Media', null, 'La comunidad del anillo', null, '606244239', '9780606244237');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (586, 43, 2001, 'Xerias', null, 'A Irmandade do Anel', 520, '848302683X', '9788483026830');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (587, 43, 2001, 'Zysk i S-Ka Wydawnictwo', 'Poznan', 'Władca pieršcieni.', null, '8372981566', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (588, 43, 2002, 'Algoritam', 'Zagreb, Croatia', 'Gospodar prstenova (dio prvi)', 479, '953-6166-11-9', '9789536166114');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (589, 43, 2002, 'Barд', null, 'The Fellowship of the Ring', null, '9545853468', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (590, 43, 2002, 'Christian Bourgois', null, 'Le Communaute de L''Anneau', 697, '2266120999', '9782266120999');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (591, 43, 2002, 'Ediciones Minotauro', 'Madrid, España', 'La Comunidad del Anillo', 299, '8439596197', '9788439596189');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (592, 43, 2002, 'Ediciones Minotauro', 'Madrid, España', 'El Señor de los Anillos I', 260, '8439596200', '9788439596189');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (593, 43, 2002, 'Europa-America', 'Mem Martins', 'A Irmandade do Anel', null, '9721041025', '9789721041028');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (594, 43, 2002, 'French & European Pubns', null, 'La compagnia dell''anello', 502, '785907424', '9780785907428');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (595, 43, 2002, 'French & European Pubns', null, 'La Compagnia dell''anello', 502, '828839816', '9780828839815');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (596, 43, 2002, 'Houghton Mifflin', 'Boston, USA', 'The Fellowship of the Ring', 410, '061826051X', '9780618260515');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (597, 43, 2002, 'Houghton Mifflin Co.', 'Boston, MA, USA', 'The Fellowship of the Ring', 407, '618260269', '9780618260263');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (598, 43, 2002, '"I︠A︡uza"', 'Moskva', 'Vlastelin Kolet︠s︡', 990, '5040081766', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (599, 43, 2002, 'Linking Publishing', null, '魔戒首部曲', 591, '9570823364', '9789570823363');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (600, 43, 2002, 'Martins Fontes', null, 'A Sociedade do Anel', null, '8533615558', '9788533615557');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (601, 43, 2002, 'Pocket', null, 'La Communauté de l''Anneau', 697, '2266128043', '9782266128049');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (602, 43, 2002, 'Rubikon', 'Beograd, Serbia', 'Družina prstena', null, '8673480671', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (603, 43, 2002, 'UITGEVERIJ', null, 'De Reisgenoten', null, '9022531937', '9789022531938');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (604, 43, 2002, 'Uitgeverij M', 'Amsterdam', 'In de Ban van de Ring: Eerste Boek', 491, '9022533964', '9789022533963');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (605, 43, 2002, 'Yi lin chu ban she', 'Nanjing', '魔戒(指环王)', 354, '7806573976', '9787806573976');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (606, 43, 2003, 'Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (607, 43, 2003, 'Ballantine Books / Del Rey', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (608, 43, 2003, 'HarperCollins', 'London, England', 'The Fellowship of the Ring', 535, '7171978', '9780007171972');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (609, 43, 2003, 'Houghton Mifflin Company', null, 'The Fellowship of the Ring', 398, '618346252', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (610, 43, 2003, 'Large Print Press', 'Waterville, ME, USA', 'The Fellowship of the Ring', null, '1594130078', '9781594130076');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (611, 43, 2003, 'Minotaur', 'Argentina', 'La comunidad del anillo', 548, '9706906517', '9789706906519');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (612, 43, 2003, 'Minotauro', null, 'La Comunidad del Anillo', null, '8445070339', '9788445070338');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (613, 43, 2003, 'Pocket', null, 'Le Communaute de L''Anneau', 538, '2266120999', '9782266120999');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (614, 43, 2003, 'Thorndike Press', 'Waterville, ME, USA', 'The Fellowship of the Ring', 855, '786251786', '9780786251780');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (615, 43, 2004, 'AST', null, 'Khraniteli Kol''tsa', 479, '5170264151', '9785170264155');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (616, 43, 2004, 'Houghton Mifflin Company', 'Boston, USA', 'The Fellowship of the Ring', 544, '618574948', '9780618574940');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (617, 43, 2004, 'UITGEVERIJ MEULENHOFF', 'Amsterdam, The Netherlands', 'De Reisgenoten', null, '9460235301', '9789460235306');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (618, 43, 2005, 'French and European Publications Inc', null, 'Le Seigneur des Anneaux 1. La Communaute de l'' Anneau (French Edition)', 697, '2266154117', '9782266154116');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (619, 43, 2005, 'HarperCollins Publishers Limited', null, 'Fellowship of the Ring', 456, null, '9780007203543');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (620, 43, 2005, 'Literackie', 'Warszawa', 'Druzyna pierscienia', null, '8370799736', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (621, 43, 2006, 'Der Hörverlag', null, 'Die Gefährten', null, '3899408861', '9783899408867');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (622, 43, 2006, 'Minotauro', null, 'La Comunidad Del Anillo', 566, '844507573X', '9788445075739');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (623, 43, 2007, 'Folio Junior', null, 'La Communauté de l''Anneau', 717, '2070612880', '9782070612888');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (624, 43, 2007, 'MINOTAURO', null, 'COMUNIDAD DEL ANILLO, LA - SEÑOR DE LOS ANILLOS I', null, '9505471149', '9789505471140');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (625, 43, 2008, 'Harpercollins', null, 'The Fellowship of the Ring', 576, '7269706', '9780007269709');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (626, 43, 2008, 'Paw Prints 2008-08-11', null, 'The Fellowship of the Ring', null, '143951836X', '9781439518366');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (627, 43, 2009, 'HarperCollins', 'New York, USA', 'The Fellowship of the Ring', null, '61917672', '9780061917677');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (628, 43, 2009, 'HarperCollins', 'Glasgow', 'The Fellowship of the Ring', null, '7322496', '9780007322497');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (629, 43, 2009, 'Wydawnictwo Amber', 'Warszawa', 'Drużyna Pierścienia', null, null, '9788324132614');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (630, 43, 2010, 'Cappelen Damm Lydbok', null, 'Ringens brorskap', null, null, '9788202336400');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (631, 43, 2010, 'Gyldendal Lyd', null, 'Eventyret om Ringen', null, '8702093693', '9788702093698');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (632, 43, 2011, 'Recorded Books', null, 'The Fellowship of the Ring', null, '146183614X', '9781461836148');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (633, 43, 2012, 'Del Rey', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (634, 43, 2012, 'Del Rey / Ballantine Books', 'New York, USA', 'The Fellowship of the Ring', 480, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (635, 43, 2012, 'HarperCollins', 'London', 'The Fellowship of the Ring', null, '7488319', '9780007488315');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (636, 43, 2012, 'Hobbit Presse', 'Stuttgart, Germany', 'Die Gefährten', null, '3608939814', '9783608939811');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (637, 43, 2012, 'Lian jing chu ban shi ye gu fen you xian gong si', 'Taipei Shi', 'Mo jie shou bu qu', 626, '9570841001', '9789570841008');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (638, 43, 2012, 'Minotauro', null, 'La comunidad del anillo', null, '8445000667', '9788445000663');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (639, 43, 2013, 'HARPERCOLLINS', null, 'FELLOWSHIP OF THE RINGS MTI', null, '7488300', '9780007488308');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (640, 43, 2013, 'Martins Fontes', 'São Paulo SP Brasil', 'A sociedade do anel', null, '8580631017', '9788580631012');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (641, 43, 2014, 'Barry Goldstein', null, 'די חברותא פון דעם פינגערל', null, '1500410225', '9781500410223');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (642, 43, 2014, 'HarperCollins', null, 'The Fellowship of the Ring', 550, '8108293', '9780008108298');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (643, 43, 2014, 'Ylin', null, '魔戒现身', 442, '7544730425', '9787544730426');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (644, 43, 2016, 'Gramedia Pustaka Utama', 'Penerbit, Indonesia', 'The Fellowship of the Ring', null, '6020332268', '9786020332260');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (645, 43, 2018, 'Del Rey', 'New York, USA', 'The Fellowship of the Ring', null, '345339703', '9780345339706');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (646, 43, 2018, 'Harper', 'London, England', 'The Fellowship of the Ring', null, '7322496', '9780007322497');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (647, 43, 2020, 'HarperCollins Publishers Limited', null, 'Fellowship of the Ring', 412, null, '9780008376123');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (648, 43, 2020, 'HarperCollins Publishers Limited', null, 'Fellowship of the Ring (the Lord of the Rings, Book 1)', 448, null, '9780008376062');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (649, 43, 2020, 'Houghton Mifflin Harcourt Publishing Company', null, 'Fellowship of the Ring', 544, null, '9780358380238');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (650, 43, null, 'Pocket', null, 'La communauté de l''anneau', 544, '2266046497', '9782266046497');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (651, 44, 1954, 'George Allen & Unwin', 'London, England', 'The Two Towers', 352, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (652, 44, 1954, 'Houghton Mifflin', 'Boston', 'The two towers', 352, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (653, 44, 1955, 'George Allen & Unwin', 'London, England', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (654, 44, 1955, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', 352, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (655, 44, 1960, 'Readers Union / George Allen & Unwin', null, 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (656, 44, 1962, 'George Allen & Unwin / Houghton Mifflin Company', 'London, England', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (657, 44, 1963, 'George Allen & Unwin', null, 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (658, 44, 1965, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (659, 44, 1966, 'G. Allen & Unwin', 'London, England', 'The Two Towers', 352, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (660, 44, 1967, 'George Allen & Unwin', 'London, England', 'The Two Towers', 352, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (661, 44, 1967, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '395082552', '9780395082553');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (662, 44, 1967, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (663, 44, 1967, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '039527222X', '9780395272220');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (664, 44, 1968, 'George Allen & Unwin', 'London, England', 'The Two Towers', 352, '48230464', '9780048230461');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (665, 44, 1969, 'George Allen & Unwin', 'London, England', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (666, 44, 1970, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345020200', '9780345020208');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (667, 44, 1970, 'Ballantine Books', 'New York, USA', 'The Two Towers', 447, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (668, 44, 1970, 'George Allen & Unwin', 'London, England', 'The Two Towers', null, '48230464', '9780048230461');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (669, 44, 1971, 'George Allen & Unwin', null, 'The Two Towers', null, '48230464', '9780048230461');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (670, 44, 1972, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (671, 44, 1972, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345015347', '9780345015341');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (672, 44, 1972, 'Klett-Cotta', 'Stuttgart, Germany', 'Die zwei Türme', null, '3608107142', '9783608107142');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (673, 44, 1972, 'Methuen Publications', null, 'The Two Towers', null, '045890760X', '9780458907601');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (674, 44, 1973, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '034523510X', '9780345235107');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (675, 44, 1973, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345015347', '9780345015341');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (676, 44, 1974, 'Ballantine Books', 'New York, N.Y., U.S.A', 'The Two Towers', null, '034523510X', '9780345235107');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (677, 44, 1974, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345240332', '9780345240330');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (678, 44, 1974, 'George Allen & Unwin', 'London, England', 'The Two Towers', null, '48230464', '9780048230461');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (679, 44, 1974, 'Unwin Books', 'London, England', 'The Two Towers', 319, '48231134', '9780048231130');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (680, 44, 1974, 'Unwin Paperbacks', 'London', 'The two towers', 313, '48232297', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (681, 44, 1975, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345248287', '9780345248282');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (682, 44, 1975, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345247868', '9780345247865');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (683, 44, 1976, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345253442', '9780345253446');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (684, 44, 1976, 'Le Livre de Poche', null, 'The Two Towers', null, '2253012084', '9782253012085');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (685, 44, 1977, 'Folio Society', 'London, England', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (686, 44, 1977, 'Methuen / Magnum', null, 'The Two Towers', null, '045890760X', '9780458907601');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (687, 44, 1977, 'The Folio Society', 'London, England', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (688, 44, 1978, 'Ballantine Books', 'New York', 'The Two Towers', 447, '345272595', '9780345272591');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (689, 44, 1978, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', 352, '395082552', '9780395082553');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (690, 44, 1978, 'Perfection Learning', null, 'The Two Towers', null, '812417852', '9780812417852');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (691, 44, 1979, 'Het Spectrum', 'Utrecht, the Netherlands', 'De Twee Torens', 370, '9027401691', '9789027401694');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (692, 44, 1979, 'Recorded Books', null, 'The Two Towers', null, '1556903227', '9781556903229');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (693, 44, 1979, 'Unwin Paperbacks', 'London, England', 'The Two Towers', 442, '48231568', '9780048231567');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (694, 44, 1980, 'Gallimard', null, 'Les Deux Tours', null, '2070501418', '9782070501410');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (695, 44, 1981, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345296060', '9780345296061');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (696, 44, 1981, 'Gondolat', null, 'A Ket Torony', null, '9632809645', '9789632809649');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (697, 44, 1981, 'Houghton Mifflin', 'Boston, USA', 'The Two Towers', 352, '395312663', '9780395312667');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (698, 44, 1981, 'Unwin Paperbacks', null, 'The Two Towers', 446, '004823186X', '9780048231864');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (699, 44, 1982, 'Ballantine Books', 'New York, USA', 'The Two Towers', 447, '345296060', '9780345296061');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (700, 44, 1982, 'Ballantine Books', 'New York, USA', 'The Two Towers', 416, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (701, 44, 1982, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '039527222X', '9780395272220');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (702, 44, 1982, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '395082552', '9780395082553');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (703, 44, 1982, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (704, 44, 1982, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', 352, '395312663', '9780395312667');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (705, 44, 1983, 'Christian Bourgois', null, 'Les Deux Tours', 408, '2267001977', '9782267001976');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (706, 44, 1984, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345296060', '9780345296061');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (707, 44, 1984, 'Easton Press', 'Norwalk, CT, USA', 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (708, 44, 1985, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345332105', '9780345332103');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (709, 44, 1986, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (710, 44, 1987, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (711, 44, 1987, 'Guild Publishing', 'London, England', 'The Two Towers', 352, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (712, 44, 1988, 'Ballantine Books', null, 'The Two Towers', null, '345008634', '9780345008633');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (713, 44, 1988, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (714, 44, 1988, 'Gallimard', null, 'Les deux tours', null, '2070334813', '9782070334810');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (715, 44, 1988, 'Houghton Mifflin Harcourt', 'Boston, USA', 'The Two Towers', 352, '395489334', '9780395489338');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (716, 44, 1990, 'Czytelnik', 'Warszawa, Poland', 'Dwie wieże', 452, '8385100083', '9788385100089');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (717, 44, 1990, 'Czytelnik', 'Warszawa', 'Dwie wieże', 452, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (718, 44, 1990, 'Czytelnik', 'Warszawa, Poland', 'Dwie Wieze', null, '8307021731', '9788307021737');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (719, 44, 1990, 'Raduga', null, 'Две твердыни', null, '5050023971', '9785050023971');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (720, 44, 1990, 'Recorded Books', null, 'The Two Towers', null, '788739581', '9780788739583');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (721, 44, 1991, 'Ballantine Books, a division of Random House, Inc.', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (722, 44, 1991, 'Houghton Mifflin', 'Boston, USA', 'The Two Towers', null, '395647398', '9780395647394');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (723, 44, 1991, 'ISIS Large Print Books', null, 'The Two Towers', 448, '1850894191', '9781850894193');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (724, 44, 1991, 'Pocket', null, 'Les Deux Tours', null, '2266046500', '9782266046503');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (725, 44, 1992, 'HarperCollins Publishers Ltd', null, 'Lord of the Rings', 352, '261102931', '9780261102934');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (726, 44, 1993, 'Ballantine Books', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (727, 44, 1993, 'HarperCollins', 'London, England', 'The Two Towers', 442, '261102362', '9780261102361');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (728, 44, 1993, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', 352, '395489334', '9780395489338');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (729, 44, 1993, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '039527222X', '9780395272220');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (730, 44, 1993, 'Pocket', null, 'LE SEIGNEUR DES ANNEAUX T2', null, '2266026569', '9782266026567');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (731, 44, 1994, 'Hermes Editorial', null, 'Las dos torres', 495, '9684461135', '9789684461130');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (732, 44, 1994, 'Houghton Mifflin', 'Boston, USA', 'The Two Towers', 352, '618002235', '9780618002238');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (733, 44, 1994, 'Houghton Mifflin Co.', 'Boston, USA', 'The Two Towers', 725, '618002235', '9780618002238');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (734, 44, 1994, 'Mariner Books / Houghton Mifflin Harcourt', 'New York, USA', 'The Two Towers', null, '547928203', '9780547928203');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (735, 44, 1995, 'Quality Paperback Book Club', null, 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (736, 44, 1996, 'Distribooks Int''l+inc', null, 'Les deux tours', 471, '2266070606', '9782266070607');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (737, 44, 1996, 'HarperCollins Publishers Ltd', null, 'The Lord of the Rings Part II - The Two Towers', 356, '261103393', '9780261103399');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (738, 44, 1997, 'HarperCollins Publishers', 'London, England', 'The Two Towers', 352, '026110358X', '9780261103580');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (739, 44, 1997, 'Ted Smart', null, 'The Two Towers', 725, '7637691', '9780007637690');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (740, 44, 1997, 'Zysk i S-ka', null, 'Dwie Wieże', 512, '8371502427', '9788371502422');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (741, 44, 1998, 'HarperCollins Publishers Ltd', null, 'The Two Towers', 352, '026110232X', '9780261102323');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (742, 44, 1999, 'Ballantine Books', null, 'The Two Towers', null, '345917448', '9780345917447');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (743, 44, 1999, 'Gallimard Jeunesse', null, 'Le Seigneur des Anneaux, tome 2', 574, '2070522687', '9782070522682');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (744, 44, 1999, 'HarperCollins', 'London, England', 'The Two Towers', 449, '261102362', '9780261102361');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (745, 44, 1999, 'Metis Yayinlari', 'Istanbul, Turkey', 'Iki kule', null, '9753421818', '9789753421812');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (746, 44, 1999, 'Tandem Library', null, 'The Two Towers', 398, '808520903', '9780808520900');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (747, 44, 1999, 'Tandem Library', null, 'The Two Towers', null, '141761840X', '9781417618408');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (748, 44, 2000, 'AST - Terra Fantastica', null, 'Две Твердыни', null, '5170011806', '9785170011803');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (749, 44, 2000, 'Bompiani', null, 'Le due Torri', null, '8845290425', '9788845290428');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (750, 44, 2000, 'Christian Bourgois', null, 'Les Deux Tours', null, '2266107992', '9782266107990');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (751, 44, 2000, 'French & European Pubns', null, 'Las dos torres', 300, '828869022', '9780828869027');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (752, 44, 2000, 'French & European Pubns', null, 'Les Deux Tours', null, '828810761', '9780828810760');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (753, 44, 2000, 'Klett-Cotta', 'Stuttgart, Germany', 'Die zwei Türme', 441, '3608935428', '9783608935424');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (754, 44, 2000, 'Martins Fontes', null, 'As Duas Torres', 380, '8533613385', '9788533613386');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (755, 44, 2001, 'Ballantine Books', 'New York, USA', 'The Two Towers', 398, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (756, 44, 2001, 'Collins', 'London', 'The Two Towers', 352, '7129718', '9780007129713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (757, 44, 2001, 'Harper Collins Publishers', null, 'The Two Towers (The Lord of the Rings, Book 2)', 464, '7123833', '9780007123834');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (758, 44, 2001, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', 352, '618153993', '9780618153992');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (759, 44, 2001, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '618129081', '9780618129089');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (760, 44, 2001, 'Klett-Cotta', null, 'Die zwei Türme', null, '3608955372', '9783608955378');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (761, 44, 2001, 'Klett-Cotta', null, 'Die zwei Türme', 608, '3608935428', '9783608935424');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (762, 44, 2001, 'Lian jing chu ban shi ye gong si', 'Taipei Shi', 'Mo jie er bu qu', 465, '9570823372', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (763, 44, 2001, 'Minotauro', 'Barcelona, Spain', 'Las dos torres', 463, '8445071769', '9788445071762');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (764, 44, 2001, 'Minotauro', 'Barcelona, Spain', 'Las dos torres', 489, '8445070347', '9788445070345');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (765, 44, 2001, 'Minotauro', null, 'Las dos torres', 464, '9505470657', '9789505470655');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (766, 44, 2001, 'Pocket', null, 'Les Deux Tours', 344, '2266118013', '9782266118019');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (767, 44, 2001, 'Quality Paperback Book Club', null, 'The Two Towers', 352, '965307816', '9780965307819');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (768, 44, 2001, 'Quality Paperback Book Club', null, 'The Two Towers', 357, '7117124', '9780007117123');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (769, 44, 2001, 'Recorded Books', null, 'The Two Towers', null, '078878983X', '9780788789830');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (770, 44, 2001, 'Recorded Books', null, 'The Two Towers', null, '788789546', '9780788789540');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (771, 44, 2001, 'Texto Online', null, 'The Two Towers', null, null, null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (772, 44, 2001, 'Tsai Fong Books, Inc', null, '雙城奇謀', null, '9570823372', '9789570823370');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (773, 44, 2001, 'Yilin Chu Ban She', null, '魔戒', 401, '780657266X', '9787806572665');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (774, 44, 2001, 'Zysk i S-ka', 'Poznan', 'Dwie wieze', null, '8372981132', '9788372981134');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (775, 44, 2002, 'Bard', null, 'The Two Towers', null, '9545853476', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (776, 44, 2002, 'Ediciones Minotauro', 'Madrid, España', 'Las dos torres', 489, '8439596227', '9788439596226');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (777, 44, 2002, 'Europa-America', 'Portugal', 'As duas Torres', null, '9721041440', '9789721041448');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (778, 44, 2002, 'French & European Pubns', null, 'Die Zwei Turme', 441, '828808880', '9780828808880');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (779, 44, 2002, 'French & European Pubns', null, 'Le Due Torri', 393, '828879761', '9780828879767');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (780, 44, 2002, 'French & European Pubns', null, 'Le Due Torri', 401, '828866058', '9780828866057');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (781, 44, 2002, 'Harper', null, 'The Two Towers', null, '7141300', '9780007141302');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (782, 44, 2002, 'Harpercollins', null, 'The Two Towers', null, '7522916', '9780007522910');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (783, 44, 2002, 'HarperCollins', 'London, England', 'The Two Towers', null, '7149220', '9780007149223');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (784, 44, 2002, 'HarperCollins', 'London, England', 'The Two Towers', null, '7136560', '9780007136568');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (785, 44, 2002, 'Houghton, Mifflin', 'Boston, USA', 'The Two Towers', 750, '618260595', '9780618260591');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (786, 44, 2002, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', 725, '618260277', '9780618260270');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (787, 44, 2002, 'J.G. Cotta''sche, Buchhandlung Nachfolger GmbH', null, 'Die Zwei Türme', 441, '3608933522', '9783608933529');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (788, 44, 2002, 'Klett-Cotta', null, 'Die zwei Türme', 448, '3608934022', '9783608934021');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (789, 44, 2002, 'Martins Fontes', null, 'As Duas Torres', 508, '8533615566', '9788533615564');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (790, 44, 2002, 'Minotauro', null, 'Las dos torres', 464, '8445071769', '9788445071762');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (791, 44, 2002, 'Pocket', null, 'Les deux tours', 472, '2266120980', '9782266120982');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (792, 44, 2002, 'Pocket', null, 'Les Deux Tours', 567, '2266127926', '9782266127929');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (793, 44, 2002, 'Rubikon', 'Beograd, Serbia', 'Dve kule', null, '867348068X', '9788673480688');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (794, 44, 2002, 'UITGEVERIJ', null, 'De Twee Torens', null, '9022531945', '9789022531945');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (795, 44, 2003, 'AST', null, 'Две твердыни', 413, '5170162758', '9785170162758');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (796, 44, 2003, 'Christian Bourgois', 'Paris, France', 'Les Deux Tours', 575, '2266132385', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (797, 44, 2003, 'HarperCollins', 'London, England', 'The Two Towers', 439, '7171986', '9780007171989');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (798, 44, 2003, 'Houghton Mifflin Company', 'Boston, USA', 'The Two Towers', null, '618346260', '9780618346264');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (799, 44, 2003, 'Large Print Press', 'Waterville, ME, USA', 'The Two Towers', 774, '159413006X', '9781594130069');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (800, 44, 2003, 'Literackie', 'Warszawa, Poland', 'Dwie wieze', null, '8373194223', '9788373194229');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (801, 44, 2003, 'Thorndike Press', 'Waterville, ME, USA', 'The Two Towers', 776, '786251751', '9780786251759');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (802, 44, 2003, 'Txalaparta', 'Tafalla, Spain', 'Bi dorreak', 454, '8481362603', '9788481362602');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (803, 44, 2004, 'AST', null, 'Vlastelin kolets. Trilogiya. Kniga 2. Dve tverdyni (Vneklassnoe chtenie)', 366, '517026416X', null);
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (804, 44, 2004, 'Houghton Mifflin', 'New York, USA', 'The Two Towers', 448, '618574956', '9780618574957');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (805, 44, 2004, 'Planeta Pub Corp', null, 'Las dos torres', null, '9703701698', '9789703701698');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (806, 44, 2005, 'Algoritam', 'Zagreb, Croatia', 'Dvije kule', 399, '953-220-280-3', '9789532202809');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (807, 44, 2005, 'HarperCollins', 'London, England', 'The Two Towers', 368, '7203551', '9780007203550');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (808, 44, 2005, 'HarperCollins Publishers', 'London', 'The Two Towers', null, '7203594', '9780007203598');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (809, 44, 2005, 'HarperCollins UK Audio', null, 'The Two Towers', null, '7228392', '9780007228393');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (810, 44, 2005, 'Pocket', null, 'Le Seigneur des Anneaux 2 - Les Deux Tours', 569, '2266154133', '9782266154130');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (811, 44, 2006, 'Booket', null, 'Las dos torres', 476, '8445075748', '9788445075746');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (812, 44, 2007, 'Gallimard Education', null, 'Seigneur Des Anneau (Folio Junior) (v. 2) (French Edition)', null, '2070612899', '9782070612895');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (813, 44, 2007, 'HarperCollins', 'London, England', 'The Two Towers', 464, '261102362', '9780261102361');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (814, 44, 2008, 'Houghton Mifflin Company', 'New York, USA', 'The Two Towers', null, '544087429', '9780544087422');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (815, 44, 2009, 'HarperCollins', 'London, England', 'The Two Towers', null, '000732250X', '9780007322503');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (816, 44, 2009, 'HarperCollins', 'New York, USA', 'The Two Towers', null, '61952893', '9780061917929');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (817, 44, 2009, 'Wydawnictwo Amber', 'Warszawa', 'Dwie Wieże', null, null, '9788324132874');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (818, 44, 2010, 'AST', null, 'Lord of the Rings. Trilogy. T. 2. Two strongholds / Vlastelin Kolets. Trilogiya. T. 2. Dve tverdyni', null, '5170675666', '9785170675661');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (819, 44, 2010, 'Gyldendal', null, 'De to tårne', null, '8702093707', '9788702093704');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (820, 44, 2011, 'Recorded Books', null, 'The Two Towers', null, '1461836158', '9781461836155');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (821, 44, 2012, 'Del Rey', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (822, 44, 2012, 'HarperCollins', 'London', 'The Two Towers', 464, '7488327', '9780007488322');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (823, 44, 2012, 'HarperCollins', 'London, England', 'The Two Towers', 352, '7488335', '9780007488339');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (824, 44, 2012, 'Houghton Mifflin Harcourt Publishing Company', null, 'Two Towers', 352, null, '9780547952024');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (825, 44, 2012, 'Klett-Cotta', 'Stuttgart, Germany', 'Die zwei Türme', null, '3608939822', '9783608939828');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (826, 44, 2012, 'Lian jing chu ban shi ye gong si', 'Taipei Shi', 'Mo jie er bu qu', 511, '957084101X', '9789570841015');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (827, 44, 2013, 'Martins Fontes - Selo Martins', 'São Paulo, Brazil', 'As duas torres', null, '8580631025', '9788580631029');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (828, 44, 2014, 'HarperCollins', null, 'The Two Towers', 452, '8108307', '9780008108304');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (829, 44, 2014, 'Houghton Mifflin Harcourt', 'Boston, USA', 'The Two Towers', 322, '544449738', '9780544449732');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (830, 44, 2015, 'CHRISTIAN BOURGOIS EDITEUR', null, 'Les deux tours', null, '2267028921', '9782267028928');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (831, 44, 2015, 'Createspace', null, 'וואס איז דער צוויטער טייל פון דער האר פון די פינגערלעך', null, '1512129038', '9781512129038');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (832, 44, 2016, 'Gramedia Pustaka Utama', 'Jakarta, Indonesia', 'The Two Towers', null, '6020332276', '9786020332277');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (833, 44, 2018, 'Del Rey', 'New York, USA', 'The Two Towers', null, '345339711', '9780345339713');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (834, 44, 2019, 'Protea Boekhuis', 'Pretoria', 'Die Twee Torings', 436, '148530976X', '9781485309765');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (835, 44, 2020, 'HarperCollins Publishers Limited', null, 'Two Towers', 385, null, '9780008376130');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (836, 44, 2020, 'Houghton Mifflin Harcourt Publishing Company', null, 'Two Towers', 448, null, '9780358380245');
INSERT INTO editions (edition_id, book_id, publication_year, publisher, publisher_location, title, pages, isbn10, isbn13) VALUES (837, 44, null, null, null, 'As Duas Torres', 440, '8483028263', '9788483028261');

-- bookstore dataset

CREATE TABLE bookstore_inventory
(
    stock_number INTEGER AUTO_INCREMENT PRIMARY KEY,
    author       TEXT,
    title        TEXT,
    `condition`  TEXT,		-- condition is apparently a keyword in MySQL
    price        DECIMAL(10,2)
);

INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1421, 'Toni Morrison', 'Beloved', 'good', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1422, 'Chinua Achebe', 'Things Fall Apart', 'like new', 4.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1423, 'Clifford Simak', 'Way Station', 'fair', 2.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1424, 'Gabriel García Márquez', 'One Hundred Year of Solitude', 'like new', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1425, 'James Baldwin', 'Go Tell It on the Mountain', 'new', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1426, 'Tomas Tranströmer', 'For the Living and the Dead', 'new', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1427, 'Arundhati Roy', 'The Ministry of Utmost Happiness', 'good', 3.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1428, 'Zeyn Joukhadar', 'The Map of Salt and Stars', 'like new', 2.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1429, 'V. S. Naipaul', 'A Bend in the River', 'good', 3);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1430, 'Neil Gaiman', 'Anansi Boys', 'fair', 2.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1431, 'Chimamanda Ngozi Adichie', 'Half of a Yellow Sun', 'good', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1432, 'V. S. Naipaul', 'A Bend in the River', 'like new', 4);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1433, 'Margaret Atwood', 'The Testaments', 'good', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1434, 'Clifford Simak', 'Way Station', 'fair', 2.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1435, 'C. J. Cherryh', 'Downbelow Station', 'good', 3.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1436, 'Richard Wright', 'Black Boy', 'like new', 4.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1437, 'Jhumpa Lahiri', 'The Namesake', 'like new', 4);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1438, 'Bessie Head', 'Maru', 'good', 2.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1439, 'Franz Kafka', 'The Metamorphosis', 'good', 3.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1440, 'N. K. Jemisin', 'The Obelisk Gate', 'good', 3);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1441, 'Richard Wright', 'Black Boy', 'fair', 2);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1442, 'Arthur C. Clarke', '2001: A Space Odyssey', 'good', 4);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1443, 'Kazuo Ishiguro', 'When We Were Orphans', 'good', 3);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1444, 'Arthur C. Clarke', 'The City and the Stars', 'new', 4.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1445, 'Arundhati Roy', 'The Ministry of Utmost Happiness', 'good', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1446, 'Edwidge Danticat', 'Krik? Krak!', 'good', 3);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1447, 'J. M. Coetzee', 'Disgrace', 'fair', 1.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1448, 'Ismail Kadare', 'The Pyramid', 'good', 2.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1449, 'Kazuo Ishiguro', 'An Artist of the Floating World', 'fair', 2.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1450, 'Toni Morrison', 'Jazz', 'good', 2.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1451, 'Kazuo Ishiguro', 'When We Were Orphans', 'like new', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1452, 'Toni Morrison', 'Jazz', 'good', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1453, 'Margaret Atwood', 'The Handmaid''s Tale', 'good', 3.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1454, 'Kazuo Ishiguro', 'The Remains of the Day', 'new', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1455, 'Gabriel García Márquez', 'One Hundred Year of Solitude', 'good', 3);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1456, 'Clifford Simak', 'Way Station', 'good', 3.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1457, 'James Baldwin', 'Go Tell It on the Mountain', 'like new', 3);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1458, 'Arthur C. Clarke', 'Rendezvous with Rama', 'good', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1459, 'Kazuo Ishiguro', 'When We Were Orphans', 'good', 4.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1460, 'Nicola Griffith', 'Slow River', 'fair', 2);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1461, 'Neil Gaiman', 'The Graveyard Book', 'like new', 4);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1462, 'Tomas Tranströmer', 'For the Living and the Dead', 'fair', 2);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1463, 'Margaret Atwood', 'The Blind Assassin', 'good', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1464, 'Chinua Achebe', 'Things Fall Apart', 'good', 2.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1465, 'Chinua Achebe', 'No Longer at Ease', 'new', 4.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1466, 'Clifford Simak', 'Way Station', 'like new', 3.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1467, 'Emily Brontë', 'Wuthering Heights', 'good', 2.5);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1468, 'Jhumpa Lahiri', 'The Namesake', 'good', 2.75);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1469, 'Assia Djebar', 'Children of the New World', 'fair', 2.25);
INSERT INTO bookstore_inventory (stock_number, author, title, `condition`, price) VALUES (1470, 'Alice Munro', 'Runaway', 'good', 3.5);

CREATE TABLE bookstore_sales
(
    receipt_number INTEGER AUTO_INCREMENT PRIMARY KEY, 
    stock_number   INTEGER,
    date_sold      TIMESTAMP DEFAULT CURRENT_TIMESTAMP, -- MySQL doesn't allow default for only DATE
    payment        TEXT
);

INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (948, 1423, '2021-07-23', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (949, 1421, '2021-07-25', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (950, 1443, '2021-07-25', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (951, 1440, '2021-07-26', 'trade in');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (952, 1442, '2021-07-28', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (953, 1462, '2021-07-30', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (954, 1437, '2021-07-31', 'trade in');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (955, 1436, '2021-07-31', 'trade in');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (956, 1428, '2021-07-31', 'trade in');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (957, 1461, '2021-07-31', 'trade in');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (958, 1457, '2021-08-02', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (959, 1456, '2021-08-03', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (960, 1424, '2021-08-04', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (961, 1432, '2021-08-04', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (962, 1447, '2021-08-04', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (963, 1431, '2021-08-05', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (964, 1452, '2021-08-07', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (965, 1427, '2021-08-07', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (966, 1464, '2021-08-08', 'credit card');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (967, 1470, '2021-08-10', 'cash');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (968, 1463, '2021-08-11', 'trade in');
INSERT INTO bookstore_sales (receipt_number, stock_number, date_sold, payment) VALUES (969, 1439, '2021-08-13', 'credit card');

-- abstract examples

CREATE TABLE s
(
    sx TEXT,
    sy INTEGER
);

INSERT INTO s (sx, sy) VALUES ('one', 1);
INSERT INTO s (sx, sy) VALUES ('two', 2);
INSERT INTO s (sx, sy) VALUES ('three', 3);

CREATE TABLE s2
(
    sx TEXT,
    sy INTEGER
);

INSERT INTO s2 (sx, sy) VALUES ('one', 1);
INSERT INTO s2 (sx, sy) VALUES ('two', 2);
INSERT INTO s2 (sx, sy) VALUES ('four', 4);

CREATE TABLE s3
(
    sx TEXT,
    sy INTEGER
);

INSERT INTO s3 (sx, sy) VALUES ('one', 1);
INSERT INTO s3 (sx, sy) VALUES ('two', 2);
INSERT INTO s3 (sx, sy) VALUES ('three', 3);

CREATE TABLE t
(
    ty INTEGER,
    tz TEXT
);

INSERT INTO t (ty, tz) VALUES (1, 'green');
INSERT INTO t (ty, tz) VALUES (2, 'blue');
INSERT INTO t (ty, tz) VALUES (3, 'yellow');

CREATE TABLE t2
(
    ty INTEGER,
    tz TEXT
);

INSERT INTO t2 (ty, tz) VALUES (1, 'green');
INSERT INTO t2 (ty, tz) VALUES (2, 'blue');
INSERT INTO t2 (ty, tz) VALUES (3, 'yellow');

CREATE TABLE t3
(
    ty INTEGER,
    tz TEXT
);

INSERT INTO t3 (ty, tz) VALUES (1, 'green');
INSERT INTO t3 (ty, tz) VALUES (2, 'blue');
INSERT INTO t3 (ty, tz) VALUES (3, 'yellow');
INSERT INTO t3 (ty, tz) VALUES (2, 'red');

-- end of script

