syntax error: select t.*, p.*, t.price as price from tbl_product p join tbl_translate t on p.id=t.item_id where t.language_id like '1' and t.table_name like 'product' and ( category_id in (121, 123, 166, 167, 168) or brand_id in (121, 123, 166, 167, 168) ) and true and enable>0 order by p.view, p.create_date desc, p.level, t.title