string(3257) "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 = 43225 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (183949,192038,192184,193637,193962,194394,194569,194575,197782,198446,199457,199533,202699,202752,203601,204054,204546,205011,209611,211400,211520,213182,213636,214106,214873,215552,215865,216013,216453,216625,216731,217006,217007,217169,217306,217316,218324,218794,220319,221894,221954,222294,223705,224886,226732,227796,228043,228056,228165,228486,228698,231299,231602,231686,231687,231767,231867,233689,237494,237597,238094,238567,239224,239336,240069,240139,240455,240940,242296,242531,243422,243451,243758,245442,245980,247428,247446,247480,247673,247816,249240,249472,250504,250903,250904,250905,250906,250907,252687,252899,254117,254867,257336,257386,257510,260930,260992,261406,262752,265868,266682,266696,267302,267307,267995,268065,268386,270694,271190,271194,274231,278582,283753,284369,285490,288004,292478,297912,298393,502203,502573,502613,503161,503424,513366,513626,515830,518419,520548,521283,528493,528855,531026,531458,532969,535452,536311,536806,542069,542865,543674,557836,558028,559179,559724,559884) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"