SELECT `product`.*,`product`.`id` AS `product_id` FROM `product` LEFT JOIN `products_levelone` ON `products_levelone`.`id`=`product`.`levelone` LEFT JOIN `products_leveltwo` ON `products_leveltwo`.`id`=`product`.`leveltwo` LEFT JOIN `products_levelthree` ON `products_levelthree`.`id`=`product`.`levelthree`
LEFT JOIN `brand` ON `brand`.`id`=`product`.`brand` WHERE `product`.`display`='1' AND (`stock_left` > '0' OR `stock_left` IS NULL OR `stock_left` = '') AND (`product`.`off_shelves_date` = '0000-00-00 00:00:00' OR `product`.`off_shelves_date` > '2025-04-20 05:42:18pm') AND (`tag1` LIKE '%EPIKHIGH%' OR `tag2` LIKE '%EPIKHIGH%') ORDER BY `id` DESC LIMIT 0,16
產品 | Buykgoodshk | 韓迷代購 | 韓國代購
