string(5238) "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 = 32016 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (157263,157359,161742,164940,169809,170989,171580,172807,174888,176790,179025,183775,184200,185443,186696,186699,186891,188094,189890,191592,191632,193119,193674,195157,195433,198353,200037,201081,201591,202475,202478,204101,204227,204229,204230,206307,206897,206901,207702,207931,207937,207938,207941,207942,213120,213122,213610,213734,215355,216057,216096,216100,217162,217186,217843,217920,218953,218955,219744,220135,221089,221875,221901,221919,221921,225492,226052,228270,228290,228699,228948,231159,231176,232419,234036,234209,235534,235699,235701,236181,237315,237891,237892,237907,237922,238221,238495,238626,239440,239478,240133,240795,240843,240844,240887,241384,241554,241609,241864,242502,242779,242784,242817,243376,243377,244880,244900,244901,244905,245435,245585,246397,246451,247126,247438,247462,247690,248344,249169,249172,249174,249475,249595,251498,251503,252330,252361,252536,252765,252784,253830,254100,254101,254102,254167,254171,255907,256048,256187,256401,256407,256408,257341,257418,257860,258012,258019,258760,258767,258768,259758,259778,260623,260936,260946,261270,261765,261768,261770,263462,263896,263982,264425,264680,264682,265349,265708,265713,265928,266264,267489,267491,267499,267505,268051,268454,268559,268623,268961,268983,269111,269340,269637,269774,270735,271356,271827,271842,271848,272901,273161,273787,275567,276691,276784,276785,277120,277529,277538,277539,277541,277542,277544,277806,278932,279547,279918,279975,280470,282989,283002,283322,283532,284010,284060,284076,284146,284147,284281,284282,284284,285160,285161,285162,285996,286411,287197,287199,287209,288023,288244,288594,288718,288911,289018,289791,290698,291049,291167,291227,291642,291649,291905,292037,292483,292493,292645,293324,294288,294289,294291,294329,294899,295472,295565,295566,295573,296733,298819,298837,298839,298963,500459,500783,501165,501448,501703,503429,503629,503762,503763,504216,504921,506618,506627,506628,507000,507320,507354,507534,508381,508382,509036,509561,509627,511216,511233,511833,512168,512176,512178,512219,512230,512448,512474,513549,513651,514676,515489,516219,516447,516608,516610,516878,517179,517294,517763,518779,518781,518782,519346,520306,520308,520314,520903,520988,520999,521099,521224,522081,522472,523580,523587,523681,523712,523723,523801,523930,523933,525742,526286,526594,526663,526963,526979,527147,527425,528122,528467,528470,528471,528472,528473,529098,529395,529412,529609,530777,531784,531843,531856,533727,533733,533735,534865,535079,535678,535725,535729,536510,536512,536907,537186,537192,537245,538130,538181,538411,539225,539229,539848,540598,540599,540609,540817,540957,541084,542701,542863,543194,543207,543324,543737,543739,543749,543784,543785,545391,545434,545589,545661,546098,546628,547660,547661,547663,548220,548256,548257,548813,549374,549508,549510,549520,550717,551302,551614,551619,553431,553619,553660,553674,553884,554633,554653,554882,555907,556956,557144,557145,557146,557147,557152,557656,559079,560583,560591,560592,560670) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"