string(3218) "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 = 2307 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (61127,61771,62518,121676,175454,190832,190877,193407,194505,194559,194560,194577,194974,195579,195713,195755,196329,197690,199466,199705,201297,201950,201952,202402,202613,202630,202631,202635,202639,202773,202982,202983,202985,202995,203615,206021,206023,206207,206715,207637,207638,208315,208316,208362,212294,212300,214115,214128,214132,214158,214168,214176,214178,214180,214211,214214,214234,214239,214565,216666,217668,218003,219207,219419,219557,219558,219559,219680,219689,219693,221115,222397,222604,223497,223571,223699,225572,226269,226541,226628,226629,226663,226664,226665,226671,226676,226677,226679,226683,227283,227302,227308,227309,227315,228885,233309,233940,234186,234286,235406,236952,237367,238506,239583,239838,240527,242766,243454,244010,247456,249163,249932,250123,254046,254287,257121,257494,257497,257511,259340,259352,259355,261900,265268,267846,269091,269735,269892,269915,274065,274161,278902,280013,280053,518558,526042,526043,539478,549591,549607,554790) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"