Re-Advertisement: Call For Proposals Job at United Nations Educational Scientific and Cultural Organisation (UNESCO) - Career Opportunity in Zambia
Website :
1721 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Re-Advertisement: Call For Proposals

[ Type: FULL TIME , Industry: Public Administration, and Government , Category: Management ]

Jobs at:

United Nations Educational Scientific and Cultural Organisation (UNESCO)

Deadline of this Job:
04 September 2020  

Duty Station:
Within Zambia , Zambia , South - Central Africa

Summary
Date Posted: Wednesday, August 26, 2020 , Base Salary: Not Disclosed


JOB DETAILS:
RE-ADVERTISEMENT: CALL FOR PROPOSALS: Evaluation of the Ministerial Commitment on comprehensive sexuality education and sexual and reproductive health services for adolescents and young people in Eastern and Southern African (ESA)
Background and Context:
A commitment for positive health outcomes for all young people in East and Southern Africa was endorsed and affirmed in 2013 by Ministers of Education and Health from 20 ESA countries. Together they agreed to work collaboratively towards a vision of young Africans who are global citizens of the future, who are educated, healthy, resilient, socially responsible, informed decision-makers, and have capacity to contribute to their community, country, and region. The countries that affirmed the commitment are Angola, Botswana, Burundi, Democratic Republic of Congo, Ethiopia, Kenya, Lesotho, Madagascar, Malawi, Mauritius, Mozambique, Namibia, Rwanda, Seychelles, South Africa, South Sudan, Swaziland, Uganda, United Republic of Tanzania, Zambia, Zimbabwe.
The ESA Commitment, as it is known, is a response to the circumstances of the region’s adolescents and young people aged 10 to 24 years and numbering around 199 million. They face many sexual and reproductive health (SRH) challenges, including early and unintended pregnancy, HIV and sexually transmitted infections (STIs), gender-based violence (GBV) and child marriage, discrimination and low access to quality friendly health services – all of which can undermine education opportunities, especially for girls, and affect future health and opportunities.
The ESA Commitment has time-bound targets agreed upon by member states which paved the way for actions to scale up delivery of sexuality education and related health services; supported joint action around developing programmes and sharing information; integration of services and reinforced linkages and referrals between schools and health services; and fostered an overall approach which facilitates access and equity and strengthens national responses to HIV and adolescent sexual and reproductive health and rights (ASRHR).
The ESA Commitment process was co-led by the East African Community (EAC) and the Southern African Development Community (SADC), with support from the United Nations Educational, Scientific and Cultural Organization (UNESCO), the Joint United Nations Programme on HIV and AIDS (UNAIDS), theUnited Nations Population Fund (UNFPA) and other UN partners. The Commitment also drew on the support of Civil Society Organizations (CSOs), and religious and youth leaders. To drive the ESA Commitment at regional level, a High-Level Group (HLG) was created, composed of regional leaders in education, sexual and reproductive health and rights (SRHR), HIV prevention, and development. Assisting the HLG is a Technical Coordinating Group (TCG), whose key task is to provide technical, administrative, and financial support to the ESA Commitment process. Having developed a Regional Accountability Framework (RAF) that breaks down the ESA Commitment targets into several processes and outcome indicators, the TCG has been instrumental in tracking progress through a harmonized monitoring and evaluation (M&E) system.
Purpose and scope of the Evaluation
After six years of implementation, an evaluation of the Commitment is needed to assess the effectiveness of the Commitment in achieving targets and improving outcomes for young people. The overall objective of the evaluation is to assess the results, take stock of progress and generate knowledge and evidence from the ESA Commitment implementation experience in 21 member countries and their respective Ministries of Health and Education. The overall purpose of the evaluation is to assess the processes and achievements made through the ESA Commitment efforts in order to draw lessons that will inform the rationale for the extension of the ESA Commitment to 2030 to align with Agenda 2030. The evaluation is intended to be forward looking and will provide information on the nature, extent and where possible, the effect of the ESA Commitment to the sexual and reproductive health and rights of adolescents and young people in East and Southern Africa, while also forming a baseline for a possible extension of the commitment beyond 2020.
The evaluation will cover the entire implementation period from 2013 to 2020. It will assess the progress made in the specific areas of the ESA Commitment Accountability Framework, review the achievements or lack thereof in meeting the targets set for 2015 and 2020 and assess the efficacy of the multi-sectoral mechanisms employed to realize the Commitment. While the evaluation will cover the experiences of each member country, in-depth study will be conducted in ten (10) purposefully selected countries from East Africa and Southern Africa and best practices will be documented and disseminated. The size sample of key informants and focus groups discussions as well as survey respondents should total to a minimum of 100 per each one of the 10 countries, where the in-depth analysis will be conducted. It is recommended the following estimation to guide the definition of the sample:
1. Minimum of 10 Key informant interviews for each one of the 10 selected countries;
2. A minimum of 2 FGDs with a maxi
mum on 8 participants for each one the of the FDGs in each one of the 10 selected countries; 3. A minimum of 74 responses to the survey that will be administered on-line to students, teachers, parents, community leaders, CSOs and traditional and religious leaders. .

