SELECT task_num, name_project, name_task,process.name_process,projects.id_project, task.id_task, process.id_process,process.code_unit,class_unit.name as cname,
  process.cost,process.quantity_all,  '' as okato_name , count(tovar_p.id_process) as tovar_p_name,
   if(task_date_plan.date_plan <'1900:00:00' ,null,task_date_plan.date_plan) as dt1,
          if(task_date_plan1.date_plan <'1900:00:00' ,null,task_date_plan1.date_plan)   as dt2, process.file1m, count(tovar.id_process) as tovar,co.name_company as coname
  FROM (class_union,projects ,task,class_union_task)  
  inner JOIN (process,task_process)  ON (process.id_process = task_process.id_process AND task_process.id_task= task.id_task and process.parent_process =0 )
  left join process as tovar_p on  (process.id_process=tovar_p.parent_process)
  left join class_unit on number_code = process.code_unit

         left join (process as tovar, company as co) on co.id_company =tovar.id_company and  process.id_process=tovar.parent_process and tovar.id_project_product >0
  left join task_date_plan on task_date_plan.id_task_date_plan = process.date_begin_process
         left join task_date_plan as task_date_plan1 on task_date_plan1.id_task_date_plan = process.date_end_process
  WHERE   class_union.id_class_union= class_union_task.id_class_union and process.type_process=0 AND class_union_task.id_task=task.id_task  AND task.id_project = projects.id_project 
  AND class_union.id_company=@c and class_union.id_user =@u 
  GROUP BY process.id_process,task.id_task
         order by process.id_process