ABA ROLI Corruption Assessment (Angola, Mozambique, Zambia) tender at American Bar Association Rule of Law Initiative
Website :
185 Days Ago
Linkedid Twitter Share on facebook

Job Description

ABA ROLI is hiring a consultant or research team to conduct a corruption risk assessment and develop a management framework for a program on Promoting Responsible Oversight and Enforcement to Combat Timber Trafficking, which is aimed at reducing the ability of criminal groups to carry out and profit from illegal logging and trafficking of timber from the Miombo woodlands. Its principal objectives are to: (1) Improve national and regional capabilities to prosecute and adjudicate cases against timber crimes and related offenses to result in appropriate sentencing outcomes, and (2) Strengthen anti-corruption efforts within relevant agencies to enhance government response, improve government accountability, and strengthen transparency as it relates to timber crime.

Position Summary:

The consultant(s) will conduct a comprehensive corruption risk assessment and develop a management framework concerning anti-corruption laws and policies as they relate to government institutions enforcing timber crime in Angola, Mozambique and Zambia. This assessment will feature a political economy analysis, examining the underlying power dynamics, incentive structures, and institutional relationships that influence the effectiveness of anti-corruption efforts. The analysis will include primary and secondary data collection to investigate structural and legal gaps, in addition to identifying the political interests, economic motivations, and social networks that impact the formulation and implementation of anti-corruption laws and policies in each project country (i.e., the formal and informal rules that govern decision-making processes; key stakeholders and their interests; and the distribution of resources and authority among anti-corruption institutions).The consultant(s) should develop clear, actionable recommendations for managing corruption based on findings from the corruption assessment. Recommendations should clearly identify the relevant stakeholders who are meant to implement that recommendation.

The consultant(s) should produce a final report including both findings and recommendations that will be used by ABA-ROLI to inform future program activities. The final report will also be presented to relevant government agencies, civil society, and other stakeholders in order to build consensus around proposed reforms.

Scope of Work:

In line with the above, ABA ROLI is seeking a legal expert or team with experience in evaluation of the legal and policy landscape surrounding anti-corruption and/or timber crimes in Angola, Mozambique and/or Zambia. The Anti-Corruption consultant(s) will report directly to the Angola Country Representative. The specific components of the assignment will be as follows:

  1. Corruption Risk Asessments: Evaluate existing anti-corruption laws and policies impacting timber crime enforcement in government institutions within Angola, Mozambique, and Zambia. Identify vulnerabilities and key factors preventing the effective enforcement of anti-corruption measures as it relates to timber crimes, whether structural, legislative, human, or otherwise. Propose clear and actionable recommendations on targeted interventions, including country-specific and regional initiatives.
  1. Mapping of Anti-Corruption Institutions: Conduct a detailed mapping of anti-corruption institutions in each of the three project countries in addition to adjacent institutions (e.g. private sector, civil society, etc.) Assess their roles, relationships, and effectiveness in preventing, detecting, and prosecuting corruption related to timber crime, as well as identify areas for regional and cross-sectoral collaboration.
  1. Political Economy Analysis: Analyze the political and economic contexts that influence corruption in the timber sector. Identify key stakeholders, power dynamics, and incentives that affect anti-corruption efforts and create obstacles to reform. Highlight opportunities for intervention, and strategies for building coalitions to support more effective anti-corruption measures.
  1. Framework Development: Design a management framework for each country that aligns with best practices in anti-corruption, tailored to the specific needs and contexts of Angola, Mozambique, and Zambia. Each framework should allow for regional validation and indicate regional considerations.
  1. Stakeholder Engagement: Collaborate with government agencies, civil society organizations, and regional partners to gather insights and ensure stakeholder buy-in for proposed initiatives. The consultant(s) should develop and execute a plan for stakeholder engagement throughout the research project lifecycle.
  1. Reporting: Prepare detailed inputs and presentations outlining findings, recommendations, and the proposed management framework. Ensure clarity and accessibility for diverse audiences.

To complete this assignment, the consultant(s) is expected to utilize both primary and secondary data sources. Primary data sources could include, for example, conducting key informant interviews with relevant stakeholders or virtual distribution of a survey. Data collection is expected to be conducted virtually, though potential for in-person data collection may be explored depending on specific project needs. Secondary data should be drawn from desk review of relevant policy documents, existing literature, national and international statistics, and other materials/sources as necessary and appropriate.

Qualifications:

All members of the research team should possess the following qualifications:

  • A bachelor’s degree in law, international law, political science, international relations, environmental science, or related field. A master’s degree is preferred.
  • Understanding of anti-corruption bodies/commissions, government institutions and justice sector actors and mechanisms in Southern Africa, especially Angola, Mozambique, and Zambia.
  • Demonstrated experience designing and conducting legal, policy or corruption risk assessments, including stakeholder interviews from the research design phase to final publication, particularly in the context of government institutions and natural resource management.
  • Proven success in performing desk reviews as well as gathering and analyzing both qualitative and quantitative data from primary and secondary sources.
  • Strong communication, analytical, and writing skills.

