string(3528) "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 = 3465
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (62490,101463,101675,103920,103978,103979,104711,105830,105882,105883,105936,105941,105942,105943,107119,108323,109960,121046,121630,121671,121716,121718,121722,122344,123154,123200,123403,124938,125026,125202,125274,125302,127785,127927,128032,128075,130008,131560,132927,132968,133762,134648,134778,134847,136862,137602,138279,139611,140287,140841,140866,143641,145130,145698,146094,146098,146424,147789,147828,147831,147836,147955,149208,149598,150807,155789,156446,158182,161976,163412,169227,170172,170325,174695,175153,177135,179584,180344,181594,182318,185138,185247,185449,187029,187273,187545,187547,187803,192105,194318,196439,197165,199828,200190,201268,203481,204551,205863,207340,207734,207900,207933,208766,208823,209964,210660,210862,211955,218036,218523,218960,219996,220146,220947,221935,222982,226627,227052,235351,235537,235954,237903,240230,240624,244801,245722,247094,247531,249411,250076,257220,257682,261363,261428,263902,264412,267427,270488,275306,275320,275335,276532,277030,277354,278508,284108,285867,285927,286315,290142,290695,291719,292515,292725,293298,293906,295549,295682,295781,296751,296752,296755,297111,297711,297720,298192,298306,502205,508256,510060,512569,514120,515122,515133,515508,515572,517876,518896,521761,524991,531869,533680,534854,534855,261521)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Viktor Janiš (*1974) pracuje ve svobodném povolání jako nakladatelský redaktor a překladatel.
V širokém žánrovém rozpětí od sci-fi, thrillerů, komiksů, grafických románů až po náročnou beletrii přeložil zhruba sto dvacet titulů, mimo jiné celé dílo Louise de Bernierese. Soustavně se věnuje Margaret Atwoodové, Alanu Moorovi, Neilu Gaimanovi a poslední dobou zejména Michelu Faberovi.
Získal osm překladatelských cen, mimo jiné obdržel Muriel za překlad Gaimanova grafického románu Hra o tebe v roce 2007 a v témže roce byl vyhlášen Nejlepším překladatelem SF a fantasy za překlad románu Jonathan Strange a pan Norrell od Susanny Clarkové.
Za překlad monumentálního neoviktoriánského románu Kvítek karmínový a bílý získal tvůrčí prémii v rámci Ceny Josefa Jungmanna.
