books: books_tags: 190 rows where tags

190 rows where tags_id = "ya"

descending

Link	tags_id	books_id
aiden-thomas/cemetery-boys,ya	ya	Cemetery Boys aiden-thomas/cemetery-boys
alan-dean-foster/the-last-starfighter,ya	ya	The Last Starfighter alan-dean-foster/the-last-starfighter
alex-gino/george,ya	ya	George alex-gino/george
alexander-wales/a-bluer-shade-of-white,ya	ya	A Bluer Shade of White alexander-wales/a-bluer-shade-of-white
alix-e-harrow/the-ten-thousand-doors-of-january,ya	ya	The Ten Thousand Doors of January alix-e-harrow/the-ten-thousand-doors-of-january
andrew-rowe/sufficiently-advanced-magic,ya	ya	Sufficiently Advanced Magic andrew-rowe/sufficiently-advanced-magic
angie-thomas/the-hate-u-give,ya	ya	The Hate U Give angie-thomas/the-hate-u-give
anne-mccaffrey/dragonflight,ya	ya	Dragonflight anne-mccaffrey/dragonflight
barbara-kloss/the-gods-of-men,ya	ya	The Gods of Men barbara-kloss/the-gods-of-men
blue-balliett/das-pentomino-orakel,ya	ya	Das Pentomino-Orakel blue-balliett/das-pentomino-orakel
brandon-sanderson/alcatraz-versus-the-evil-librarians,ya	ya	Alcatraz Versus the Evil Librarians brandon-sanderson/alcatraz-versus-the-evil-librarians
brandon-sanderson/alcatraz-versus-the-scriveners-bones,ya	ya	Alcatraz Versus the Scrivener's Bones brandon-sanderson/alcatraz-versus-the-scriveners-bones
brandon-sanderson/the-hero-of-ages,ya	ya	The Hero of Ages brandon-sanderson/the-hero-of-ages
brent-weeks/the-black-prism,ya	ya	The Black Prism brent-weeks/the-black-prism
brian-mcclellan/promise-of-blood,ya	ya	Promise of Blood brian-mcclellan/promise-of-blood
brian-selznick/the-invention-of-hugo-cabret,ya	ya	The Invention of Hugo Cabret brian-selznick/the-invention-of-hugo-cabret
c-m-spivey/from-under-the-mountain,ya	ya	From Under the Mountain c-m-spivey/from-under-the-mountain
c-s-pacat/captive-prince,ya	ya	Captive Prince c-s-pacat/captive-prince
casey-mcquiston/red-white-royal-blue,ya	ya	Red, White & Royal Blue casey-mcquiston/red-white-royal-blue
cassandra-clare/city-of-ashes,ya	ya	City of Ashes cassandra-clare/city-of-ashes
cassandra-clare/city-of-bones,ya	ya	City of Bones cassandra-clare/city-of-bones
cassandra-clare/city-of-glass,ya	ya	City of Glass cassandra-clare/city-of-glass
catherynne-m-valente/the-girl-who-circumnavigated-fairyland-in-a-ship-of-her-own-making,ya	ya	The Girl Who Circumnavigated Fairyland in a Ship of Her Own Making catherynne-m-valente/the-girl-who-circumnavigated-fairyland-in-a-ship-of-her-own-making
china-mieville/railsea,ya	ya	Railsea china-mieville/railsea
chris-beckett/dark-eden,ya	ya	Dark Eden chris-beckett/dark-eden
christina-henry/lost-boy-the-true-story-of-captain-hook,ya	ya	Lost Boy: The True Story of Captain Hook christina-henry/lost-boy-the-true-story-of-captain-hook
christoph-marzi/lycidas,ya	ya	Lycidas christoph-marzi/lycidas
claudie-arseneault/city-of-strife,ya	ya	City of Strife claudie-arseneault/city-of-strife
cornelia-funke/inkdeath,ya	ya	Inkdeath cornelia-funke/inkdeath
cornelia-funke/inkheart,ya	ya	Inkheart cornelia-funke/inkheart
cornelia-funke/inkspell,ya	ya	Inkspell cornelia-funke/inkspell
cory-doctorow/little-brother,ya	ya	Little Brother cory-doctorow/little-brother
courtney-schafer/the-whitefire-crossing,ya	ya	The Whitefire Crossing courtney-schafer/the-whitefire-crossing
david-levithan/two-boys-kissing,ya	ya	Two Boys Kissing david-levithan/two-boys-kissing
diana-wynne-jones/cart-and-cwidder,ya	ya	Cart and Cwidder diana-wynne-jones/cart-and-cwidder
diana-wynne-jones/conrads-fate,ya	ya	Conrad's Fate diana-wynne-jones/conrads-fate
diana-wynne-jones/dark-lord-of-derkholm,ya	ya	Dark Lord of Derkholm diana-wynne-jones/dark-lord-of-derkholm
diana-wynne-jones/the-lives-of-christopher-chant,ya	ya	The Lives of Christopher Chant diana-wynne-jones/the-lives-of-christopher-chant
diana-wynne-jones/the-magicians-of-caprona,ya	ya	The Magicians of Caprona diana-wynne-jones/the-magicians-of-caprona
diana-wynne-jones/the-tough-guide-to-fantasyland,ya	ya	The Tough Guide to Fantasyland diana-wynne-jones/the-tough-guide-to-fantasyland
diana-wynne-jones/witch-week,ya	ya	Witch Week diana-wynne-jones/witch-week
diane-duane/a-wizard-abroad,ya	ya	A Wizard Abroad diane-duane/a-wizard-abroad
diane-duane/a-wizard-alone,ya	ya	A Wizard Alone diane-duane/a-wizard-alone
diane-duane/a-wizard-of-mars,ya	ya	A Wizard of Mars diane-duane/a-wizard-of-mars
diane-duane/deep-wizardry,ya	ya	Deep Wizardry diane-duane/deep-wizardry
diane-duane/high-wizardry,ya	ya	High Wizardry diane-duane/high-wizardry
diane-duane/so-you-want-to-be-a-wizard,ya	ya	So You Want to Be a Wizard diane-duane/so-you-want-to-be-a-wizard
diane-duane/the-wizards-dilemma,ya	ya	The Wizard's Dilemma diane-duane/the-wizards-dilemma
diane-duane/wizards-at-war,ya	ya	Wizards at War diane-duane/wizards-at-war
diane-duane/wizards-holiday,ya	ya	Wizard's Holiday diane-duane/wizards-holiday
ekaterina-sedia/heart-of-iron,ya	ya	Heart of Iron ekaterina-sedia/heart-of-iron
emma-bull/war-for-the-oaks,ya	ya	War for the Oaks emma-bull/war-for-the-oaks
emmy-von-rhoden/der-trotzkopf,ya	ya	Der Trotzkopf emmy-von-rhoden/der-trotzkopf
eoin-colfer/artemis-fowl,ya	ya	Artemis Fowl eoin-colfer/artemis-fowl
eoin-colfer/the-arctic-incident,ya	ya	The Arctic Incident eoin-colfer/the-arctic-incident
eoin-colfer/the-eternity-code,ya	ya	The Eternity Code eoin-colfer/the-eternity-code
eoin-colfer/the-opal-deception,ya	ya	The Opal Deception eoin-colfer/the-opal-deception
eoin-colfer/the-wish-list,ya	ya	The Wish List eoin-colfer/the-wish-list
erin-morgenstern/the-night-circus,ya	ya	The Night Circus erin-morgenstern/the-night-circus
ernest-cline/ready-player-one,ya	ya	Ready Player One ernest-cline/ready-player-one
fran-wilde/updraft,ya	ya	Updraft fran-wilde/updraft
g-willow-wilson/alif-the-unseen,ya	ya	Alif the Unseen g-willow-wilson/alif-the-unseen
garth-nix/abhorsen,ya	ya	Abhorsen garth-nix/abhorsen
garth-nix/lirael,ya	ya	Lirael garth-nix/lirael
garth-nix/sabriel,ya	ya	Sabriel garth-nix/sabriel
genevieve-cogman/the-invisible-library,ya	ya	The Invisible Library genevieve-cogman/the-invisible-library
genevieve-valentine/mechanique,ya	ya	Mechanique genevieve-valentine/mechanique
glen-cook/the-black-company,ya	ya	The Black Company glen-cook/the-black-company
harper-lee/to-kill-a-mockingbird,ya	ya	To Kill a Mockingbird harper-lee/to-kill-a-mockingbird
holly-black/the-cruel-prince,ya	ya	The Cruel Prince holly-black/the-cruel-prince
j-k-rowling/harry-potter-and-the-deathly-hallows,ya	ya	Harry Potter and the Deathly Hallows j-k-rowling/harry-potter-and-the-deathly-hallows
j-k-rowling/harry-potter-and-the-goblet-of-fire,ya	ya	Harry Potter and the Goblet of Fire j-k-rowling/harry-potter-and-the-goblet-of-fire
j-k-rowling/harry-potter-and-the-half-blood-prince,ya	ya	Harry Potter and the Half-Blood Prince j-k-rowling/harry-potter-and-the-half-blood-prince
j-k-rowling/harry-potter-and-the-order-of-the-phoenix,ya	ya	Harry Potter and the Order of the Phoenix j-k-rowling/harry-potter-and-the-order-of-the-phoenix
j-k-rowling/harry-potter-and-the-prisoner-of-azkaban,ya	ya	Harry Potter and the Prisoner of Azkaban j-k-rowling/harry-potter-and-the-prisoner-of-azkaban
jane-yolen/sister-emilys-lightship-and-other-stories,ya	ya	Sister Emily's Lightship and Other Stories jane-yolen/sister-emilys-lightship-and-other-stories
jessica-townsend-jim-madsen/nevermoor,ya	ya	Nevermoor jessica-townsend-jim-madsen/nevermoor
john-bierce/into-the-labyrinth,ya	ya	Into the Labyrinth john-bierce/into-the-labyrinth
john-m-ford/growing-up-weightless,ya	ya	Growing Up Weightless john-m-ford/growing-up-weightless
jonathan-stroud/ptolemys-gate,ya	ya	Ptolemy's Gate jonathan-stroud/ptolemys-gate
jonathan-stroud/the-amulet-of-samarkand,ya	ya	The Amulet of Samarkand jonathan-stroud/the-amulet-of-samarkand
jonathan-stroud/the-golems-eye,ya	ya	The Golem's Eye jonathan-stroud/the-golems-eye
jonathan-stroud/the-ring-of-solomon,ya	ya	The Ring of Solomon jonathan-stroud/the-ring-of-solomon
jonathan-stroud/the-screaming-staircase,ya	ya	The Screaming Staircase jonathan-stroud/the-screaming-staircase
juliet-marillier/daughter-of-the-forest,ya	ya	Daughter of the Forest juliet-marillier/daughter-of-the-forest
justin-travis-call/master-of-sorrows,ya	ya	Master of Sorrows justin-travis-call/master-of-sorrows
kai-meyer/frostfeuer,ya	ya	Frostfeuer kai-meyer/frostfeuer
kai-meyer/the-glass-word,ya	ya	The Glass Word kai-meyer/the-glass-word
kai-meyer/the-stone-light,ya	ya	The Stone Light kai-meyer/the-stone-light
kai-meyer/the-water-mirror,ya	ya	The Water Mirror kai-meyer/the-water-mirror
klaus-kordon/der-erste-fruhling,ya	ya	Der erste Frühling klaus-kordon/der-erste-fruhling
klaus-kordon/die-roten-matrosen,ya	ya	Die roten Matrosen klaus-kordon/die-roten-matrosen
klaus-kordon/ein-trummersommer,ya	ya	Ein Trümmersommer klaus-kordon/ein-trummersommer
klaus-kordon/krokodil-im-nacken,ya	ya	Krokodil im Nacken klaus-kordon/krokodil-im-nacken
klaus-kordon/mit-dem-rucken-zur-wand,ya	ya	Mit dem Rücken zur Wand klaus-kordon/mit-dem-rucken-zur-wand
koushun-takami/battle-royale,ya	ya	Battle Royale koushun-takami/battle-royale
kurt-held/die-rote-zora-und-ihre-bande,ya	ya	Die rote Zora und ihre Bande kurt-held/die-rote-zora-und-ihre-bande
laini-taylor/daughter-of-smoke-bone,ya	ya	Daughter of Smoke & Bone laini-taylor/daughter-of-smoke-bone
leigh-bardugo/six-of-crows,ya	ya	Six of Crows leigh-bardugo/six-of-crows
lemony-snicket/the-austere-academy,ya	ya	The Austere Academy lemony-snicket/the-austere-academy

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE [books_tags] (
   [tags_id] TEXT REFERENCES [tags]([id]),
   [books_id] TEXT REFERENCES [books]([id]),
   PRIMARY KEY ([books_id], [tags_id])
);