Specific objectives of the evaluation include the following:
1. Relevance
The evaluation should assess the design and focus of the ESA Commitment Accountability Framework and review the extent to which the objectives of the Commitment are consistent with the needs and priorities of adolescents and young people, the implementation partners, and key stakeholders within the member states. Questions to be answered here include, but not limited to the following:
• How has the ESA Commitment influenced the development of national ASRHR policy, strategy and plans?
• How has the ESA Commitment influenced national priorities aiming at fulfilling adolescent and young people sexual and reproductive health rights?
• To what extent has the target group been involved in the ESA commitment coordination processes in the country? Have the target populations/primary beneficiaries been reached?Why or why not?
• To what extent are the interests, voices and priorities of adolescents and young people taken into consideration in planning and implementation of the interventions?
• Has a participatory/coordination methodology been applied as a means to achieve a larger degree of ownership by the countries?
• How do stakeholders and target groups perceive the ESA Commitment and contributions made toward improving the sexual reproductive health and rights of adolescents and young people? What is the perceived value going forward?
• To what extent are issues of rights to Sexual and Reproductive Health (SRH) and HIV prevention for young key populations, particularly LGBTI considered?
• Did the implementation of the ESA Commitments benefit from the support of the partners? If yes, who are the key stakeholders?
2. Effectiveness
The evaluation will assess how the ESA commitment ‘operationalization’ processes that were put in place at regional and national level have been effective in coordinating the achievement of the commitment in the different countries. Questions to be answered include the following:
• To what extent did the Technical Coordinating Group mechanism contribute in meeting results?
• What results were achieved (quality and extent)? How were the results achieved? How do they respond to the targets set in the accountability framework?
• What factors contributed to effective achievement of results, across the different country contexts?
• How effective has the Accountability Framework been in responding to the needs of the beneficiaries?
• What challenges were faced during implementation of the commitment and how can they be used to improve future plans in accessing services to the target group?
• What are the future intervention strategies and issues?
• Are there any examples of unintended results (positive or negative) from project implementation?
3. Efficiency
The evaluation will assess the efficiency of ESA Commitment implementation in terms of how country investments in the areas of the commitment have converted to results. Questions to be answered include the following:
• Have countries budgeted for the realization of the targets set by the accountability framework? If so, to what extent is the investment justified by its actual results so far?
• To what extent have countries been able to coordinate all the relevant initiatives under the umbrella of the ESA Commitment?
• What is the added benefit of a regional commitment / HLG/ TGC to achieving targets of the Commitment?
• Have the interventions been brought to scale for optimal impact?
• Are the national coordination mechanisms multi-sectoral in nature and do they include planning and fiscal Ministries such as Finance and Economic Planning?
• What challenges if any have been experienced in project implementation?
4. Sustainability
The evaluation should also examine the sustainability of national interventions designed to achieve the ESA Commitment’s targets. Questions to be answered include the following:
• What is the likelihood of continuation and sustainability of the key interventions undertaken by countries and partners to achieve the ESA Commitment targets beyond the year 2020?
• What are the strategies put in place at the national level to sustain the implementation of key interventions beyond 2020?
• Are the results achieved under the umbrella of the ESA Commitment sustainable at national level?
• What was the degree of involvement of private sector/civil society organizations in the implementation of ESA commitment as they are major service providers in health and education sectors?
• Are the ESA Commitment interventions/targets integrated into and prioritized in the national development strategies and UN Sustainable Development Cooperation Framework at the Country level?
• What are the opportunities for sharing and exchanging of best practices for replication and scale up within the countries in the ESA regions?
5. Emerging issues
The evaluation should not only look into the results achieved against the accountability framework but will also generate the necessary information for a possible extension including emerging issues relevant to the core of the commitment and not yet included. Questions to be answered include the following:
• If you had to recommend for the extension of the ESA Commitment beyond the year 2020, what are key areas of work that you would like to include? Why?
• Please give us a list of three (3) main areas of work that need to be included in the ESA commitment to ensure the full realization of adolescents’ sexual and reproductive health and the principle of leaving no one behind?
• Are there good practices/lessons learned that have emerged from the synergies and complementarities among the participating countries in form of South-South Cooperation?
Methodology for Evaluation
This evaluation will be conducted virtually. No field-work is expected in the countries or communities due to the uncertainty due to the COVID-19 pandemic. A mixed-methods approach is desired for this evaluation. It is expected that the evaluation will gather both quantitative and qualitative data on the ten commitments, the nine targets of the commitment and the individual elements of the Accountability Framework. As such, the evaluation is expected to use a combination of methods, including but not limited to the following:
• Desk study and review of all relevant documentation including the ESA Commitment documents, annual work-plans, annual progress reports, mid-term review report, reports of the High-Level Group and the Technical Coordinating Group
• Desk study, review and sub-analysis of relevant secondary data, including Demographic and Health Surveys (DHS), Multiple Indicator Cluster Surveys (MICS) and other population surveys and studies, for all ESA Commitment member states
• In virtual depth interviews to gather primary data from key stakeholders using a structured methodology and interviews with relevant key informants
• Virtual Focus Group discussions with beneficiaries and other stakeholders
• On-line administration of surveys to the selected sample.
A Results-Based Management approach will be applied considering not only progress toward the targets set, but quality and the logic of the commitment, as well as its consequences. The approach would allow us to analyze why intended results have or have not been achieved. It will help to identify gaps and bottlenecks and enable assessment of specific causal contributions of outputs to outcomes, examine the implementation process and explore unintended results. The results-based approach will also ensure the measurement of relevance of the action and ownership of the programme and it will offer recommendations for improvement.
Expected Deliverables
Deliverable 1: An inception report which contains the objectives and scope, description of methodology/methodological approach, data collection tools, data analysis methods, key informants/agencies, review questions, performance criteria, work plan and reporting requirements including ethical approval requirements and tools for submission. It should include a clear matrix relating all these aspects and a desk review with a list of the documents consulted as well as a quality assurance plan.
Deliverable 2: Draft report to be shared with key stakeholders for comments whose structure follows Introduction, Methodology, Analysis, Key challenges/Opportunities, Lessons Learned, Key Recommendations, Conclusions and Annexes.
Deliverable 3: Presentation of the draft report: develop and present a PowerPoint presentation showing preliminary findings, lessons learned and recommendations to the ESA Commitment’s key stakeholders. Comments made by the key stakeholders will inform the draft report.
Deliverable 4: Final evaluation report incorporating all comments received and a final PowerPoint Presentation summarizing the report.
Deliverable 5: Master presentation of the findings and recommendations.
Required expertise and qualification
I. Firm/Entity


