string(3256) "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 = 9059
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (107363,107396,120989,131685,131687,131688,131689,131690,131691,131692,133001,133472,141363,160737,161569,164771,168247,168250,168251,168253,171767,182699,182701,182702,182703,182704,182705,187768,187769,189068,189088,190541,192187,192268,194572,194572,195040,195068,196996,198271,198459,199246,199596,199997,200143,200901,202274,202343,202624,202826,202952,204544,205245,205364,206199,206604,207961,208499,210084,210632,210846,211416,211967,212389,213283,213283,214954,215260,215376,219212,220786,221481,222315,226114,226513,226531,226540,226544,227042,228284,231170,232676,235335,235354,235501,235527,236939,237113,238587,241402,242571,243127,244774,244788,244792,244846,245476,245703,245708,245790,247207,248764,249945,249981,250130,250346,250969,251178,252491,253503,253524,254038,254127,254511,256515,258542,259958,260862,261361,264047,265275,265958,270055,270056,270057,273549,273564,275331,275876,275886,277454,277551,280119,281928,285362,297033,509121,511323,514631,529519,529791,532317,542784,543061,518993,534636)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Jeden z nejúspěšnějších spisovatelů současnosti se
narodil v roce 1948. Do fantastického žánru vstoupil na
začátku sedmdesátých let a rychle sbíral první úspěchy za svou povídkovou tvorbu. V roce 1977 začal působit rovněž jako editor žánrových antologií a dodnes
je v tomto směru nejznámější svým projektem Divoké
karty. V osmdesátých letech psaní na několik let opustil
a věnoval se televizní produkci. K fantastice se vrátil obsáhlou a dodnes stále ještě nedokončenou fantasy sérií
Píseň ledu a ohně, která celosvětově proslula svým televizním zpracováním pod názvem Hra o trůny.
