string(2927) "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 = 5130
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (101574,136505,149095,151238,155333,155340,158729,158771,163193,166095,166096,169651,170712,171817,173792,173942,180535,180536,183107,190832,191066,192583,194404,194652,195579,199162,199163,209084,211510,213300,215858,215903,219919,223680,224863,235499,235500,239059,241927,254068,255125,257093,259441,272252,275011,276776,281039,282630,284313,285111,290073,293700,295474,295834,298443,500161,500836,504313,504344,504376,508339,508379,508769,509671,510272,514542,516590,517211,518485,520793,520805,527957,529026,532978,533557,533621,541320,541922,543843,544324,544379,545201,545243,545253,548380,548431,552895,553821,555810,557747,559615,560340,515878,208754,209078,215473,217923,534987,536128)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Markéta Pilátová (nar. 1973) je spisovatelka, novinářka, autorka knih pro děti, překladatelka a hispanistka. Dvakrát byla nominovaná na Cenu Josefa Škvoreckého a na Magnesii Literu a získala ocenění Zlatá stuha. Je autorkou řady románů, povídkových knih, básní a třinácti dětských knih. K nejznámějším románům patří Žluté oči vedou domů, Tsunami blues nebo S Baťou v džungli. Knihy Markéty Pilátové vyšly už ve dvanácti světových jazycích. www.marketapilatova@cz
