select * from product where (product_material = '20' ) and product_cut = '' and product_shape = '' and product_reprt !='' and product.product_net < '532000' and product.product_net > '0.6015037593985' and product.product_carats < '1000' and product.product_carats > '0.1' and product.product_status <> 99 order by product.product_net