You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND active='y' ORDER BY name' at line 1SELECT companies.* FROM companies, brand_company_link WHERE companies.id=brand_company_link.company_id AND brand_company_link.id = AND active='y' ORDER BY name