SELECT SQL_CALC_FOUND_ROWS * FROM websr_diamond_details WHERE 1  AND diamond_quantity = 1  AND supplier_id IN (2,4,5,7,8,9,10) AND diamond_type='lab' AND shape IN ("Round") AND final_price >= 1700 AND final_price <= 2300 AND weight >= 1.56 AND weight <= 2.56 AND cut IN ("Excellent","Ideal") AND color IN ("E","F") AND clarity IN ("IF","VVS1") ORDER BY final_price ASC LIMIT 0,6