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"

Arnošt Goldflam

Arnošt Goldflam

Č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.