sky_travel
(sky_travel)
金牌会员
 
老会员
UID 19156
精华
0
积分 1259
帖子 1424
金钱 1259 喜悦币
威望 0
人脉 0
阅读权限 70
注册 2003-3-25
来自 www.88838.com
状态 离线
|
[推荐阅读] 为何是未结束的字符串常量！ 我在线等……
昏。不说说了要做什么了吗？
我基本做出来了
把目标表多加2个字段再删除
insert tb_pic1 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu<4 ;
insert tb_pic1 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu<4 ;
alter table `tb_pic1` DROP `id`;
alter table `tb_pic1` DROP `type`;
insert tb_pic2 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
insert tb_pic2 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>4 and tb_trade.tradetypeu<8 ;
alter table `tb_pic2` DROP `id`;
alter table `tb_pic2` DROP `type`;
insert tb_pic3 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
insert tb_pic3 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>8 and tb_trade.tradetypeu<12 ;
alter table `tb_pic3` DROP `id`;
alter table `tb_pic3` DROP `type`;
insert tb_pic4 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
insert tb_pic4 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>12 and tb_trade.tradetypeu<16 ;
alter table `tb_pic4` DROP `id`;
alter table `tb_pic4` DROP `type`;
insert tb_pic5 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
insert tb_pic5 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>16 and tb_trade.tradetypeu<20 ;
alter table `tb_pic5` DROP `id`;
alter table `tb_pic5` DROP `type`;
insert tb_pic6 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
insert tb_pic6 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>20 and tb_trade.tradetypeu<24 ;
alter table `tb_pic6` DROP `id`;
alter table `tb_pic6` DROP `type`;
insert tb_pic7 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
insert tb_pic7 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>24 and tb_trade.tradetypeu<28 ;
alter table `tb_pic7` DROP `id`;
alter table `tb_pic7` DROP `type`;
insert tb_pic8 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
insert tb_pic8 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>28 and tb_trade.tradetypeu<32 ;
alter table `tb_pic8` DROP `id`;
alter table `tb_pic8` DROP `type`;
insert tb_pic9 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
insert tb_pic9 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>32 and tb_trade.tradetypeu<36 ;
alter table `tb_pic9` DROP `id`;
alter table `tb_pic9` DROP `type`;
insert tb_pic10 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
insert tb_pic10 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>36 and tb_trade.tradetypeu<40 ;
alter table `tb_pic10` DROP `id`;
alter table `tb_pic10` DROP `type`;
insert tb_pic11 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
insert tb_pic11 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>40 and tb_trade.tradetypeu<44 ;
alter table `tb_pic11` DROP `id`;
alter table `tb_pic11` DROP `type`;
insert tb_pic12 select logo_image0.regnum,logo_image0.bin_data,logo_image0.filesize,logo_image0.filetype,logo_image0.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image0 where tb_trade.registid=logo_image0.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image1.regnum,logo_image1.bin_data,logo_image1.filesize,logo_image1.filetype,logo_image1.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image1 where tb_trade.registid=logo_image1.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image2.regnum,logo_image2.bin_data,logo_image2.filesize,logo_image2.filetype,logo_image2.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image2 where tb_trade.registid=logo_image2.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image3.regnum,logo_image3.bin_data,logo_image3.filesize,logo_image3.filetype,logo_image3.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image3 where tb_trade.registid=logo_image3.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image4.regnum,logo_image4.bin_data,logo_image4.filesize,logo_image4.filetype,logo_image4.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image4 where tb_trade.registid=logo_image4.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image5.regnum,logo_image5.bin_data,logo_image5.filesize,logo_image5.filetype,logo_image5.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image5 where tb_trade.registid=logo_image5.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image6.regnum,logo_image6.bin_data,logo_image6.filesize,logo_image6.filetype,logo_image6.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image6 where tb_trade.registid=logo_image6.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image7.regnum,logo_image7.bin_data,logo_image7.filesize,logo_image7.filetype,logo_image7.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image7 where tb_trade.registid=logo_image7.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image8.regnum,logo_image8.bin_data,logo_image8.filesize,logo_image8.filetype,logo_image8.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image8 where tb_trade.registid=logo_image8.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image9.regnum,logo_image9.bin_data,logo_image9.filesize,logo_image9.filetype,logo_image9.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image9 where tb_trade.registid=logo_image9.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image10.regnum,logo_image10.bin_data,logo_image10.filesize,logo_image10.filetype,logo_image10.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image10 where tb_trade.registid=logo_image10.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image11.regnum,logo_image11.bin_data,logo_image11.filesize,logo_image11.filetype,logo_image11.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image11 where tb_trade.registid=logo_image11.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image12.regnum,logo_image12.bin_data,logo_image12.filesize,logo_image12.filetype,logo_image12.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image12 where tb_trade.registid=logo_image12.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image13.regnum,logo_image13.bin_data,logo_image13.filesize,logo_image13.filetype,logo_image13.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image13 where tb_trade.registid=logo_image13.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image14.regnum,logo_image14.bin_data,logo_image14.filesize,logo_image14.filetype,logo_image14.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image14 where tb_trade.registid=logo_image14.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image15.regnum,logo_image15.bin_data,logo_image15.filesize,logo_image15.filetype,logo_image15.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image15 where tb_trade.registid=logo_image15.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image16.regnum,logo_image16.bin_data,logo_image16.filesize,logo_image16.filetype,logo_image16.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image16 where tb_trade.registid=logo_image16.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image17.regnum,logo_image17.bin_data,logo_image17.filesize,logo_image17.filetype,logo_image17.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image17 where tb_trade.registid=logo_image17.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image18.regnum,logo_image18.bin_data,logo_image18.filesize,logo_image18.filetype,logo_image18.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image18 where tb_trade.registid=logo_image18.regnum and tb_trade.tradetypeu>44 ;
insert tb_pic12 select logo_image19.regnum,logo_image19.bin_data,logo_image19.filesize,logo_image19.filetype,logo_image19.create_date,tb_trade.registid,tb_trade.tradetypeu from tb_trade,logo_image19 where tb_trade.registid=logo_image19.regnum and tb_trade.tradetypeu>44 ;
alter table `tb_pic12` DROP `id`;
alter table `tb_pic12` DROP `type`;
| 
百姓生活网
老百姓自己的网站，为百姓服务的网站，数据来源于百姓服务于百姓，提供全国20多个大城市20多万家餐馆，购物等商店详细信息，地图等资料，您可随心所欲的点评任何商家
|
|
