string(3321) "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 = 22
        AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
        AND books.binding <> ''
        AND book_id.meta_value IN (45,5358,61306,62188,62228,62486,100931,101425,101822,103896,103974,104543,105693,106125,106447,106509,106864,107663,121450,121672,121862,122293,122300,122305,122544,124532,127651,128684,131063,134632,134633,135115,136239,139914,142190,143715,149596,150298,152403,153171,154600,158293,159472,159553,160811,161303,169567,169568,169569,169570,169759,170586,171690,172059,172794,175412,176524,179027,184134,185421,188847,189069,189101,189576,194530,196428,198241,199413,200813,200873,203426,203484,205634,205839,209181,210467,211180,215836,216268,217570,219515,219859,221164,222476,224229,224933,225723,227919,235629,237522,241158,245560,246005,247946,250901,250960,251027,253747,253755,254567,254607,255309,256464,257901,258081,262108,262525,263336,263583,265591,266144,267428,268699,268841,269578,271997,274042,274651,276857,277386,277457,278969,283485,285671,286114,287090,288121,288703,289377,289445,296557,502100,502375,502376,502645,503319,504175,504208,504719,505315,505503,506693,508816,510628,513000,516855,528070,530974,531364,531483,532329,537260,540477,544028,557462,557466,559790)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"