string(3655) "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 = 6608
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (103612,106968,120875,122120,124387,125834,128644,130027,130221,131158,131926,132162,132384,133357,135624,135853,136674,137587,137673,141876,141887,142186,144207,148007,150923,153175,153945,153998,155241,158164,161991,162481,164549,166731,168294,168706,168925,169854,172062,174093,174273,176070,178757,186666,186670,187688,188008,189523,192982,197253,198167,198200,198677,198784,199432,200803,201115,205809,208267,208290,209045,209280,209941,211679,212007,215558,216586,217169,219034,219503,219506,220231,220334,221422,222064,224110,224177,224650,224753,226459,228159,228454,231912,233432,235907,237471,238542,238638,240932,242651,242894,243972,244934,245559,245753,247085,247321,247394,247478,247514,247997,248169,250016,250102,251273,251487,251650,252799,253604,254179,254972,255642,256420,257125,257332,257516,260208,260812,261320,261567,262204,262329,262728,263975,264593,266057,267746,268017,269681,269760,269921,271891,273122,273206,275321,278623,278674,278958,280558,281316,284957,285495,285919,286879,287432,287946,288321,289016,289248,297717,298187,500738,502425,502550,502621,503991,508498,508504,512231,513356,513380,515384,516594,518000,518854,518976,519398,519698,521103,521270,521326,522992,524891,526778,526780,527895,528846,528888,529544,529740,532467,536339,536802,537175,537758,538053,542971,545587,545767,546105,547571,549193,550355,550362,550419,550750,550759,550760,550793,555430,557075,557931,559878)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Petra Diestlerová (* 1972) vystudovala angličtinu a francouzštinu na katedře překladatelství a tlumočnictví FF UK. Pracuje v nakladatelství, překládá převážně angloamerickou prózu různých žánrů včetně dětské literatury a populárně-naučné texty. Za diplomovou práci Polopřímá řeč jako problém překladatelský obdržela v roce 1996 Bolzanovu cenu. Dvakrát získala tvůrčí prémii v rámci Ceny Josefa Jungmanna udělované Obcí překladatelů, a to v roce 2014 za překlad románu Davida Mitchella Tisíc podzimů Jacoba de Zoeta, a v roce 2016 za nový překlad románu Charlese Dickense David Copperfield.
