56,679
社区成员
发帖
与我相关
我的任务
分享
SELECT
d.id,
d.project_code,
d.push_type,
d.push_name,
d.push_to,
d.push_from,
d.push_way,
tr.isread,
d.push_content,
d.push_attachment,
d.add_time,
d.push_status,
d.push_reviewer,
push_time,
d.reviewer_time,
d.push_class,
d.rel_object,
p.short_name AS project_name,
u1. NAME AS push_to_name,
u2. NAME AS push_from_name,
u3. NAME AS push_reviewer_name
FROM tb_push_data d
LEFT JOIN tb_project p ON p.short_code = d.project_code
LEFT JOIN tb_user u1 ON u1. CODE = d.push_to
LEFT JOIN tb_user u2 ON u2. CODE = d.push_from
LEFT JOIN tb_user u3 ON u3. CODE = d.push_reviewer
LEFT JOIN tb_push_log tr ON tr.pushdata_id = d.id
WHERE 1 = 1
AND d.add_time BETWEEN '2017-01-01' and '2018-01-11'
GROUP BY d.id
LIMIT 0,100
受影响的行: 0
时间: 24.933s
SELECT
d.id,
d.project_code,
d.push_type,
d.push_name,
d.push_to,
d.push_from,
d.push_way,
tr.isread,
d.push_content,
d.push_attachment,
d.add_time,
d.push_status,
d.push_reviewer,
push_time,
d.reviewer_time,
d.push_class,
d.rel_object,
p.short_name AS project_name,
u1. NAME AS push_to_name,
u2. NAME AS push_from_name,
u3. NAME AS push_reviewer_name
FROM
tb_push_data d,
tb_project p,
tb_user u1,
tb_user u2,
tb_user u3,
tb_push_log tr
WHERE 1 = 1
and p.short_code = d.project_code
and u1. CODE = d.push_to
and u2. CODE = d.push_from
and u3. CODE = d.push_reviewer
and tr.pushdata_id = d.id
AND d.add_time BETWEEN '2017-01-01' and '2018-01-11'
GROUP BY d.id
LIMIT 0,100
受影响的行: 0
时间: 0.189s