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

select j.job_id,r.recruiter_company_name,r.recruiter_featured,r.recruiter_logo,r.recruiter_url,j.job_title,j.job_reference,j.min_experience,j.max_experience,j.job_location,j.job_state,j.job_state_id,j.job_country_id,re_adv,expired,j.job_salary,j.job_allowance,j.job_industry_sector,j.job_type,j.min_experience,j.max_experience,j.job_description,dd.indeed_id,dd.indeed_url,j.post_url,j.url,job_short_description,j.latitude,j.longitude,j.job_skills,c.country_name,c.country_code,zz.zr_id,zz.zr_url,j.job_source from jobs as j left outer join recruiter as r on (j.recruiter_id=r.recruiter_id ) left outer join recruiter_login as rl on (rl.recruiter_id=r.recruiter_id ) left outer join countries as c on (c.id = j.job_country_id) left outer join indeed_job as dd on (j.job_id=dd.job_id) left outer join ziprecruiter_job as zz on (j.job_id=zz.job_id) where j.recruiter_id=r.recruiter_id and r.recruiter_id=rl.recruiter_id and rl.recruiter_status='Yes' and j.job_id='886' and j.expired >='2024-09-19 17:07:13' and j.re_adv <='2024-09-19 17:07:13' and j.job_status='Yes' and ( j.deleted is NULL or j.deleted='0000-00-00 00:00:00')

[TEP STOP]