select C_ID C_APPLYNAME C_REPORTPHONE C_CREATAT C_REMARK C_REPORTAT C_STATUS m1 m10 m11 m2 m3 m4 m5 m6 m7 m8 m9 R_PLACE_ID R_STATEMENT_ID from t_projectreportbatch as j left join t_place as p on jR_PL

SELECT j.C_ID, j.C_APPLYNAME, j.C_REPORTPHONE, j.C_CREATAT, j.C_REMARK, j.C_REPORTAT, j.C_STATUS, j.m1, j.m10, j.m11, j.m2, j.m3, j.m4, j.m5, j.m6, j.m7, j.m8, j.m9, j.R_PLACE_ID, j.R_STATEMENT_ID FROM t_projectreportbatch as j LEFT JOIN t_place as p on j.R_PLACE_ID=p.C_ID WHERE j.R_STATEMENT_ID = 46 AND p.R_PARENT_ID = 441424000000