An Error Was Encountered

Error Number: 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 ': group by prodrets.id_prod order by prodrets.LISTPRICE ASC' at line 3

SELECT * FROM prodrets, prop2types, types, complex, neighborhood WHERE prodrets.id_prod = prop2types.id_prod AND prop2types.id_type = types.id_type AND prodrets.a_complexid = complex.id_complex AND prodrets.a_areaid = neighborhood.id_neigh AND prodrets.a_status = 1 AND prop2types.id_type = 2http: group by prodrets.id_prod order by prodrets.LISTPRICE ASC