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
)
Deprecated: Creation of dynamic property DataCountryTopic::$vmsql is deprecated in /var/www/vhosts/dgmonitor/classes/src/DataCountryTopic.php on line 35
Array
(
[sql] => SELECT DISTINCT id_indicator
FROM dgm
WHERE main_category=?
AND id_subcategory = ?
ORDER BY id_subcategory, id_indicator
[params] => Array
(
[0] => general digital services
[1] => 5010
)
[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
)
Digital Government MetaMonitor
Topic General Digital Services in
United Kingdom
This digital government service is currently not available in this country.