SRO-International Consultant–Design and Delivery of a two-week capacity building workshop on Trade in Services statistics tender at United Nations Economic Commission for Africa (UNECA)
564 Days Ago
Linkedid Twitter Share on facebook
Result of Service

A two-week capacity building workshop on Trade in Services statistics and Informal Cross-Border Trade (ICBT) measurement methodologies in Mozambique.

Work Location

Remote

Expected duration

Three Months

Duties and Responsibilities

PROJECT BACKGROUND:

In its role both as a think-tank and as a provider of technical assistance to African member States, the United Nations Economic Commission for Africa (ECA) assumes the lead technical and coordinating role within the United Nations system for supporting African countries to become AfCFTA-ready, as part of deepening Africa’s trade integration through domestication and effective implementation of the Agreement establishing the AfCFTA. An important complementary component of this initiative is to strengthen capacities of member states in the development and regular updates of trade statistics databases in order to inform evidence-based policy analysis.

 

Against this background, the Government of Mozambique, through its Ministry of Industry and Trade (MIC) has requested the ECA through its Subregional office for Southern Africa (SRO-SA) to strengthen capacities of the Government of Mozambique to compile formal trade statistics aligned with International Merchandise Trade Statistics 2010, (IMTS 2010) and using Eurotrace as the software to produce and maintain formal trade statistics for Mozambique in the area of goods and for alignment with the Manual on Statistics of International Trade in Services 2010 (MSITS 2010) in the area of services. This request was formulated as a follow up to Phase One of a project titled “Technical assistance to the Government of Mozambique to develop an integrated data management system on External Trade Statistics in the context of the African Continental Free Trade Area (AfCFTA)”.

The current request will be funded under a project titled “Strengthening Capacities in Trade in Services Statistics for Southern African member States: Mozambique and Namibia”. The overarching objective of this project is to strengthen trade statistical capacities and availability of trade statistics in two SROSA member states, namely Mozambique and Namibia through trainings of officials to collect, process and produce up-to-date trade and tourism data. The project, which will end on 31 December 2023, consists of two broad outcomes as follows:

OC1: Strengthened capacities of government officials and enumerators to compile trade statistics including trade in services statistics

OC2: Enhanced availability of trade statistics in Mozambique and Namibia through the conduct of surveys and updated databases/trade portals with production of new trade reports

Due to a significant scaled-down budget, the component for Mozambique will focus only on the achievement of OC1 whose two planned activities were as follows:

Under Component one (Mozambique)
1. Government Officials from MIC, INE, Bank of Mozambique and Customs will be trained and refreshed on the compilation of formal trade statistics and the use of Eurotrace to compile formal merchandise trade statistics;
2. Fieldwork staff (enumerators) will be trained on data collection of trade in services statistics (focus on travel) and informal cross border trade statistics.

A capacity building workshop on formal trade statistics and Eurotrace was held in the context of this project from 22 May to 2 June in Maputo, Mozambique addressing No.1. in the above.

The ECA SRO-SA, in collaboration with the ECA African Center of Statistics (ACS), held a series of consultative meetings between June and August 2023 with the MIC, the National Institute of Statistics (INE), the Central Bank of Mozambique and the Customs Authorities to discuss the further implementation of the current project. Based on these consultations, it was agreed to recruit an International consultant to organize a two-week capacity-building workshop, among others, on Eurotrace, trade in services statistics, management of foreign trade database and Balance of Payments data. Furthermore, given that the INE, Central Bank and Customs are collaborating to implement an Informal Cross-Border Trade Survey in Mozambique, training of enumerators and staff at these institutions and MIC in the area of informal cross-border trade measurement methodologies will be relevant. In this context, the ECA SRO-SA, in collaboration with the ECA ACS, is seeking to recruit an international consultant to design and deliver a two-week capacity building workshop in Maputo, targeted at staff (especially statisticians and trade analysts) and enumerators from MIC, INE, Central Bank and Customs in order to train them in the area of trade, Balance of Payments data, trade in services statistics, and ICBT statistics and relevant measurement methodologies.

DUTIES AND RESPONSIBILITIES:
Under the general supervision of the Chief, Subregional Initiatives Section, SRO-SA and the direct supervision of the Economic Affairs Officer, Subregional Initiatives Section, SRO-SA, the Successful Consultant will have the following list of duties and responsibilities:

