string(3921) "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 = 656
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (1473,5442,61707,63161,100251,101712,102493,103559,103560,105215,107711,107712,107713,109417,116775,121088,122535,129197,129201,131299,131907,131909,133596,133806,133912,134256,135312,135481,135767,135769,137362,138334,139398,139659,139792,140614,141717,141718,141811,141812,141813,141814,142128,142232,143271,143272,143399,144478,145140,145141,145354,145506,145894,146047,146383,146392,146393,146853,146925,146926,146927,147068,147478,148052,148075,148287,148763,149030,149273,150464,150520,151117,151474,153381,154240,156833,159887,160407,160671,165324,165727,165978,165979,165983,166076,166194,166228,167938,168369,168452,170005,175107,175314,175871,175872,175873,175874,175875,175876,175877,175878,175879,175880,175881,175883,176216,176233,176235,176237,176372,176502,176810,176827,176828,176830,176831,176833,176836,176854,176856,177246,177747,177994,178254,178255,179356,181747,184016,187264,189713,191330,191361,192228,192548,195797,195798,198944,199939,201016,201737,202832,202833,203505,204402,204422,204800,207161,207169,207367,207385,207398,207406,207436,210052,210056,210058,210182,211673,217390,219016,219404,220960,221613,222238,226213,236532,242802,244604,248277,249147,251782,252525,252605,252608,253098,253780,258188,258862,259073,259830,263696,264121,266117,271607,274598,274619,278714,279574,280092,280141,283604,283748,286804,286884,287276,287991,288376,289513,289517,289523,289528,290151,290228,292547,292642,292804,292805,292911,295457,295628,296438,296440,297324,297844,507432,508247,510420,513902,518086,519706,519869,521032,522248,522576,524291,524665,526796,529757,529817,530868,530890,537355,537736,538956,539004,539163,540271,540587,548067,548880,559751,560276)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Skotský spisovatel a lékař. Známý převážně pro svého Sherlocka Holmese.
Narodil se do katolické rodiny a v devíti letech ho rodiče poslali do jezuitské internátní školy, kde jediná jeho radost byla psaní dopisů matce. Vystudoval lékařství, kromě literatury se věnoval politice a sportu, angažoval se v obhajobě lidských práv. Odřekl se náboženství, stal se spiritistou. Byl dvakrát ženat, měl 5 dětí. Byl velmi plodným autorem, kromě světově známých detektivních příběhů (Sherlok Holmes, Pes baskervilský apod.) psal historické romány, hry, verše, science fiction aj.
