Tutti i dettagli nella sezione Concorsi Pubblici del sito internet dell’Ente
Nuovi agenti per l’organico della Polizia Locale del Comune di Gravina in Puglia. E’ stato difatti pubblicato il bando di concorso per la selezione di cinque posti a tempo pieno determinato, sino al 31 Dicembre 2021, salvo proroghe, nelle more dell’espletamento del concorso a tempo indeterminato, di prossima indizione. “L’iniziativa - sottolinea il sindaco Alesio Valente - punta a potenziare il personale della Polizia Locale, in aggiunta alle assunzioni già portate a compimento negli ultimi mesi. E’ necessario fare di più ed è quel che ci accingiamo a fare, per assicurare una sempre migliore efficienza di un settore essenziale per la vita della comunità”.
La domanda di ammissione al concorso dovrà essere presentata esclusivamente tramite procedura telematica, entro e non oltre le ore 23.59 dell’11.11.2021. Maggiori informazioni ed il bando in versione integrale sono disponibili nella sezione “Concorsi Pubblici” del sito internet del comune di Gravina in Puglia, all’indirizzo www.comune.gravina.ba.it
Gravina in Puglia, 27 Ottobre 2021
Comune di Gravina in Puglia Puglia
password_clear ⇒
groups ⇒
limittype ⇒ 0
leadingMax ⇒ 750
introMax ⇒ 500
Ignore_Existing_Read_More ⇒ 0
Strip_Formatting ⇒ 0
wrap_output ⇒ 0
wrap_output_template ⇒ %OUTPUT%
Enabled_Front_Page ⇒ 1
add_trimming_dots ⇒ 0
trimming_dots ⇒ ...
categories_switch ⇒ 0
categories ⇒
articles_switch ⇒ 0
debug ⇒ 0
Thumbnails ⇒ 0
Thumbnails_Class ⇒
Strip_Image_Formatting ⇒ 0
Force_Image_Handle ⇒ 0
csscode ⇒ .margin-h-8 {margin:8px;}
session.token ⇒ 198c78bea0bce81af45621069de1d675
Application 0.000 seconds (+0.000); 0.76 MB (+0.761) - afterLoad
Application 0.091 seconds (+0.091); 3.04 MB (+2.279) - afterInitialise
Application 0.204 seconds (+0.113); 4.82 MB (+1.778) - afterRoute
Application 0.309 seconds (+0.105); 6.64 MB (+1.820) - afterDispatch
Application 0.376 seconds (+0.066); 7.65 MB (+1.013) - afterRender
7.64 MB (8,015,560 Bytes)
SELECT `data`
FROM `koul8_session`
WHERE `session_id` = '31dacc05f3d6a0d097113ad5f36bc9c5'
DELETE
FROM `koul8_session`
WHERE `time` < '1715529139'
SELECT `session_id`
FROM `koul8_session`
WHERE `session_id` = '31dacc05f3d6a0d097113ad5f36bc9c5'
LIMIT 0, 1
INSERT INTO `koul8_session`
(`session_id`, `client_id`, `time`)
VALUES
('31dacc05f3d6a0d097113ad5f36bc9c5', 0, '1715536339')
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM koul8_usergroups AS a
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `koul8_viewlevels`
SELECT folder AS type, element AS name, params
FROM koul8_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_autotweet'
SELECT `custom_data`
FROM `koul8_extensions`
WHERE `type` = 'component'
AND `element` = 'com_sef'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM koul8_menu AS m
LEFT JOIN koul8_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT a.rules
FROM koul8_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT id, home, template, s.params
FROM koul8_template_styles as s
LEFT JOIN koul8_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM koul8_languages
WHERE published=1
ORDER BY ordering ASC
SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM koul8_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM koul8_content AS a
LEFT JOIN koul8_categories AS c
on c.id = a.catid
LEFT JOIN koul8_users AS u
on u.id = a.created_by
LEFT JOIN koul8_categories as parent
ON parent.id = c.parent_id
LEFT JOIN koul8_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM koul8_categories AS cat JOIN koul8_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 15570
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-12 17:52:19')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-12 17:52:19')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM koul8_categories as c
LEFT JOIN koul8_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM koul8_categories AS cat JOIN koul8_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=73
AND badcats.id is null
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id
ORDER BY c.lft
SELECT `id`
FROM `koul8_users`
WHERE `username` = 'guest'
LIMIT 0, 1
SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.category.34')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SHOW FULL COLUMNS
FROM `koul8_assets`
SELECT id
FROM koul8_assets
WHERE parent_id = 0
SELECT rules
FROM koul8_assets
WHERE id = '1'
SHOW FULL COLUMNS
FROM `koul8_content`
SELECT (catid) As Expr1
FROM koul8_content
WHERE (id=15570)
SHOW FULL COLUMNS
FROM `koul8_users`
SELECT *
FROM `koul8_users`
WHERE `id` = 43
SELECT `g`.`id`,`g`.`title`
FROM `koul8_usergroups` AS g
INNER JOIN `koul8_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 43
SELECT b.id
FROM koul8_user_usergroup_map AS map
LEFT JOIN koul8_usergroups AS a
ON a.id = map.group_id
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 43
SELECT a.rules
FROM koul8_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT a.*,c.access AS category_access
FROM koul8_content AS a
LEFT JOIN koul8_categories AS c
on c.id = a.catid
WHERE a.id = 15570
SELECT (catid) As Expr1
FROM koul8_content
WHERE (id=15570)
SELECT Count(*) As Expr1
FROM ((koul8_content AS c
LEFT JOIN koul8_users AS u
ON u.id=c.created_by)
LEFT JOIN koul8_content AS ar
ON c.parentid=ar.id)
LEFT JOIN koul8_users AS aru
ON aru.id=ar.created_by
WHERE (c.catid=34)
AND (c.access IN (1,1))
AND (ar.access IN (1,1))
AND c.parentid=15570
AND c.state = 1
UPDATE koul8_content
SET hits = hits + 1
WHERE id = 15570
SHOW TABLES
SHOW FULL COLUMNS
FROM `koul8_autotweet_automator`
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`plugin` = 'automator'
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`id` = '1'
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`plugin` = 'content'
SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
WHERE `koul8_autotweet_automator`.`id` = '2'
SELECT images
FROM `koul8_content`
WHERE `id` = '15570'
UPDATE `koul8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1715536339;s:18:\"session.timer.last\";i:1715536339;s:17:\"session.timer.now\";i:1715536339;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:25:\"autoreadmoreDefaultParams\";a:19:{s:9:\"limittype\";s:1:\"0\";s:10:\"leadingMax\";s:3:\"750\";s:8:\"introMax\";s:3:\"500\";s:25:\"Ignore_Existing_Read_More\";s:1:\"0\";s:16:\"Strip_Formatting\";s:1:\"0\";s:11:\"wrap_output\";s:1:\"0\";s:20:\"wrap_output_template\";s:40:\"<div class=\"autoreadmore\">%OUTPUT%</div>\";s:18:\"Enabled_Front_Page\";s:1:\"1\";s:17:\"add_trimming_dots\";s:1:\"0\";s:13:\"trimming_dots\";s:3:\"...\";s:17:\"categories_switch\";s:1:\"0\";s:10:\"categories\";s:0:\"\";s:15:\"articles_switch\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:10:\"Thumbnails\";s:1:\"0\";s:16:\"Thumbnails_Class\";s:0:\"\";s:22:\"Strip_Image_Formatting\";s:1:\"0\";s:18:\"Force_Image_Handle\";s:1:\"0\";s:7:\"csscode\";s:25:\".margin-h-8 {margin:8px;}\";}s:13:\"session.token\";s:32:\"198c78bea0bce81af45621069de1d675\";}'
, `time` = '1715536340'
WHERE `session_id` = '31dacc05f3d6a0d097113ad5f36bc9c5'
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM koul8_extensions
4 × SELECT koul8_autotweet_automator.*
FROM koul8_autotweet_automator
3 × SELECT b.rules
FROM koul8_assets AS a
LEFT JOIN koul8_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT (catid) As Expr1
FROM koul8_content
2 × SELECT a.rules
FROM koul8_assets AS a
1 × SELECT *
FROM `koul8_users`
1 × SELECT rules
FROM koul8_assets
1 × SELECT id
FROM koul8_assets
1 × SELECT b.id
FROM koul8_user_usergroup_map AS map
LEFT JOIN koul8_usergroups AS a
ON a.id = map.group_id
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT images
FROM `koul8_content`
1 × SELECT Count(*) As Expr1
FROM ((koul8_content AS c
LEFT JOIN koul8_users AS u
ON u.id=c.created_by)
LEFT JOIN koul8_content AS ar
ON c.parentid=ar.id)
LEFT JOIN koul8_users AS aru
ON aru.id=ar.created_by
1 × SELECT a.*,c.access AS category_access
FROM koul8_content AS a
LEFT JOIN koul8_categories AS c
on c.id = a.catid
1 × SELECT `id`
FROM `koul8_users`
1 × SELECT `g`.`id`,`g`.`title`
FROM `koul8_usergroups` AS g
INNER JOIN `koul8_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM koul8_contact_details AS contact
1 × SELECT folder AS type, element AS name, params
FROM koul8_extensions
1 × SELECT id, rules
FROM `koul8_viewlevels
1 × SELECT b.id
FROM koul8_usergroups AS a
LEFT JOIN koul8_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT `session_id`
FROM `koul8_session`
1 × SELECT `custom_data`
FROM `koul8_extensions`
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM koul8_menu AS m
LEFT JOIN koul8_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `data`
FROM `koul8_session`
1 × SELECT *
FROM koul8_languages
1 × SELECT id, home, template, s.params
FROM koul8_template_styles as s
LEFT JOIN koul8_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM koul8_categories as c
LEFT JOIN koul8_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM koul8_categories AS cat JOIN koul8_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SHOW TABLE
1 × SHOW FULL COLUMNS
FROM `koul8_autotweet_automator
1 × UPDATE `koul8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1715536339;s:18:\"session.timer.last\";i:1715536339;s:17:\"session.timer.now\";i:1715536339;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:25:\"autoreadmoreDefaultParams\";a:19:{s:9:\"limittype\";s:1:\"0\";s:10:\"leadingMax\";s:3:\"750\";s:8:\"introMax\";s:3:\"500\";s:25:\"Ignore_Existing_Read_More\";s:1:\"0\";s:16:\"Strip_Formatting\";s:1:\"0\";s:11:\"wrap_output\";s:1:\"0\";s:20:\"wrap_output_template\";s:40:\"<div class=\"autoreadmore\">%OUTPUT%</div>\";s:18:\"Enabled_Front_Page\";s:1:\"1\";s:17:\"add_trimming_dots\";s:1:\"0\";s:13:\"trimming_dots\";s:3:\"...\";s:17:\"categories_switch\";s:1:\"0\";s:10:\"categories\";s:0:\"\";s:15:\"articles_switch\";s:1:\"0\";s:5:\"debug\";s:1:\"0\";s:10:\"Thumbnails\";s:1:\"0\";s:16:\"Thumbnails_Class\";s:0:\"\";s:22:\"Strip_Image_Formatting\";s:1:\"0\";s:18:\"Force_Image_Handle\";s:1:\"0\";s:7:\"csscode\";s:25:\".margin-h-8 {margin:8px;}\";}s:13:\"session.token\";s:32:\"198c78bea0bce81af45621069de1d675\";}' , `time` = '1715536340'
1 × UPDATE koul8_content
SET hits = hits + 1
1 × SHOW FULL COLUMNS
FROM `koul8_users
1 × INSERT INTO `koul8_session` (`session_id`, `client_id`, `time`)
VALUES ('31dacc05f3d6a0d097113ad5f36bc9c5', 0, '1715536339'
1 × SHOW FULL COLUMNS
FROM `koul8_assets
1 × SHOW FULL COLUMNS
FROM `koul8_content
1 × DELETE
FROM `koul8_session`