string(6168) "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 = 5021 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (101460,101894,103705,103928,105831,105889,105890,105943,106676,106786,106912,106913,107177,107362,107378,108145,108234,108515,108530,109960,120657,120879,120880,120989,121419,122421,122590,123059,123385,123710,123961,124439,124578,124779,125246,125467,125480,125836,127242,127324,127937,128542,129157,129481,130374,130608,130775,130890,131559,131743,132074,132614,132642,132968,133761,133762,134144,134388,134519,134633,135582,135740,135849,136242,137711,139319,139363,139908,140285,140413,140526,140940,141205,141215,142087,142560,142664,142783,142996,143137,144108,144299,144699,145324,145328,145691,146009,146530,146661,146749,147248,147514,147996,148815,149324,150251,150490,150799,151705,152063,152326,152623,154356,155400,155965,157413,157947,158200,158432,158446,158681,160332,160499,161808,161827,162132,162770,163880,164916,165067,166353,166591,167425,168747,169131,169191,169801,170082,170341,170492,170988,171052,171161,171611,172296,173531,173645,173903,174256,175557,176221,177158,177503,179350,179856,180540,180541,180542,181986,182436,183298,184838,185179,185446,185876,186094,186348,186882,186891,188218,188834,189068,189277,189534,189958,190395,190456,190521,190914,191720,192355,194252,194572,194785,196081,196227,196996,198004,198271,198652,199079,199758,199948,200143,200215,200217,200437,202122,202763,202837,204210,204212,205245,205477,205861,205863,205864,206597,206602,206603,206604,206633,206844,207625,208175,208272,210392,210632,210655,210657,210995,211018,211770,211870,212439,212792,213026,213283,215144,215147,215256,215902,216612,217214,217215,217607,217807,217855,219016,219072,219212,219272,219888,219915,219916,220234,220369,220521,220690,220786,221478,221481,221485,221910,221998,222315,222398,224001,224519,224667,226057,227311,228377,228378,228941,230926,230958,231083,231138,231170,231339,232164,232249,232251,232277,233661,233693,233694,233788,233862,235173,235250,235496,236265,236277,236381,237028,237054,237171,237320,237704,238590,239489,239627,240230,240703,240794,241417,241589,242461,242492,242576,242780,242989,243194,243196,244454,244458,244462,244465,244723,244846,244859,245117,245477,245703,245729,245735,246409,246569,247119,247284,247699,247938,247999,248277,248619,248854,248866,249421,249938,249982,250023,250310,250500,251326,251729,251803,251804,251805,252767,252770,252774,253819,253827,254038,254265,254321,254838,255878,255953,256421,257140,257999,258005,258272,258763,258984,259421,259422,259423,259425,259653,260488,260862,261104,261766,261906,262006,262425,263904,264688,265275,265291,265556,265958,266008,266324,266706,267975,268038,268963,268966,268968,270929,271710,271864,272080,272309,273737,273790,275320,275331,275886,276027,276557,277035,277123,277508,277536,277551,277588,277589,278523,278524,278549,280498,280499,281368,281950,282632,283324,283594,283597,284108,284279,285163,285231,285362,285521,285835,285838,286701,286702,287276,287851,287991,288376,289673,289780,291645,291981,291983,292492,292494,292496,292501,292511,292515,292644,293298,294287,294910,294914,295202,295581,298553,298557,298844,500461,500478,501449,502195,502539,503244,505989,505991,506179,506619,506625,506626,506631,506856,506906,506996,507533,508293,509471,509553,510238,510243,510693,511040,511834,512289,512569,513571,513697,514271,514631,515352,515385,515536,515538,515750,516873,516912,517876,519204,519204,519486,519958,520009,521207,521812,521989,521990,521991,522474,523726,523765,523924,525594,525666,526047,526207,526230,526285,526295,526974,529210,529519,529791,529809,529866,530283,531817,531819,531844,531869,532317,533462,533949,534469,535242,535446,535454,535455,535456,535730,538134,538154,539527,539529,540489,540602,540877,541321,542630,542699,542784,542864,543061,543887,545436,546094,546182,548260,549525,551077,551152,551190,552542,553676,554592,554650,554651,554886,554890,555688,557161,557189,558457,558719,559713,559716,559718,560228,560944,178439,549826,518460) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"