string(3019) "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 = 18264
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (132030,133534,143891,150374,152464,153404,155814,155859,155866,155875,162135,169949,174346,187538,197305,203600,206176,213597,215894,221711,222834,223737,224368,225325,226499,228622,231381,231465,231567,233265,235038,237739,239435,240905,242587,244482,247043,251394,252004,252546,254843,261256,268744,270493,270498,270657,270698,271345,273110,279077,279078,280830,283914,286632,286634,293244,293277,294126,294139,295483,295485,296721,297829,297830,297831,500346,500347,502193,502726,503507,507693,507694,507718,508737,509620,510129,511017,511131,512427,515046,515047,516268,516703,516721,518669,518670,522632,523431,525532,526607,527759,532988,535736,535807,536425,537153,540145,543217,543939,545594,548488,551126,551129,551131,551346,551398,553216,553592,554042,554592,560389,560943)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Milan Pohl (* 1982) vystudoval žurnalistiku a mediální studia, pracuje jako literární překladatel a redaktor. Do češtiny převedl více než 60 knih převážně v žánru sci-fi/fantasy, včetně románů Timothyho Zahna, Roberta Jacksona Bennetta, Johna Flanagana či Evana Wintera, mimo žánr například paměti britského agenta Paula Dukese Tanec s gestapem či generační román Patrioti Sany Krasikovové, podílel se na překladu a dramaturgii televizního seriálu Firefly. Publikoval okolo patnácti autorských povídek, zejména v časopise XB-1, nebeletristický Turistický zápisník (2017) a sci-fi novelu Střepy v prachu (2018). Rád se toulá přírodou, ať už individuálně s krosnou na zádech, nebo při dálkových pochodech a ultratrailech, jako je Beskydská sedmička.
