Product not found!
1064 - 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 ')' at line 1

select u_brand_lookup.* from u_brand_lookup where mcmodel in (select body_type from products_to_model p2m join products_model pm on p2m.model_id = pm.model_id where products_id = )