string(3098) "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 = 1404
AND author_role.meta_value IN ('Autor', 'Ilustrace', 'Překlad')
AND books.binding <> ''
AND book_id.meta_value IN (6178,6459,103078,106622,124211,127822,130621,132528,136873,141735,141735,142303,145634,148696,150078,153700,157004,158329,166175,166431,166507,173957,174702,175897,175916,176299,176299,176513,177274,177274,178345,180311,180312,183800,184015,187179,188933,188933,189133,189133,189326,189329,189329,189330,189330,190832,191537,195579,198463,199227,200298,200644,200644,200648,200805,200805,200935,200938,200938,201474,201474,203490,203502,205227,206107,206466,208974,209750,210211,211201,212483,215348,217608,217684,219983,220519,220967,221286,223541,225625,225662,233766,233814,234982,235572,235574,237344,238538,243775,243775,251649,252567,252567,252924,253943,255070,261867,269548,269548,269569,269569,273595,277631,280288,282946,285379,286177,286726,294703,294987,297422,297567,297623,505842,516480,517029,517532,528805,530942,540334,552044,552044,555638,559882)
) ranked_results
WHERE ranked_results.rn = 1
ORDER BY ranked_results.post_date DESC"
Český herec, dramatik, režisér, pedagog a spisovatel pro děti. Je podruhé ženatý, z prvního manželství má dospělou dceru. Jeho nynější manželkou je výtvarnice a scénografka Petra Goldflamová-Štětinová, se kterou má syna a dceru.
V 80. letech začal být obsazován do menších filmových a televizních rolí. Největší ohlas měly role Arnošta ve filmu Dědictví aneb Kurvahošigutntag a Lustiga ve snímku Lotrando a Zubejda.
