Undecided

An unexpected error occurred.

mysql error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'join OpportunityInterestNot n on n.opportunity_id = o.opp_id and n.user_id =...' at line 1] in EXECUTE("SELECT *, co.name as company_name FROM Opportunity o left join OpportunityInformation oi on o.opp_id = oi.oi_opp_id left join OpportunityAdminInfo oai on o.opp_id = oai.oad_opp_id left join OpportunityApplicationInfo opai on o.opp_id = opai.oai_opp_id left join OpportunityAuditionInformation oaui on o.opp_id = oaui.oau_opp_id left join Company co on oi.company_id = co.company_id left join Program po on oi.program_id = po.program_id left join OpportunityInterest i on i.opportunity_id = o.opp_id and i.user_id = left join OpportunityInterestNot n on n.opportunity_id = o.opp_id and n.user_id = where 1=1 and ((status = 1 and now() > publish_date) or (status = 4 and oai.created_by = )) and ifnull(i.interested,0) = '0' and ifnull(n.not_interested,0) = '0' order by publish_date desc limit 0,10 ")