☆恭賀!!!!順天堂持續通過澳洲藥管局TGA查廠,並獲得PIC/S A1最高殊榮☆☆☆
SELECT * FROM prod WHERE ptype != 'V' AND p12 = '2' AND ptype != 'B' 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') ) ORDER BY asno , ptype , prpak ASC