$data = DB::select(DB::raw("SELECT pur_price FROM productpricing WHERE
                        mst_uid = (SELECT 
                                mst_uid
                            FROM
                                master_material
                            WHERE prd_id = :product_id
                                    AND mtl_id = :material
                                    AND color_id = :color
                                    AND mtl_status ='1')
                                     AND ($size between pur_sqft1 AND ifnull(pur_sqft2,$size))"),
                                    array('product_id'      =>$product_id,
                                             'material'     =>$material,
                                             'color'        =>$color,                                                 
                                    ));