string(3321) "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 = 22 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (45,5358,61306,62188,62228,62486,100931,101425,101822,103896,103974,104543,105693,106125,106447,106509,106864,107663,121450,121672,121862,122293,122300,122305,122544,124532,127651,128684,131063,134632,134633,135115,136239,139914,142190,143715,149596,150298,152403,153171,154600,158293,159472,159553,160811,161303,169567,169568,169569,169570,169759,170586,171690,172059,172794,175412,176524,179027,184134,185421,188847,189069,189101,189576,194530,196428,198241,199413,200813,200873,203426,203484,205634,205839,209181,210467,211180,215836,216268,217570,219515,219859,221164,222476,224229,224933,225723,227919,235629,237522,241158,245560,246005,247946,250901,250960,251027,253747,253755,254567,254607,255309,256464,257901,258081,262108,262525,263336,263583,265591,266144,267428,268699,268841,269578,271997,274042,274651,276857,277386,277457,278969,283485,285671,286114,287090,288121,288703,289377,289445,296557,502100,502375,502376,502645,503319,504175,504208,504719,505315,505503,506693,508816,510628,513000,516855,528070,530974,531364,531483,532329,537260,540477,544028,557462,557466,559790) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"