店铺查询

yujian

2019-05-05 51e93be914519e149ae42ad6ee4a0f9126d8f7d5

店铺查询

 fanli/src/main/java/com/yeshi/fanli/mapping/taobao/TaoBaoShopMapper.xml

@@ -182,7 +182,8 @@
        LEFT JOIN `yeshi_ec_taobao_shop_info` tt ON tt.`tsi_id` = pp.bcs_shop_id
        LEFT JOIN `yeshi_ec_taobao_goods` tg ON tg.`sellerId` = a.sellerId    
         WHERE (SELECT COUNT(DISTINCT(e1.id)) FROM yeshi_ec_taobao_goods AS e1 WHERE  e1.sellerId = tg.sellerId AND e1.biz30day <![CDATA[ >]]> tg.biz30day)<![CDATA[ <]]> 3
        ORDER BY pp.`bcs_top`,pp.`bcs_create_time` DESC,tg.`biz30day` DESC
             AND  pp.`bcs_state` = 1
        ORDER BY pp.`bcs_top`,pp.`bcs_orderby`
    </select>
    
    <select id="countBrandShopinfo"  resultType="Long">