In addition to the general qualifications listed above, the lead researcher should possess the following qualifications:

  • A master’s degree in law, international law, political science, international relations, environmental science, or related field.
  • Minimum 5-10 years of professional experience working directly with the anti-corruption bodies/commissions, government institutions (forestry departments, law enforcement agencies, etc.), and justice sector actors and mechanisms in Angola, Mozambique and/or Zambia.
  • Strong understanding of anti-corruption laws, policies, and frameworks at the national and international levels.
  • Strong understanding of the current environmental context in Angola, Mozambique and/or Zambia, specifically illegal logging practices within the Miombo Woodlands region, including policy and legislation surrounding these practices and knowledge of the government institutions enforcing timber crimes.
  • Experience working in Southern Africa (especially Angola, Mozambique, or Zambia) and/or elsewhere in Sub-Saharan Africa, and strong understanding of political and operating context the target countries.
  • Fluency in English is required; proficiency in Portuguese is an added advantage.

Estimated Timeline: Specific timelines will be discussed with the successful candidate, but the consultant(s) will be expected to work within the period from November 1, 2024 to March 1, 2025.

Expression of Interest: Please submit the following:

  • Curriculum Vitae for all members of the research team.
  • Brief proposal describing approach and anticipated timeline for completion of the assignment. If applying as a team, the proposal should also outline the roles and responsibilities of each member of the research team.
  • Three professional references with contact information
  • Monthly or daily rate (can be revisited if candidate advances to further hiring stages)
  • Estimated budget to complete the assessment
  • A sample of a relevant report or analysis completed in the past

Only candidates whose applications are shortlisted will be contacted for an interview.

To apply for this job please visit www.devex.com

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Monday, October 28 2024
Duty Station: Lusaka
Posted: 14-10-2024
No of Jobs: 1
Start Publishing: 14-10-2024
Stop Publishing (Put date of 2030): 14-10-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.955MBMemory Usage421msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "5899f71960688d979091403bf97e0668" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1744921734 "last" => 1744921734...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (17.3ms)
  • afterInitialise (11.13MB) (67.74ms)
  • afterRoute (5.06MB) (32.96ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (216μs)
  • afterRenderComponent com_jsjobs (3.12MB) (30.05ms)
  • Before Access::preloadComponents (all components) (239.64KB) (6.48ms)
  • After Access::preloadComponents (all components) (132.72KB) (837μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (17μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (329μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (69.88ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (60.45ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (6μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (284μs)
  • afterDispatch (79.41KB) (109μs)
  • afterRender (13.78MB) (133ms)
  • 1 x afterRender (13.78MB) (31.64%)
    133.06ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.59MB) (16.62%)
    69.88ms
    1 x afterInitialise (11.13MB) (16.11%)
    67.74ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (14.37%)
    60.45ms
    1 x afterRoute (5.06MB) (7.84%)
    32.96ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (7.15%)
    30.05ms
    1 x afterLoad (4.12MB) (4.11%)
    17.30ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.54%)
    6.48ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.2%)
    837μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.08%)
    329μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    284μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.05%)
    216μs
    1 x afterDispatch (79.41KB) (0.03%)
    109μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    17μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    6μs
90 statements were executed, 23 of which were duplicates, 67 unique16.78ms304.23KB
  • SELECT @@SESSION.sql_mode;95μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?175μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1125μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id80μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`162μs1.55KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest109μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'132μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`177μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'202μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config99μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'96μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'55μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'48μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'65μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Corruption-Assessment-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Corruption-Assessment-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Corruption-Assessment-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC203μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Corruption-Assessment-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Corruption-Assessment-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Corruption-Assessment-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC211μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id196μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'303μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'214μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'212μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'269μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'202μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'61μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'216μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 67070513μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'229μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 67070405μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'228μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering297μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'216μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'209μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering227μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'210μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'219μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'62μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'57μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'206μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'193μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'52μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2137μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2136μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'492μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'511μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2142μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2123μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2122μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'163μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'295μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'171μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering121μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)458μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0115μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2299μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2496μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2892μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38102μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39125μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4093μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0103μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft375μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft314μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft459μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-ABA-ROLI-Corruption-Assessment-Angola,-Mozambique,-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070' AND `published` = 1147μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-ABA-ROLI-Corruption-Assessment-Angola,-Mozambique,-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070'99μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration292μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'143μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field126μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'89μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1103μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'170μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`309μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'99μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc173μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`368μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid101μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid137μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-ABA-ROLI-Corruption-Assessment-Angola,-Mozambique,-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67070'92μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 162μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"334μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.03ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin116μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin88μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`85μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'67μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 399069μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?71μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?171μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy