syntax error: select p.*, t.title, t.description, t.price, t.price_sale 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 (168) or brand_id in (168) ) and  enable>0 order by p.view, p.create_date desc, p.level, t.title