string(3353) "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 = 2188 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (61024,105844,136336,148578,160060,162087,174274,178431,178891,190837,190864,193411,194531,194561,195807,196283,196293,196318,196319,196330,196331,196341,197262,199447,200397,200403,202620,202634,202636,202641,202770,202780,202800,202801,203834,204198,205451,205525,205939,207633,208312,208320,208322,210060,211912,212084,212086,212087,212103,212342,212363,212675,214094,214110,214117,214125,214131,214138,214142,214151,214163,214172,214177,214206,214210,214212,214213,214232,214235,215753,216425,216613,218089,218812,219412,219416,219556,219686,219708,221396,222008,222594,223492,223725,224661,224983,226507,226508,226524,226535,226659,226673,226678,226688,227051,227068,227287,227288,227297,228875,229001,230485,230494,231342,232640,233188,233218,233942,234103,234164,236044,237114,238505,238584,240585,240586,240599,242094,242480,244578,244581,244800,248951,249838,249949,249964,249989,250077,250107,250120,252965,255349,255927,257284,261938,262005,262515,265252,267195,267198,268478,268481,269018,269020,270159,279080,502073,509347,510440,521581,524513,526379,533632,540356,541868,549555,549593,551834,551835,554803) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"