string(2990) "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 = 9271
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (107736,116920,125260,126014,126656,128540,130425,131093,134396,143722,144996,145390,146933,148869,157463,159685,165498,167577,168335,172949,179714,183422,183462,190642,192442,199154,199445,201155,201155,202992,206507,207692,210376,211017,217004,220930,222690,224131,224187,228771,232148,232151,233066,233255,234562,234982,235494,235803,236251,236858,236858,237999,238538,240717,246292,250264,252189,255476,258039,258985,259051,260223,260438,262034,267561,269387,275308,276330,276330,276540,276759,280306,282672,284237,287189,298788,500547,500745,500755,501915,503620,504181,504396,506165,506211,507727,509212,511061,512962,514399,515125,516774,516777,516778,516778,518172,520729,521305,527766,529771,535996,543843,544118,545325,546123,548413,560212,267172)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
(nar. 1977 v Olomouci) je spisovatel, překladatel a vysokoškolský učitel. Je autorem několika sbírek poezie (Básně na děrné štítky, Atlas bytostí, Malá tma aj.) a řady knížek pro děti, rovněž rozhlasových her a odborných publikací. Do češtiny převedl např. verše Georga Trakla, R. M. Rilka či Paula Celana, ale také Goethova Fausta. Ve spolupráci s výtvarníkem Františkem Petrákem vznikla sbírka veršů Zahrada s meruňkami, včelami a mandloní. Za svou tvorbu obdržel četná ocenění, např. Cenu Jiřího Ortena za sbírku Vraní zpěvy a dvakrát cenu Magnesia Litera – za poezii (Větrní. Zcestné verše) a za knihu pro děti a mládež (Listonoš vítr).
