Choose your mobile device brand
SELECT DISTINCT m_make FROM brodit_products WHERE m_category <> 'Vehicles' AND m_make <> '' AND m_active = 'Y' AND m_productid IN (216322, 216323, 216324, 216325, 216326, 216327, 718090, 718161, 718164, 718190, 718191, 718228, 718232, 718233, 718234, 718235, 718236, 718263, 718300, 719090, 719161, 719190, 719191, 719228, 719232, 719233, 719234, 719235, 719263, 719300) ORDER BY m_make asc;
