string(10824) "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 = 41430 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (150080,153248,156884,157030,157141,157188,158136,160097,160561,160673,166294,168700,172224,172225,182088,183064,183324,184871,186073,189247,189248,192113,192224,202952,204165,204429,204431,204740,205035,205043,205049,205050,205053,205070,205072,205562,205635,206543,206558,206920,207475,207766,208138,208145,208379,208392,208429,209596,209951,210578,210585,211667,213312,214064,214465,215044,215535,215577,215628,215762,216686,216804,216930,218071,218329,218397,218591,218900,219096,219120,219212,220323,220616,220736,221199,221282,224873,225156,225477,225478,225530,225639,225640,225641,225643,225644,225645,225775,226131,226132,226133,226135,226138,226140,226142,226492,226494,227506,227512,227646,227661,227727,229559,229565,229614,229617,229639,229646,229743,229888,230244,230476,231354,231397,231399,231420,231452,231462,231973,232004,232034,232038,232061,232074,232091,232411,232793,232870,233028,233030,233048,233050,233161,233176,233190,233198,233664,234207,234208,234376,234451,234624,234819,234820,234929,235188,235388,235617,235659,235912,236180,236427,236917,236939,237147,237672,237674,237675,237879,238907,239187,239436,239979,240129,240130,240193,240490,240779,240787,240788,240789,241152,241207,241238,241331,241605,241651,242009,242010,242011,242012,242013,242014,242786,244336,244412,244690,244881,246054,246092,246093,246095,247561,247562,247563,247565,247650,247699,248834,248888,249168,249176,249232,249285,249899,250277,250281,250298,250299,250300,250303,250304,250309,250313,250727,250733,250735,250740,250791,250979,250982,250983,250984,250985,250986,250987,250988,250989,250990,251219,251253,251336,251367,251384,251499,251500,251504,251659,251727,251728,251863,252754,252769,252773,252844,252860,252861,253296,253824,253884,254042,254099,254684,255281,255284,255286,255297,255407,255408,255410,255412,255741,255952,256089,256158,256391,256921,256923,257099,257416,257570,257800,257801,257892,257947,258498,258499,258500,258501,258762,258836,258839,258842,258845,259370,259389,259450,259754,259793,260065,260359,260363,260379,260380,260383,260385,260386,260394,260538,260541,260544,260548,260549,260551,260935,260948,260950,260986,261372,261376,261378,261380,261382,261422,261423,261425,261426,261763,261922,261963,262267,262585,262586,262902,263048,263460,263498,263509,263531,263678,263854,263884,263893,263902,263904,263904,263941,263942,263943,264083,264177,264283,264329,264463,264881,264892,264909,265019,265196,265307,265397,265555,265556,265607,265611,265652,265768,266243,266294,266579,266629,266638,266998,267180,267183,267259,267348,267359,267387,267400,267483,267497,267539,267541,267676,267677,267702,267792,267808,267809,267810,267811,267835,268127,268128,268148,268353,268378,268394,268620,268782,268840,268900,268900,268959,268962,268972,268973,268991,269001,269002,269009,269010,269011,269012,269019,269141,269301,269428,269429,269519,269941,270357,270358,270359,270360,270364,270365,270366,270367,270368,270699,270821,270946,270952,270976,270982,271172,271296,271330,271355,271532,271817,272173,272451,272544,272545,272546,272548,272563,272568,272570,272571,272626,272689,272970,272972,272974,272975,273262,273366,273441,273792,273956,274209,274326,275034,275269,275272,275273,275274,275275,275276,275277,275536,275537,275576,275625,275651,275652,275654,275694,275730,275935,275936,276114,276692,276779,277173,277174,277206,277533,277559,277584,277620,277662,277664,277665,277672,278595,278596,278598,278599,278659,278836,278935,279014,279111,279112,279137,279145,279209,279244,279253,279460,279462,279584,279611,279612,279613,279614,279615,280181,280233,280236,280260,280261,280478,280747,280822,281304,281307,281364,281384,281504,281538,281859,281906,282490,282709,282843,282853,283113,283189,283444,283531,283563,283658,283659,283671,283873,284035,284036,284144,284232,284283,284409,284412,284415,284568,284583,284685,284732,285040,285058,285059,285060,285064,285075,285076,285077,285078,285084,285085,285086,285087,285088,285089,285103,285158,285401,285446,285447,285929,286164,286166,286171,286244,286246,286285,286319,286679,286745,286749,286751,286820,286854,286856,286857,286860,286903,287243,287380,287741,287779,287981,288236,288241,288389,288677,288866,289534,289551,289552,289553,289971,290033,290065,290121,290333,290440,290441,291273,291317,291902,292052,292498,292641,292807,292871,294866,294867,294918,295027,295031,295051,295052,295053,295054,295269,295425,295510,295594,295596,295597,295605,296065,296432,296485,297115,297401,297440,297442,297445,297800,298091,298144,298246,298425,298550,298554,299029,299075,500066,500084,500566,500833,501160,501162,502358,502813,503278,503917,504168,504345,504375,504949,505013,505026,505029,505038,505128,506014,506357,506635,506900,507107,507205,507225,507524,507543,507995,507997,508350,508667,508669,508670,508672,508673,508674,508689,508696,508697,508699,508732,508794,509079,509081,509094,509098,509099,509101,509131,509135,509178,509181,509545,509590,509631,509636,509637,510225,511022,511033,511034,511056,511074,511078,511108,511110,511114,511115,511116,511146,511211,511642,512041,512043,512044,512225,512233,512481,512625,512627,512756,513043,513044,513157,513204,513212,513213,513348,513350,513352,513487,513488,513539,514082,514413,514523,514656,514977,515085,515274,515451,515491,515493,515840,515906,516108,516459,516768,516803,517238,517249,517293,517708,518105,518148,518207,518683,518776,518780,519676,519962,519964,520082,520083,520207,520290,520355,520358,520922,521164,521430,521787,521799,522016,522024,522025,522029,522231,522242,522325,522351,522385,522466,522511,522514,522577,522579,522615,522760,523501,523538,523583,523625,523626,523751,523919,523923,524482,524483,524708,524840,524843,524845,524994,524995,524996,525083,525143,525144,525145,525146,525147,525148,525149,525150,525598,525720,525792,526150,526569,526605,526693,526723,526860,527545,527547,527935,528124,528481,528841,528950,528951,528955,529086,529099,529635,529639,529730,529735,529818,529946,530131,530406,530769,531092,531155,531637,531842,531846,531878,531971,532906,533274,533341,533883,533884,533947,533954,533978,534178,534217,534420,534927,534928,534974,535121,535315,535384,535727,535758,535940,536173,536443,536599,536974,536975,536978,536980,536983,537022,537185,537194,537215,537242,537400,537565,537613,537671,537985,537992,538151,538407,538412,538469,538502,538685,538688,538689,538690,538699,539067,539308,539543,539554,539557,539579,539580,539581,539583,539584,539585,539745,540221,540223,540224,540226,540497,540595,541055,541057,541058,541065,541188,541196,541247,541329,541511,541672,542642,542655,542797,542798,542799,542800,542912,543018,543251,543362,543386,543483,543485,543486,543487,543705,543741,543746,543783,543789,544095,544173,544362,544363,544553,544560,544561,544587,544595,544612,544613,544614,544615,544616,544626,544627,544634,544637,544690,544725,544727,544730,544738,544754,544828,544925,544928,544993,545159,545161,545189,545218,545219,545220,545221,545239,545281,545282,545294,545337,545340,545341,545390,545437,545451,545499,545726,545727,545802,545817,545968,545977,546011,546063,546360,546370,546503,546618,546896,546898,546903,546972,547039,547109,547110,547111,547129,547134,547138,547441,547666,547907,547910,547912,547914,547916,547917,547919,547986,548267,548434,548472,548712,548862,549023,549382,549443,549446,549447,549449,549452,549504,549516,550394,550519,550720,551222,551587,551607,551707,551758,551759,551823,552502,552548,552689,552697,552770,552772,552779,552874,552901,552902,552903,552904,552905,552906,552907,552909,552911,552912,552913,552914,552915,552995,553279,553281,553282,553569,553586,553589,553681,553733,553734,553735,553916,554791,554792,554793,554794,554795,554796,554797,554798,554799,554857,554913,554940,555033,555035,555037,555038,555657,555658,555659,555660,555669,555676,555679,555906,556466,557033,557035,557038,557073,557135,557142,557446,557944,557945,558150,558152,558260,558353,558355,558537,558608,558612,558616,558959,558961,559321,559596,559604,559606,559988,559992,560178,560316,180675,215656,216539,218350,226276,227325,227933,236525,254479,256620,256736,257816,260949,261459,266660,267167,272632,275577,279800,280264,284270,291596,509198,515157,516384,533949,534017,534606,536985,539269,541771,544986,550371,556458,180922,215626,231013,234054,241126,241157,250373,254123,264795,264798,265347,265357,265578,266021,266835,271160,274341,276819,277378,277430,283678,287324,291105,291116,503221,516146,528876,535912,536183,547131,548466,553901,217510,217990,219548,219551,268061,501679,517000,522374,264582,291133) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"