SELECT
	o.DESCRIPTION,
	c.REGIST_NO,
	c.`REGIST_DATE`,
	i.`LOSS_NO`,
	i.loss_name,
	i.`loss_type`,
	i.SURVEY_NAME,
	i.SURVEY_NUMBER,
	s.`SURVEY_TYPE`,
	i.SURVEY_ORGNAME,
	i.SURVEY_ORGCODE,
	i.`STATUS`,
	i.HAS_JY_TASK,
	i.DISPATCH_TIME,
	i.DISPATCH_TYPE,
	i.SURVEY_TEL
FROM
	sd_dispatch_item i
LEFT JOIN sd_case_info c ON c.ID = i.CASE_INFO_ID
LEFT JOIN sd_org_info o ON c.ORG_ID = o.ID
LEFT JOIN `sd_survey` s ON i.`SURVEY_ID` = s.`ID`
WHERE
	1 = 1
AND c.isVehicleInsurance = 1
AND i.HAS_JY_TASK = 0
AND i.`STATUS` IN ('2', '10', '11', '12')
AND i.loss_type IN ('1', '2', '6', '7')
ORDER BY
	c.REGIST_DATE DESC