query
RESULTSET
query
  ITEM_DATE ITEM_DATE_TO ITEM_ID ITEM_PEOPLE ITEM_SHORT_TITLE ITEM_SUBTYPE ITEM_TYPE ITEM_URI ITEM_VALID_FROM ITEM_VENUE
1 2012-05-30 00:00:00.0 [empty string] 8131 [empty string] Vice-President Kroes urges member states and citizens to endorse 116 000 hotline for missing children [empty string] 251 http://ec.europa.eu/information_society/newsroom/cf/itemdetail.cfm?item_id=8131 2012-05-30 14:48:00.0 [empty string]
2 2012-05-30 00:00:00.0 [empty string] 8130 Neelie Kroes, Vice President of the European Commission responsible for the Digital Agenda Call 116 000 – efforts to save missing children [empty string] 255 http://europa.eu/rapid/pressReleasesAction.do?reference=SPEECH/12/396&format=HTML&aged=0&language=EN&guiLanguage=en 2012-05-30 14:42:00.0 [empty string]
3 2012-05-29 00:00:00.0 [empty string] 8128 [empty string] Vice-President Kroes to propose action on consumer choice and "net neutrality" [empty string] 251 http://europa.eu/rapid/pressReleasesAction.do?reference=MEMO/12/389&format=HTML&aged=0&language=en&guiLanguage=en 2012-05-29 16:50:00.0 [empty string]
CACHED false
EXECUTIONTIME 227
SQL select * from ( select item_id, item_type, item_subtype, decode(item_long,'1','http://ec.europa.eu/information_society/newsroom/cf/','') || item_uri item_uri, item_short_title, item_valid_from, item_people, item_venue, item_date, item_date_to from v_newsroom_homepage where (item_type in (251, 252, 254, 255) or (item_type = 250 and nvl(item_date,sysdate) > sysdate)) AND item_id NOT IN (?,?,?) order by item_valid_from DESC) where rownum < 4
SQLPARAMETERS
array
1 8052
2 8039
3 8020

Funding

query
RESULTSET
query
  ITEM_DATE_TO ITEM_ID ITEM_SHORT_TITLE ITEM_URI
1 2012-06-14 00:00:00.0 8060 ENIAC launches call for proposals http://ec.europa.eu/research/participants/portal/page/cooperation?callIdentifier=ENIAC-2012-2
2 2012-07-18 00:00:00.0 8122 Study on benchmarking of parental control tools for the online protection of children - SIP-BENCH III (SMART 2012/0044) http://ted.europa.eu/udl?uri=TED:NOTICE:162358-2012:TEXT:EN:HTML&src=0
3 2012-09-06 00:00:00.0 8059 ARTEMIS launches call for proposals http://cordis.europa.eu/fetch?CALLER=EN_NEWS&ACTION=D&RCN=34580
CACHED false
EXECUTIONTIME 10
SQL select * from ( select item_id, decode(item_long,'1','http://ec.europa.eu/information_society/newsroom/cf/','') || item_uri item_uri, item_short_title, item_date_to from v_newsroom_homepage where item_type = 253 and nvl(item_date_to,sysdate+1) > sysdate order by item_date_to ASC ) where rownum < 4

Events

query
RESULTSET
query
  ITEM_DATE ITEM_DATE_TO ITEM_ID ITEM_SHORT_TITLE ITEM_URI ITEM_VENUE
1 2012-05-31 00:00:00.0 2012-06-01 00:00:00.0 8052 Pan European Partnership and Investment for Mobile Services - MOBIP 2012 http://www.e-unlimited.com/mobip Thessaloniki, Greece
2 2012-06-04 00:00:00.0 2012-06-06 00:00:00.0 8039 ICT - Driving the City of tomorrow? http://www.majorcities.eu/conferences/2012-vienna Vienna, Austria
3 2012-06-06 00:00:00.0 2012-06-07 00:00:00.0 8020 European Data Forum 2012 http://www.data-forum.eu/ Copenhagen, Denmark
CACHED false
EXECUTIONTIME 53
SQL select * from ( select item_id, decode(item_long,'1','http://ec.europa.eu/information_society/newsroom/cf/','') || item_uri item_uri, item_short_title, item_date, item_date_to, item_venue from v_newsroom_homepage where item_type = 250 and nvl(item_date,sysdate) > sysdate order by item_date ASC ) where rownum < 4

Library

query
RESULTSET
query
  ITEM_DATE ITEM_ID ITEM_PEOPLE ITEM_SHORT_TITLE ITEM_SUBTYPE ITEM_TYPE ITEM_URI ITEM_VENUE
1 2012-05-29 00:00:00.0 8127 Neelie Kroes, Vice-President of the European Commission responsible for the Digital Agenda Making Open Access a reality for Science [empty string] 255 http://europa.eu/rapid/pressReleasesAction.do?reference=SPEECH/12/392&format=HTML&aged=0&language=EN&guiLanguage=en [empty string]
2 2012-05-24 00:00:00.0 8121 Neelie Kroes, Vice-President of the European Commission responsible for the Digital Agenda Electronics for Europe [empty string] 255 http://europa.eu/rapid/pressReleasesAction.do?reference=SPEECH/12/382&format=HTML&aged=0&language=EN&guiLanguage=en [empty string]
3 2012-05-21 00:00:00.0 8110 Neelie Kroes, Vice-President of the European Commission responsible for the Digital Agenda New powers to shape the Telecoms Single Market: one year on [empty string] 255 http://europa.eu/rapid/pressReleasesAction.do?reference=SPEECH/12/363&format=HTML&aged=0&language=EN&guiLanguage=en [empty string]
CACHED false
EXECUTIONTIME 114
SQL select * from ( select item_id, item_short_title, decode(item_long,'1','http://ec.europa.eu/information_society/newsroom/cf/','') || item_uri item_uri, item_type, item_subtype, item_date, item_people, item_venue from v_newsroom_homepage where item_type in (252, 254, 255) AND item_id not in (?,?,?,?,?,?) order by item_date desc) where rownum < 4
SQLPARAMETERS
array
1 8052
2 8039
3 8020
4 8131
5 8130
6 8128