string(3088) "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 = 9751 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (108452,130194,132789,133784,138700,164373,166296,169731,169758,172508,191660,202338,206007,208562,213348,221995,235994,237097,239530,242307,246132,247644,249517,251189,251532,255925,257026,257279,259217,259697,262647,263388,263492,263607,264837,266297,268448,269674,271749,273831,275144,275983,276117,276380,278605,278606,281675,283530,286294,286456,287060,287122,287153,288782,289131,289602,289613,290859,295451,297526,299041,299071,299077,501562,501901,506232,507333,507336,507360,508821,510503,512193,513620,515694,517266,517575,518473,518474,518475,518510,518549,518865,518992,518998,519015,521241,521260,522066,522793,523136,523281,524558,524608,524943,525274,525787,526529,526671,527041,527218,528673,529071,531863,532951,536471,537419,540555,540807,541490,541617,542704,543298,543463,543569,543688,548540,548803,552517,552722,555175,555939,559258) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"