string(19021) "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 = 436
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (1024,2339,2349,4421,5538,5989,5990,6102,6154,6155,60471,60483,60515,60625,60653,60924,60928,60959,60967,61049,61091,61229,61231,61238,61393,61479,61486,61487,61520,61564,61572,61684,61686,61708,61724,61882,61958,61959,61996,62006,62102,62142,62169,62183,62446,62546,62631,62653,62729,62730,62772,62773,62864,62869,62921,63072,63250,63252,100115,100158,100236,100249,100268,100358,100359,100360,100478,100488,100525,100537,100567,100592,100594,100746,100800,100813,100826,100827,100828,100833,101055,101144,101158,101179,101180,101287,101288,101607,101703,101754,101771,101771,101824,101832,101834,101851,101873,101879,101885,101886,102013,102133,102134,102136,102138,102143,102253,102486,102623,102639,102640,102654,102688,102710,102764,102765,102794,102795,102797,102809,102810,102815,102817,102819,102923,103016,103016,103029,103035,103056,103057,103065,103068,103127,103128,103233,103242,103260,103298,103368,103372,103373,103405,103406,103407,103416,103416,103434,103526,103539,103545,103546,103548,103549,103596,103658,103849,103861,104163,104183,104247,104262,104316,104468,104473,104562,104574,104583,104650,104698,104881,105069,105464,105484,105503,105506,105508,105519,105530,105551,105582,105615,105620,105667,105728,105747,105750,105759,106064,106088,106151,106208,106234,106285,106318,106322,106339,106383,106395,106444,106454,106555,106569,106588,106755,106757,106806,106940,106951,106955,106966,107006,107134,107168,107296,107493,107542,107757,107767,107932,107934,107935,107940,107941,107951,107965,108020,108126,108167,108168,108302,108411,108626,108627,109274,109402,111378,111518,111605,116055,116551,116565,116678,116703,116811,116831,116894,116984,117123,117128,118359,118370,120157,120558,120596,120757,120836,120838,121108,121234,121243,121391,121537,121593,121631,121697,121701,121744,121750,121754,121883,122016,122052,122068,122094,122134,122194,122305,122363,122371,122450,122464,122549,122600,122683,122858,122861,122863,122865,122895,122898,123014,123015,123035,123162,123216,123359,123414,123697,123777,123841,124045,124092,124141,124205,124217,124274,124351,124354,124425,124482,124571,124675,124797,124975,125120,125171,125627,125647,125649,125655,125754,125754,125803,125909,125924,125952,125965,126023,126034,126097,126239,126299,126300,126460,126470,126480,126607,126692,126717,126880,126885,126917,126933,126934,126953,127267,127310,127403,127410,127618,127647,127660,127790,127852,127904,127943,127960,128174,128260,128291,128407,128421,128445,128469,128587,128630,128679,128690,128770,128773,128818,128836,128842,128870,128924,128932,128945,129024,129080,129120,129166,129169,129315,129340,129376,129388,129390,129569,129684,129708,129724,129738,129854,129886,130028,130029,130253,130450,130456,130460,130477,130648,130670,130700,130708,130835,130977,130991,130996,131020,131212,131249,131250,131251,131263,131271,131272,131273,131288,131407,131441,131604,131627,131705,131849,131868,131869,131981,131986,132186,132354,132403,132404,132420,132464,132655,132872,132905,132972,132995,133120,133546,133547,133772,133971,134007,134201,134205,134888,135473,136115,137126,137181,137905,138184,138383,138481,138492,138571,138578,138659,138671,138674,138761,138786,138902,138954,138955,138960,138971,138980,139029,139255,139548,140140,140445,140461,141438,141451,141512,141857,141861,141988,142092,142117,142154,142550,142553,142601,143028,143084,143387,143468,143565,143657,143919,144457,144631,144741,144948,145502,146080,151361,152719,152720,159646,162938,167594,167707,167856,168382,168675,168677,168681,168682,168683,168684,168686,169169,169557,169680,169681,169684,169686,169972,170701,171962,172020,172058,172399,173233,173339,173343,174605,175157,176007,176015,176016,183621,184422,184528,184864,186068,186132,186803,188894,191261,191908,192100,193353,194488,199322,201461,201970,202001,203286,203748,205241,207864,208089,208098,208386,209405,209949,210065,210258,210576,211007,211862,212489,213653,214511,214512,215655,215831,216168,216255,217070,217762,218333,218338,219243,220188,220727,221473,222584,224869,226130,228539,228555,228559,228560,228569,228579,228588,228590,228591,228592,228597,228598,228606,228607,228616,228641,228644,228655,228886,229577,229578,229588,230074,230076,230077,230078,230079,230080,230082,230084,230086,230087,230088,230091,230092,230093,230095,230096,230099,230100,230102,230103,230105,230106,230108,230109,230112,230113,230114,230115,230119,230121,230122,230123,230124,230128,230132,230145,230146,230147,230148,230149,230150,230151,230152,230153,230155,230156,230158,230161,230162,230163,230166,230169,230171,230172,230174,230176,230177,230178,230179,230180,230183,230184,230185,230187,230190,230191,230194,230195,230197,230198,230199,230200,230202,230203,230204,230205,230206,230208,230209,230210,230212,230213,230216,230218,230219,230220,230222,230223,230225,230226,230228,230229,230230,230231,230232,230235,230237,230239,230243,230245,230246,230247,230248,230249,230250,230251,230252,230256,230262,230693,231180,231391,231507,231521,231792,231977,232184,232806,232936,233126,233177,233326,233332,233333,233595,233597,233598,233599,233600,233601,233603,233604,233605,233606,233618,233718,233726,233742,233755,233760,233764,233767,233782,233783,233789,233794,233816,233823,233835,233837,233838,233840,233841,233842,233844,233847,233851,233853,233857,233859,233860,233864,233866,234234,234241,234378,234496,234513,234515,234518,234521,234556,234561,234587,234756,234983,234985,235007,235008,235009,235023,235035,235036,235037,235110,235169,235176,235177,235456,235590,235640,235658,235706,235883,235967,235969,236000,236005,236017,236294,236301,236314,236320,236683,236691,236769,236786,236796,236797,236810,236845,236846,236848,236850,236851,236853,236854,236975,236980,236983,237033,237063,237069,237075,237084,237091,237172,237181,237355,237356,237477,237647,237659,237862,238756,238822,239021,239106,239146,239568,239570,239571,239572,239593,239596,239597,239598,239601,239615,239697,239720,239724,239747,239748,239751,239752,239758,239769,239774,239790,239797,240695,240945,240972,240973,240986,240999,241012,241027,241028,241032,241058,241090,242331,242396,242402,242404,242424,242425,242427,242431,242450,242451,242457,242459,242460,243599,243602,243609,243622,243628,243636,243637,243700,243701,243702,244701,244707,244715,244863,246050,246053,246101,246103,246105,246106,246108,246132,246138,246344,247728,248481,248482,248483,248484,248495,248508,248541,248551,248961,248966,248967,248970,249190,249206,249214,249320,249374,249375,249385,249645,249657,249660,249663,249664,250370,250391,250393,250421,250623,250628,250638,250640,250645,250999,251002,251005,251006,251008,251313,251401,251407,251412,251675,251676,251678,251679,251680,251723,251725,251726,251738,251745,252112,252148,252172,252178,252179,252181,252205,252207,252209,252223,252232,252424,252428,252437,252475,252563,252791,252826,252844,253563,253571,253575,254009,254273,254653,254686,254687,254688,254765,254828,254834,254840,255469,255750,255767,255769,255771,255772,255775,255776,255778,255780,255783,255784,255791,255792,255803,255806,255807,255808,255809,255810,256174,256701,256704,256874,256881,256906,256913,256918,256930,256949,256954,256967,256971,256972,257044,257047,257907,258068,258155,258160,258161,258162,258163,258164,258165,258166,258167,258168,258169,258170,258226,258228,258229,258234,258235,258236,258237,258241,258242,258243,259046,259050,259139,259196,259217,259221,259241,259242,259243,259246,259247,259249,259269,259272,259277,259280,259282,260166,260169,260172,260175,260179,260181,260183,260453,260619,260721,260902,261011,261240,261244,261245,261246,261248,261252,261253,261255,261256,261257,261915,262315,262373,263388,263564,263607,263673,263679,263682,263695,263702,263706,263709,263714,263750,263751,263752,263754,263755,263756,263761,263762,263764,263855,263949,264048,264078,264117,264297,264518,264519,264523,264524,264537,264671,264857,264858,264861,264885,264888,264905,264919,264945,264959,264960,264962,264963,265679,265779,265780,265781,265792,266111,266322,266326,266340,266346,266351,266385,266396,266397,266403,266533,266720,266721,266741,266744,266745,266771,266772,267094,267223,267245,267262,267268,267282,267284,267285,267286,267287,267288,267289,267290,267291,267413,267520,267679,267759,268099,268111,268113,268114,268118,268119,268120,268121,268130,268132,268133,268157,268158,268159,268160,268161,268163,268325,268533,268727,268868,268933,269484,269507,269691,269693,269778,269859,270192,270587,270593,270639,270666,270671,270680,270682,270683,270684,270686,270687,270692,270745,271256,271383,271598,271599,271622,271623,271624,271805,271810,271850,271855,271860,271862,271880,272008,272010,272165,272185,272647,272800,273433,273434,273485,273657,273688,273691,273898,273910,273946,274026,274027,274028,274049,274064,274461,274637,274653,274842,274843,274854,274878,274880,274894,274920,274924,274927,274928,274930,274947,274950,274987,274991,274998,275043,275049,275071,275079,275095,275109,275114,275119,275120,275121,275122,275291,275399,275452,275464,275467,275512,275514,275529,275540,275743,275745,275746,275785,275839,276459,276516,276594,276704,276953,277177,277183,277783,278522,278525,278526,278527,279107,280450,280486,280488,280489,280490,280739,280840,280861,280888,281026,281035,281094,281104,281558,281646,281647,281682,281683,281692,281709,281725,282090,282091,282092,282100,282165,282346,282470,282484,282554,282556,282601,282603,282611,282640,282679,282680,283394,283607,284110,284111,284112,284133,284329,284408,284532,284790,284879,285011,285012,285047,285111,285179,285246,285247,285249,285877,286013,286024,286027,286028,286043,286059,286068,286289,286339,286659,286912,287282,287307,287341,287351,287404,287424,287730,287743,287823,287837,287841,287889,287954,288112,288569,288831,289073,289081,289157,289158,289296,289303,289313,289314,289419,289636,289789,289790,289796,289827,290277,290278,290298,290485,290487,290545,290675,290740,290838,290844,291389,291391,291455,291780,291785,291801,292630,292775,292826,292981,293156,293612,294049,294059,294064,294077,294078,294082,294085,294086,294098,294099,294160,294198,294259,294280,294281,294850,294868,295204,295479,295592,295629,295740,296041,296314,296316,296323,296475,296535,296610,296627,296717,296721,296798,296810,296813,296850,296864,296866,296925,296996,297002,297089,297161,297162,297165,297167,297263,297807,297810,297813,297821,297828,297969,298238,298462,298463,298479,298521,298523,298524,298539,298540,298608,298628,298629,298714,298941,500067,500108,500192,500195,500488,500526,500555,500591,500622,500736,500827,501016,501320,501361,501383,501519,501520,501536,501590,501591,501592,501614,501719,501722,501727,501860,501967,501968,502176,502623,502654,502655,502657,502658,502727,502794,503084,503216,503251,503253,503286,503306,503313,503315,503467,503469,503489,503492,503493,503495,503521,503522,503598,503647,503670,503830,503921,504179,504180,504191,504192,504286,504307,504479,504485,504486,504581,504835,505011,505126,505197,505201,505223,505240,505253,505423,505432,505463,505465,505474,505639,505756,505808,505926,505946,506071,506133,506134,506136,506146,506149,506175,506547,506549,506771,506868,506877,506905,507091,507096,507106,507111,507125,507142,507154,507174,507176,507228,507229,507230,507249,507404,507414,507566,507567,507618,507760,507841,507842,507853,507857,507957,508089,508111,508368,508405,508410,508999,509142,509407,509576,509634,509644,510061,510071,510346,510494,510546,510553,510564,510617,510715,511028,511029,511036,511037,511039,511053,511188,511544,511672,511683,511778,511827,511962,511963,511995,512001,512260,512424,512713,512960,513077,513146,513167,513181,513198,513203,513209,513217,513478,513879,513894,514040,514044,514045,514111,514138,514144,514227,514228,514230,514244,514245,514246,514247,514279,514280,514339,514340,514342,514729,514737,514786,515035,515041,515233,515256,515704,516410,516426,516427,516441,516450,516451,516453,516457,516491,516492,516996,517035,517039,517077,517135,517371,517437,517678,517704,517712,517793,517794,517972,518046,518078,518079,518178,518179,518240,518243,518370,518383,518384,518386,518619,518644,518664,518671,519627,519659,519689,519760,519801,520108,520115,520136,520164,520174,520331,520332,520398,520675,520743,520916,521116,521300,521306,521307,521308,521327,521345,521353,521358,521371,521389,521390,521391,521738,521874,521886,521890,521891,521940,521941,522033,522108,522221,522269,522278,522341,522427,522454,522498,522535,522557,522583,522585,522586,522664,522671,522684,522685,522686,522693,522694,522739,522762,522818,522911,523298,523477,523510,523513,523528,523534,523535,523613,523653,523830,523987,523988,524373,524490,524732,524733,524762,525169,525171,525179,525435,525444,525574,525843,525923,525968,526017,526018,526329,526461,526486,526487,526489,526490,526491,526512,527551,527558,527569,527839,527840,527903,527977,528736,528737,528769,528784,529310,529349,529350,529383,529526,530013,530014,530037,530072,530082,530093,530100,530101,530107,530118,530446,530456,530949,530979,530981,531105,531348,531798,532084,532085,532088,532102,532125,532176,532206,532220,532229,532320,532414,532415,532417,532422,532427,532433,532434,532546,532556,532560,532677,532759,532894,533118,533121,533143,533241,533369,533383,533475,533674,533686,533732,533833,534036,534062,534063,534066,534155,534181,534281,534514,534529,534646,534729,534833,534835,534966,534996,535124,535203,535215,535348,535353,535400,535405,535532,535537,535590,535617,535690,535958,536004,536019,536021,536029,536059,536063,536156,536217,536298,536361,536452,536723,536779,536820,536886,536918,537014,537017,537018,537135,537177,537433,537435,537436,537438,537454,537488,537495,537601,537850,538194,538314,538394,538578,538697,538846,538947,538948,539025,539291,539841,540028,540031,540032,540141,540170,540178,540203,540253,540254,540255,540256,540263,540297,540298,540299,540321,540328,540372,540488,540495,540514,540529,540686,540899,541249,541254,541277,541587,541832,542022,542055,542815,542816,542826,542827,542828,542829,542906,543007,543008,543009,543012,543427,543534,543647,543653,543654,543701,543801,544016,544083,544085,544107,544108,544109,544110,544111,544114,544361,544442,544657,544661,544709,544743,544787,544788,544790,544792,544827,544843,544844,544846,544847,544848,544849,544850,544876,544877,544878,544911,544920,544927,544952,544953,544954,545012,545013,545019,545037,545061,545080,545086,545098,545244,545297,545299,545300,545307,545308,545310,545311,545349,545491,545692,545694,545696,545784,545840,545877,545920,545921,545926,545927,546114,546144,546173,546174,546175,546183,546218,546221,546222,546258,546259,546264,546363,546365,546467,546568,546592,546786,546788,546825,546967,546968,546993,547065,547284,547301,547303,547306,547647,547713,547813,547814,547816,547832,547833,547846,548119,548446,548475,548504,548548,548555,548558,548584,548601,548602,548637,548717,548830,548831,549026,549212,549416,549418,549419,549456,549457,549460,549461,549528,549577,549642,549644,549679,549686,549690,549691,549695,549764,549773,549774,549785,550036,550077,550094,550098,550101,550120,550173,550174,550392,550431,550639,550646,550656,550686,550728,550729,550730,550896,550898,550938,550953,550974,550996,551046,551047,551048,551069,551071,551072,551075,551082,551125,551126,551129,551131,551133,551135,551137,551138,551139,551140,551146,551148,551158,551159,551166,551169,551454,551471,551596,551650,551737,551741,551749,551754,551755,551761,551782,551814,551930,552003,552188,552201,552212,552230,552231,552240,552246,552248,552250,552322,552382,552384,552385,552386,552400,552461,552534,552550,552679,552680,552796,552812,552819,553299,553336,553474,553479,553973,554033,554078,554080,554086,554092,554093,554140,554141,554149,554159,554169,554170,554171,554184,554286,554290,554325,554344,554348,554351,554352,554355,554358,554363,554567,554570,554573,554605,554629,554670,554671,554672,554684,554837,554881,555814,556203,557772,557773,557775,557832,557833,558104,558526,558535,558541,558542,558543,558544,558752,558873,558874,558992,559017,559142,559161,559189,559194,559202,559224,559225,559238,559250,559264,559284,559442,559503,559609,559695,559784,559785,559796,559861,559866,559911,559941,559972,560007,560055,560076,560083,560091,560095,560126,560177,560188,560199,560638,560920,560924,560925,560926,560943,560948,101756,168614,169083,169084,172388,189843,209661,216027,216401,216755,217065,218660,219465,237331,238367,238687,241669,270690,281430,285774,286488,286562,503558,516837,540590,179999,180016,180071,182734,182742,182743,182748,182752,182768,182769,182794,182823,182824,182840,182861,182893,182920,234834,287383,509020,180026,215842,240718,242184,179998,182775,182825,182928,216415,513536,515444)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
