string(3838) "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 = 37334 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (107704,130154,140298,141736,142502,143229,143660,144639,146884,147468,150334,151066,152059,152192,153700,153701,153775,156863,165289,169312,170375,171443,173472,175803,175810,175835,175897,175898,176210,176215,176337,176395,176447,176472,176500,176642,176652,176653,176665,176702,176850,177242,179894,183384,183385,183391,183417,183461,184861,191602,200298,201487,205002,206239,208125,209569,210450,211457,211956,212399,217191,217517,217569,218567,221731,222239,223884,224358,224948,228526,231020,231611,232522,235544,238224,240831,242104,243248,244608,248930,249323,249604,249830,250410,251816,251828,253502,254880,255140,257126,257508,257818,258337,260444,260493,264899,266599,267161,268976,269595,269609,269613,269638,269965,270786,272547,272923,272932,273761,273890,274343,274361,274962,275066,275817,277046,277343,280502,280522,283359,283666,283970,284016,284384,284796,284997,287219,287220,287493,288700,288892,289664,290056,290058,292733,293430,294980,297760,297761,297762,298642,298789,500193,500395,500621,501171,501663,504331,504566,504567,505842,506762,506773,508249,508291,508536,508942,510367,510368,510372,510373,514633,514849,514859,514884,515138,515144,515649,516022,516025,517222,517659,517669,517706,518056,518058,520550,523249,525259,525265,526616,527121,527394,530872,531636,531642,532803,532804,533004,533127,534501,534602,534603,536309,537903,539515,541889,544093,544132,544969,545473,546052,549218,549220,549378,549379,549881,551609,552390,552422,552471,552678,553395,553844,554122,554560,555873,557501,557503,557671,557672,559646,561361,563099,563750,564755,565026,565066,566919) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"