string(7512) "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 = 6095 AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad') AND books.binding <> '' AND book_id.meta_value IN (102916,103003,103347,106401,106649,106650,106686,107741,108058,108384,120670,121621,121703,122168,122264,123080,123084,123486,123811,124215,125522,126187,127446,127447,127622,127782,127786,128199,128200,128201,128372,128717,128908,129003,130549,130555,131146,131734,133392,133408,133501,133710,134445,134542,135193,136092,136235,136696,136784,136871,137113,139444,139652,140432,140534,141318,141761,142094,143105,143834,144447,145855,146922,147223,147878,149964,150290,150800,151613,152999,153554,153846,154992,155043,155553,156866,159928,160553,160707,161809,162158,162463,162847,163196,166620,167161,167388,169184,169801,169835,170035,170080,170664,170953,171473,172641,172684,173042,178462,178503,179597,179610,179612,179751,183379,183540,184326,184680,185175,185419,185420,186350,186552,186637,186844,187922,189227,189278,189495,189685,190368,190646,190732,191616,191701,191702,191846,192413,192797,193369,193693,193896,194144,194274,195109,196053,196266,196279,196295,196334,196623,196668,196721,197015,197368,197677,197724,198075,198096,198163,198470,198635,198741,199029,199186,199615,199735,200368,200405,200468,200737,200774,201365,201526,201903,201904,202370,202589,202608,202655,202926,202930,202955,203086,203098,203522,203523,203524,203525,203528,203537,204867,204888,205387,205510,205670,205795,205848,206282,206289,207444,207605,207728,208268,208521,208608,208760,208801,208804,208846,209852,210772,211136,211141,211181,211392,211680,211830,212103,212259,212583,213467,213856,213922,214093,214206,214209,214695,214829,215270,215540,215579,215891,216063,216431,216887,218090,218441,218458,218657,218977,219114,219239,219376,219415,219421,219559,219657,220013,221101,221159,221801,225995,226666,226822,227283,228264,228554,228645,228738,228885,230447,230675,230988,231185,231618,231693,231887,231906,232373,232399,232452,232726,233223,233308,234165,234169,234286,234326,234874,235123,235481,236106,236752,236839,238095,238229,238347,238387,238637,239312,239338,239340,239479,239532,240077,240376,240814,241369,241418,242848,243296,243712,243772,244630,245110,245166,245423,245711,245734,245971,245974,246423,247027,247084,247088,247196,247203,247426,247516,247861,248004,248033,248103,248200,248221,248224,248271,248669,249325,249439,249458,249601,249831,249930,250073,250107,250508,250547,250804,251379,251509,251832,251943,252188,252296,253006,253093,253165,253348,253591,253786,254379,254595,254660,254766,255068,255228,255363,255470,255928,257139,257408,258479,258955,258995,259021,259347,259348,259451,259515,260787,260819,260993,261015,261684,261685,261830,261973,262050,262346,263314,263511,263981,264153,264187,264418,264471,264701,265127,265143,265778,266250,266283,266473,266738,267368,267407,268045,268410,268411,268481,268866,269669,270217,270737,270814,270880,270894,271014,271282,271475,271554,271670,271830,271903,273202,273487,273719,274062,274076,275152,275318,275319,276058,276152,276175,276177,276483,276998,277061,277580,277727,278072,279043,279218,279241,279451,279630,279639,279921,280186,280503,280625,280886,280993,281870,282245,282646,282647,282648,282649,283545,284516,285221,285357,285454,285458,285476,285508,285845,285923,286069,287419,287758,287830,288090,288107,288345,288503,288504,288653,288980,289183,289217,289399,291078,291292,291760,293048,293249,293266,293649,293899,294043,294256,294262,294268,294360,295210,295522,296632,296715,296914,297321,297345,297347,297359,298199,298498,299038,500329,500342,500633,500650,500694,500889,501567,501568,501904,502009,502200,502564,502808,502914,503016,503268,504034,504382,504597,505781,505907,506193,506195,506504,506505,506931,507026,507074,507423,507622,507652,507820,508419,508421,508494,508496,509087,510425,510467,510696,510698,510964,511111,511461,511842,512598,513032,513039,513276,513800,513824,513845,514131,515437,515503,516475,516510,516825,517149,517791,518271,518312,518340,518342,518343,518344,518345,518377,518526,518878,518879,518968,519001,519104,519106,519326,519485,520963,521719,522057,522073,522074,522858,522882,523003,523142,523416,524093,524393,524819,525120,525356,526003,526230,526307,526384,526577,526724,526886,526889,527125,527170,527520,527800,528511,528722,528795,529217,529254,529446,529593,529809,530830,531063,531741,531829,531961,531963,531966,531968,531973,531977,531979,531982,531983,531984,532183,532755,532873,533048,533156,533750,533785,533944,534029,534030,534055,534057,534129,534469,534505,534739,535459,535460,535765,536150,536162,536175,536239,536439,537726,538057,538078,538305,538446,538483,538754,539050,539976,540378,540827,541141,541234,541235,541322,541625,541769,541844,542062,542569,542764,542765,542949,543521,543620,544466,544712,544713,544715,544734,545054,545575,545912,546014,546301,546350,546351,546352,546353,546354,546355,546356,546357,546715,547668,547868,547968,547969,547971,547972,547973,547997,548039,548204,548954,549218,549220,549292,549378,549379,549973,550048,550611,550824,550827,551367,551805,551951,552198,552220,552242,552278,552396,552671,553352,553566,553757,554031,554032,554155,554400,554401,554550,554661,554789,554805,555420,555765,556179,557386,557515,557720,557757,558067,558246,558540,558723,559051,559128,559201,559241,559418,559493,559561,559701,559920,559935,560827,560841,560852,560919,560965,212014) ) ranked_results WHERE ranked_results.rn = 1 ORDER BY ranked_results.post_date DESC"