sql 例子

SELECT  p.id id , p.name site_name  ,m.master_name fzr_name , m.master_id area_code
             from voc_equipment e left join voc_equ_param_rel  r on e.id = r.equ_id
             left join voc_params  p on p.id = r.param_id
						   left join voc_param_master  m on m.master_id = p.master_id
              where 1=1 and  FIND_IN_SET(e.id,(SELECT GROUP_CONCAT(equs_id) from site s where s.id in  ('1','9')))


SELECT  p.id id , p.name site_name  ,m.master_name fzr_name , m.master_id area_code
             from voc_equipment e left join voc_equ_param_rel  r on e.id = r.equ_id
             left join voc_params  p on p.id = r.param_id
						   left join voc_param_master  m on m.master_id = p.master_id
              where 1=1 and  FIND_IN_SET(e.id,(SELECT s.equs_id from site s where s.id =  '1'))

   SELECT p.user_pay_id, p.user_pay_type, p.user_pay_point, p.user_pay_state,
        p.user_balance, p.user_id, p.merchant_name, p.activity_name, p.source_id,
        p.record_version, p.create_by, p.create_date_time, p.update_by, p.update_date_time, p.update_count,
        u.job_id , u.user_name
        from t_d_point_user_pay p left join t_b_point_user u on u.user_id = p.user_id
        where p.source_id = #{tdPointMerchantDTO.merchantId}
        <if test="tdPointMerchantDTO.yearMonth != null and tdPointMerchantDTO.yearMonth !='' ">
            date_format( p.create_date_time,'%Y-%m') = #{tdPointMerchantDTO.yearMonth}
        </if>
        order by p.create_date_time DESC