>I tried to include all fields list in the group by clause, and still receiving error 1807 (invalid group by clause).
Remove all non-aggreage fields from your select excluding IDPARCELA. Run query to make sure that there is no errors in it. After that start adding fields one by one to the column list and group by until you find which one cause tyhe problem.
--sb--