RFP for Installation of Off-Grid Solar Plant for Chimphanje Health Centre – PM26072024 tender at Engineers without Borders Zambia
Website :
175 Days Ago
Linkedid Twitter Share on facebook

Summary

EWB Zambia is collaborating with EWB Canada to implement the Engineering Brighter Tomorrow’s (EBT) project. This project aims at electrifying twelve (12) schools and health care facilities in Zambia and Malawi. Stakeholders’ engagement was carried out in April which informed a longlist of schools and health care centers in Zambia and Malawi.

A demand assessment was carried out to inform the design of the solar system. The roll out of the twelve sites would be preceded by a pilot project at Chimphanje Rural Health Center. Engineers Without Boarders Zambia expects to have solar power equipment installed at the above-mentioned sites. As a result Engineers Without Boarders Zambia is looking for Contractors to design and install Solar equipment at the above mentioned sites.The applicants will have the capacity, experience and qualifications to design, procure and install the solar power equipment. Engineers Without Boarders Zambia hereby invites any party that feels they could successfully undertake and complete one or more solar power projects to submit their proposals for consideration.

Background of the Project

Site Summary

Chimpanje Rural Health Centre

Chimpanje health care facility 40 km from Petauke turn-off and it is accessible by a graded gravel road about 8km from the Great East Road. Chimpanje Rural Health Centre has six (6) staff comprising of a Nurse in charge, a Nurse, a Community outreach officer, an Environmental Health Technician (EHT) and a watchman. The rural health centre is not connected to the grid, but the nearest grid connection line is a 33kV line along the great east road about 10 km from the health center.

Chimpanje has 4 staff houses, a maternity wing and a newly an almost completed mother’s shelter. An aerial view is shown below. There is no existing Mini Grid and therefore Localized roof top installations are recommended.

Design and Specifications

Specific Conditions

The table below summarizes the Daily KW demand and daily usage in Kwh for each Health center and school. The Kwh was arrived at by factoring in the loading pattern and the load profiles are provide in the appendix.

Facility Daily Demand kW:

Day 5.88kW

Night6.08kW

Total 11.96kW

Facility Daily Usage kWh:

Day 19.81kW

Night 17.42kW

Total 37.23kW

Requirements for Chimpjanje:

The Table below summarizes the requirements. The total Kwh usage is summarized in table

Equipment Quantity Nameplate Power (W)

Maternity Wing

Indoor Lighting 14 10

Outdoor Lighting 7 10

Water Heater / Kettle 2 2000

Sterilization Autoclave 1 3500

Infant Warmer 1 550

Newborn Incubator 1 1000

Phototherapy Unit, infant 1 180

SUBTOTAL

Outpatient Department

Indoor Lighting 6 10

Charging Socket 7 5

Outdoor Lighting 4 10

Pharmacy Charging Socket for Laptop 1 60

TV 1 75

Refrigerator 50l 2 100

Laptop Computer 2 60

Desktop Computer 1 90

Printer 1 800

SUBTOTAL

House for Nurse (2 Rooms) X 3

40” TV 3 100

Sound System/Radio 3 45

Decoder 3 25

Phone Charging Ports 24 5

Laptop 3 50

Indoor Lighting 6 7

Outdoor Lighting 6 10

SUBTOTAL

House for Nurse In Charge (7 Rooms)

40” TV 1 100

Sound System/Radio 1 50

Decoder 1 25

Phone Charging Ports 4 5

Fridge 1 100

Indoor Lighting 7 7

Outdoor Lighting 4 10

SUBTOTAL

House for EHT (3 Rooms)

33” TV 1 55

Sound System/Radio 1 50

Decoder 1 25

Phone Charging Ports 8 5

DC Fridge (189.8kWh/anum) 1 75

Indoor Lighting 3 10

Outdoor Lighting 4 10

SUBTOTAL

Water Supply

Pump 1m3/day, 80m head (Assumed) 1 1800

SUBTOTAL

TOTAL

Requirements:

1. Size and Specify the PV array for the facility factoring in Peak sunshine hours and PV derating due to temperature, dirt and Module Mismatch.

