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š

Viktor Janiš

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.