Roma dream

“Roma Dream” is a collection of four stories about the residents of Trans-Carpathian settlements

Videos

About the project

Denys, Myroslav, Diana, and Renata are considered as successful Roma so they strive to give the lead

Denys was raised in an orphanage where he runs music workshop now. He lives in the settlement, in his mother-in-law’s house with his wife and three children. However, he always wears for work career apparel with a tie and polished shoes. Denys has bought a plot of land and he dreams of building the house and leaving the settlement.

Myroslav works at the regional Television and Radio Broadcasting Company where he makes and presents a weekly broadcast for Roma people. The topics of these shows include sports competitions in which Roma people participate, work of Roma organizations, and even historical events which aim to awake the self-respect of the Roma people.  

Diana is 23 years old she lives in the “Radvanka” settlement. She is a mother of two children from two marriages and she doesn’t give up the dream of studying and becoming a professional choreographer. Diana runs dance workshop at the local Roma school. She is convinced that when people stop dance their folk dances the nation will stop its existence.

Renata was born in a settlement in Mukacheve. She studied to become a lawyer at the Interregional Academy of Personnel Management (the IAPM) and moved to the town with her parents. Recently, Renata started to work in the Centre for Legal Information and Consulting which was founded in the former house of her parents. For the first time in Mukacheve settlement history, Roma people can get a free legal consultation. Renata helps to renew passports, to issue birth certificates for children, and represents Roma people’s interests in courts.

 

The films of “Roma Dream” cycle were created with the support of International Renaissance Foundation in the framework of the “Legal Empowerment of the Poor” initiative.


FILM CREW

Roman Bondarchuk – director, cameraman

Borys Peter – sound director

Dar’ya Averchenko – journalist, scriptwriter, executive producer

Olga Zhmurko – consulting expert on human rights

PRODUCTION
Kherson City Association of Journalists “Pivden”, Frunze Str., 2, 73000 Kherson, Ukraine, +380 67 989 9987, daverchenko@gmail.com and International Documentary Human Rights Film Festival Docudays UA.

