string(4424) "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 = 2697 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (61529,100689,101952,102874,102875,104710,105341,105869,106404,106971,118255,120771,121597,121598,122227,124170,124312,124807,126220,127242,127982,128962,129008,129009,129019,129112,129113,129347,131404,131747,132910,132968,133384,133387,133388,133761,133762,134238,135474,135590,136193,136433,136572,138764,141212,141265,142488,145320,147208,148181,150985,151830,152795,156509,157029,157383,158374,160537,161838,162083,162271,162285,163407,163515,165561,167153,167439,170203,170413,172184,173673,175320,177627,183269,186265,186612,187311,188771,191246,192268,192660,194572,195513,196005,196563,200614,201252,201456,201947,202368,202459,202952,203976,204568,204569,204724,204742,204754,204770,208842,208906,209541,210632,210694,210771,211113,212176,212336,213283,214764,215090,215145,215481,215715,217265,218675,219212,219233,219796,219809,220781,221020,221479,222434,224540,224553,225381,225860,226105,226113,226627,226630,228484,231280,231643,231903,232175,232762,233281,233463,233941,234073,234113,234197,234287,234349,234738,236679,237059,237115,238606,239116,239379,239442,239590,240751,240755,240868,241251,241404,241566,241710,244345,244346,244787,244860,248665,249164,249423,249929,249981,250171,250398,250491,251178,254078,254539,255132,255159,255268,255300,259359,259496,260449,260925,261068,261979,262617,262636,262646,263508,264555,265260,266305,266937,267626,268188,268246,269359,269754,269756,269803,269943,270485,271367,271456,271820,272152,273064,273067,273147,273721,273922,273952,275013,275500,276340,278107,279278,280182,280462,281343,281556,282240,282241,282287,282874,283850,283971,284092,284209,285218,285492,285539,285612,287644,289622,289624,291252,291667,292497,295068,295448,295790,296261,297022,298986,500323,501188,502584,502683,502780,503213,503906,505529,505622,506522,507146,507332,507717,509504,510482,511336,511487,513399,513714,514417,514633,514709,516912,518460,518698,520074,523197,525827,525863,526181,526677,527787,532208,532209,532411,533193,533834,534076,534598,534614,535445,536762,538936,539839,539840,541815,542855,544354,545379,545748,546388,546841,547733,548723,549293,549617,549629,551705,552522,552576,552877,554592,554820,555007,559481,560675) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"