{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `material_stock_id`, `material_id`, `material_stock_quantity`, `material_stock_location`, `material_stock_project`, `material_stock_min_qty`, `material_stock_max_qty`, `material_stock_re_order_qty`, `material_stock_re_order_level`, `material_stock_active`, `material_stock_remarks`, `material_stock_last_updated_by`, `material_stock_last_updated_on`, `stock_project_name`, `added_user_name`, `stock_material_code`, `stock_material_name`, `stock_material_price`, `stock_unit_name`, `stock_location_name`\r\n FROM material_stock_view\r\n WHERE `material_stock_active` = '1' AND `material_stock_quantity` > 0 \r\n ORDER BY material_stock_quantity DESC\r\n \r\n ","aaData":[]}