select products.* from products where 1 AND product_type='miscellaneous-spare-parts' order by p_id desc