DM.ADOQ_DTJ32.SQL.Clear;
DM.ADOQ_DTJ32.Active:=false;
DM.ADOQ_DTJ32.sql.Add('select vagon_registers_id, vagon_num, order_num, date_order, order_num_dtj, date_order_dtj,');
DM.ADOQ_DTJ32.sql.Add('station_out_id,station_dosylka_id, station_in_id, goods_code_id,goods_mass, kontainer_num, kontainer_mass,tariff_summ,koef_vpk,ktj_summ,');
DM.ADOQ_DTJ32.sql.Add('dg.goods_short_name  as dg_name, ds1.station_name as ds1, ds2.station_name as ds2, ds3.station_name as ds3,');
DM.ADOQ_DTJ32.sql.Add('dc1.contragent_name  as consignor_name,dc2.contragent_name  as consignee_name,train_id,natural_list_num,');
DM.ADOQ_DTJ32.sql.Add('mt.moving_tipes_name as moving_type_id,dtj_distance.distance_length as len,rt.rent_name as rent_id,country_id,vagon_date_out,time_date_out,');
DM.ADOQ_DTJ32.sql.Add('vagon_date_in,time_date_in,vt.vagon_type_short as vagon_type_id,scan_name,scan_name_dtj,punkt_perexoda_id,pp.punkt_name as punkt_name,');
DM.ADOQ_DTJ32.sql.Add('row_number() OVER (PARTITION BY order_num ORDER BY date_order DESC) AS num');              //сортировка
DM.ADOQ_DTJ32.sql.Add('From Dtj_Reestr');
DM.ADOQ_DTJ32.sql.Add('left join dtj_stations ds1 on dtj_reestr.station_out_id = ds1.station_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_stations ds2 on dtj_reestr.station_dosylka_id = ds2.station_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_stations ds3 on dtj_reestr.station_in_id = ds3.station_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_goods dg on dtj_reestr.goods_code_id = dg.goods_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_contragents dc1 on dtj_reestr.consignor_id = dc1.contragent_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_contragents dc2 on dtj_reestr.consignee_id = dc2.contragent_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_punkty_perexoda pp on dtj_reestr.punkt_perexoda_id = pp.punkt_code');
DM.ADOQ_DTJ32.sql.Add('left join dtj_vagon_type vt on dtj_reestr.vagon_type_id = vt.vagon_type_id');
DM.ADOQ_DTJ32.sql.Add('left join dtj_moving_types mt on dtj_reestr.moving_type_id = mt.moving_tipes_id');
DM.ADOQ_DTJ32.sql.Add('left join dtj_rent_type rt on dtj_reestr.rent_id = rt.rent_id');
DM.ADOQ_DTJ32.sql.Add('left join dtj_distance on dtj_reestr.distance_id = dtj_distance.distance_id');                                    //ошибка!
DM.ADOQ_DTJ32.SQL.Add('where status is null and control_date between to_date('''+DateToStr(DateTimePicker1.Date)+''', ''dd.mm.yyyy'')');
DM.ADOQ_DTJ32.sql.Add('and to_date('''+DateToStr(DateTimePicker2.Date)+''', ''dd.mm.yyyy'')');
DM.ADOQ_DTJ32.sql.Add('and (GOODS_CODE_ID = 2000 or GOODS_CODE_ID = 3000');
DM.ADOQ_DTJ32.sql.Add('or order_num Like ''%F'' or KONTAINER_NUM is not null)');
DM.ADOQ_DTJ32.sql.Add('order by vagon_registers_id,num');
DM.ADOQ_DTJ32.Active:=true;

select vagon_registers_id, vagon_num, order_num, date_order, order_num_dtj, date_order_dtj,
station_out_id,station_dosylka_id, station_in_id, goods_code_id,goods_mass, kontainer_num, kontainer_mass,tariff_summ,koef_vpk,ktj_summ,
dg.goods_short_name  as dg_name, ds1.station_name as ds1, ds2.station_name as ds2, ds3.station_name as ds3,
dc1.contragent_name  as consignor_name,dc2.contragent_name  as consignee_name,train_id,natural_list_num,
mt.moving_tipes_name as moving_type_id,dtj_distance.distance_length as len,rt.rent_name as rent_id,country_id,vagon_date_out,time_date_out,
vagon_date_in,time_date_in,vt.vagon_type_short as vagon_type_id,scan_name,scan_name_dtj,punkt_perexoda_id,pp.punkt_name as punkt_name,
row_number() OVER (PARTITION BY order_num ORDER BY date_order DESC) AS num
From Dtj_Reestr
left join dtj_stations ds1 on dtj_reestr.station_out_id = ds1.station_code
left join dtj_stations ds2 on dtj_reestr.station_dosylka_id = ds2.station_code
left join dtj_stations ds3 on dtj_reestr.station_in_id = ds3.station_code
left join dtj_goods dg on dtj_reestr.goods_code_id = dg.goods_code
left join dtj_contragents dc1 on dtj_reestr.consignor_id = dc1.contragent_code
left join dtj_contragents dc2 on dtj_reestr.consignee_id = dc2.contragent_code
left join dtj_punkty_perexoda pp on dtj_reestr.punkt_perexoda_id = pp.punkt_code
left join dtj_vagon_type vt on dtj_reestr.vagon_type_id = vt.vagon_type_id
left join dtj_moving_types mt on dtj_reestr.moving_type_id = mt.moving_tipes_id
left join dtj_rent_type rt on dtj_reestr.rent_id = rt.rent_id
left join dtj_distance on dtj_reestr.distance_id = dtj_distance.distance_id
where status is null 
and control_date BETWEEN to_date('01.10.2017','dd.mm.yyyy') and to_date('01.11.2017','dd.mm.yyyy')
and (GOODS_CODE_ID = 2000 or GOODS_CODE_ID = 3000
or order_num Like '%F' or KONTAINER_NUM is not null)
order by vagon_registers_id,num;