string(3277) "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 = 4426
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (100578,101522,102379,105930,106172,107216,107217,108167,108168,108466,118750,120806,121047,121305,121615,123746,125546,125728,128364,132920,134146,134314,134589,134796,135609,136803,138245,140801,141583,141586,141587,141819,142097,142964,144303,144966,146064,148154,150601,150604,153436,154136,154331,155396,158435,159677,159840,162942,163750,165820,166531,166619,171816,176848,186301,194112,194170,194681,194886,196624,199073,203435,203445,208663,209972,210282,211593,216893,234983,240989,241006,242235,250053,252149,262965,266982,273734,279708,280811,297244,297318,298644,298658,501872,501908,502722,503985,504258,504313,504344,506019,506044,506938,507145,507657,508286,508339,508537,512214,512220,513565,513806,513849,514224,514488,514738,514791,515706,515773,518883,518884,519099,519100,522318,522353,522354,524017,524233,524456,524965,527658,527662,527663,528687,530138,530320,530791,531128,531946,533150,533395,533788,534249,536393,537427,538002,539963,540134,547168,551720,553268,555843,558840,559681,560210,189568,195428,535450,542644)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Český novinář a spisovatel sci-fi.
Vystudoval fakultu sociálních věd a publicistiky Univerzity Karlovy v Praze a rok nato získal titul PhDr. Mezitím již působil jako redaktor Československého rozhlasu a podílel se na vysílání i v osudný den okupace Československa sovětskými vojsky. Pracoval na propagaci nakladatelství Albatros a obchodního domu Kotva. Vydává internetové deníky Neviditelný pes a DigiNeff.
