string(5350) "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 = 13685 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (124637,125351,126551,127624,128067,128549,129151,129152,130346,133385,133386,134538,136952,138012,138042,139070,139189,139342,139920,140228,141166,141469,141617,141636,144358,144590,144791,145117,146762,147862,147864,148197,150069,150070,150071,150184,150472,151016,151345,151534,151803,153079,154330,154365,155998,156372,156792,157019,157146,157520,157767,157926,162157,162482,163346,163497,164547,165771,166377,166824,166884,166942,167423,167427,168043,168918,169555,172299,172977,173068,173328,173329,173799,174883,175506,175718,177646,177777,177778,179482,181884,184841,185043,185322,186480,186873,188250,188255,189815,190551,190571,191092,193208,193748,194392,194409,196008,197488,198070,198098,198659,198696,199224,199361,200757,202377,202550,203025,203695,204334,204564,204771,205815,205816,207562,208705,209454,210068,210432,211379,211689,212124,213375,213656,213662,214743,214821,215104,215234,216004,216444,217648,217748,218466,219336,220780,220941,221024,221865,222757,223502,224052,225855,225856,226450,228505,230912,231442,231881,231909,233585,234182,234441,234510,234688,234889,234891,234892,235464,235466,235502,235537,236389,236590,236633,236634,236919,238201,238250,238362,239003,239245,239786,239843,240074,241363,241380,241428,242429,242527,242825,243075,243076,243739,245099,245566,245568,245607,245898,246083,246277,246367,247037,247094,247397,247450,247458,247619,247817,248074,248152,248179,248193,248207,248268,248295,249434,249782,250478,250505,250584,250586,250589,250793,250874,250927,251265,251293,252630,252879,252998,253259,254406,255857,256217,256564,257327,258312,258936,259546,259563,260111,260976,260991,261113,261279,261280,261348,261923,262235,262535,262643,263192,263399,263430,263590,263747,265024,265323,266664,266708,268220,268247,268248,268515,268624,268631,268634,269227,269730,269889,270090,270206,270272,270288,270874,271325,271530,272581,274275,274411,274553,274809,276014,276059,276368,277224,278824,279211,280792,280926,281502,281649,281815,282457,282540,282631,282990,283066,283171,284421,284590,284868,285244,287497,288088,288871,290062,290827,290869,291460,291586,295586,296834,297122,297254,297306,297330,297393,297394,297658,297738,297915,298337,298532,299017,500869,500872,501744,501871,502066,503241,504411,505924,506055,506200,506235,507632,508931,510309,511882,512323,512553,512557,514011,514347,515198,515520,515979,517233,517521,518399,518864,519005,519066,519519,520452,520696,521213,521231,521688,521692,521770,523256,523577,524212,524521,524537,524787,524870,525001,525722,525858,526518,526638,527593,528592,528910,528998,529239,529919,531116,531720,531762,532311,532368,532443,532687,532688,532994,533109,533463,533496,534195,535784,535791,536903,537712,537713,537775,537889,538200,538202,538854,539532,539836,541251,541521,541839,542008,542601,543587,543618,543916,544343,545333,546366,546397,546472,546773,547354,547386,548348,549708,550516,550807,550873,551540,551753,551857,551861,552250,552505,552638,553393,553396,553463,554786,554824,555486,555550,555636,555928,555989,556190,556551,557990,558502,559444,560385,560636,560979,561061,561065,562848) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"