string(4376) "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 = 4893 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (101277,101781,102326,103291,103699,104711,106343,106344,106345,106346,106347,106348,106349,106350,106351,106352,106353,106354,106355,106362,106579,106921,106983,106984,106985,106986,106987,106988,106989,106990,106991,107127,107129,107130,107131,107132,107330,108105,108322,108428,108571,108676,121669,121670,121973,122277,122590,122956,122958,124110,126005,126916,126928,128253,128422,130156,130487,130729,131682,132751,133228,135215,136613,136805,137613,137614,138091,138885,140685,141366,141504,141700,141701,143332,143333,143334,143413,143646,143647,145119,146399,146516,146522,146524,146525,147610,147615,147826,148185,148435,148446,148762,148764,149793,150738,153310,153312,154513,154514,156068,156464,157193,157194,158370,158371,159676,160717,160733,161913,162036,164168,165165,169407,169815,171766,174373,174398,175776,175959,176262,176755,177815,178366,178596,184182,186169,186621,187456,187945,188005,188006,188413,188800,189011,189122,189123,189160,189638,189917,190537,190538,192183,192186,192854,195390,195393,195526,196403,197793,197795,199244,199245,199973,200141,200142,200144,201791,203985,204784,207085,207086,208211,208396,208587,213897,213899,213901,214645,214647,215631,217424,217426,219568,219572,220287,222190,223861,225151,225659,228064,231123,231614,231742,234049,234051,234052,235272,236101,236713,237446,237643,239192,240041,240768,241535,243812,244854,244894,245692,248628,248629,250209,251700,253337,253345,253783,253802,254123,256834,257250,257253,258277,258278,259443,261626,261627,261802,263810,263811,266879,268746,269685,270194,270568,271529,271531,271535,272942,273219,273220,273971,275873,276852,276855,278616,279704,282301,282765,282766,282767,282768,282769,282770,282875,284440,286483,287300,287302,288674,291740,293336,296650,296652,298997,298998,504530,504533,508318,508320,508323,508325,508328,508330,509245,510127,510198,510213,511291,521827,521829,521831,524120,524124,526277,526278,526279,526283,535473,537616,537620,537805,538038,538041,538042,541013,541018,546161,546166,548000,548002,548441,548442,554082,554084,556996,556997,556998,557456,557457,560582,192653,262419,275164,244895,548440,221539) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"