A Database Error Occurred

Error Number: 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 'or t.tenSerID like "%," or t.tenSerID like ",%" or t.tenSerID like "%,,%") O...' at line 1

select t.*,l.locName as tenLocation,te.avail_option,te.exp_option,te.exp_time from tblTenant t left join tblLocation l on l.locID=t.tenLocID left join tblTenantAvail ta on t.tenID = ta.tenant_id and ta.is_deleted = 0 left join tblExpOption te on te.id = ta.avail_exp_id where t.tendisable=0 and (ta.is_deleted = 0 or ta.is_deleted is null) and (t.tenSerID like or t.tenSerID like "%," or t.tenSerID like ",%" or t.tenSerID like "%,,%") ORDER BY t.show_availability desc,ifnull(te.id,1000) asc,t.tenName

Filename: /home/bonnerbb9838/public_html/models/service_model.php

Line Number: 17