Interventional, Non-Invasive and Invasive Cardiologists needed, signing bonus!
Oklahoma
Oklahoma
Error at 2026-01-27 20:02:20:
Query:
SELECT j.jobID, j.headline, j.state, j.dateposted, s.url AS specialtyUrl
FROM e_jobs j
LEFT JOIN specialties s ON s.specialtyID = j.specialtyID
WHERE j.status = 'published'
AND (j.valid_through IS NULL OR j.valid_through >= CURDATE())
AND j.jobID != 16338
AND (j.specialtyID = 6 OR j.state = 'Oklahoma') ORDER BY
CASE WHEN j.specialtyID = 6 THEN 1 ELSE 2 END,
CASE WHEN j.state = 'Oklahoma' THEN 1 ELSE 2 END,
j.dateposted DESC
LIMIT 3
Error: Unknown column 'j.valid_through' in 'where clause'