SELECT caipan.id,caipan.judge_name cku_title,caipan.judge_title cku_position, image.image_min_url, image.image_max_url FROM show_judge caipan LEFT JOIN cku_image image ON caipan.id = image.match_referee_id WHERE caipan.id IN (${ids}) cku_content, cku_position insert into cku_caipan (id, cku_title, cku_picture, cku_zhijiao, cku_country, cku_sex, cku_ssbh, cku_sczz, cku_content, cku_position) values (#{id,jdbcType=INTEGER}, #{ckuTitle,jdbcType=VARCHAR}, #{ckuPicture,jdbcType=VARCHAR}, #{ckuZhijiao,jdbcType=VARCHAR}, #{ckuCountry,jdbcType=VARCHAR}, #{ckuSex,jdbcType=VARCHAR}, #{ckuSsbh,jdbcType=VARCHAR}, #{ckuSczz,jdbcType=VARCHAR}, #{ckuContent,jdbcType=LONGVARCHAR}, #{ckuPosition,jdbcType=LONGVARCHAR}) insert into cku_caipan id, cku_title, cku_picture, cku_zhijiao, cku_country, cku_sex, cku_ssbh, cku_sczz, cku_content, cku_position, #{id,jdbcType=INTEGER}, #{ckuTitle,jdbcType=VARCHAR}, #{ckuPicture,jdbcType=VARCHAR}, #{ckuZhijiao,jdbcType=VARCHAR}, #{ckuCountry,jdbcType=VARCHAR}, #{ckuSex,jdbcType=VARCHAR}, #{ckuSsbh,jdbcType=VARCHAR}, #{ckuSczz,jdbcType=VARCHAR}, #{ckuContent,jdbcType=LONGVARCHAR}, #{ckuPosition,jdbcType=LONGVARCHAR}, SELECT id,judge_name cku_title,judge_title cku_position FROM show_judge where 1 = 1 and judge_name like '%${name}%' and judge_title like '%${position}%' ORDER BY ID DESC limit ${count},${limit} SELECT * FROM cku_caipan SELECT count(*) FROM show_judge WHERE 1=1 and judge_name like '%${name}%' and judge_title like '%${position}%' update cku_caipan cku_title = #{ckuTitle,jdbcType=VARCHAR}, cku_picture = #{ckuPicture,jdbcType=VARCHAR}, cku_zhijiao = #{ckuZhijiao,jdbcType=VARCHAR}, cku_country = #{ckuCountry,jdbcType=VARCHAR}, cku_sex = #{ckuSex,jdbcType=VARCHAR}, cku_ssbh = #{ckuSsbh,jdbcType=VARCHAR}, cku_sczz = #{ckuSczz,jdbcType=VARCHAR}, cku_content = #{ckuContent,jdbcType=LONGVARCHAR}, cku_position = #{ckuPosition,jdbcType=LONGVARCHAR}, where id=#{id,jdbcType=INTEGER} delete from cku_caipan where id=#{id,jdbcType=INTEGER} select * from cku_caipan where id=#{id,jdbcType=INTEGER}