string(3893) "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 = 8210 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (106110,106111,106112,106821,107362,107395,108234,108391,109936,113168,118138,120992,123007,123166,123429,125832,126610,127239,127242,129360,130366,131956,131958,132069,132968,133761,133762,134002,134469,134694,136011,136441,136442,138290,141222,144948,145750,146010,147136,147678,149459,151060,152293,152558,154244,155757,155758,155760,155761,155762,155834,158903,159069,160361,161165,162869,163831,167426,169063,170406,171071,174421,181981,192821,196321,198354,199157,199159,202653,208319,208818,209282,210630,210940,212703,213657,213727,215119,215146,215148,216101,219410,220633,221906,222378,224003,226360,226513,228209,228314,228458,228540,228620,231819,233019,235527,237925,237945,239632,240375,241406,241407,242493,242582,243134,244201,244461,245476,245676,245721,245963,247455,248107,248313,249512,249846,249921,249963,250129,250347,252053,254038,254077,254263,254530,255855,256854,257119,257957,258249,258328,258761,258834,258879,259353,259453,260177,260790,260862,261122,261384,261389,262483,262516,263843,263916,264873,265047,266258,266589,266812,269321,269345,269349,270356,270445,270928,271022,272843,272950,273148,275331,275886,279674,279978,282459,284518,285255,285412,287360,287572,287590,288025,288067,288357,292012,292550,294897,295155,297519,298970,500005,501746,503553,506225,507825,510450,510869,511456,514631,515383,516534,516598,516912,517388,517969,518993,519022,519029,519056,519188,520086,520661,522080,523935,525261,525918,528639,529151,531146,532012,532198,534636,536340,537396,540874,540875,541168,541626,543323,543551,543575,544272,545593,548740,549157,549743,552525,552840,553639,554592,554707,555416,556040,557406,558286,559384) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"