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 ')) AND( ((DisplayOn LIKE 'D,%') OR (DisplayOn LIKE '%,D') OR (DisplayOn ...' at line 4. SQL query:
SELECT *
FROM gs_product_option
WHERE ('P'='' OR Status='P')
AND (CategoryID=0 OR CategoryID IN (58,))
AND( ((DisplayOn LIKE 'D,%') OR (DisplayOn LIKE '%,D') OR (DisplayOn LIKE '%,D,%') OR (DisplayOn = 'D')))
AND (0=0 OR ProductOptionID!=0)
ORDER BY Ordering ASC