string(3207) "SELECT DISTINCT
ranked_results.ID,
ranked_results.meta_key,
ranked_results.post_date,
ranked_results.meta_value,
ranked_results.title,
ranked_results.stock,
ranked_results.group_id
FROM (
SELECT
wp_30a7d99a36_posts.ID,
author_id.meta_key,
wp_30a7d99a36_posts.post_date,
book_year.meta_value,
books.title,
books.stock,
books.group_id,
ROW_NUMBER() OVER (
PARTITION BY books.group_id
ORDER BY
CASE WHEN books.stock > 0 THEN 0 ELSE 1 END,
wp_30a7d99a36_posts.post_date DESC
) as rn
FROM wp_30a7d99a36_posts
INNER JOIN books ON wp_30a7d99a36_posts.ID = books.id
LEFT JOIN wp_30a7d99a36_postmeta author_id
ON (author_id.post_id = wp_30a7d99a36_posts.ID AND author_id.meta_key LIKE 'acf_book_creators_%_acf_book_creator_id')
LEFT JOIN wp_30a7d99a36_postmeta book_group_id
ON (book_group_id.post_id = wp_30a7d99a36_posts.ID AND book_group_id.meta_key = 'acf_book_argo_group_id')
LEFT JOIN wp_30a7d99a36_postmeta author_role
ON (author_role.post_id = wp_30a7d99a36_posts.ID AND author_role.meta_key LIKE REPLACE(author_id.meta_key, 'id', 'role'))
LEFT JOIN wp_30a7d99a36_postmeta book_id
ON (book_id.post_id = wp_30a7d99a36_posts.ID AND book_id.meta_key = 'acf_book_argo_id')
LEFT JOIN wp_30a7d99a36_postmeta book_year
ON (book_year.post_id = wp_30a7d99a36_posts.ID AND book_year.meta_key = 'acf_book_year')
LEFT JOIN wp_30a7d99a36_term_relationships determination
ON (determination.object_id = wp_30a7d99a36_posts.ID AND determination.term_taxonomy_id = 48)
LEFT JOIN wp_30a7d99a36_postmeta thumbnail_id
ON (thumbnail_id.post_id = wp_30a7d99a36_posts.ID AND thumbnail_id.meta_key = '_thumbnail_id')
WHERE
wp_30a7d99a36_posts.post_type = 'book'
AND wp_30a7d99a36_posts.post_status IN ('publish', 'future')
AND author_id.meta_value = 8083
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (105936,106406,106921,107055,107406,107754,120880,121046,125026,128075,130008,130471,133414,135582,136354,136589,137172,140848,140866,143316,144677,145130,146009,146861,147610,147615,147943,149460,151198,155789,157593,159602,161907,165940,167811,171572,173658,174253,175675,185247,185449,186283,189423,189424,193337,194916,198354,205863,205864,207933,209540,210862,213727,215085,218036,218960,219357,219358,220506,221248,221249,226208,226732,229975,232180,232769,235250,235351,237171,237903,238567,240230,241926,242743,243422,243451,243909,243938,244972,245699,247531,249321,249411,249828,250265,250687,252766,253471,254516,257127,257140,257175,258033,259056,259701,259922,260488,262714,263902,267427,268835,269221,269685,269973,273971,274556,275329,276532,277354,277601,278508,280155,283194,285927,291824,292478,292627,293298,295550,296225,500478,507161,507499,511831,512569,512703,528897,531869,534515,535242,535452,547599,557836,221539,226171,259654,260934,285159,558049)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Neil Gaiman (*1960), původem Brit, žijící od roku 1992 v USA, je
jedním z nejznámějších a nejoceňovanějších spisovatelů a scenáristů zaměřených na žánr sci-fi a fantasy. Gaiman píše jak pro dospělé, tak pro děti. Proslavil se desetidílným komiksem Sandman
či scénářem k televiznímu seriálu Nikdykde, podle něhož později
napsal knihu a komiks. Gaimanovy světoznámé romány Hvězdný
prach a Američtí bohové byly zfilmovány, posledně jmenovaný
jako mnohadílný seriál. Navrch tento veleúspěšný román získal
mj. ceny Hugo a Nebula. K autorovým nejlepším knihám pro děti
pak patří Koralina a Kniha hřbitova, ta obdržela Newbery Medal,
Cenu Hugo či Carnegie Medal.
