mysql left join

SELECT *,type,status,server_id FROM `dp_email_server` server LEFT JOIN `dp_email_stop` stop ON (server.smtp_id = stop.server_id)
WHERE status = '0' AND 'jjtest@qq.com' LIKE CONCAT('%',type,'%')