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