string(3082) "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 = 24548
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (142925,144945,145425,145426,145438,145442,145443,145444,149363,149368,149413,150111,153943,159677,161041,164360,164363,165010,165011,165166,165167,171816,174516,178893,186648,187925,189038,191754,195351,202764,205168,205174,205188,206192,206828,206829,207980,208249,210228,212397,215192,217018,217525,221834,224288,224289,224779,224890,225077,226159,230782,231545,232145,236432,236931,239301,239334,241765,244424,245844,249574,249621,250463,255387,255501,258141,258596,260200,261921,264934,265132,265135,267190,270751,270811,273289,278105,282329,282726,282744,282746,282748,283790,284288,284848,285588,286001,286719,288764,289942,292065,298074,298198,500669,500973,507005,511515,512901,518902,518961,521778,521817,521850,523634,523929,525011,525565,533399,535051,535370,535723,536790,537749,539676,543848,545324,546547,515878,252579,534912,535073)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Vratislav Kadlec (* 1981) vystudoval Literární akademii; působí jako překladatel (mj. dvakrát získal cenu Zlatá stuha za překlad knih pro děti) a redaktor; byl šéfredaktorem měsíčníku Plav a principálem divadelního spolku Prvobytně pospolná společnost.
