该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
SELECT t0.c_Id,t0.c_CreateTime,t0.c_UpdateTime,t0.c_State,t1.c_CompanyId,t1.c_OriginalCompany,t1.c_LeaderId,t1.c_Name,t1.c_Logo,t1.c_Slogan,t1.c_Intro,t1.c_Location,t1.c_Bp, t2.c_Kind AS c_CompanyKind, t2.c_Name AS c_CompanyName, t2.c_Logo AS c_CompanyLogo, t3.c_Username AS c_LeaderUsername, t3.c_Avatar AS c_LeaderAvatar, t3.c_Roles AS c_LeaderRoles, t4.c_State AS c_LeaderState, IFNULL(t5.c_ViewCount,0) AS c_ViewCount,IFNULL(t5.c_FavoriteCount,0) AS c_FavoriteCount,IFNULL(t5.c_InterestCount,0) AS c_InterestCount,IFNULL(t5.c_ReplyCount,0) AS c_ReplyCount,IFNULL(t5.c_AgreeCount,0) AS c_AgreeCount,IFNULL(t5.c_DisagreeCount,0) AS c_DisagreeCount, IFNULL(t6.c_Target,'') AS c_MarketingTarget,IFNULL(t6.c_Method,'') AS c_MarketingMethod,IFNULL(t6.c_Competitor,'') AS c_MarketingCompetitor,IFNULL(t6.c_Advantage,'') AS c_MarketingAdvantage, IFNULL(t7.c_Income,'') AS c_OperatingIncome,IFNULL(t7.c_Cost,'') AS c_OperatingCost,IFNULL(t7.c_Profit,'') AS c_OperatingProfit,IFNULL(t7.c_Remark,'') AS c_OperatingRemark, IFNULL(t8.c_Money,0) AS c_FinancingMoney,IFNULL(t8.c_Share,0) AS c_FinancingShare,IFNULL(t8.c_Purpose,'') AS c_FinancingPurpose,IFNULL(t8.c_RoundId,'0') AS c_FinancingRoundId, t9.c_Name AS c_RoundName, t9.c_Stage AS c_RoundStage
FROM wt_object AS t0
JOIN t_company_project AS t1 ON t0.c_Id = t1.c_ObjectId
JOIN t_workunit AS t2 ON t1.c_CompanyId = t2.c_ObjectId
JOIN wt_user AS t3 ON t1.c_LeaderId = t3.c_ObjectId
JOIN wt_object AS t4 ON t1.c_LeaderId = t4.c_Id
LEFT JOIN wt_object_count AS t5 ON t0.c_Id = t5.c_ObjectId
LEFT JOIN t_company_project_marketing AS t6 ON t0.c_Id = t6.c_ProjectId
LEFT JOIN t_company_project_operating AS t7 ON t0.c_Id = t7.c_ProjectId
LEFT JOIN t_company_project_financing AS t8 ON t0.c_Id = t8.c_ProjectId
JOIN t_financing_round AS t9 ON t8.c_RoundId = t9.c_Id
WHERE (t0.c_Id = 149) AND (t0.c_State != -1)
当然不是手写的,是我的 ORM 框架自动生成的。