QR.SQL.Add('select n.node_name, '+
   'count(case     when (date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and status=2) or (date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and status=4 and date(sell_date)>="'+date2mysql(report_datestart.Text)+'") then s.id end) as tot_cnt,'+
   'round(sum(case when date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and (status=2) or (date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and status=4 and date(sell_date)>="'+date2mysql(report_datestart.Text)+'") then total_weight end),2) as tot_wt,'+
   'sum(case       when date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and (status=2) or (date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and status=4 and date(sell_date)>="'+date2mysql(report_datestart.Text)+'") then kredit end) as tot_kr,'+
   'sum(case       when date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and (status=2) or (date(s.shop_date)<"'+date2mysql(report_datestart.Text)+'" and status=4 and date(sell_date)>="'+date2mysql(report_datestart.Text)+'") then price end) as tot_pr,'+

   'count(case when date(s.shop_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and (status in(2,4)) then s.id end) as new_cnt,'+
   'round(sum(case when date(s.shop_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and (status in(2,4)) then total_weight end),2) as new_wt,'+
   'sum(case when date(s.shop_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and (status in(2,4)) then kredit end) as new_kr,'+
   'sum(case when date(s.shop_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and (status in(2,4)) then price end)as new_pr,'+

   'count(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then s.id end) as sell_cnt,'+
   'round(sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then total_weight end),2) as sell_wt,'+
   'sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then kredit end) as sell_kr,'+
   'sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then vyruchka end) as sell_pr,'+
   'sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 and price>vyruchka then price-vyruchka end) as sell_discount,'+


   'count(case when store_num is not null and date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then s.id end) as sell_l_cnt,'+
   'round(sum(case when store_num is not null and date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then total_weight end),2) as sell_l_wt,'+
   'sum(case when store_num is not null and  date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then kredit end) as sell_l_kr,'+
   'sum(case when store_num is not null and date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=4 then vyruchka end) as sell_l_pr,'+

   'count(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=5 then s.id end) as ret_cnt,'+
   'round(sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=5 then total_weight end),2) as ret_wt,'+
   'sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=5 then kredit end) as ret_kr,'+
   'sum(case when date(s.sell_date) between "'+date2mysql(report_datestart.Text)+'" and "'+date2mysql(report_dateend.Text)+'" and status=5 then price end) as ret_pr,'+

   'count(case when (status=2 and date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'") or (date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'" and status=4 and date(sell_date)>"'+date2mysql(report_dateend.Text)+'") then s.id end) as end_cnt,'+
   'round(sum(case when (status=2  and date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'") or (date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'" and status=4 and date(sell_date)>"'+date2mysql(report_dateend.Text)+'") then total_weight end),2) as end_wt,'+
   'sum(case when (status=2 and date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'") or (date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'" and status=4 and date(sell_date)>"'+date2mysql(report_dateend.Text)+'") then kredit end) as end_kr,'+
   'sum(case when (status=2 and date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'") or (date(s.shop_date)<="'+date2mysql(report_dateend.Text)+'" and status=4 and date(sell_date)>"'+date2mysql(report_dateend.Text)+'") then s.price end) as end_pr '+

     'from nodes n left join storage s  on n.Id=s.node_num group by s.node_num order by node_name'
   );