SQL:
SELECT j.id as jid, j.job_name, j.post_date, j.application_date, o.id as oid, o.org_name, o.uid as ouid, o.imgext FROM job_positions as j LEFT JOIN org_profiles as o ON (j.org_id = o.id) LEFT JOIN system_users as u ON (o.uid=u.uid) WHERE j.active='true' AND o.active='true' AND u.active='true' AND j.application_date >= '2019-04-26 13:44:20'ORDER BY j.post_date DESC