SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '-2608960274743539883' ?) ? ) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '6271574769421997' ?) ? ) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 5.14285714285714 ?) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 2.57142857142857 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 6.85714285714286 ?) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 5 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 1.71428571428571 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,year(formmain_9182.field0005) f2,count(formmain_9182.field0039) f3,org_member0.sort_id f4,org_unit1.sort_id f5 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ( formmain_9182.field0083 ?is null or formmain_9182.field0083 ?<= 0.1437125749) and formmain_9182.field0089 ?is not ?null ?) ?group by formmain_9182.field0047,formmain_9182.field0004,year(formmain_9182.field0005),org_member0.sort_id,org_unit1.sort_id order by f4 asc,f0 asc,f5 asc,f1 asc,f2 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '-2608960274743539883' ?) ? ) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '-2608960274743539883' ?) ? ) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '6271574769421997' ?) ? ) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '6271574769421997' ?) ? ) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 5.14285714285714 ?) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 5.14285714285714 ?) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 2.57142857142857 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 2.57142857142857 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 6.85714285714286 ?) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 6.85714285714286 ?) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 5 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 5 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 1.71428571428571 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 1.71428571428571 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ?group by formmain_9182.field0047,org_member0.sort_id order by f2 asc,f0 asc; SELECT formmain_9182.field0047 f0,formmain_9182.field0004 f1,count(formmain_9182.field0039) f2,org_member0.sort_id f3,org_unit1.sort_id f4 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ( formmain_9182.field0083 ?is null or formmain_9182.field0083 ?<= 0.1437125749) and formmain_9182.field0089 ?is not ?null ?) ?group by formmain_9182.field0047,formmain_9182.field0004,org_member0.sort_id,org_unit1.sort_id order by f3 asc,f0 asc,f4 asc,f1 asc; SELECT formmain_9182.field0047 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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ( formmain_9182.field0083 ?is null or formmain_9182.field0083 ?<= 0.1437125749) and formmain_9182.field0089 ?is not ?null ?) ?group by formmain_9182.field0047,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.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '-2608960274743539883' ?) ? ) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0051 ?= '6271574769421997' ?) ? ) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 5.14285714285714 ?) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 2.57142857142857 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ? ( formmain_9182.field0070 ?<> '6930849267007113057' ?OR formmain_9182.field0070 ?is null ?) ?and datediff(formmain_9182.field0059 ,formmain_9182.field0005 ) <= 6.85714285714286 ?) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 5 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( formmain_9182.field0092 ?is not ?null and datediff(formmain_9182.field0092 ,formmain_9182.field0005 ) <= 1.71428571428571 and str_to_date(date_format(formmain_9182.field0092 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')<>str_to_date('2000-01-01 00:00','%Y-%m-%d %H:%i') and str_to_date(date_format(formmain_9182.field0005 ,'%Y-%m-%d %H:%i'),'%Y-%m-%d %H:%i')>=str_to_date('2022-03-16 08:00','%Y-%m-%d %H:%i') ?) ; SELECT count(formmain_9182.field0039) f0 FROM formmain_9182 formmain_9182 left join org_member org_member0 on ?org_member0.id = formmain_9182.field0047 left join org_unit org_unit1 on ?org_unit1.id = formmain_9182.field0004 where ? ( ( formmain_9182.field0083 ?is null or formmain_9182.field0083 ?<= 0.1437125749) and formmain_9182.field0089 ?is not ?null ?) ; ?
|