string(3264) "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 = 21945 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (138320,169746,173644,175253,175254,175255,175256,175259,176223,180402,182177,183896,186814,187962,188841,190522,190829,193456,193544,194518,195568,196705,196720,198936,199700,199738,199850,202361,207044,207512,209520,209540,212540,214238,218079,219655,222783,227906,233531,235497,236115,239580,241188,243146,244017,248596,249652,257535,258993,259009,262641,262698,263495,264032,268492,269214,269513,270563,271242,273740,273772,279504,279631,280413,280456,280639,280897,283114,284085,291638,294157,295100,296720,296865,296871,298398,299099,500081,501407,503799,504117,504254,505636,505916,507057,507562,507643,507701,508480,511696,512675,513244,514173,514175,518196,520794,522216,523344,523474,524387,526628,527466,527604,527976,528757,529320,530116,530984,532216,533822,534785,538476,538755,539165,540396,540863,543358,543731,544459,544684,544821,545787,546072,546758,547029,547315,548198,548615,549962,550567,550568,550892,550899,551615,551940,552299,552983,553283,554303,554484,557577,557731,558947,559401,559794,561137,561817) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"