需求全部数据导出(验证是否有图片)

```sql SELECT a.id AS '需求id', a.requirement_name AS '需求名称', a.demand_type AS '需求类型', a.requirement_desc AS '需求描述', a.status AS '上下架状态', a.is_available AS '是否逻辑删除', a.approve AS '需求是否通过', a.label AS '标签', a.technical_field AS '技术领域一级', c.application_field AS '应用领域', c.investment_amount AS '交易金额', a.effective_end_day AS '信息有效期', c.unit_name AS '单位名称', a.contact AS '联系人', a.telephone AS '联系电话', a.email AS '邮箱', a.contact_person AS '联系人(运营使用)', a.contact_phone AS '联系电话(运营使用)', a.effective_end_day AS '信息有效期', a.is_effective_end_day AS '是否永久有效', a.publisher_id AS '发布者', d.province AS '成果-省代码', d.city AS '成果-市代码', d.district AS '成果-区代码', dm1.name AS '省', dm2.name AS '市', c.result_details_industry_field AS '成果-产业领域', c.result_details_technical_phase AS '成果-技术需求所处阶段', c.result_details_cooperation_type AS '成果-合作方式', a.effective_end_day AS '成果-信息有效期', c.patent_legal_status AS '专利- 法律状态', c.patent_category AS '专利-专利类别', c.patent_cooperation_type AS '专利-合作方式', c.trademark_classification AS '商标-商标分类', a.create_date AS '需求创建时间', a.options AS '附件id', a.pic_id AS '图片ID', CASE WHEN LEN(a.pic_id) > 0 THEN '是' ELSE '否' END AS '是否有图片', a.options AS '附件id', a.data_source AS '数据来源' FROM t_requirement_common a LEFT JOIN t_requirement_property c ON a.id = c.req_id LEFT JOIN t_results_details_common d ON a.id = d.id LEFT JOIN t_dynamic_menu dm1 ON d.province = dm1.code LEFT JOIN t_dynamic_menu dm2 ON d.city = dm2.code ORDER BY a.create_date DESC ```

全部评论

联系我们

025-66041049

在线咨询:点击这里给我发消息

邮件:face2obejct@gmail.com

工作时间:8:00-23:50

QR code