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

Job Description

ABA ROLI is hiring a consultant or consultancy firm to conduct a gap analysis 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:

By the end of January 2025, the Gap Analysis consultant or consultancy firm will conduct a gap analysis of the justice system’s handling of timber-related crimes from identification and investigation to case-building, prosecution, and sentencing. Its purpose is to identify the challenges in the prosecution and adjudication of Miombo-related timber crime cases in the project’s three target countries of Angola, Mozambique, and Zambia with attention paid to other Miombo woodlands countries (e.g., Malawi, Tanzania) as resources allow.

The methodology will combine desk research, field observation (if funds allow), and stakeholder interviews to gather qualitative and quantitative data on countries’ handling of timber crimes as well as the level of regional and cross-border coordination. Qualitative data sources could include, for example, information from key informant interviews with relevant stakeholders or virtual distribution of a survey. Quantitative data could include statistics or figures collected from desk review of relevant policy documents, existing literature, national and international statistics, and other materials/sources as necessary and appropriate. Data collection is expected to be conducted virtually, though potential for in-person data collection may be explored depending on specific project needs.

 
 

The study’s goal is intended to be a practical examination that uncovers the structural factors that lead to the failure to protect, investigate, enforce, and adjudicate timber crimes. The final report should make practical recommendations based on findings that will inform the project’s next steps, offering a comprehensive analysis of the state of the justice sector as it pertains to identifying, prosecuting, and sentencing timber crimes cases. The analysis should also serve as a resource and learning tool for relevant justice sector and regulatory agencies and stakeholders, international organizations, and civil society groups within the target countries.

Scope of Work:

In line with the above, ABA ROLI is seeking a consultant or firm with experience in operations and management of the justice delivery system surrounding environmental crimes in Angola, Mozambique and/or Zambia. The Gap Analysis consultant or consultancy firm will report directly to the Angola Country Representative and DC-based Program Manager. The specific purpose of the assignment will be to:

  1. Map the justice sector actors and relevant regulatory agencies responsible for investigation, prosecution, and adjudication of Miombo-related timber crime cases in all three target countries (Angola, Mozambique, and Zambia). Stakeholder mapping should identify the roles and responsibilities of each agency, how agencies interact/are related to each other, and where any administrative overlaps or gaps may be occurring.
  2. Identify the gaps and challenges in the prosecution and adjudication of Miombo-related timber crime cases in the three target countries and uncover the root causes for failure to protect, investigate, enforce, and adjudicate timber crimes, whether structural, behavioral, or otherwise. The consultant should identify both country-specific and cross-cutting (regional) gaps and challenges.
  3. Conduct comparative analysis across jurisdictions of the strengths and weaknesses of the justice systems’ handling of timber-related crimes, from identification and investigation to case-building, prosecution, and sentencing.
  4. Offer clear recommendations on targeted interventions, whether country specific or regional (e.g., legal and policy reforms, capacity-building initiatives, resource allocation, the establishment of specialized units or task forces to handle timber crime cases, financial incentives to permit illegal timber activities, etc.).
  1. Conduct validation exercises with regional stakeholders’ multiple times throughout the research project lifecycle. Consultant(s) should develop a clear framework for engaging regional stakeholders in the research process. Present the findings at a regional convening of justice-sector actors in Zambia (likely December 2025) following the finalization of the analysis to build consensus and support for project activities and to support potential next-step policy and legal reform efforts.

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 and knowledge of the legal and justice system, court operations and procedural law in Angola, Mozambique and/or Zambia.
  • Demonstrated experience designing and conducting gap or needs analyses from assessment initiation to final publication.
  • Demonstrated experience in qualitative data collection, including stakeholder interviews,
  • Proven success in performing desk reviews as well as gathering and analyzing both qualitative and quantitative data from primary and secondary sources
  • Strong analytical, communication, 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 courts, lawyers, prosecutors and other justice sector actors and mechanisms in Angola, Mozambique and/or Zambia.
  • 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 civil society sector.
  • 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 in the target countries.
  • Fluency in English is required; Portuguese (written and spoken) 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 February 1, 2025.

Expression of Interest: Please submit the following:

  • Curriculum Vitae for each member 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 assignment
  • 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.912MBMemory Usage1.7sRequest 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
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745821654 "last" => 1745821654...
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) (217ms)
  • afterInitialise (11.08MB) (405ms)
  • afterRoute (5.03MB) (127ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (279μs)
  • afterRenderComponent com_jsjobs (3.14MB) (106ms)
  • Before Access::preloadComponents (all components) (239.64KB) (8.32ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.29ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (25μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (405μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (130ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (438ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (8μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (23.47ms)
  • afterDispatch (79.41KB) (159μs)
  • afterRender (13.77MB) (240ms)
  • 1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (25.78%)
    437.55ms
    1 x afterInitialise (11.08MB) (23.87%)
    405.06ms
    1 x afterRender (13.77MB) (14.11%)
    239.52ms
    1 x afterLoad (4.12MB) (12.78%)
    216.82ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (7.68%)
    130.31ms
    1 x afterRoute (5.03MB) (7.5%)
    127.25ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (6.23%)
    105.75ms
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (1.38%)
    23.47ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (0.49%)
    8.32ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.08%)
    1.29ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.02%)
    405μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.02%)
    279μs
    1 x afterDispatch (79.41KB) (0.01%)
    159μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    25μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    8μs
90 statements were executed, 23 of which were duplicates, 67 unique92.15ms288.2KB
  • SELECT @@SESSION.sql_mode;55μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?147μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1140μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)25.38ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`150μs1.59KB/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` = :guest409μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'84μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`79μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'179μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config136μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'188μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'73μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'72μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'71μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Gap-Analysis-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Gap-Analysis-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Gap-Analysis-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC242μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Gap-Analysis-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Gap-Analysis-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-ABA-ROLI-Gap-Analysis-Angola%2C-Mozambique%2C-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC341μ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.id199μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'336μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'305μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'269μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'353μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'287μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'93μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'142μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'357μ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 = 67069804μs20.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'372μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 670698.26ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'315μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering368μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'333μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'293μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering331μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'344μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'303μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'141μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'122μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'394μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'262μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'90μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'89μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2185μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2164μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'587μ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'589μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2192μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2185μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2176μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'314μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'326μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'262μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering231μ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)831μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0246μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22193μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24197μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28185μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38158μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39158μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40165μ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` = 0125μ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.lft573μ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.lft387μ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.lft597μ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-Gap-Analysis-Angola,-Mozambique,-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069' AND `published` = 1320μ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-Gap-Analysis-Angola,-Mozambique,-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069'151μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration330μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'154μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field166μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'120μ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` = 1185μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'217μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`336μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'104μ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 desc206μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`398μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid148μ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` = :muserid234μ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-Gap-Analysis-Angola,-Mozambique,-Zambia-tender-at-American-Bar-Association-Rule-of-Law-Initiative-67069'147μ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` = 185μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"367μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.15ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin151μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin107μ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`157μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'161μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'303μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 3990107μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?114μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?36.3ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy