string(3438) "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 = 7288
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (104597,116908,120421,121099,125212,125212,125215,125215,128352,128748,128748,128987,129330,130172,132662,132880,133871,134172,135384,135384,136827,140510,140511,141997,142437,149652,149652,151025,151025,151498,158956,158956,158980,159338,159339,159685,165445,166285,166287,172639,173169,173169,174103,175325,175772,177414,177415,182028,182028,182665,182665,183839,183839,185278,189148,189148,191589,192442,193213,193213,193215,193218,193218,193219,193219,195248,195248,195415,199058,199059,199060,202891,202891,202892,202892,207611,207611,208117,208117,208121,208121,212254,213739,213740,215788,215788,219429,219429,219431,219431,219433,219433,219464,219464,222733,226170,226170,235336,235336,235338,235338,240717,242057,242057,242058,242059,242059,243324,249919,249919,255198,255198,256383,256383,257689,257689,257690,257690,258915,258915,259051,262034,263322,263322,264000,264000,265754,265755,265756,272147,272147,273359,273359,281560,281560,288825,288825,288828,288828,291122,296129,296129,505654,505654,505655,505655,513463,513463,516017,516017,516310,519361,519361,519374,519374,530494,530494,530495,530495,530500,530500,530815,538337,538337,543779,543779,549083,560758,560758,560759,560759,507571)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
