SELECT "waylist_tech"."date_input_tech",   
         "tech_transport"."garage_number",
			"type_loader"."Type_Loader",   
			isnull("smen_point"."id_type_loader",1) as id_loader,         
			"load_point_ref_book"."ekg_name",   
         "unload_point_ref_book"."fall_name",   
         "rock_type_ref_book"."type_rock",   
         "smen_point"."number_trip" as trip, 
          "waylist_tech"."regime_of_work" as id_regim,
         round("smen_point"."middle_distance",2) as dist,   
         "cor_coefficient"."coeff_corr_temp" as k1,   
         ((Minutes(datetime('00:00:00'),"smen_point"."time_on_factory"))/[color=red]60.00[/color]) as time_fact,   
         "cor_coefficient"."coeff_corr_use" as k2,   
         "cor_coefficient"."tarif" ,
     
 (select "dba"."way_length"."mid_length"
    from "dba"."way_length"
   where ( "dba"."load_point_ref_book"."id_load_point" = "dba"."way_length"."id_load_point" ) and  
         ( "dba"."unload_point_ref_book"."id_unload_point" = "dba"."way_length"."id_unload_point" ) and  
         ( "dba"."rock_type_ref_book"."id_rock" = "dba"."way_length"."id_rock" ) and
         ("dba"."way_length"."middle_distance"=dist) and
         ( ( "dba"."way_length"."date_input_length" >= DATEFORMAT("waylist_tech"."date_input_tech",'yyyy-mm-01')))) as midl_length1 ,

(select ("dba"."way_length"."coeff_corr")
    from "dba"."way_length"
   where ( "dba"."load_point_ref_book"."id_load_point" = "dba"."way_length"."id_load_point" ) and  
         ( "dba"."unload_point_ref_book"."id_unload_point" = "dba"."way_length"."id_unload_point" ) and  
         ( "dba"."rock_type_ref_book"."id_rock" = "dba"."way_length"."id_rock" ) and
        ("dba"."way_length"."middle_distance"=dist) and("dba"."way_length"."middle_distance"=dist) and  
         ( ( "dba"."way_length"."date_input_length" >= DATEFORMAT("waylist_tech"."date_input_tech",'yyyy-mm-01') ) )) as k3 ,
  
     k1*k2*k3 as k,
     nsi_on_trips(0,id_regim,dist+midl_length1,id_loader)as id_min,
     nsi_on_trips(1,id_regim,dist+midl_length1,id_loader)as id_max,
     nsi_on_trips_pr((select isnull(nsi_way_length.NSI_LENGTH ,0) from "dba".nsi_way_length  where (nsi_way_length.id_nsi_way_length=id_min and nsi_way_length.id_type_loader=id_loader)),
(select isnull(nsi_way_length.NSI_LENGTH ,0) from "dba".nsi_way_length  where (nsi_way_length.id_nsi_way_length=id_max and nsi_way_length.id_type_loader=id_loader)),
(select isnull(nsi_way_length.nsi_num_trip ,0) from "dba".nsi_way_length  where (nsi_way_length.id_nsi_way_length=id_min and nsi_way_length.id_type_loader=id_loader)),
       (select isnull(nsi_way_length.nsi_num_trip ,0) from "dba".nsi_way_length where (nsi_way_length.id_nsi_way_length=id_max and nsi_way_length.id_type_loader=id_loader)),
      (dist+midl_length1))  as n_midl,
       [color=red]round(n_midl,2) as n_mid,[/color]
      [color=red] round(n_mid*k,2) as n_mid1,[/color]
       round(tarif*11/n_mid1,2) as sale_trip,
       round(time_fact*tarif,2) as zarp_fact,  
		 round(isnull(zarp_fact,2),2) +
		isnull((SELECT (round(isnull(round(tarif*11/n_mid1,2)*trip,0),2))WHERE isnull(time_fact,0)=0),0) as zarp
         


    FROM "waylist_tech",   
         "tech_transport",
			"type_loader",   
         "smen_point",   
         "load_point_ref_book",   
         "unload_point_ref_book",   
         "rock_type_ref_book",
         "density_rock_ref_book",
         "cor_coefficient"  
   WHERE ( "tech_transport"."id_automobile_t" = "waylist_tech"."id_automobile_t" ) and  
         ( "smen_point"."number_waylist_t" = "waylist_tech"."number_waylist_t" ) and
			( "type_loader"."id_Type_Loader"= isnull("smen_point"."id_type_loader",1)) and 
         ( "load_point_ref_book"."id_load_point" = "smen_point"."id_load_point" ) and  
         ( "unload_point_ref_book"."id_unload_point" = "smen_point"."id_unload_point" ) and 
         ( "smen_point"."id_density_rock" = "density_rock_ref_book"."id_density_rock" ) and   
         ( "rock_type_ref_book"."id_rock" = "density_rock_ref_book"."id_rock" ) and  
         ( "smen_point"."id_density_rock" = "density_rock_ref_book"."id_density_rock" ) and
         (("cor_coefficient" ."data_corr"= DATEFORMAT("waylist_tech"."date_input_tech",'yyyy-mm-01')) AND ( "waylist_tech"."date_input_tech" <= :dat2 ))and
         (( "waylist_tech"."date_input_tech" >= :dat1 ) AND  
         ( "waylist_tech"."date_input_tech" <= :dat2 ))
 
          
ORDER BY "tech_transport"."garage_number" ASC,   
        	"smen_point"."id_type_loader" asc,
			"load_point_ref_book"."ekg_name" ASC,
         "unload_point_ref_book"."fall_name" ASC,   
         "rock_type_ref_book"."type_rock" ASC