2. Size the appropriate Battery storage for the facility factoring in losses. Size the appropriate Charger with MPPT and appropriately sized Battery Bank. Lithium Ion Batteries are preferred.

3. Size appropriate Inverter(s) for the facility factoring in Inverter efficiency.

4. Size appropriate Centralized AC Distribution Board or feeder pillar with appropriately sized MCBs or MCCBS to feed the various utility points under each facility. There is an existing feeder Pillar at the Facility into which the Solar Plant may feed.

5. Support structures, foundations and housing for the Solar Plant inverters and Batteries.

6. Size cabling and all accessories needed to set the solar Plant to work.

7. Provide Protection for the Panels and inverters against lightening and earth the installations in accordance to Local wiring regulations and IEC standards for Solar Installations.

8. The Installations shall be appropriately earthed and have sufficient Lightening Protections. These will be done in accordance to ZABS and IEC standards for roof mounted solar installations.

9. The installer/supplier shall guarantee that daily energy production from their installations shall meet the daily energy requirements.

10. Produce design drawings for each system showing all system components for each facility.

11. Commission and set the system to work

General Conditions

The following list describes the components requested by Engineers Without Boarders Zambia for its projects. Engineers Without Boarders Zambia reserves right to amend the specifications and quantities of components based on Project needs, design change recommendations by the project engineers and installers.

Components List Summary

a) Solar Arrays 500- 550-watt standard (alternative sizes may be offered in addition to this requirement)

b) Solar Brackets, Rails and Mounting Hardware for asbestos and metal tilt roofs.

c) MC4 Connectors

d) PV Array Combiner Boxes suitable for the system size that it will service.

e) Combination Off-Grid Inverter/ MPPT Controllers sized to meet the system requirements for each facility.

f) Solar Batteries – 12 VDC, 200 AH gel cell maintenance free units or lithium ion batteries of equivalent voltage and characteristic sizes.

g) Battery Cabinets lockable design appropriate for each Facility.

h) Cable size and quantities as in 2.5 mm, 4 mm, 10 mm, and 16 mm copper stranded wire depending on ampacity in each case

i) Distribution Panels with appropriately sized MCBs, MCCBs, earthing and Lightening protection.

Design and Specification requirements

Design and Technical Specifications Each applicant must include the following technical information in their proposal.

1. All applicants must include the complete design, supply and installation of a solar system based on the requirements. Please note that the Kwh daily consumption was arrived at by factoring in the usage times and Load Factor thus it is not an accurate approximation to derive the usage hours using the given Kwh and Kw. Peak-Sun shine hours for each site will be used to determine the ac Kw and then factoring in losses to determine the Dc Kw requirement. The summary of the Load profiles is provided in the appendix.

2. The solar system may be designed to operate as a hybrid system with solar as P1 (Priority 1) and the existing utility as P2 (Priority 2) in cases where there is an existing Power sources.The photovoltaic (PV) panels will be mounted on selected roofs.

3. As part of an applicant’s proposal, the applicant must submit a Bill of Quantities that contains the following information on the technical specifications of the proposal:

a) The make, model number, manufacturer/provider/distributor name and/or other identifying information for each electrical and mechanical item used in the proposal.

b) The required number of each electrical and mechanical item needed to complete the installation.

c) The price per unit of each listed electrical and mechanical item.

d) The total price for the cost of these goods.

e) Schematic electrical drawings of the proposed solar power system.

f) Information on the proposed housing for storage of the power system’s batteries including information regarding the temperature control mechanisms that will be used to achieve the desired storage conditions.

g) A summary section that states the AC voltage output of the proposed solar power system (and indicates whether single phase or three phase).

h) The number of batteries needed to complete the proposed installation, the capacity of the battery system with power autonomy designed for a 24 hour (one day) autonomy period.

i) Engineers Without Boarders Zambia will work with each applicant to to verify the discharge test records for the Batteries recommended.

j) The warranty periods for both the proposed batteries and PV panels and the items covered under these warranties, together with information on any optional or extended warranties that may be available.

k) The maintenance schedule for the installation and the training that the applicant will offer (or will arrange to be offered) to end users.