128.6 ms
page/common/index     SQL: 31     show widget info
↓↓↓
Logger Console
Title Value
MySQL query #1 0.0001 [read][SELECT * FROM cms_languages ORDER BY pos ASC]
MySQL query #2 0.0001 [read][SELECT href FROM page WHERE href<>'']
MySQL query #3 6.8902 [read][SELECT * FROM cms_modules WHERE `module`='page']
MySQL query #4 0.0003 [read][SELECT rtable.`id` AS `id`, rtable.`tree_id` AS `tree_id`, rtable.`tree_path` AS `tree_path`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`href` AS `href`, rtable.`template` AS `template`, rtable.`view_groups` AS `view_groups`, rtable.`view_users` AS `view_users`, rtable.`cms_seo_title_eng` AS `cms_seo_title`, rtable.`cms_seo_description_eng` AS `cms_seo_description`, rtable.`cms_seo_keywords_eng` AS `cms_seo_keywords`, rtable.`active` AS `active`, rtable.`inmenu` AS `inmenu`, rtable.`menuname_eng` AS `menuname`, rtable.`page_redirect` AS `page_redirect`, rtable.`news` AS `news`, rtable.`partners` AS `partners`, rtable.`main_image` AS `main_image`, rtable.`short_body_eng` AS `short_body` FROM `page` as rtable WHERE (rtable.`href`= 'project/:href') ORDER BY rtable.`tree_path` ASC LIMIT 1]
MySQL query #5 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`name` AS `name` FROM `cms_user_groups` as rtable ORDER BY rtable.`name` ASC]
MySQL query #6 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`name` AS `name` FROM `cms_users` as rtable ORDER BY rtable.`name` ASC]
MySQL query #7 0.0005 [read][SELECT rtable.`id` AS `id`, rtable.`tree_id` AS `tree_id`, rtable.`tree_path` AS `tree_path`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`href` AS `href`, rtable.`template` AS `template`, rtable.`view_groups` AS `view_groups`, rtable.`view_users` AS `view_users`, rtable.`cms_seo_title_eng` AS `cms_seo_title`, rtable.`cms_seo_description_eng` AS `cms_seo_description`, rtable.`cms_seo_keywords_eng` AS `cms_seo_keywords`, rtable.`active` AS `active`, rtable.`inmenu` AS `inmenu`, rtable.`menuname_eng` AS `menuname`, rtable.`page_redirect` AS `page_redirect`, rtable.`news` AS `news`, rtable.`partners` AS `partners`, rtable.`main_image` AS `main_image`, rtable.`short_body_eng` AS `short_body`, page.`id` as join_page_redirect_id, page.`tree_id` as join_page_redirect_tree_id, page.`tree_path` as join_page_redirect_tree_path, page.`name_eng` as join_page_redirect_name, page.`body_eng` as join_page_redirect_body, page.`href` as join_page_redirect_href, page.`template` as join_page_redirect_template, page.`view_groups` as join_page_redirect_view_groups, page.`view_users` as join_page_redirect_view_users, page.`cms_seo_title_eng` as join_page_redirect_cms_seo_title, page.`cms_seo_description_eng` as join_page_redirect_cms_seo_description, page.`cms_seo_keywords_eng` as join_page_redirect_cms_seo_keywords, page.`active` as join_page_redirect_active, page.`inmenu` as join_page_redirect_inmenu, page.`menuname_eng` as join_page_redirect_menuname, page.`page_redirect` as join_page_redirect_page_redirect, page.`news` as join_page_redirect_news, page.`partners` as join_page_redirect_partners, page.`main_image` as join_page_redirect_main_image, page.`short_body_eng` as join_page_redirect_short_body FROM `page` as rtable LEFT JOIN `page` ON rtable.`page_redirect`=`page`.id WHERE (rtable.`inmenu`= '1') AND (rtable.`tree_path` IN ('01', '0101')) OR (rtable.`tree_path` LIKE '0101%') ORDER BY rtable.`tree_path`]
MySQL query #8 0.0001 [read][SELECT rtable.`id` AS `id` FROM `cms_tables` as rtable WHERE (rtable.`tablename`= 'page') LIMIT 1]
MySQL query #9 0.0003 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`image` AS `image`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`href` AS `href` FROM `news_project` as rtable WHERE (rtable.`page_id` IN ('1', '4')) AND (rtable.`table_id`= '2') ORDER BY rtable.`pos` ASC]
MySQL query #10 0.0004 [read][SELECT rtable.`id` AS `id`, rtable.`name_eng` AS `name`, rtable.`image` AS `image`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`href` AS `href` FROM `partners` as rtable WHERE (rtable.`page_id` IN ('1', '4')) AND (rtable.`table_id`= '2') ORDER BY rtable.`pos` ASC]
MySQL query #11 0.0001 [read][SELECT c.*, w.name as wname, w.id as id, c.id as cid, c.name as name, c.view_users, c.view_groups, m.module, w.func, w.moduleConf, c.stable, p.id as page_id, w.is_cached as is_cached, m.moduleConf as commonModuleConf FROM cms_containers c LEFT JOIN page p ON p.id=c.page LEFT JOIN cms_widgets w ON w.id=c.widget LEFT JOIN cms_modules m ON m.id=w.module WHERE c.active='1' ORDER BY c.pos ASC]
MySQL query #12 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`tree_id` AS `tree_id`, rtable.`tree_path` AS `tree_path`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`href` AS `href`, rtable.`template` AS `template`, rtable.`view_groups` AS `view_groups`, rtable.`view_users` AS `view_users`, rtable.`cms_seo_title_eng` AS `cms_seo_title`, rtable.`cms_seo_description_eng` AS `cms_seo_description`, rtable.`cms_seo_keywords_eng` AS `cms_seo_keywords`, rtable.`active` AS `active`, rtable.`inmenu` AS `inmenu`, rtable.`menuname_eng` AS `menuname`, rtable.`page_redirect` AS `page_redirect`, rtable.`news` AS `news`, rtable.`partners` AS `partners`, rtable.`main_image` AS `main_image`, rtable.`short_body_eng` AS `short_body` FROM `page` as rtable WHERE (rtable.`href`= 'project/:href') ORDER BY rtable.`tree_path` ASC LIMIT 1]
MySQL query #13 0.0001 [read][SELECT rtable.`tree_path` AS `tree_path`, rtable.`id` AS `id` FROM `page` as rtable WHERE (rtable.`tree_path` IN ('01', '0101')) OR (rtable.`tree_path` LIKE '0101%') ORDER BY rtable.`tree_path`]
MySQL query #14 0.0005 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`image` AS `image`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`menu_icon` AS `menu_icon`, rtable.`year` AS `year`, rtable.`href` AS `href`, rtable.`has_video` AS `has_video`, rtable.`title_o_project_eng` AS `title_o_project`, rtable.`body_o_project_eng` AS `body_o_project`, rtable.`project_news` AS `project_news`, rtable.`files` AS `files`, rtable.`gallerie` AS `gallerie`, rtable.`is_about` AS `is_about`, rtable.`is_video` AS `is_video`, rtable.`is_news` AS `is_news`, rtable.`is_gallery` AS `is_gallery`, rtable.`is_files` AS `is_files`, rtable.`is_partners` AS `is_partners`, rtable.`name2_eng` AS `name2`, rtable.`subdomain` AS `subdomain` FROM `projects` as rtable ORDER BY rtable.`pos` ASC]
MySQL query #15 0.0004 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`image` AS `image`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`menu_icon` AS `menu_icon`, rtable.`year` AS `year`, rtable.`href` AS `href`, rtable.`has_video` AS `has_video`, rtable.`title_o_project_eng` AS `title_o_project`, rtable.`body_o_project_eng` AS `body_o_project`, rtable.`project_news` AS `project_news`, rtable.`files` AS `files`, rtable.`gallerie` AS `gallerie`, rtable.`is_about` AS `is_about`, rtable.`is_video` AS `is_video`, rtable.`is_news` AS `is_news`, rtable.`is_gallery` AS `is_gallery`, rtable.`is_files` AS `is_files`, rtable.`is_partners` AS `is_partners`, rtable.`name2_eng` AS `name2`, rtable.`subdomain` AS `subdomain` FROM `projects` as rtable WHERE (rtable.`href`= 'roma-dream') LIMIT 1]
MySQL query #16 0.0001 [read][SELECT rtable.`id` AS `id` FROM `cms_tables` as rtable WHERE (rtable.`tablename`= 'projects') LIMIT 1]
MySQL query #17 0.0004 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`image` AS `image`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`href` AS `href` FROM `news_project` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #18 0.0003 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`image` AS `image`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`video_youtube` AS `video_youtube` FROM `videos` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #19 0.0003 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`body_eng` AS `body`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`file` AS `file`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`name` AS `name` FROM `files` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #20 0.0004 [read][SELECT rtable.`id` AS `id`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`main_image` AS `main_image` FROM `galleries` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #21 0.0002 [read][SELECT * FROM cms_translate]
MySQL query #22 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`image` AS `image`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`menu_icon` AS `menu_icon`, rtable.`year` AS `year`, rtable.`href` AS `href`, rtable.`has_video` AS `has_video`, rtable.`title_o_project_eng` AS `title_o_project`, rtable.`body_o_project_eng` AS `body_o_project`, rtable.`project_news` AS `project_news`, rtable.`files` AS `files`, rtable.`gallerie` AS `gallerie`, rtable.`is_about` AS `is_about`, rtable.`is_video` AS `is_video`, rtable.`is_news` AS `is_news`, rtable.`is_gallery` AS `is_gallery`, rtable.`is_files` AS `is_files`, rtable.`is_partners` AS `is_partners`, rtable.`name2_eng` AS `name2`, rtable.`subdomain` AS `subdomain` FROM `projects` as rtable WHERE (rtable.`href`= 'roma-dream') LIMIT 1]
MySQL query #23 0.0001 [read][SELECT rtable.`id` AS `id` FROM `cms_tables` as rtable WHERE (rtable.`tablename`= 'projects') LIMIT 1]
MySQL query #24 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`image` AS `image`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`href` AS `href` FROM `news_project` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #25 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`name_eng` AS `name`, rtable.`image` AS `image`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`video_youtube` AS `video_youtube` FROM `videos` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #26 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`body_eng` AS `body`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`file` AS `file`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`name` AS `name` FROM `files` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #27 0.0001 [read][SELECT rtable.`id` AS `id`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`main_image` AS `main_image` FROM `galleries` as rtable WHERE (rtable.`page_id` IN ('1')) AND (rtable.`table_id`= '49') ORDER BY rtable.`pos` ASC]
MySQL query #28 0.0003 [read][SELECT rtable.`id` AS `id`, rtable.`name_eng` AS `name`, rtable.`body_eng` AS `body`, rtable.`gallery` AS `gallery`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`main_image` AS `main_image` FROM `galleries` as rtable WHERE (rtable.`id` IN ('2')) AND (rtable.`active`= '1')]
MySQL query #29 0.0001 [read][SELECT rtable.`id` AS `id` FROM `cms_tables` as rtable WHERE (rtable.`tablename`= 'galleries') LIMIT 1]
MySQL query #30 0.0003 [read][SELECT rtable.`id` AS `id`, rtable.`page_id` AS `page_id`, rtable.`image` AS `image`, rtable.`name_eng` AS `name`, rtable.`table_id` AS `table_id`, rtable.`pos` AS `pos`, rtable.`column` AS `column` FROM `gallery` as rtable WHERE (rtable.`page_id` IN ('2')) AND (rtable.`table_id`= '53') ORDER BY rtable.`pos` ASC]
MySQL query #31 0.0002 [read][SELECT rtable.`id` AS `id`, rtable.`idate` AS `idate`, rtable.`body_eng` AS `body`, rtable.`active` AS `active`, rtable.`pos` AS `pos`, rtable.`file` AS `file`, rtable.`column` AS `column`, rtable.`table_id` AS `table_id`, rtable.`page_id` AS `page_id`, rtable.`name` AS `name` FROM `files` as rtable WHERE (rtable.`page_id`= '1')]
controller: page/common/index: 0.1236
Total sql queries 31
Total exec time 128.6
Memory usage 1.3307 MB
Peak memory usage 2.0574 MB
Loaded libs benchmark, cache, config, controller, crud, database, error, language, loader, log, mail, model, modules, parser, request, router, session, tree, uri
Loaded modules container, docuspace, interface, page, translate, users