Executed Query -> select jobs.id,jobs.awaiting_moderation,jobs.is_suspended,jobs.job_type,jobs.is_featured,jobs.company_id,jobs.job_title,jobs.employment_type,jobs.relavent_experience_from,jobs.relavent_experience_to,jobs.job_description,comp.company_logo,comp.company_name, i.industry_name, jcate.job_category, l.country_id,l.state,l.city1,concat(u.first_name,' ',u.last_name) as user_name,u.id as posted_user_id from tbl_jobs jobs left join tbl_companies comp on jobs.company_id = comp.id left join tbl_industries i on i.id = comp.company_industry_id left join tbl_job_category jcate on jobs.job_category_id = jcate.id left join tbl_locations l on jobs.location_id = l.id left join tbl_users u on u.id = jobs.user_id where last_date_of_application >= '2025-04-15' and jobs.is_suspended = 'n' and jobs.awaiting_moderation = 0 and jobs.status = 'a' and jobs.job_description != '' and jobs.apply_email != '' group by jobs.id order by cast(jobs.is_featured as char) desc, jobs.added_on desc