1. Hold consultations with INE, MIC, Central Bank, Customs, and ECA to design the two-week capacity building workshop, defining objectives, planned outcomes and training activities in order to submit to ECA the concept note and agenda of the two-week workshop that should be held no later than 30 November 2023 along with the module contents.
2. Prepare and deliver the technical materials of the two-week workshop with a focus on methodologies to be used to compile trade in services statistics, balance of payments statistics and ICBT statistics that are aligned to international standards;
3. Prepare the training modules of the workshop and submit to ECA the modules contents at least 15 days before the workshop; the modules should be in English and shall be translated to Portuguese by ECA.
4. Train at the workshop a group of enumerators and staff (max 25) on how to conduct trade in services and ICBT surveys, highlighting good practices and approaches to deal with bottlenecks;
5. Design and deliver break-out sessions and training activities within the workshop using approaches to foster learning and sharing of experiences and in order to understand the gaps in trade statistics in Mozambique;
6. Prepare a mission report and a workshop report detailing the results of the workshop;
7. Deliver a final report to ECA highlighting the challenges and gaps behind trade statistics compilation and utilization in Mozambique with recommendations on how to address the gaps and promote harmonization of trade statistics in Mozambique across the 4 institutions: INE, Central Bank, Customs and MIC.

Qualifications/special skills

Advanced University Degree (Master’s Degree or Equivalent) in statistics, economics, trade or a relevant field is required. A first-level University Degree in combination with two additional years of relevant experience may be accepted in lieu of the Master’s Degree.
A minimum of 5 years of relevant work experience in at least one of the following areas is required: trade statistics, trade in services, statistics, informal cross-border trade and international development.

Languages

English and French are the working languages of the United Nations Secretariat. For this consultancy assignment, fluency in English is required. Knowledge of the other is an advantage. Knowledge of another UN Language is an advantage. Fluency in Portuguese is an added advantage.

No Fee

THE UNITED NATIONS DOES NOT CHARGE A FEE AT ANY STAGE OF THE RECRUITMENT PROCESS (APPLICATION, INTERVIEW MEETING, PROCESSING, OR TRAINING). THE UNITED NATIONS DOES NOT CONCERN ITSELF WITH INFORMATION ON APPLICANTS’ BANK ACCOUNTS.

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

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.946MBMemory Usage541msRequest 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" => "a166594669290b1752572d119a95ffd0" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1745862729 "last" => 1745862729...
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) (25.9ms)
  • afterInitialise (11.13MB) (89.63ms)
  • afterRoute (5.03MB) (35.6ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (258μs)
  • afterRenderComponent com_jsjobs (3.11MB) (43.48ms)
  • Before Access::preloadComponents (all components) (235.64KB) (7.48ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.11ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (23μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (344μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (108ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (88.45ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (7μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (338μs)
  • afterDispatch (75.16KB) (125μs)
  • afterRender (13.77MB) (140ms)
  • 1 x afterRender (13.77MB) (25.85%)
    139.93ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.62MB) (19.95%)
    108.01ms
    1 x afterInitialise (11.13MB) (16.56%)
    89.63ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (16.34%)
    88.45ms
    1 x afterRenderComponent com_jsjobs (3.11MB) (8.03%)
    43.48ms
    1 x afterRoute (5.03MB) (6.58%)
    35.60ms
    1 x afterLoad (4.12MB) (4.78%)
    25.90ms
    1 x Before Access::preloadComponents (all components) (235.64KB) (1.38%)
    7.48ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.2%)
    1.11ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    344μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.06%)
    338μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.05%)
    258μs
    1 x afterDispatch (75.16KB) (0.02%)
    125μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    23μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    7μs
90 statements were executed, 23 of which were duplicates, 67 unique26.4ms288.23KB
  • SELECT @@SESSION.sql_mode;48μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?109μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 199μ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_id1.29ms992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`98μ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` = :guest101μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'94μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`74μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'177μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config117μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'76μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'62μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'73μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'53μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-International-Consultant%25e2%2580%2593Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-SRO-International-Consultant%25e2%2580%2593Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-International-Consultant%25e2%2580%2593Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC254μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-International-Consultant%25e2%2580%2593Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-SRO-International-Consultant%25e2%2580%2593Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-SRO-International-Consultant%25e2%2580%2593Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC267μ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.id241μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'346μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'238μ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'284μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'211μ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 = 51537609μs20.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'228μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 515378.12ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'246μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering305μ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'239μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering269μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'238μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'65μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'59μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'305μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'220μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'72μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'71μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2157μ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'549μ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'549μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2179μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2154μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2138μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'298μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering183μ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)638μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0108μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22120μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24124μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28105μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38114μs81.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39208μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40129μ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` = 073μ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.lft362μ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.lft266μ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.lft439μ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-SRO-International-Consultant–Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537' AND `published` = 1143μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-SRO-International-Consultant–Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537'128μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration250μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'166μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field100μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'74μ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` = 1120μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'192μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`277μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'110μ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 desc183μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`276μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid121μ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` = :muserid146μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-SRO-International-Consultant–Design-and-Delivery-of-a-two-week-capacity-building-workshop-on-Trade-in-Services-statistics-tender-at-United-Nations-Economic-Commission-for-Africa-UNECA-51537'112μ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` = 192μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"242μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES737μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin93μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin99μ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`100μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'108μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'260μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 509566μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?84μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?207μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy