string(8220) "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 = 80106 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (145995,153514,184328,196264,225289,249542,260254,275285,275286,286590,289771,290557,290570,290573,293440,293898,294046,295075,295249,295284,295306,295307,295309,295318,295319,295450,295499,295751,295783,295868,296056,296059,296223,296259,296284,296324,296466,296488,296534,296537,296538,296579,296591,296619,296623,296626,296627,296631,296702,296726,296738,296809,296823,296868,296872,296925,296960,296964,296977,297020,297020,297088,297093,297142,297321,297664,297758,297778,297794,297796,297879,297918,297968,297997,298025,298026,298050,298182,298209,298287,298408,298497,298504,298623,298721,298811,298814,298956,299091,500097,500102,500360,500467,500531,500539,500672,500807,500846,500862,500958,501308,501323,501400,501517,501642,501643,501886,501890,502101,502263,502593,502599,502661,502730,502857,502887,502903,502923,502926,502989,503020,503030,503171,503174,503229,503268,503269,503400,503504,503517,503572,503575,503584,503674,503922,503995,504008,504036,504043,504127,504193,504203,504204,504272,504563,504637,504883,504901,504980,504981,504982,504983,504984,504985,504991,505037,505039,505056,505184,505185,505186,505187,505188,505190,505199,505796,505832,505983,506161,506249,506267,506301,506588,506755,507102,507197,507237,507267,507553,507738,507784,507837,507840,508047,508146,508458,508557,508559,508559,508560,508560,508561,508570,508572,508572,508668,508736,508737,508762,509014,509018,509058,509579,510343,510344,510543,510559,510663,510708,510786,510787,510880,510929,510938,511057,511167,511168,511184,511187,511217,511307,511364,511458,511460,511550,511631,511666,511864,512110,512391,512420,512439,512452,512527,512769,512828,512831,513066,513069,513091,513408,513409,513461,513797,513953,513959,514024,514099,514372,514444,514535,514733,514811,514922,515040,515119,515130,515397,515455,515500,515625,515693,515710,515714,515872,516062,516109,516148,516379,516379,516409,516424,516685,516864,516928,516964,517203,517477,517490,517580,517582,517582,517593,517803,517942,518061,518120,518332,518420,518462,518463,518464,518472,518511,518557,518559,518597,518692,518786,519170,519200,519349,519501,519513,519569,519581,519594,519636,519656,519763,520101,520131,520285,520362,520363,520525,520541,520648,520682,520905,520998,521050,521076,521089,521177,521177,521256,521296,521314,521480,521531,521606,521650,521765,521766,521940,521941,522435,522453,522751,522769,522867,522928,522929,523255,523426,523858,524257,524511,524580,524627,524638,524647,524797,524827,524867,524925,524929,524930,524954,525113,525223,525322,525400,525513,525518,525520,525521,525523,525649,525652,525793,525831,526022,526024,526070,526440,526451,526595,526767,526987,527444,527476,527477,527602,527602,527609,527700,527802,527803,527808,527880,527884,528503,528558,528587,528598,528662,528896,529022,529052,529077,529127,529170,529176,529563,529637,529754,529755,529756,529757,529881,530006,530190,530311,530386,530591,530699,530762,530899,531130,531218,531286,531320,531518,531572,531895,532071,532073,532275,532280,532410,532418,532564,532617,532818,532842,532898,532944,533107,533294,533404,533486,534081,534091,534313,534361,534473,534653,534712,534774,534971,535135,535137,535322,535524,535830,535855,536254,536287,536367,536440,536734,536959,537344,537351,537530,537724,537788,537830,537863,537944,538037,538132,538251,538367,538492,538500,538520,538557,539056,539065,539163,539357,539566,539887,539893,539899,539944,540020,540053,540165,540786,540809,540913,541381,541517,541734,541828,541829,541884,542530,542565,542653,542672,542885,542902,542962,542999,543087,543094,543274,543377,543379,543380,543425,543669,543673,543689,543702,543888,543934,544074,544077,544170,544347,544489,544548,544549,544590,544593,544691,544826,544930,544979,545062,545084,545143,545155,545344,545368,545368,545373,545373,545457,545679,545685,545686,545712,545899,545899,545937,546088,546125,546289,546404,546421,546421,546591,546591,546669,546669,546810,546874,547152,547168,547184,547247,547560,547587,547757,547828,547869,547931,547942,548072,548091,548330,548332,548385,548401,548414,548507,548546,548561,548562,548647,548651,548696,548704,548809,548809,548817,548993,549130,549130,549134,549420,549442,549459,549464,549903,549961,550146,550190,550210,550510,550737,550738,550964,551059,551207,551208,551214,551239,551287,551538,552079,552298,552421,552597,552666,552768,552930,552934,552940,552941,552946,552950,552961,553152,553261,553402,553602,553683,553689,553850,553963,554073,554079,554083,554091,554095,554097,554098,554136,554146,554187,554191,554192,554195,554196,554197,554199,554485,554491,554538,554543,554621,554778,554804,554815,554934,554937,554972,554977,555048,555052,555177,555202,555317,555320,555321,555323,555331,555344,555363,555397,555422,555463,555514,555519,555557,555558,555559,555564,555571,555588,555589,555643,555711,555716,555729,555730,555735,555738,555741,555744,555746,555949,555968,555970,555982,555985,555992,555994,555996,556001,556004,556005,556086,556176,556213,556234,556244,556253,556253,556256,556297,556345,556376,556379,556388,556409,556424,556576,556577,556579,556592,556972,556982,556984,557004,557039,557086,557249,557253,557254,557255,557287,557321,557355,557385,557445,557449,557450,557599,557609,557707,557829,557843,557844,557846,557858,557859,557860,557868,557902,557975,558039,558042,558059,558066,558071,558100,558129,558141,558194,558213,558214,558217,558219,558220,558222,558310,558314,558334,558336,558364,558385,558388,558417,558427,558468,558468,558552,558561,558579,558579,558595,558620,558654,558664,558678,558691,558709,558717,558831,558834,558881,558902,558933,558982,559008,559010,559032,559035,559037,559054,559063,559254,559269,559476,559478,559550,559554,559589,559599,559712,559714,559721,559723,559786,559787,559789,559801,559803,559832,559835,559841,559846,559847,560042,560067,560088,560100,560108,560138,560172,560575,560682,560805,560891,560902,560965,561003,273341,503880,517248,532568,544481,545678,529150,503756,513308) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"