$command = Yii::app()->db->createCommand()->select($select)
->from('ueb_product.ueb_ebay_online_listing_bidding as t')
->leftJoin('ueb_product.ueb_ebay_online_listing as a', 'a.itemid = t.itemid')
->leftJoin('ueb_product.ueb_product as d','d.sku=a.sku')
->where($where)
->group('t.itemid')
->order($sort_str)
->limit($limit, $offset);
$list = $command->queryAll(true);
$biddingItemAllArr = UebModel::model('Ebayonlinelistingbidding')
->getDbConnection()->createCommand()
->select('itemid,b_itemid,b_sellerid,b_start_price,b_fee,b_listing_status,b_currency,b_sold_1,b_sold_3,b_sold_7')
->from('ueb_ebay_online_listing_bidding')
->where('itemid in ('.$itemIdStr.')')
->queryAll();