Tablet Holders

Clear Filters SELECT ft.m_id, ft.m_display_name FROM s_filter_tags ft JOIN s_filter_producttags fpt ON ft.m_id = fpt.filtertag_id WHERE ft.m_active = 'Y' AND ft.m_filter_set = '5' AND EXISTS (SELECT t.m_broditid FROM s_products t WHERE fpt.product_id = t.m_broditid AND t.m_active = 'Y' AND t.m_status = '30' AND t.m_broditid IN ('511848','511849','511850','710319','712320','712325','712326','712332','712333','713319','713320','713325','713326','713332','713333','711002','712002','712224','712225','713224','713225','721002','710317','710318','710330','712317','712318','712323','712324','712330','712331','713317','713318','713323','713324','713330','713331','735317','735318','735323','735324','735330','735331','736317','736318','736323','736324','736330','736331','739317','739318','739330','741317','741318','741330','746317','746318','746323','746324','746330','746331','747317','747318','747323','747324','747330','747331','735319','735320','735325','735326','735332','735333','736319','736320','736325','736326','736332','736333','739319','739320','739332','741319','741320','741332','746319','746320','746325','746326','746332','746333','747319','747320','747325','747326','747332','747333','710320','710332','712319','721224','721225','727002','735224','735225','736224','736225','739003','741003','746224','746225','747224','747225','752002','711328','712328','712329','713328','713329','735328','735329','736328','736329','746328','746329','747328','747329','710285','739285') ) GROUP BY ft.m_id ORDER BY ft.m_order