string(3144) "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 = 4217
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (100261,108998,122089,125067,125973,126383,129879,130860,131163,134929,136877,137703,143522,150041,153942,156847,158075,160025,163370,167918,168064,168220,172444,173087,174049,174050,178737,178738,185444,189217,189256,193037,195246,195953,196386,197867,198482,207731,213285,219702,219754,221625,224818,224821,224887,230933,231154,235879,239242,239322,242921,244748,247496,249432,250910,252599,255498,255917,257484,258385,258386,259585,259586,259587,259588,261760,262041,263589,264726,264878,264997,265303,266303,269656,270433,270747,270813,271009,271728,271894,273203,275357,276689,278594,279730,279854,281640,281930,283243,285916,286563,289398,291081,291082,292064,295135,295136,295190,298696,507927,508824,514849,514884,515427,519667,520555,521172,522079,522294,522379,525124,526543,527112,528573,532992,533575,536992,538324,538792,540389,540417,541139,541345,543590,551281,554696,555632,555851,560884,560945)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Lucie Šavlíková (* 1970), dlouholetá nakladatelská redaktorka, překladatelka a autorka knih pro děti:Lucie Šavlíková (1970) je literární
redaktorka, překladatelka
a autorka dětských knih.
Podílela se na několika projektech
zaměřených na čtenářskou
gramotnost a iniciovala vznik
ojedinělých metodických příruček
k dětským knihám.
