string(2963) "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 = 35653
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (165454,176471,178749,179306,185521,186504,190581,191155,192576,192712,195476,195823,195825,198479,199248,200987,201686,202191,202490,202873,202957,203779,203885,205306,206086,207515,207571,207604,207950,210960,213322,213442,217448,219805,221254,224353,224764,229038,231569,231645,234695,237266,237752,238977,239175,239243,241875,243655,244469,244495,250408,251898,253639,257338,257523,270327,272144,273562,275818,276987,277810,280520,282911,284189,284637,285896,286616,287722,288248,289151,293093,293100,500322,500781,502050,502240,502491,505856,505861,507397,510826,510827,511698,518158,518753,518777,518783,518898,518901,521282,525048,525558,535648,536622,536624,537156,542064,545853,551049,551371,552823,555889,561394,562037)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Linda Kaprová
Linda Kaprová (*1982) vystudovala švédštinu a translatologii na FF UK v Praze. Věnuje se překladům z angličtiny i švédštiny, a to zejména detektivnímu žánru, ale také literatuře faktu. V roce 2007 získala čestné uznání na III. ročníku překladatelské soutěže na Filozofické fakultě Ostravské univerzity a od roku 2013 působí též jako soudní překladatelka a tlumočnice.