( 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
想對外分享這則貼文嗎?運用網址更方便呦~