Buy New/Used Airpod

Select Brand SELECT * FROM soum_prod_subcat WHERE prod_subcat_id IN (SELECT DISTINCT brand FROM soum_product_master WHERE `category_type` LIKE '%airpod%') APPLE ONE PLUS SAMSUNG NOISE REDMI BOAT PEBBLE OPPO