Job Skills: Not Specified


The firm should fit or exceed the following profile(s)
Mandatory
• It is mandatory for Firm/Entity to have a minimum 5 years of global/international experience in programme/ project evaluation. Firm/entity with less than the required number of years of experience will be disqualified
• It is mandatory for Firm/Entity to be registered in Africa, or have affiliation with an Africa based Firm/Entity with presence in the majority or all the countries where the evaluation will be undertaken.
• Proven experience in submitting research protocols for ethical approvals in countries, supported by at least two references
Desirable
• It is desirable for Firm/Entity to have designed and implemented a minimum of three (3) evaluations at regional level in the field of adolescent and young people sexual and reproductive health and rights
• It is desirable for a Firm/Entity to have worked in the past on a project/assignment with the UN System or Regional Economic Communities
• It is desirable for a Firm/Entity to have at least one (1) partner firm in half of the target countries (5 or more).
The firm will be required to submit one sample of previous similar work produced and proof of registration.
II. Team leader
The team of consultants should have the following profile(s).
Mandatory
• It is mandatory for the Team Leader to have at least an advanced degree in one of the following fields: Public health, Demography, Development Studies, Health Economics, Social Sciences, or other related studies; a PhD will be an added advantage;
• It is mandatory for the proposed Team Leader to have minimum 10 years of programme and project evaluation experience at regional/global/international level.
Desirable
• It is desirable for firm to propose a Team Leader with experience in the field of adolescent and young people sexual and reproductive health and rights at the regional and international level
• It is desirable for the Team Leader to have proven experience and skills in developing policy, strategic documents and conducting complex evaluation in Africa at regional and national levels within UN, EAC and SADC
• It is desirable that the Team Leader has experience relating to evaluation methodologies and techniques to be used, supported by at least three (3) references
III. Senior Evaluation Expert (specify if different from Team Leader)
• It is mandatory for the Senior Evaluation Expert to possess a Master’s Degree in Population, Demography, Statistics, Public Health, Development Studies or other related studies;
• It is mandatory for the Senior Evaluation Expert to have 7 years of experience in project/program evaluation at regional or national level;
• It is mandatory for the Senior Evaluation Expert to demonstrate proven experience in conducting reviews and evaluations involving adolescents and young peoples’ sexual and reproductive health and rights, supported by at least three (3) references
• It is desirable for the Senior Evaluation Expert to demonstrate experience and skills in knowledge base creation and ability to develop systems for improved performance, supported by at least two (2) references


