IT数码 购物 网址 头条 软件 日历 阅读 图书馆
TxT小说阅读器
↓语音阅读,小说下载,古典文学↓
图片批量下载器
↓批量下载图片,美女图库↓
图片自动播放器
↓图片自动播放器↓
一键清除垃圾
↓轻轻一点,清除系统垃圾↓
开发: C++知识库 Java知识库 JavaScript Python PHP知识库 人工智能 区块链 大数据 移动开发 嵌入式 开发工具 数据结构与算法 开发测试 游戏开发 网络协议 系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑 笔记本 显卡 显示器 固态硬盘 硬盘 耳机 手机 iphone vivo oppo 小米 华为 单反 装机 图拉丁
 
   -> 开发工具 -> 数据统计SQL,可拆分使用 -> 正文阅读

[开发工具]数据统计SQL,可拆分使用

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 ?) ;
?

  开发工具 最新文章
Postman接口测试之Mock快速入门
ASCII码空格替换查表_最全ASCII码对照表0-2
如何使用 ssh 建立 socks 代理
Typora配合PicGo阿里云图床配置
SoapUI、Jmeter、Postman三种接口测试工具的
github用相对路径显示图片_GitHub 中 readm
Windows编译g2o及其g2o viewer
解决jupyter notebook无法连接/ jupyter连接
Git恢复到之前版本
VScode常用快捷键
上一篇文章      下一篇文章      查看所有文章
加:2022-04-18 18:03:22  更:2022-04-18 18:04:21 
 
开发: C++知识库 Java知识库 JavaScript Python PHP知识库 人工智能 区块链 大数据 移动开发 嵌入式 开发工具 数据结构与算法 开发测试 游戏开发 网络协议 系统运维
教程: HTML教程 CSS教程 JavaScript教程 Go语言教程 JQuery教程 VUE教程 VUE3教程 Bootstrap教程 SQL数据库教程 C语言教程 C++教程 Java教程 Python教程 Python3教程 C#教程
数码: 电脑 笔记本 显卡 显示器 固态硬盘 硬盘 耳机 手机 iphone vivo oppo 小米 华为 单反 装机 图拉丁

360图书馆 购物 三丰科技 阅读网 日历 万年历 2024年11日历 -2024/11/14 14:58:54-

图片自动播放器
↓图片自动播放器↓
TxT小说阅读器
↓语音阅读,小说下载,古典文学↓
一键清除垃圾
↓轻轻一点,清除系统垃圾↓
图片批量下载器
↓批量下载图片,美女图库↓
  网站联系: qq:121756557 email:121756557@qq.com  IT数码