query
RESULTSET
query
  DATEPROD DATETRANS GENRE REF SHOTDURATION SHOTSUM SHOTTIME VIDSUM VIDTITLE
1 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:00:05 Title 10:00:00 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
2 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:00:07 Soundbite by a Journalist (in ENGLISH): So you say EU support for governments in Egypt is well-intentioned but ineffective. Why? 10:00:05 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
3 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:00:42 Soundbite by Karel Pinxten, Member of the European Court of Auditors (in ENGLISH): Well, it is well-intentioned, which means that over the last years the Commission has definitely taken quite a few measures when it gave aid to Egypt. Measures in terms of starting, for example, discussions about human rights, creating a subcommittee, etc., but although the intentions are there, the results are not. So if we compare the intentions and the initiatives taken by the Commission in Egypt over the last years as well under the former regime as another current one, well, the results are not up to the expectations. 10:00:12 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
4 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:00:07 Soundbite by a Journalist (in ENGLISH): But aren’t you being a bit naive here? This is a country in turmoil and you are expecting a nice, tidy audit trail. 10:00:55 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
5 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:00:57 Soundbite by Karel Pinxten (in ENGLISH): Well, we are not naive at all, but I think we have to be realistic and I think we are. If you speak about an audit trail, for example, if you look at the budget of the country of Egypt and you don't find any amounts – provisions – for the expenses of the President, you don't find amounts for the huge expenditure of the military, you find a special fund of 4 billion euro, of which no one knows what it’s meant for, where the money comes from, where the money goes to. So it’s, in these circumstances, absolutely impossible to follow an audit trail. So we are not naive, we are very realistic but I think we have to set minimum standards in terms of human rights, in terms of democracy, in terms of the fight against corruption and in terms of a decent public finance management. 10:01:03 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
6 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:00:03 Soundbite by a Journalist (in ENGLISH): Ok. In practical terms then, what are your recommendations? 10:02:01 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
7 2013-06-18 00:00:00.0 2013-06-18 00:00:00.0 Report I-079577 00:01:02 Soundbite by Karel Pinxten (in ENGLISH): Well… Egypt is a very important country in the area and it is a very important partner for the European Union. In the past, the Commission set forward some conditions for giving aid to the country in terms of human rights, in terms of democracy, in terms of public finance management, in terms of fighting corruption. So what is important is that, if the Commission set forward some conditions that they stick to it that they impose these conditions to those countries, and also to Egypt, if they want to get money from the European taxpayer. So, we have such a thing as European values and if we spent the European taxpayers’ money, the European taxpayer definitely will want these values to get the necessary respect from those who want to have European money. 10:02:04 On 18 June 2013, Karel Pinxten, Member of the European Court of Auditors, gave an interview on EU cooperation with Egypt in the field of governance, in Luxembourg. Interview of Karel Pinxten, Member of the European Court of Auditors on EU cooperation with Egypt in the field of governance
CACHED false
EXECUTIONTIME 62
SQL SELECT case when Length(vid_doc.PROD_END) = 4 then to_date(vid_doc.PROD_END || '0101','yyyymmdd') when Length(vid_doc.PROD_END) = 6 then to_date(vid_doc.PROD_END || '01','yyyymmdd') else to_date(vid_doc.PROD_END,'yyyymmdd') end dateprod, case when Length(vid_ver.DISTR_BEG) = 4 then to_date(vid_ver.DISTR_BEG || '0101','yyyymmdd') when Length(vid_ver.DISTR_BEG) = 6 then to_date(vid_ver.DISTR_BEG || '01','yyyymmdd') else to_date(vid_ver.DISTR_BEG,'yyyymmdd') end datetrans, vid_doc.REF, vid_doc_titles.TITLE vidtitle, vid_doc_summ.SUMM vidsum , thes_vid_genre_ml.TITLE genre, substr(vid_shot.TC_BEG,1,8) shottime, vid_shot_summ.SUMM shotsum, substr(vid_shot.TC_DUR,1,8) shotduration FROM vid_doc , vid_ver , vid_doc_titles , vid_doc_summ , thes_vid_genre_ml, vid_shot, vid_shot_summ WHERE vid_doc.REF = vid_ver.DOC_REF AND vid_doc.REF = vid_doc_titles.DOC_REF AND vid_doc.REF = vid_doc_summ.DOC_REF AND vid_doc.REF = ? AND vid_doc_titles.LANG = ? AND vid_doc_summ.LANG = ? AND vid_doc.INTERNET = 'Y' AND vid_ver.INTERNET = 'Y' AND vid_doc.GENRE = thes_vid_genre_ml.THES_ID AND thes_vid_genre_ml.LANG = ? AND vid_ver.REF = vid_shot.VER_REF AND vid_shot.REF = vid_shot_summ.SHOT_REF AND vid_shot_summ.LANG = ? ORDER BY vid_shot.TC_BEG
SQLPARAMETERS
array
1 I-079577
2 EN
3 EN
4 EN
5 EN