最新消息
會員專區
產品訂購
新手上路
相關連結
客戶服務
SELECT * FROM prod WHERE ptype != '' AND ( ( ptype = 'M' OR ptype = 'S' OR ptype = 'E' ) OR ( asno = '1610' AND ptype = 'B' AND prpak = '60' ) OR ( asno = '1130' AND ptype = 'O' AND prpak = '15A' ) OR ( asno = 'V0084' AND ptype = 'E' AND prpak = '150' ) OR ( asno = 'V0084' AND ptype = 'T' AND prpak = '150' ) OR ( asno = 'V0068' AND ptype = 'E' AND prpak = '120' ) ) AND stopyn = 'N' AND stopmd = 'N' AND prc2 != 0 AND ( isNumeric(prpak) = 1 OR asno = '1130' ) AND prc2 != 9999 AND stpnum != -1 AND ( SUBSTRING(asno, 1,1) in ('0','1','2','5','6','7') OR ( ( asno = 'A1002' AND prpak = '10' ) OR ( asno = 'A1080' AND prpak = '20' ) OR ( asno = 'A1087' AND prpak = '20' ) OR ( asno = 'V0084' AND ptype = 'E' AND prpak = '150' ) OR ( asno = 'V0084' AND ptype = 'T' AND prpak = '150' ) OR ( asno = 'V0068' AND ptype = 'E' AND prpak = '120' ) ) ) ORDER BY asno , ptype , prpak ASC
