/job_search_by_industry.php
1525 - Incorrect DATETIME value: '0000-00-00 00:00:00'

select count(j.job_id) as x1 from jobs as j left outer join recruiter_login as rl on (j.recruiter_id=rl.recruiter_id) left outer join recruiter as r on (rl.recruiter_id=r.recruiter_id) left outer join zones as z on (j.job_state_id=z.zone_id or z.zone_id is NULL) left outer join countries as c on (j.job_country_id =c.id) where job_id in ( select distinct (j.job_id) from jobs as j left join jobs_job_category as jc on(j.job_id=jc.job_id ) where j.expired >='2024-10-04 08:40:50' and j.re_adv <='2024-10-04 08:40:50' and j.job_status='Yes' and ( j.deleted is NULL or j.deleted='0000-00-00 00:00:00') and jc.job_category_id in (26) ) and rl.recruiter_status='Yes' and j.expired >='2024-10-04 08:40:50' and j.re_adv <='2024-10-04 08:40:50' and j.job_status='Yes' and ( j.deleted is NULL or j.deleted='0000-00-00 00:00:00')

[TEP STOP]