select picno,infono,picdescr=case when picdescr<>'' then picdescr else pickeyword end ,piclarge,picsmall,picsource,PicWidth,PicHeight,PicMemSize from info_pics WHERE  picalive='t'  and showid>= 10945 and showid<= 10968