string(3277) "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 = 4426 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (100578,101522,102379,105930,106172,107216,107217,108167,108168,108466,118750,120806,121047,121305,121615,123746,125546,125728,128364,132920,134146,134314,134589,134796,135609,136803,138245,140801,141583,141586,141587,141819,142097,142964,144303,144966,146064,148154,150601,150604,153436,154136,154331,155396,158435,159677,159840,162942,163750,165820,166531,166619,171816,176848,186301,194112,194170,194681,194886,196624,199073,203435,203445,208663,209972,210282,211593,216893,234983,240989,241006,242235,250053,252149,262965,266982,273734,279708,280811,297244,297318,298644,298658,501872,501908,502722,503985,504258,504313,504344,506019,506044,506938,507145,507657,508286,508339,508537,512214,512220,513565,513806,513849,514224,514488,514738,514791,515706,515773,518883,518884,519099,519100,522318,522353,522354,524017,524233,524456,524965,527658,527662,527663,528687,530138,530320,530791,531128,531946,533150,533395,533788,534249,536393,537427,538002,539963,540134,547168,551720,553268,555843,558840,559681,560210,189568,195428,535450,542644) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"