推動101

最新貼文
參觀人氣
本日人氣: 24
累積人氣: 58,010
頻道清單
上一層
分享 推播通知
目前身份: 訪客
(
 SELECT b.*, a.bg_mp_scope FROM bg_mps_00001 AS a INNER JOIN 
 ((SELECT * FROM collect_001_products) UNION (SELECT * FROM collect_002_products)) AS b ON a.collect_product_id = b.collect_product_id 
 WHERE a.bg_keyword_char_id = 10020000001
)

UNION

(SELECT *, '0' as bg_mp_scope FROM 
	((SELECT * FROM collect_001_products WHERE collect_product_title LIKE '%¹qµø%') UNION (SELECT * FROM collect_002_products WHERE collect_product_title LIKE '%¹qµø%')) AS product 
 WHERE product.collect_product_id NOT IN ( 
		SELECT collect_product_id FROM bg_mps_00001 WHERE bg_keyword_char_id = 10020000001
 )
) ORDER BY bg_mp_scope DESC
推動101 發表在 留言 (0) 人氣 (142)
分享給朋友
網址

想對外分享這則貼文嗎?運用網址更方便呦~

載入中...