Array
(
    [total_jobs_in_db] => 23
    [active_jobs] => 23
    [jobs_found] => 0
    [sql] => SELECT 
    j.id, 
    j.title, 
    j.slug, 
    LEFT(j.description, 300) as description, -- Truncate for display
    j.salary_min, 
    j.salary_max, 
    j.salary_currency,
    j.location_type, 
    j.city, 
    j.country,
    j.experience_level, 
    j.is_featured, 
    j.is_urgent,
    j.created_at, 
    j.published_at, 
    j.application_deadline,
    j.total_vacancies,
    j.status,
    e.id as employer_id, 
    e.company_name, 
    e.company_logo, 
    e.is_verified,
    jt.name as job_type_name, 
    jt.slug as job_type_slug,
    jc.name as category_name, 
    jc.slug as category_slug,
    (SELECT COUNT(*) FROM applications a WHERE a.job_id = j.id) as application_count
FROM jobs j
LEFT JOIN employers e ON j.employer_id = e.id
LEFT JOIN job_types jt ON j.job_type_id = jt.id
LEFT JOIN job_categories jc ON j.category_id = jc.id
WHERE j.status IN ('active', 'published')
ORDER BY 
    j.is_featured DESC,
    j.is_urgent DESC,
    j.created_at DESC
    [params] => Array
        (
        )

)