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"