syntax error: SELECT DISTINCT p.* FROM table_giasearch AS p JOIN table_product AS m ON p.giatu <= m.gia and p.giaden >= m.gia WHERE (m.id_list = OR m.id_list1 like '%%' OR m.id_cat = ) AND p.hienthi = 1 AND m.hienthi = 1 ORDER BY p.id