string(3627) "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 = 7967
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (105769,105772,105773,105774,105779,105780,105782,106677,107361,107362,107392,108234,108393,109960,123730,124646,130877,132348,132800,134003,134168,136893,140615,144421,147592,147832,148502,148953,152716,152739,154509,155913,157468,165786,165996,166619,167820,168242,171768,172051,174678,175358,175866,176862,176918,178541,182519,182953,188046,188373,189898,192966,194332,198855,198935,200323,200352,204495,204673,204808,206529,207853,207912,208800,209918,210345,210832,210844,210857,212537,214940,217202,217825,220288,223772,223997,224464,227420,231142,233348,234094,235703,237836,243954,244699,247380,250094,250101,254197,256088,256732,256734,256991,257120,257520,261019,263455,263563,264377,264526,264529,264544,264556,264557,266464,266518,266538,266545,266934,270193,270822,271107,271606,271608,271810,272107,272507,273128,273252,273256,273442,273443,273444,273451,273575,273782,274807,275771,275908,276216,276674,276781,278460,279232,279544,279745,280043,280084,280301,280303,280547,280708,285585,288542,288605,290669,291139,291145,291703,291855,291867,292366,292367,293379,294404,294422,294575,295438,297551,298808,500354,500828,501004,502569,502722,503434,503784,503985,504029,506972,506973,513322,513441,514333,521006,521257,522804,523881,524339,524965,527221,527585,527662,527663,528077,532491,534249,534362,535228,535780,537412,544628,550027,550029,554636,555861,557919,560072,515112)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"