Menu
Array
(
[0] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/db.class.php
[line] => 426
[function] => _trigger_error
[class] => db_connection
[object] => db_connection Object
(
[_host:db_connection:private] => localhost
[_user:db_connection:private] => q07idn22_abruzzoimpresa_it
[_pass:db_connection:private] => _a0w4y2M2
[_name:db_connection:private] => q07idn22_abruzzoimpresa_it
[_connection:db_connection:private] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
)
)
[field_count] => 28
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.6.16-MariaDB-cll-lve
[server_version] => 100616
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 13201266
[warning_count] => 0
)
[_selecion:db_connection:private] => 1
[_transaction:db_connection:private] => 0
[_last_query_res:db_connection:private] =>
[_info_queries:db_connection:private] => Array
(
[0] => Array
(
[query] => SELECT *
FROM tbl_go_config
[durata] => 0.3659725189209
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/sito.class.php
[line] => 40
[function] => __construct()
)
[1] => Array
(
[query] => SELECT provincia,siglaprovincia
FROM tbl_go_provincia
WHERE provincia<>"ESTERO"
ORDER BY provincia
[durata] => 0.5490779876709
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/geo.inc.php
[line] => 7
[function] => require('/var/www/vhosts/abru [...]')
)
[2] => Array
(
[query] => SELECT p.*, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (1)
GROUP BY p.id
-- Ordinamento per data di pubblicazione e di modifica (la pagina
-- modificata diventa la prima della data di pubblicazione)
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 7
[durata] => 6.5681934356689
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 240
[function] => get_by_cats(array(1), 'en', true, 7)
)
[3] => Array
(
[query] => SELECT *
FROM tbl_go_categorie_pagine
WHERE id = 1
AND lang = 'en'
[durata] => 0.43702125549316
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/categoria_pagina.class.php
[line] => 26
[function] => get(1, 'en', true)
)
[4] => Array
(
[query] => SELECT p.*, cat.nome, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <> 0
AND p.in_evidenza = 1
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 1.6767978668213
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 330
[function] => get_by_cat_last_evidenza(array(5, 6, 7, 8, 9), 'en', 1, 1, true)
)
[5] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
[durata] => 0.31900405883789
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(5, 6, 7, 8, 9), 'en', 8, true, null)
)
)
[_total_time:db_connection:private] => 9.9160671234131
)
[type] => ->
[args] => Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11 - Query:
SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
[1] => 256
)
)
[1] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/db.class.php
[line] => 97
[function] => query
[class] => db_connection
[object] => db_connection Object
(
[_host:db_connection:private] => localhost
[_user:db_connection:private] => q07idn22_abruzzoimpresa_it
[_pass:db_connection:private] => _a0w4y2M2
[_name:db_connection:private] => q07idn22_abruzzoimpresa_it
[_connection:db_connection:private] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
)
)
[field_count] => 28
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.6.16-MariaDB-cll-lve
[server_version] => 100616
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 13201266
[warning_count] => 0
)
[_selecion:db_connection:private] => 1
[_transaction:db_connection:private] => 0
[_last_query_res:db_connection:private] =>
[_info_queries:db_connection:private] => Array
(
[0] => Array
(
[query] => SELECT *
FROM tbl_go_config
[durata] => 0.3659725189209
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/sito.class.php
[line] => 40
[function] => __construct()
)
[1] => Array
(
[query] => SELECT provincia,siglaprovincia
FROM tbl_go_provincia
WHERE provincia<>"ESTERO"
ORDER BY provincia
[durata] => 0.5490779876709
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/geo.inc.php
[line] => 7
[function] => require('/var/www/vhosts/abru [...]')
)
[2] => Array
(
[query] => SELECT p.*, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (1)
GROUP BY p.id
-- Ordinamento per data di pubblicazione e di modifica (la pagina
-- modificata diventa la prima della data di pubblicazione)
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 7
[durata] => 6.5681934356689
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 240
[function] => get_by_cats(array(1), 'en', true, 7)
)
[3] => Array
(
[query] => SELECT *
FROM tbl_go_categorie_pagine
WHERE id = 1
AND lang = 'en'
[durata] => 0.43702125549316
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/categoria_pagina.class.php
[line] => 26
[function] => get(1, 'en', true)
)
[4] => Array
(
[query] => SELECT p.*, cat.nome, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <> 0
AND p.in_evidenza = 1
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 1.6767978668213
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 330
[function] => get_by_cat_last_evidenza(array(5, 6, 7, 8, 9), 'en', 1, 1, true)
)
[5] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
[durata] => 0.31900405883789
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(5, 6, 7, 8, 9), 'en', 8, true, null)
)
)
[_total_time:db_connection:private] => 9.9160671234131
)
[type] => ->
[args] => Array
(
[0] =>
SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => query
[class] => db
[type] => ::
[args] => Array
(
[0] =>
SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
)
)
[3] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/index.php
[line] => 38
[function] => get_by_cats_last
[class] => pagina
[type] => ::
[args] => Array
(
[0] => Array
(
[0] => 5
[1] => 6
[2] => 7
[3] => 8
[4] => 9
)
[1] => en
[2] => 8
[3] => 1
[4] =>
)
)
)
Array
(
[0] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/db.class.php
[line] => 426
[function] => _trigger_error
[class] => db_connection
[object] => db_connection Object
(
[_host:db_connection:private] => localhost
[_user:db_connection:private] => q07idn22_abruzzoimpresa_it
[_pass:db_connection:private] => _a0w4y2M2
[_name:db_connection:private] => q07idn22_abruzzoimpresa_it
[_connection:db_connection:private] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
)
)
[field_count] => 29
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.6.16-MariaDB-cll-lve
[server_version] => 100616
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 13201266
[warning_count] => 0
)
[_selecion:db_connection:private] => 1
[_transaction:db_connection:private] => 0
[_last_query_res:db_connection:private] =>
[_info_queries:db_connection:private] => Array
(
[0] => Array
(
[query] => SELECT *
FROM tbl_go_config
[durata] => 0.3659725189209
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/sito.class.php
[line] => 40
[function] => __construct()
)
[1] => Array
(
[query] => SELECT provincia,siglaprovincia
FROM tbl_go_provincia
WHERE provincia<>"ESTERO"
ORDER BY provincia
[durata] => 0.5490779876709
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/geo.inc.php
[line] => 7
[function] => require('/var/www/vhosts/abru [...]')
)
[2] => Array
(
[query] => SELECT p.*, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (1)
GROUP BY p.id
-- Ordinamento per data di pubblicazione e di modifica (la pagina
-- modificata diventa la prima della data di pubblicazione)
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 7
[durata] => 6.5681934356689
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 240
[function] => get_by_cats(array(1), 'en', true, 7)
)
[3] => Array
(
[query] => SELECT *
FROM tbl_go_categorie_pagine
WHERE id = 1
AND lang = 'en'
[durata] => 0.43702125549316
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/categoria_pagina.class.php
[line] => 26
[function] => get(1, 'en', true)
)
[4] => Array
(
[query] => SELECT p.*, cat.nome, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <> 0
AND p.in_evidenza = 1
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 1.6767978668213
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 330
[function] => get_by_cat_last_evidenza(array(5, 6, 7, 8, 9), 'en', 1, 1, true)
)
[5] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
[durata] => 0.31900405883789
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(5, 6, 7, 8, 9), 'en', 8, true, null)
)
[6] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (4)
AND p.id <> 0
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 1.5408992767334
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(4), 'en', 1, true)
)
[7] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 0.27179718017578
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(5), 'en', 1, true, null)
)
)
[_total_time:db_connection:private] => 11.728763580322
)
[type] => ->
[args] => Array
(
[0] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11 - Query:
SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[1] => 256
)
)
[1] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/db.class.php
[line] => 97
[function] => query
[class] => db_connection
[object] => db_connection Object
(
[_host:db_connection:private] => localhost
[_user:db_connection:private] => q07idn22_abruzzoimpresa_it
[_pass:db_connection:private] => _a0w4y2M2
[_name:db_connection:private] => q07idn22_abruzzoimpresa_it
[_connection:db_connection:private] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 7.4.33
[client_version] => 70433
[connect_errno] => 0
[connect_error] =>
[errno] => 1064
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
[error_list] => Array
(
[0] => Array
(
[errno] => 1064
[sqlstate] => 42000
[error] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
...' at line 11
)
)
[field_count] => 29
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.5.5-10.6.16-MariaDB-cll-lve
[server_version] => 100616
[sqlstate] => 42000
[protocol_version] => 10
[thread_id] => 13201266
[warning_count] => 0
)
[_selecion:db_connection:private] => 1
[_transaction:db_connection:private] => 0
[_last_query_res:db_connection:private] =>
[_info_queries:db_connection:private] => Array
(
[0] => Array
(
[query] => SELECT *
FROM tbl_go_config
[durata] => 0.3659725189209
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/sito.class.php
[line] => 40
[function] => __construct()
)
[1] => Array
(
[query] => SELECT provincia,siglaprovincia
FROM tbl_go_provincia
WHERE provincia<>"ESTERO"
ORDER BY provincia
[durata] => 0.5490779876709
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/geo.inc.php
[line] => 7
[function] => require('/var/www/vhosts/abru [...]')
)
[2] => Array
(
[query] => SELECT p.*, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (1)
GROUP BY p.id
-- Ordinamento per data di pubblicazione e di modifica (la pagina
-- modificata diventa la prima della data di pubblicazione)
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 7
[durata] => 6.5681934356689
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 240
[function] => get_by_cats(array(1), 'en', true, 7)
)
[3] => Array
(
[query] => SELECT *
FROM tbl_go_categorie_pagine
WHERE id = 1
AND lang = 'en'
[durata] => 0.43702125549316
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/categoria_pagina.class.php
[line] => 26
[function] => get(1, 'en', true)
)
[4] => Array
(
[query] => SELECT p.*, cat.nome, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <> 0
AND p.in_evidenza = 1
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 1.6767978668213
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 330
[function] => get_by_cat_last_evidenza(array(5, 6, 7, 8, 9), 'en', 1, 1, true)
)
[5] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5, 6, 7, 8, 9)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 8
[durata] => 0.31900405883789
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(5, 6, 7, 8, 9), 'en', 8, true, null)
)
[6] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (4)
AND p.id <> 0
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 1.5408992767334
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(4), 'en', 1, true)
)
[7] => Array
(
[query] => SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[durata] => 0.27179718017578
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => get_by_cats_last(array(5), 'en', 1, true, null)
)
)
[_total_time:db_connection:private] => 11.728763580322
)
[type] => ->
[args] => Array
(
[0] =>
SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
[1] => Array
(
)
)
)
[2] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/include/classes/pagina.class.php
[line] => 293
[function] => query
[class] => db
[type] => ::
[args] => Array
(
[0] =>
SELECT p.*, cat.nome as nome_categoria, cat.uri as uri_categoria, GROUP_CONCAT(t.tag SEPARATOR ',') AS tags
FROM tbl_go_pagine AS p
LEFT JOIN tbl_go_pagine_tags AS pt ON p.id = pt.id_pagina
LEFT JOIN tbl_go_categorie_pagine AS cat ON p.id_categoria_pagina = cat.id
LEFT JOIN tbl_go_tags AS t ON (t.id = pt.id_tag AND t.lang=p.lang)
WHERE p.deleted = 0
AND p.lang = 'en'
AND p.pubblica = 1 AND (p.data_pubblicazione IS NULL OR p.data_pubblicazione <= CURDATE())
AND p.id_categoria_pagina IN (5)
AND p.id <>
GROUP BY p.id
ORDER BY data_pubblicazione DESC, update_date DESC
LIMIT 1
)
)
[3] => Array
(
[file] => /var/www/vhosts/abruzzoimpresa.it/httpdocs/index.php
[line] => 59
[function] => get_by_cats_last
[class] => pagina
[type] => ::
[args] => Array
(
[0] => Array
(
[0] => 5
)
[1] => en
[2] => 1
[3] => 1
[4] =>
)
)
)
Menu
Inserisci le credenziali per effettuare l'accesso. Una volta entrato nell'area riservata, potrai sfogliare l'ultimo numero e consultare l'archivio storico di Abruzzo Impresa.
Contattaci se hai problemi ad effettuare l'accesso.
info@abruzzoimpresa.it