SELECT Gh_fields.id AS fld_id, Gh_date.id AS date_id,;
  Gh_fields.table_id;
 FROM ;
     gh_fields,;
    gh_date;
 WHERE ( (  Gh_fields.table_id = (  3  );
   AND  Gh_date.rep_date >= CTOD("01.09.2007") );
   AND  Gh_date.rep_date <= CTOD("30.09.2007") );
   AND  Gh_date.hall_id = (  1  )

SELECT SUM(gh_data.data), foo.fld_id
FROM (SELECT gh_fields.id AS fld_id, gh_date.id AS date_id, gh_fields.table_id  FROM gh_fields, gh_date
         WHERE gh_fields.table_id= 3  
    AND gh_date.rep_date>=:start_date AND gh_date.rep_date<=:end_date 
    AND gh_date.hall_id=:id

) AS foo
            LEFT JOIN gh_data 
                        ON (foo.fld_id = gh_data.field_id AND foo.date_id =gh_data.main_id)
WHERE (gh_data.mode_id= 1  OR gh_data.mode_id IS NULL) 
GROUP BY foo.fld_id
ORDER BY foo.fld_id