SELECT products_id,products_name,categories_id from products where categories_id = 12 and brand = acer ORDER BY products_id DESC LIMIT 48