Job Education Requirements: Not Specified


Job Experience Requirements: Not Specified


Work Hours: 8

 

{module 312}

Job application procedure
All interested consultants/firms are requested to submit a proposal:
• Explaining their competencies to meet the requirements of the assignment;
• Explaining, in detail, the proposed methodology to be used in carrying out the assignment, including sampling strategy (not just sample size but also urban, rural, age, sex disaggregation, etc.);
• Providing the a workplan with expected duration of the assignment and dates of availability; roles and competencies of core team members;
• Providing a detailed professional budget in USD (Indicate daily professional rates and days);
• Attaching brief technical bio data of core team members;
• Providing evidence of similar work undertaken recently (Not more than 5 years old) and references.
Management Arrangement
The Evaluation Team will report to the Technical Coordinating Group under the leadership of SADC and EAC. M&E Advisors from the participating UN agencies will provide technical guidance on the evaluation and ensure independence of the evaluation process, and that policy is followed.
UNESCO, UNFPA, UNAIDS,
WHO, UNDP and UNICEF will manage the evaluation and provide logistical support under the overall guidance of SADC Secretariat and the East Africa Community.
Financial bid
The financial bid will have to include the following items (not exhaustive list) and ensure alignment with the proposed methodology:
1. Human resources costs
2. Ethical approval costs (expedite processes to be considered)
3. Data collection and analysis costs
4. Desk review and sub-analysis of relevant data costs
5. Quality assurance plan costs 6. Overheads costsbr/
> Important: Upon recruitment of the successful Firm/Entity, deliverables will be broken down based on each agency’s financial contribution. The Firm/Entity will then enter into bilateral contractual agreements with each individual agency.
10. Submission of proposal
Interested Consultants to submit technical and financial proposals via email to: vacancies.harare@unesco.org  no later than 4 September 2020 (Midnight CAT). Emails to reflect Ref: HAR/ED/HIV/ESA Commitment Evaluation (Re-advertised)


