Can't execute query

SELECT FROM products_tw p, categories_tw c, products_category_tw as it WHERE = AND = it.category AND p.available = '1' AND c.available = '1'  AND brandType =   GROUP by

MySQL Error: 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 'GROUP by' at line 1

This script cannot continue, terminating.