l) Any other information regarding the technical specifications that the applicant considers important for evaluation purposes, such as the DC voltage of the solar system, the capacity of the charge controller, the capacity of the inverter, the number and rating of the PV panels or any other accessories that will support the installations (e.g., fuses, MCBs, tamper/theft-proof frame for the PV panels, cabling, etc.).

m) A delivery schedule, together with backup supporting documentation, for the needed equipment and material.

n) Each applicant must also submit the following non-technical information that will be used by the Evaluation Team to assess the relative capacity and qualifications of the applicant:

Other Non-Technical Requirements from the Bidders

o) A company profile that provides:

1. The physical and postal address for the applicant’s principal office in Zambia and, for international firms, its headquarters office and

2. The name, title, business and/or mobile phone numbers and an email address for one or more contact persons.

3. A description of the company that includes (i) a discussion of key staff member’s qualifications and experience, (ii) proof of the applicant’s capacity to implement projects of comparable complexity and (iii) any evidence of past experience in project of similar size.

4. The names of at least three companies or organizations for whom the applicant has recently designed and installed a Solar System If the Evaluation Team requests contact information for the applicant’s references, the applicant will provide Engineers Without Boarders Zambia with the requested contact information within two business days of the request.

5. Evidence of (i) sufficient cash or other easily liquidated financial reserves equal to at least, or (ii) access to a credit facility offered either by a reputable financial institution or equipment manufacturer of not less than, 30% of the overall proposal sum.

6. A copy of a valid tax clearance certificate (for local firms only).

7. Copies of the applicant’s certificate of company registration or incorporation and any certificate of amendment to that registration/incorporation, together with evidence that the company is in good standing.

8. A bid security or bond from a reputable and established bank or insurance company in Zambia equal to at least two percent (2%) of the overall cost of the applicant’s proposal.

9. A summary of the applicant’s experience in after sales customer service and post installation maintenance together with any terms and conditions generally applied by the applicant to these services.

10. A site Visit may be required and in this case the Bidders will Provide proof of site visit in their Bids.

Appendix A: Recommended BOQ Format

SN. Item Description Quantity Unit Unit Rate (ZMK) Total (ZMK)

1

500/550W Solar Panels Bidders to indicate the type of Solar Panels they are offering in their Proposals 26 Each

Attach the Technical Data sheets if the Solar Panels being offered.

Each Building will/may have its own Roof top installation. The Proposal to show clearly number of Panels for each installation or block

2 Sealed Deep cycle Maintenance Free batteries 200AH,12Vdc Attach technical data sheets 20 Each

Supply complete with terminal connectors and battery lugs 1 Lot

Attach discharge test curves for the Batteries proposed.

3 Inverter/MPPT Controller 18KVA,200A,48VDC 3 phase Attach technical data sheets

1 Each

Details for how the Inverter will be mounted

Protection provided for the inverter

Warranty for the inverter

Useful life

4 Array Mounting Array rails 1 LOT

Array Middle clamp LOT

Array end clamps LOT

Array Z or J Hooks LOT

Array Cap screws LOT

Array rail connectors LOT

Solar Panels Support Frame 1 Each

5 Battery Cabinet and support rack Supply complete with Battery lugs and Battery connectors 1 Each

6 PV Cables 2.5mm Solar PV Cable 1 LOT

4mm Solar PV Cable metres

10mm Solar PV Cable metres

16mm Solar PV Cable metres

7 MC4 Connectors 1 Lot

380Vac Feeder Pillar free standing complete with 630A MCCB ,15 X 100A MCCBS, Surge arrestor, neutral and earthing Bars to receive Power from the inverters 1 Each

8 220vac Distribution Boxes 12 way complete with 63A breaker, Surge arrestor and assorted MCBs 10 Each

9 16mm X 4 core armoured Cable 500 Metres

10 Allow for Excavations and Burying of armoured cables 500 Metres

11 Containerized substation with air conditioning to house inverters, batteries and feeder pillar 1 Each

12 Miscellaneous Electrical wiring of Light points and socket outlets and installation for DB boxes to receive Power from the central Solar Plant AC Feeder Pillar.

Allow for making well sub-standard electrical wiring.

To be split and shown clearly for each building Under each Health Post or school. 7 Each

13 Contingency 5% of total cost for each Lot. 1 Sum

