SELECT * FROM `eb_store_product` WHERE  `is_del` = 0  AND `is_show` = 1  AND `ptype` = 2  AND `sn` IN ('G50-Water-&-Slurry-Collectors-(100----200-mm)','G50 Water & Slurry Collectors (100--200 mm)') LIMIT 1