string(4523) "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 = 6644 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (103665,122716,123604,123869,125016,126895,127594,127814,128667,129432,130000,130129,130440,131742,132488,132663,133638,133838,134931,136511,136713,136774,137676,138554,139224,139227,140507,140715,141105,141899,142683,143945,145695,148683,148967,151904,152407,154733,155142,156232,156844,156960,156997,157011,157236,157874,158259,161710,162563,163374,165687,166136,167172,167864,169314,169325,169514,169642,170048,170777,171343,173055,174269,174714,175441,176131,178126,179518,179786,179787,179791,179918,179949,180123,181744,182677,184438,184797,184798,184799,186249,187274,187871,188135,188298,189150,189310,193079,194217,194565,196028,196117,197036,198180,200396,204646,204972,206003,207650,208262,209481,209606,210316,211303,212666,214621,215922,217809,217928,219383,219972,220077,220953,221671,223713,223729,223802,224527,225365,225568,225972,226408,231078,231560,233849,234875,236303,236598,236744,238721,239604,239694,242374,242496,242584,244700,244747,245940,246104,248613,249296,249318,251496,251658,251935,252111,252478,252681,253125,253769,253975,254135,255651,256664,256792,257068,257979,258117,258523,259214,259365,259460,260354,260555,260847,261041,262195,262262,262370,262371,262374,262462,262503,262661,263338,263417,263560,263657,263832,264246,264357,264836,266154,266156,266327,266758,267061,267394,267424,267741,267971,268369,268571,268944,269180,269200,269258,269791,270699,271488,271569,271653,272171,272764,276417,276584,276859,278536,279028,279880,280803,280858,280946,281617,282082,282286,282724,282784,283415,283416,283935,283937,284117,284673,285063,286878,287349,287490,288573,290454,290455,290550,291826,294540,295179,295503,295952,296113,296933,296934,297213,297334,297572,297588,297864,298709,500112,500492,500588,501121,501359,503083,503333,503334,503338,503782,503976,504120,504434,504482,504573,505638,505998,507069,507878,508366,510627,510994,511208,511912,512746,512789,514439,517827,518327,520755,520771,520788,521125,522401,522600,524670,525379,529979,530951,530952,531082,532062,532406,532813,533201,533235,533402,533670,533863,533879,534071,536664,538218,538513,539863,541242,543017,543181,543186,543493,543498,543527,544601,549676,549739,550005,550941,551157,552072,552307,552782,553084,554046,554162,554263,554662,555556,556961,557091,557512,559563) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"