string(4203) "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 = 2079
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (60925,61305,61635,61691,61692,61969,62277,62438,62634,62657,62665,62879,100555,100715,100918,101579,101618,101620,101682,102002,102389,103247,103577,104243,104306,105731,107368,107825,122256,122257,122449,124833,125586,127402,132071,133204,134723,134725,136903,137525,140057,141131,141131,145035,145327,145457,145731,146696,147593,151308,152703,153447,156230,156406,156485,160366,162156,167822,168400,169883,172791,172912,173976,175562,179292,182167,182714,183797,186815,188614,189842,190128,190352,190458,191196,191808,191844,192071,193776,194609,196025,196569,197495,197513,197978,199016,199476,199727,199991,200152,200948,200963,201187,201999,202796,203013,203897,204693,206697,207725,208167,208168,208669,209842,211714,212241,212444,213426,215109,215671,217317,217673,218595,218759,220320,220578,221978,223788,224327,224695,225040,225171,226374,230053,231899,235537,237805,237963,239953,239962,240059,240128,240375,240447,240457,241299,241656,243006,244201,244728,245134,246275,246343,248412,249950,249973,250469,250900,252008,252675,252849,252986,253252,253367,253552,254052,254376,254763,255847,255903,255913,255982,256194,256432,256767,257276,259135,259861,259877,260374,260609,260932,261024,263078,267814,269898,271292,274988,275270,275324,275325,275356,275705,275896,276739,279651,281082,281577,282174,283502,284246,284743,284762,285692,286248,286258,286295,287023,287390,288247,288700,288730,289396,291899,291943,292765,292767,293692,294050,294697,295768,297282,298992,500187,500704,501242,501315,501423,503349,503350,504095,504397,504439,506166,506490,507202,507604,508457,508751,508958,509512,509526,509548,509552,510800,511227,512308,514442,514923,516544,519125,521144,521408,521946,522400,522505,522962,523441,523849,523871,524552,526961,527489,529007,530936,532852,533040,533569,534246,534846,535616,536403,537300,539396,540634,540929,541904,541907,543028,544182,545974,548661,548975,549385,549590,549832,552412,552516,556218,556271,557370,559421,561052)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Martin Pokorný
Martin Pokorný (1973) překládá beletrii (např. Vlny Virginie Woolfové, U ptáků plavavých Flanna O’Briena či Nejlepší léta slečny Jean Brodieové Muriel Sparkové), populárně-naučnou literaturu a odborné texty převážně z oboru filosofie, politologie a literární vědy (Krysí stezka a Návrat do Lvova Philippa Sandse, Uspořádání světa Henryho Kissingera či rozhovor Timothyho Snydera s Tonym Judtem Intelektuál ve dvacátém století ad.). Dlouhodobě spolupracuje s nakladatelstvími PROSTOR, Odeon, Karolinum či Rubato.