SELECT
s.periodsno,s.sitename,t.*
FROM
subcampaign_doctor t LEFT JOIN `subcampaign` s ON s.id=t.subCampaignId
WHERE
(SELECT COUNT(1) FROM subcampaign_doctor WHERE subCampaignId=t.subCampaignId AND phone=t.phone)>1
s.periodsno,s.sitename,t.*
FROM
subcampaign_doctor t LEFT JOIN `subcampaign` s ON s.id=t.subCampaignId
WHERE
(SELECT COUNT(1) FROM subcampaign_doctor WHERE subCampaignId=t.subCampaignId AND phone=t.phone)>1