All Jobs

QUICK ALERT SUBSCRIPTION

{module 316}

Job Info
Job Category: Administrative jobs in Zambia
Job Type: Full-time
Deadline of this Job: 4 September 2020
Duty Station: Zambia
Posted: 26-08-2020
No of Jobs: 1
Start Publishing: 26-08-2020
Stop Publishing (Put date of 2030): 26-08-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.316MBMemory Usage628msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-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" => 1747166855 "last" => 1747166855...
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) (28.12ms)
  • afterInitialise (11.09MB) (90.97ms)
  • afterRoute (5.03MB) (37.08ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (239μs)
  • afterRenderComponent com_jsjobs (3.19MB) (39.81ms)
  • Before Access::preloadComponents (all components) (251.64KB) (7.88ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.04ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (21μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (331μs)
  • afterDispatch (2.38MB) (109ms)
  • afterRender (31.55MB) (312ms)
  • 1 x afterRender (31.55MB) (49.72%)
    312.46ms
    1 x afterDispatch (2.38MB) (17.32%)
    108.86ms
    1 x afterInitialise (11.09MB) (14.48%)
    90.97ms
    1 x afterRenderComponent com_jsjobs (3.19MB) (6.34%)
    39.81ms
    1 x afterRoute (5.03MB) (5.9%)
    37.08ms
    1 x afterLoad (4.12MB) (4.47%)
    28.12ms
    1 x Before Access::preloadComponents (all components) (251.64KB) (1.25%)
    7.88ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.17%)
    1.04ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    331μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    239μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    21μs
89 statements were executed, 23 of which were duplicates, 66 unique45.53ms334.22KB
  • SELECT @@SESSION.sql_mode;66μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?122μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1103μ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)762μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`101μ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` = :guest141μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'117μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`89μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'192μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config122μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'92μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'84μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'75μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'75μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Re-Advertisement%3A-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Re-Advertisement%3A-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Re-Advertisement%3A-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC223μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Re-Advertisement%3A-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Re-Advertisement%3A-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Re-Advertisement%3A-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC328μ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.id167μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'355μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'258μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'223μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'357μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'209μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'227μ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 = 18774765μs76.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'254μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 187741.28ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'267μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering348μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'212μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering257μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'271μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'264μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'100μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'80μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'229μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'89μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'77μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2170μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2168μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'498μ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'523μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2172μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2140μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2165μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'345μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'261μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering221μ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)654μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0147μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22106μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24141μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28135μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38323μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40168μ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` = 01.6ms1.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.lft539μ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.lft290μ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.lft651μ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-Re-Advertisement:-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774' AND `published` = 1260μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Re-Advertisement:-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774'142μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration325μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'152μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field135μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'125μ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` = 1145μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'203μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`346μ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 desc201μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`430μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid163μ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` = :muserid155μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Re-Advertisement:-Call-For-Proposals-Job-at-United-Nations-Educational-Scientific-and-Cultural-Organisation-UNESCO-Career-Opportunity-in-Zambia-18774'152μ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` = 1100μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"444μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.16ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin146μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin114μ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`115μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'145μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'307μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 372288μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?127μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?22.51ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy