fanli-server.git

			@@ -173,7 +173,7 @@
			SELECT tt.,tg. FROM
			(SELECT COUNT(t.`id`) AS totalGoods,t.`sellerId` FROM `yeshi_ec_taobao_goods` t
			LEFT JOIN `yeshi_ec_brand_class_shop` p ON t.`sellerId` = p.bcs_shop_id
			WHERE p.`bcs_id` IS NOT NULL AND p.`bcs_state` = 1 AND t.`couponAmount` > 0
			WHERE p.`bcs_id` IS NOT NULL AND p.`bcs_state` = 1 AND t.`couponAmount` <![CDATA[>]]> 0
			<if test="cid != null">AND p.`bcs_cid` =#{cid}</if>
			GROUP BY t.`sellerId` HAVING totalGoods<![CDATA[>]]> 2
			ORDER BY p.`bcs_top`,p.`bcs_create_time` DESC
			@@ -182,15 +182,17 @@
			LEFT JOIN `yeshi_ec_brand_class_shop` pp ON a.sellerId = pp.bcs_shop_id
			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
			AND pp.`bcs_state` = 1
			WHERE (SELECT COUNT(DISTINCT(e1.id)) FROM yeshi_ec_taobao_goods AS e1
			WHERE e1.couponAmount<![CDATA[>]]>0 AND e1.sellerId = tg.sellerId
			AND e1.biz30day <![CDATA[ >]]> tg.biz30day)<![CDATA[<]]> 3
			AND pp.`bcs_state` = 1 AND tg.`couponAmount` <![CDATA[>]]> 0
			ORDER BY pp.`bcs_top`,pp.`bcs_orderby`
			</select>

			<select id="countBrandShopinfo" resultType="Long">
			SELECT IFNULL(COUNT(*),0) FROM (SELECT COUNT(t.`id`) AS totalGoods FROM `yeshi_ec_taobao_goods` t
			LEFT JOIN `yeshi_ec_brand_class_shop` p ON t.`sellerId` = p.bcs_shop_id
			WHERE p.`bcs_id` IS NOT NULL AND p.`bcs_state` = 1 AND t.`couponAmount` > 0
			WHERE p.`bcs_id` IS NOT NULL AND p.`bcs_state` = 1 AND t.`couponAmount` <![CDATA[>]]>0
			<if test="cid != null">AND p.`bcs_cid` =#{cid}</if>
			GROUP BY t.`sellerId` HAVING totalGoods<![CDATA[>]]> 2)a
			</select>