A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY c.SortOrder asc' at line 6

SELECT a.*, concat(b.fname, " ", b.lname) as member_name, b.image as p_mem_image, c.title as job_title, (select name from tbl_salutation where id=b.salutation) as salutaion, (select name from tbl_peoplegroup where id=b.PeopleGroup) as ppl_group FROM (tbl_staff a) INNER JOIN tbl_portalmembers b ON b.id=a.MemberID INNER JOIN tbl_jobtitle c ON c.id=a.job_title_id WHERE a.display='yes' and ((date(now()) between date(a.start_date) and date(a.end_date)) or((date(now())>=date(a.start_date)) and (date(a.end_date)='0000-00-00' or a.end_date is null))) and (a.diocese_id=1) and (a.organizationID =) ORDER BY c.SortOrder asc