14 Labour and Transport To be shown individually for each site considering installation for all lots may not take place at the same time. 1 Sum

Total

Appendix B: Bid Summary

LOT Facility Deliver, Supply, install and Commission Solar systems as Per specifications Total Cost $

1 Chimphanje Rural Health Center Refer to requirements

Appendix C: Load Profiles for the Facility

https://docs.google.com/spreadsheets/d/1EVjKCOXfRD0SXM0DKP1joTQF8pPG07vg/edit?usp=sharing&ouid=105318715207361904153&rtpof=true&sd=true

Email: ewb.zambia@gmail.com for any queries or to receive pdf of RFP .

Upload your bid to our drive on link or email is at ewb.zambia@gmail.com  with subject RFP Chimphanje Health Centre.

Job Info
Job Category: Management jobs in Zambia
Job Type: Full-time
Deadline of this Job: Tuesday, August 13 2024
Duty Station: Lusaka
Posted: 30-07-2024
No of Jobs: 1
Start Publishing: 30-07-2024
Stop Publishing (Put date of 2030): 30-07-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
64.232MBMemory Usage403msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.31
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.27-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" => 1737453772 "last" => 1737453772...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (17.66ms)
  • afterInitialise (11.93MB) (73.26ms)
  • afterRoute (5.26MB) (32.02ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (160μs)
  • afterRenderComponent com_jsjobs (3.19MB) (27.65ms)
  • Before Access::preloadComponents (all components) (259.64KB) (4.89ms)
  • After Access::preloadComponents (all components) (132.72KB) (865μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (234μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.5MB) (41.35ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.18MB) (62.68ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (263μs)
  • afterDispatch (95.35KB) (93μs)
  • afterRender (17.09MB) (141ms)
  • 1 x afterRender (17.09MB) (34.95%)
    140.73ms
    1 x afterInitialise (11.93MB) (18.2%)
    73.26ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.18MB) (15.57%)
    62.68ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.5MB) (10.27%)
    41.35ms
    1 x afterRoute (5.26MB) (7.95%)
    32.02ms
    1 x afterRenderComponent com_jsjobs (3.19MB) (6.87%)
    27.65ms
    1 x afterLoad (4.12MB) (4.39%)
    17.66ms
    1 x Before Access::preloadComponents (all components) (259.64KB) (1.21%)
    4.89ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.21%)
    865μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    263μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    234μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    160μs
    1 x afterDispatch (95.35KB) (0.02%)
    93μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    13μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    5μs
90 statements were executed, 23 of which were duplicates, 67 unique19.32ms288.2KB
  • SELECT @@SESSION.sql_mode;54μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?108μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 181μ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)850μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`82μ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` = :guest118μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'72μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`83μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'167μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config192μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'77μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'55μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'60μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'84μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-%25e2%2580%2593-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-%25e2%2580%2593-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-%25e2%2580%2593-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC179μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-%25e2%2580%2593-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-%25e2%2580%2593-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-%25e2%2580%2593-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC263μ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.id159μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'369μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'231μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'219μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'286μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'83μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'80μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'286μ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 = 63339732μs84.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'234μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 63339354μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'239μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering342μ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'272μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering285μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'290μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'251μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'114μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'281μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'44μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2131μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2117μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'342μ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'351μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2118μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2124μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 288μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'179μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'163μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering153μ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)622μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 086μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2285μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24101μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2872μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38131μs17.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39137μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40147μ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` = 0160μ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.lft308μ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.lft231μ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.lft352μ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-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-–-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339' AND `published` = 1160μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-–-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339'118μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration252μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'92μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field79μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'68μ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` = 1135μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'181μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`269μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'111μ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 desc172μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`338μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid109μ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` = :muserid102μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-RFP-for-Installation-of-Off-Grid-Solar-Plant-for-Chimphanje-Health-Centre-–-PM26072024-tender-at-Engineers-without-Borders-Zambia-63339'118μ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` = 1121μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"287μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES828μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin141μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin94μ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`93μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'103μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 744469μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?135μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?2ms912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy