Array
(
    [sql] => 
    SELECT t1.*, 
    ROUND((val_presence*0.5) + (val_upfreq*0.25) + (val_machine_readable*0.25), 2) as c_index
    FROM (
        SELECT t0.main_category, t0.subcategory, t0.country, t0.country_name, t0.id_main_category, t0.sub_sort_ord,
                COALESCE(dr.n_indicators,0) n_indicators , 
                COALESCE(dr.presence, 0) presence,  
                COALESCE(dr.val_presence, 0) val_presence,
                COALESCE(dr.val_upfreq, 0) val_upfreq,
                COALESCE(dr.val_machine_readable, 0) val_machine_readable
            FROM (
                SELECT dgm.main_category, dgm.subcategory, dgm.country, cn.country_name, id_main_category,  dgm.sub_sort_ord
                FROM dgm
                INNER JOIN country cn ON cn.abbr = dgm.country
                WHERE dgm.rev_last = 1
                AND visible_subcategory = 1
                GROUP BY id_main_category, main_category, subcategory, country
                ORDER BY id_main_category, main_category, subcategory, country)
                t0 
            LEFT JOIN data_rank dr 
                ON dr.main_category = t0.main_category
                AND dr.subcategory = t0.subcategory
                AND dr.country = t0.country
                AND year=?
        ) t1 
    ORDER BY id_main_category, sub_sort_ord, main_category, subcategory, country_name
               
    [params] => Array
        (
            [0] => 2020
        )

    [errno] => SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #6 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'dguptake.dgm.sub_sort_ord' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
)
<br />
<b>Deprecated</b>:  Creation of dynamic property DataCountryTopic::$vmsql is deprecated in <b>/var/www/vhosts/dgmonitor/classes/src/DataCountryTopic.php</b> on line <b>35</b><br />
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3020
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3030
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3010
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
Array
(
    [sql] => SELECT DISTINCT id_indicator 
                FROM dgm 
                WHERE main_category=?
                 AND id_subcategory = ?
                ORDER BY id_subcategory, id_indicator
                
    [params] => Array
        (
            [0] => messaging
            [1] => 3040
        )

    [errno] => SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'dguptake.dgm.id_subcategory' which is not in SELECT list; this is incompatible with DISTINCT
)
<br />
<b>Warning</b>:  Cannot modify header information - headers already sent by (output started at /var/www/vhosts/dgmonitor/classes/src/DbException.php:28) in <b>/var/www/vhosts/dgmonitor/classes/src/Rpc.php</b> on line <b>18</b><br />
{"main_category":{"id_main_category":3000,"main_category":"Messaging","visible":1,"sort_order":3,"summary":"Indicators for this topic focus on mapping the use of the national system for sending digital messages from government organisations to citizens and businesses.\nMessaging is measured by assessing the yearly numbers of cumulative registered users for both digital mail and SMS, downloaded and installed mobile applications, cumulative adhered public organisations and digital mails sent to both citizens and businesses."},"country":{"abbr":"IT","country_name":"Italy","summary":"<p><strong>eID <\/strong><a href=\"https:\/\/www.spid.gov.it\">SPID<\/a> is the Italian solution that enables users to use a single digital identity to access all online public administration services from electronic devices. The legal head of an organisation can apply for and use his\/her digital identity SPID to access online services. For this purpose, it is also possible to equip their employees with digital identities for the <a href=\"https:\/\/www.spid.gov.it\/domande-frequenti?lang=en-001\">professional use<\/a> of the legal person.The eID system doesn&rsquo;t include a digital proxy service.<\/p>\n<p><strong>ePayment <\/strong><a href=\"https:\/\/www.pagopa.gov.it\/it\/pagopa\/dashboard\/\">PagoPA<\/a> is an initiative that allows citizens and businesses to realise electronic payments to the public administration on the basis of rules, standards and tools defined by the Agency for Digital Italy (AgID) and accepted by public administration bodies, banks, post offices and other payment institutions.<\/p>\n<p><strong>Messaging<\/strong> <a href=\"https:\/\/www.agid.gov.it\/en\/platforms\/certified-email;\">Certified email (PEC)<\/a> is the channel through which it is possible to send official documents to participate in both tenders and competition notices, to stipulate contracts of any kind, to communicate with the institutions. The PEC is used by citizens, businesses, professionals and public administrations in various fields: from the legal one to healthcare and banking. There is no government SMS service in place.<\/p>\n<p><strong>Transparency <\/strong>Citizens are able to consult their data incorporated into the <a href=\"https:\/\/www.agid.gov.it\/en\/platforms\/national-register-of-the-resident-population\">National Register of the Resident Population (ANPR)<\/a> by logging in to the ANPR website. It is foreseen that more registers are included and made accessible to citizens. There is no digital service allowing citizens to have insight in their ongoing affairs.<\/p>\n<p><strong>General Digital Services<\/strong> No systematic measurement of digital form submission nor user satisfaction has been found.<\/p>\n<p>While some data on the uptake of SPID is publicly available, the <em>Digital Government MetaMonitor <\/em>suggests improvements regarding completeness, machine readability, and update frequency. The same applies for data on the uptake of the national systems for ePayment and electronic messaging. No data on digital form submission and user satisfaction are available. Regarding transparency, the Italian Agency for Digitisation updates and publishes information on the uptake of its <a href=\"https:\/\/avanzamentodigitale.italia.it\/it\/progetto\/anpr\">National Registry database<\/a> on a monthly basis.<\/p>"},"subc":[{"id_subcategory":3020,"subcategory":"Overall uptake"},{"id_subcategory":3030,"subcategory":"Personal uptake"},{"id_subcategory":3010,"subcategory":"Business uptake"},{"id_subcategory":3040,"subcategory":"Public sector uptake"}],"timestamp":"2025-06-01T16:05:40+00:00"}