SELECT * FROM product WHERE code='GIFT-000001' AND ishide<>1xxx

Test product

RM1.10

Available: In Stock

Quantity