全世界最长的统计SQL语句,可拆分使用

5 篇文章 1 订阅
3 篇文章 0 订阅

SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,year(formmain_9182.field0005) f3,count(formmain_9182.field0039) f4,org_member0.sort_id f5,ctp_enum_item_1.sortnumber f6,org_unit2.sort_id f7 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-2774886543271441207'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-5281604613155831703'  )  ) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f5 asc,f0 asc,f6 asc,f1 asc,f7 asc,f2 asc,f3 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,year(formmain_9182.field0005) f3,count(formmain_9182.field0039) f4,org_member0.sort_id f5,ctp_enum_item_1.sortnumber f6,org_unit2.sort_id f7 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 1.7149700599) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f5 asc,f0 asc,f6 asc,f1 asc,f7 asc,f2 asc,f3 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,year(formmain_9182.field0005) f3,count(formmain_9182.field0039) f4,org_member0.sort_id f5,ctp_enum_item_1.sortnumber f6,org_unit2.sort_id f7 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 0.1437125749) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f5 asc,f0 asc,f6 asc,f1 asc,f7 asc,f2 asc,f3 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,year(formmain_9182.field0005) f3,count(formmain_9182.field0039) f4,org_member0.sort_id f5,ctp_enum_item_1.sortnumber f6,org_unit2.sort_id f7 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 3.4251497006 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f5 asc,f0 asc,f6 asc,f1 asc,f7 asc,f2 asc,f3 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,year(formmain_9182.field0005) f3,count(formmain_9182.field0039) f4,org_member0.sort_id f5,ctp_enum_item_1.sortnumber f6,org_unit2.sort_id f7 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 5.1437125749 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f5 asc,f0 asc,f6 asc,f1 asc,f7 asc,f2 asc,f3 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,year(formmain_9182.field0005) f3,count(formmain_9182.field0039) f4,org_member0.sort_id f5,ctp_enum_item_1.sortnumber f6,org_unit2.sort_id f7 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 6.85714285714286 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f5 asc,f0 asc,f6 asc,f1 asc,f7 asc,f2 asc,f3 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,ctp_enum_item_1.sortnumber f5,org_unit2.sort_id f6 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-2774886543271441207'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-5281604613155831703'  )  ) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f6 asc,f2 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,ctp_enum_item_1.sortnumber f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-2774886543271441207'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-5281604613155831703'  )  ) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,org_member0.sort_id,ctp_enum_item_1.sortnumber order by f3 asc,f0 asc,f4 asc,f1 asc;
SELECT formmain_9182.field0003 f0,count(formmain_9182.field0039) f1,org_member0.sort_id f2 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-2774886543271441207'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-5281604613155831703'  )  ) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,org_member0.sort_id order by f2 asc,f0 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,ctp_enum_item_1.sortnumber f5,org_unit2.sort_id f6 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 1.7149700599) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f6 asc,f2 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,ctp_enum_item_1.sortnumber f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 1.7149700599) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,org_member0.sort_id,ctp_enum_item_1.sortnumber order by f3 asc,f0 asc,f4 asc,f1 asc;
SELECT formmain_9182.field0003 f0,count(formmain_9182.field0039) f1,org_member0.sort_id f2 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 1.7149700599) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,org_member0.sort_id order by f2 asc,f0 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,ctp_enum_item_1.sortnumber f5,org_unit2.sort_id f6 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 0.1437125749) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f6 asc,f2 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,ctp_enum_item_1.sortnumber f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 0.1437125749) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,formmain_9182.field0058,org_member0.sort_id,ctp_enum_item_1.sortnumber order by f3 asc,f0 asc,f4 asc,f1 asc;
SELECT formmain_9182.field0003 f0,count(formmain_9182.field0039) f1,org_member0.sort_id f2 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 0.1437125749) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   )  group by formmain_9182.field0003,org_member0.sort_id order by f2 asc,f0 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,ctp_enum_item_1.sortnumber f5,org_unit2.sort_id f6 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 3.4251497006 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f6 asc,f2 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,ctp_enum_item_1.sortnumber f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 3.4251497006 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,org_member0.sort_id,ctp_enum_item_1.sortnumber order by f3 asc,f0 asc,f4 asc,f1 asc;
SELECT formmain_9182.field0003 f0,count(formmain_9182.field0039) f1,org_member0.sort_id f2 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 3.4251497006 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,org_member0.sort_id order by f2 asc,f0 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,ctp_enum_item_1.sortnumber f5,org_unit2.sort_id f6 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 5.1437125749 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f6 asc,f2 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,ctp_enum_item_1.sortnumber f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 5.1437125749 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,org_member0.sort_id,ctp_enum_item_1.sortnumber order by f3 asc,f0 asc,f4 asc,f1 asc;
SELECT formmain_9182.field0003 f0,count(formmain_9182.field0039) f1,org_member0.sort_id f2 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 5.1437125749 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,org_member0.sort_id order by f2 asc,f0 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,formmain_9182.field0004 f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,ctp_enum_item_1.sortnumber f5,org_unit2.sort_id f6 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 6.85714285714286 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,formmain_9182.field0004,org_member0.sort_id,ctp_enum_item_1.sortnumber,org_unit2.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f6 asc,f2 asc;
SELECT formmain_9182.field0003 f0,formmain_9182.field0058 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,ctp_enum_item_1.sortnumber f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 6.85714285714286 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,formmain_9182.field0058,org_member0.sort_id,ctp_enum_item_1.sortnumber order by f3 asc,f0 asc,f4 asc,f1 asc;
SELECT formmain_9182.field0003 f0,count(formmain_9182.field0039) f1,org_member0.sort_id f2 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 6.85714285714286 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  )  group by formmain_9182.field0003,org_member0.sort_id order by f2 asc,f0 asc;
SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-2774886543271441207'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-5281604613155831703'  )  ) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   ) ;
SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 1.7149700599) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   ) ;
SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0089  is not  null and ( formmain_9182.field0083  is null or formmain_9182.field0083  <= 0.1437125749) and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and  ( formmain_9182.field0004  = :sys_con_0 ) and   ( formmain_9182.field0051  <> '-6428950382177661347'  OR formmain_9182.field0051  is null  )  and   ( formmain_9182.field0051  <> '262545013246871717'  OR formmain_9182.field0051  is null  )   ) ;
SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 3.4251497006 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  ) ;
SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 5.1437125749 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  ) ;
SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on  org_member0.id = formmain_9182.field0003 left join ctp_enum_item ctp_enum_item_1 on  ctp_enum_item_1.id = formmain_9182.field0058 left join org_unit org_unit2 on  org_unit2.id = formmain_9182.field0004 where   (  (   ( formmain_9182.field0045  = '-5281604613155831703'  )  or   ( formmain_9182.field0045  = '6962147356500706938'  )  or   ( formmain_9182.field0045  = '-2774886543271441207'  )  ) and formmain_9182.field0086  >= 6.85714285714286 and   ( formmain_9182.field0070  <> '6930849267007113057'  OR formmain_9182.field0070  is null  )  and   ( formmain_9182.field0051  = '8298050780058435864'  )  and  ( formmain_9182.field0004  = :sys_con_0 )  ) ;
 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

功臣诗★俊

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值