string(3355) "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 = 11666
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (121504,127258,130126,130382,133152,144858,145323,146514,147149,148503,151826,151827,152792,152903,153001,155823,158027,171028,175412,179561,189684,190320,190829,191015,193375,193410,194562,195425,195712,196279,196291,196322,196336,196428,196705,197780,199479,199495,199649,199700,199727,200368,201293,201949,202619,202638,202640,202643,202646,202650,202660,202660,202771,202776,202793,202934,202937,202977,202979,203607,204258,206069,206478,206495,206497,206627,207512,207519,207641,209507,209674,211914,211914,212303,213110,214086,214105,214139,214159,214161,214179,214224,214226,214229,214231,214238,215949,216080,216419,217658,218227,218692,219408,219413,219418,219420,219684,220943,220947,220949,220955,223495,223808,224332,224660,224714,226434,226538,226621,226668,227280,231192,231744,232523,233936,234107,234798,235497,237009,237366,238455,241729,242284,244795,247265,249944,249950,250006,250018,254826,255038,257272,257395,258440,259342,259343,259350,260381,262027,262521,262522,264202,265224,266807,267645,270752,270753,272746,281929,286009,286315,287464,502954,503985,504029,510415,542574,548765,549610,550164)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Petr Onufer (* 1976) vystudoval anglistiku a bohemistiku na Filozofické fakultě Univerzity Karlovy a na University of Texas v Austinu. V nakladatelství Argo vede edici angloamerických autorů (AAA), edici angloamerických básníků (AAB) a literárněkritickou edici Specula. Vyučoval na anglistice v Praze a v Českých Budějovicích. Texty o literatuře publikuje v Revolver Revue, Souvislostech a dalších časopisech. Soustavně působí jako překladatel – z angličtiny převedl například díla Josepha Conrada, T. S. Eliota, Williama Faulknera, Jacka Kerouaca, Dona DeLilla, Michaela Chabona, Richarda Wilbura, Wolfganga Isera či Terryho Eagletona. Je editorem prvního českého výboru z americké literární kritiky Před potopou. Kapitoly z americké literární kritiky 1930–1970. V roce 2018 vydal v nakladatelství Karolinum knihu Obtížná balanc. Ke kánonu anglofonních literatur v českém kontextu.
