string(4612) "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 = 3138
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (62069,62229,100276,100668,100821,100821,100925,101171,102383,106417,107045,107528,107529,107573,108275,117880,118288,121281,121281,124007,124928,124929,125030,125448,125449,125454,129460,129461,129467,129469,129479,130790,133460,133460,135605,136643,136644,137239,141723,145008,145010,145047,145048,145126,145300,145306,145723,145725,145769,146030,146044,146143,146172,147922,148497,148498,148813,149484,149856,150096,150658,150753,151473,151704,153123,155362,155943,156568,156814,156815,157791,158957,160283,160380,160625,162113,162279,163381,163387,164133,166048,166049,166063,166066,166071,166073,166179,166182,166188,166191,166192,167205,167515,168964,171765,174593,176324,176328,176334,176438,176464,176646,176744,176745,177257,177258,177676,177712,177727,178072,178378,178391,178615,178618,178683,179491,179927,179928,179929,179930,179932,180109,180110,183585,183588,183646,184020,184213,184406,185236,185775,186136,186475,187078,187392,188111,189772,189878,189883,189884,189987,190676,193065,193966,194613,194792,194884,195165,195793,196083,196697,197159,197944,199072,199074,201458,201493,201601,201679,201695,201738,201739,201794,202230,203274,204642,204643,205041,205227,205681,206107,206240,206753,207368,208753,211135,213651,213749,213753,213902,214767,214770,215397,215466,215467,215989,217532,217859,219135,220223,220825,222280,222396,223882,224488,224581,225828,226859,231624,235365,235523,236748,237344,237406,239315,239315,244607,250965,251196,252334,257293,264952,267522,267524,268726,269393,271124,273578,273580,273582,275336,275675,276711,278828,280391,281236,284729,285722,287640,287647,287669,288078,288978,289853,290179,290302,290341,290578,290580,290595,290770,290809,290809,290889,290893,290906,290932,291216,291254,291577,292021,292924,293162,293253,293344,295246,297457,297482,297483,297484,297485,297573,297627,298789,500475,500549,500549,500549,501063,501663,501689,501751,502837,507503,507869,507968,508249,508311,508314,508422,508791,510746,511270,512513,512514,513363,513498,513974,514026,514557,514859,514860,516776,517637,518238,519095,519631,519838,522093,522783,523137,524494,524495,524503,524505,525040,525813,528953,530591,530673,530915,530916,530918,532655,532832,534247,534604,535273,535383,537162,540645,541217,541222,541223,545232,545453,545515,545608,545885,545885,547460,547796,547798,549207,549242,549868,550324,550324,560093,516500)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Karel Čapek, český spisovatel, intelektuál, novinář, dramatik, překladatel a fotograf. Sedminásobný aspirant na Nobelovu cenu za literaturu. Proslavil se zejména svými divadelními hrami a fejetony. Narodil se do početné rodiny jako nejmladší ze tří sourozenců. Bratr Josef se stal známým malířem a spisovatelem, sestra Helena kromě několika próz vynikla vzpomínkovou knihou. Podnikl řadu cest do zahraničí, jež mu byly inspirací pro cestopisné fejetony a prózy.
