[size=large]insert into t_schedule_conflict (publishId,pubVersion)
SELECT a.publishId, a.pubVersion
FROM t_publish_time_strategy a, t_publish_timerange b
where a.publishId=temp_publishId and a.pubVersion=temp_pubVersion and a.timerangeId=b.timerangeId;[/size]
SELECT a.publishId, a.pubVersion
FROM t_publish_time_strategy a, t_publish_timerange b
where a.publishId=temp_publishId and a.pubVersion=temp_pubVersion and a.timerangeId=b.timerangeId;[/size]