string(3262) "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 = 2117
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (60961,102837,104609,105518,106896,120585,123261,128458,131067,131068,131847,133365,135033,137349,140402,141977,141978,142724,142746,142792,142801,143599,143660,143683,144089,144090,144186,144188,144639,147019,147020,147021,148077,150500,150501,150596,151296,152371,152919,154458,154462,158143,158146,161524,162440,163563,167793,168913,168915,169753,170689,171700,173071,175810,175812,175824,175825,175826,175827,183705,186721,187556,189319,190359,211957,215879,218461,219074,219573,219751,221179,226084,226209,226476,230449,230946,231172,231199,231619,231688,231870,234426,242863,243475,245565,245966,246258,246276,247491,247493,247494,247849,248148,248201,249783,250978,255883,256828,258129,258244,258363,259136,259533,263451,263723,264024,264726,266235,266791,271894,274378,275502,275790,276351,279936,283727,283805,284385,521211,521662,521884,524718,524719,525781,526776,532648,533347,533408,533413,533423,533425,533429,533506,533512,533519,533528,533595,533602,533608,534520,534888,536127,537104,537633,539539,545026,545177)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Britský romanopisec, scénárista a povídkář. Mnoho jeho děl bylo zfilmováno, například Karlík a továrna na čokoládu.
Stal se jedním z nejprodávanějších autorů na světě. Narodil se norským rodičům a byl pojmenován podle národního norského hrdiny Roalda Amundsena. Doma mluvil s rodiči a sestrami pouze norsky. Když mu byly čtyři roky, zemřela jeho sedmiletá sestra na apendicitidu a o měsíc později otec na zápal plic. Dahlova matka se poté rozhodla, že se s dětmi nevrátí do Norska, protože jejich otec si přál, aby studovaly na anglických školách. Byl velmi dobrý sportovec, stal se kapitánem školního squashového týmu a hrál i za školní fotbalový tým. Je držitelem ceny Edgara Allana Poea Stříbrné pisátko.
