Is there any way for SUM() function NOT to "round" the sum of some numbers?

Can anyone tell me how to achieve this (if there is any?)

Cause this is causing kinda big declination from the sum results i was expecting…

I have a table , in each cell there are different numbers , which are pulled from a table.Not all the cells of the table are pulled from the mysql table.Some are calculated with php.

I need to calculate the precise sum of 7 cells. I will give the examle of the 1st the idea is the same

I use this query to make the sum of this mathematical formula within the SUM brackets

SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)*1.005)
From `kiniseis`
WHERE `date` BETWEEN '$_GET[date1]' AND '$_GET[date2]'

Ok the problem is that after 20-25 records , the sum is correct , but after that there is a high declination of the actual sum. (i tested that by hand to see the accuracy of the sum , and also with excel).

So after i tried many things , i end up to the conclusion that the sum funcion rounds the ratio (kinisis_1c / kinisis_1b) , and causes the above problem of declination from the actual sum of those numbers.

All the fields of the database table are DECIMAL(11,0)

Thats why i search a way to bypass this problem if there is any way ofcourse.

Thanks in advance

i’m sorry, the php is no good for me, i don’t do php (remember, this is the mysql forum, not the php forum)

dealing with the precision of intermediate results is ~not~ best solved by creating a temporary table

earlier on in this thread you changed all your columns from DECIMAL(11,0) to INTEGER, but i see that you have changed them back – i suggest you change them back to INTEGER

meanwhile, you are experiencing a foreign key error, yes? do you have any trouble understanding what this error message is telling you?

Hello r937 , i tried to sum a variable but it didnt gaved me precise results again.
Its a bug of the sum function when it has a formula with a division inside it.

Yet again i learn that it doesnt have a problem when it doesnt include a division inside it.

So i thought to make a 2nd table which will hold the division part multiplied with a number, and to be connected with a foreign key with the 1st table.
Here are the 2 tables dump

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.41


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema gas_station
--

CREATE DATABASE IF NOT EXISTS gas_station;
USE gas_station;

--
-- Definition of table `kiniseis`
--

DROP TABLE IF EXISTS `kiniseis`;
CREATE TABLE `kiniseis` (
  `id_kiniseon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kinisis_1a` decimal(11,0) NOT NULL,
  `100a` decimal(11,0) NOT NULL,
  `super_1a` decimal(11,0) NOT NULL,
  `95_1a` decimal(11,0) NOT NULL,
  `95_2a` decimal(11,0) NOT NULL,
  `super_2a` decimal(11,0) NOT NULL,
  `kinisis_2a` decimal(11,0) NOT NULL,
  `kinisis_1b` decimal(11,0) NOT NULL,
  `100b` decimal(11,0) NOT NULL,
  `super_1b` decimal(11,0) NOT NULL,
  `95_1b` decimal(11,0) NOT NULL,
  `95_2b` decimal(11,0) NOT NULL,
  `super_2b` decimal(11,0) NOT NULL,
  `kinisis_2b` decimal(11,0) NOT NULL,
  `kinisis_1c` decimal(11,0) NOT NULL,
  `100c` decimal(11,0) NOT NULL,
  `super_1c` decimal(11,0) NOT NULL,
  `95_1c` decimal(11,0) NOT NULL,
  `95_2c` decimal(11,0) NOT NULL,
  `super_2c` decimal(11,0) NOT NULL,
  `kinisis_2c` decimal(11,0) NOT NULL,
  `kinisis_1d` decimal(11,0) NOT NULL,
  `100d` decimal(11,0) NOT NULL,
  `super_1d` decimal(11,0) NOT NULL,
  `95_1d` decimal(11,0) NOT NULL,
  `95_2d` decimal(11,0) NOT NULL,
  `super_2d` decimal(11,0) NOT NULL,
  `kinisis_2d` decimal(11,0) NOT NULL,
  `kinisis_1e` decimal(11,0) NOT NULL,
  `100e` decimal(11,0) NOT NULL,
  `super_1e` decimal(11,0) NOT NULL,
  `95_1e` decimal(11,0) NOT NULL,
  `95_2e` decimal(11,0) NOT NULL,
  `super_2e` decimal(11,0) NOT NULL,
  `kinisis_2e` decimal(11,0) NOT NULL,
  `kinisis_a` decimal(11,0) NOT NULL,
  `100_a` decimal(11,0) NOT NULL,
  `95_a` decimal(11,0) NOT NULL,
  `super_a` decimal(11,0) NOT NULL,
  `kinisis_b` decimal(11,2) NOT NULL,
  `100_b` decimal(11,2) NOT NULL,
  `95_b` decimal(11,2) NOT NULL,
  `super_b` decimal(11,2) NOT NULL,
  `date` date NOT NULL,
  `fpa` decimal(11,2) NOT NULL,
  `poliseon_ID` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_kiniseon`),
  KEY `FK_kiniseis` (`poliseon_ID`),
  CONSTRAINT `FK_kiniseis` FOREIGN KEY (`poliseon_ID`) REFERENCES `poliseis` (`id_poliseon`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kiniseis`
--

/*!40000 ALTER TABLE `kiniseis` DISABLE KEYS */;
/*!40000 ALTER TABLE `kiniseis` ENABLE KEYS */;


--
-- Definition of table `poliseis`
--

DROP TABLE IF EXISTS `poliseis`;
CREATE TABLE `poliseis` (
  `id_poliseon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kinisis_1` decimal(11,4) NOT NULL,
  `100ara` decimal(11,4) NOT NULL,
  `super_1` decimal(11,4) NOT NULL,
  `95_1` decimal(11,4) NOT NULL,
  `95_2` decimal(11,4) NOT NULL,
  `super_2` decimal(11,4) NOT NULL,
  `kinisis_2` decimal(11,4) NOT NULL,
  PRIMARY KEY (`id_poliseon`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `poliseis`
--

/*!40000 ALTER TABLE `poliseis` DISABLE KEYS */;
/*!40000 ALTER TABLE `poliseis` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

And below is the insert record page which while the insertion i want to calculate the division number i stated above :

<?php require_once('../Connections/gas_connection.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insert_form")) {
  $insertSQL = sprintf("INSERT INTO kiniseis (kinisis_1a, `100a`, super_1a, `95_1a`, `95_2a`, super_2a, kinisis_2a, kinisis_1b, `100b`, super_1b, `95_1b`, `95_2b`, super_2b, kinisis_2b, kinisis_1c, `100c`, super_1c, `95_1c`, `95_2c`, super_2c, kinisis_2c, kinisis_1d, `100d`, super_1d, `95_1d`, `95_2d`, super_2d, kinisis_2d, kinisis_1e, `100e`, super_1e, `95_1e`, `95_2e`, super_2e, kinisis_2e, kinisis_a, `100_a`, `95_a`, super_a, kinisis_b, `100_b`, `95_b`, super_b, `date`, fpa) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['1'], "double"),
                       GetSQLValueString($_POST['2'], "double"),
                       GetSQLValueString($_POST['3'], "double"),
                       GetSQLValueString($_POST['4'], "double"),
                       GetSQLValueString($_POST['5'], "double"),
                       GetSQLValueString($_POST['6'], "double"),
                       GetSQLValueString($_POST['7'], "double"),
                       GetSQLValueString($_POST['8'], "double"),
                       GetSQLValueString($_POST['9'], "double"),
                       GetSQLValueString($_POST['10'], "double"),
                       GetSQLValueString($_POST['11'], "double"),
                       GetSQLValueString($_POST['12'], "double"),
                       GetSQLValueString($_POST['13'], "double"),
                       GetSQLValueString($_POST['14'], "double"),
                       GetSQLValueString($_POST['15'], "double"),
                       GetSQLValueString($_POST['16'], "double"),
                       GetSQLValueString($_POST['17'], "double"),
                       GetSQLValueString($_POST['18'], "double"),
                       GetSQLValueString($_POST['19'], "double"),
                       GetSQLValueString($_POST['20'], "double"),
                       GetSQLValueString($_POST['21'], "double"),
                       GetSQLValueString($_POST['22'], "double"),
                       GetSQLValueString($_POST['23'], "double"),
                       GetSQLValueString($_POST['24'], "double"),
                       GetSQLValueString($_POST['25'], "double"),
                       GetSQLValueString($_POST['26'], "double"),
                       GetSQLValueString($_POST['27'], "double"),
                       GetSQLValueString($_POST['28'], "double"),
                       GetSQLValueString($_POST['29'], "double"),
                       GetSQLValueString($_POST['30'], "double"),
                       GetSQLValueString($_POST['31'], "double"),
                       GetSQLValueString($_POST['32'], "double"),
                       GetSQLValueString($_POST['33'], "double"),
                       GetSQLValueString($_POST['34'], "double"),
                       GetSQLValueString($_POST['35'], "double"),
                       GetSQLValueString($_POST['36'], "double"),
                       GetSQLValueString($_POST['37'], "double"),
                       GetSQLValueString($_POST['38'], "double"),
                       GetSQLValueString($_POST['39'], "double"),
                       GetSQLValueString($_POST['40'], "double"),
                       GetSQLValueString($_POST['41'], "double"),
                       GetSQLValueString($_POST['42'], "double"),
                       GetSQLValueString($_POST['43'], "double"),
                       GetSQLValueString($_POST['date'], "date"),
                       GetSQLValueString($_POST['select_fpa'], "double"));

  mysql_select_db($database_gas_connection, $gas_connection);
  $Result1 = mysql_query($insertSQL, $gas_connection) or die(mysql_error());

  $insertGoTo = "../confirmation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

$venzini_kinisis_1 = @($row_KINISEIS['kinisis_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['kinisis_1a'];
$venzini_100ara = @($row_KINISEIS['100c']/$row_KINISEIS['100b']) * $row_KINISEIS['100a'];
$venzini_super_1 = @($row_KINISEIS['super_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['super_1a'];
$venzini_95_1 = @($row_KINISEIS['95_1c']/$row_KINISEIS['95_1b']) * $row_KINISEIS['95_1a'];
$venzini_95_2 = @($row_KINISEIS['95_2c']/$row_KINISEIS['95_2b']) * $row_KINISEIS['95_2a'];
$venzini_super_2 = @($row_KINISEIS['super_2c']/$row_KINISEIS['super_2b']) * $row_KINISEIS['super_2a'];
$venzini_kinisis_2 = @($row_KINISEIS['kinisis_2c']/$row_KINISEIS['kinisis_2b']) * $row_KINISEIS['kinisis_2a'];

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insert_form")) {
  $insertSQL = sprintf("INSERT INTO poliseis (kinisis_1, `100ara`, super_1, `95_1`, `95_2`, super_2, kinisis_2) VALUES (%s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['$venzini_kinisis_1'], "double"),
                       GetSQLValueString($_POST['$venzini_100ara'], "double"),
                       GetSQLValueString($_POST['$venzini_super_1'], "double"),
                       GetSQLValueString($_POST['$venzini_95_1'], "double"),
                       GetSQLValueString($_POST['$venzini_95_2'], "double"),
                       GetSQLValueString($_POST['$venzini_super_2'], "double"),
                       GetSQLValueString($_POST['$venzini_kinisis_2'], "double"));

  mysql_select_db($database_gas_connection, $gas_connection);
  $Result1 = mysql_query($insertSQL, $gas_connection) or die(mysql_error());

  $insertGoTo = "../confirmation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_gas_connection, $gas_connection);
$query_KINISEIS = "SELECT * FROM kiniseis";
$KINISEIS = mysql_query($query_KINISEIS, $gas_connection) or die(mysql_error());
$row_KINISEIS = mysql_fetch_assoc($KINISEIS);
$totalRows_KINISEIS = mysql_num_rows($KINISEIS);
?>

The values that will be posted in the poliseis table (the 2nd one) is those that are calculated with their declared variable :

$venzini_kinisis_1 = @($row_KINISEIS['kinisis_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['kinisis_1a'];
$venzini_100ara = @($row_KINISEIS['100c']/$row_KINISEIS['100b']) * $row_KINISEIS['100a'];
$venzini_super_1 = @($row_KINISEIS['super_1c']/$row_KINISEIS['kinisis_1b']) * $row_KINISEIS['super_1a'];
$venzini_95_1 = @($row_KINISEIS['95_1c']/$row_KINISEIS['95_1b']) * $row_KINISEIS['95_1a'];
$venzini_95_2 = @($row_KINISEIS['95_2c']/$row_KINISEIS['95_2b']) * $row_KINISEIS['95_2a'];
$venzini_super_2 = @($row_KINISEIS['super_2c']/$row_KINISEIS['super_2b']) * $row_KINISEIS['super_2a'];
$venzini_kinisis_2 = @($row_KINISEIS['kinisis_2c']/$row_KINISEIS['kinisis_2b']) * $row_KINISEIS['kinisis_2a'];

I run the whole thing but i receive the following error :

Cannot add or update a child row: a foreign key constraint fails (`gas_station`.`kiniseis`, CONSTRAINT `FK_kiniseis` FOREIGN KEY (`poliseon_ID`) REFERENCES `poliseis` (`id_poliseon`) ON DELETE CASCADE ON UPDATE CASCADE)

Something is wrong but i can not see it :frowning:
Any suggestions to this problem?

Thanks again :slight_smile:

i am sorry, i have no idea what you are doing

perhaps you could flag your thread and ask a moderator to move it to the php forum if that’s where you’re going to do the sum

r937 thank you very much i appreciate it :slight_smile:

I had small mistake in my query (i want to de-tax a number basicly, column fpa is the added tax value)

Was my mistake that i didnt told you a small but important detail.
The values i calculated from excel was from an other page i have that has 1 table , and in a cell adds 3 values. The number that is computed by the sum of those 3 values (with tax value included) , on an other cell is computed like below
((sum of 3 values)/(1+fpa)) * 1.005

Ok now with repeat region of the table i got the amount of this formula stated above for each record.

The totals that are correct ,which are the below ones (57 records, bewtween 2 dates)
7,102.56
4,247.54
5,240.10
5,671.92
6,406.82
2,153.26
4,448.42
4,673.18
4,671.98
5,158.61
5,987.77
5,585.56
4,745.54
5,378.74
4,992.81
5,382.46
6,929.17
4,289.44
4,034.80
6,120.87
5,093.98
5,230.31
6,212.02
6,117.57
4,318.29
6,048.58
5,207.88
4,402.67
5,735.78
5,803.50
6,056.55
7,045.01
6,263.73
5,513.73
5,213.03
5,981.59
6,335.09
5,876.68
5,415.44
5,427.29
5,963.86
5,994.41
4,762.65
5,911.36
5,430.57
5,027.80
4,538.96
5,317.29
4,869.89
5,553.88
5,816.56
5,602.75
3,981.29
6,727.43
5,152.47
5,487.49
4,427.71

Total sum = 307,086.64

Now after i searched carefully on google i came up to this piece of information from Microsoft that says that there is a precision problem with SUM() function
http://support.microsoft.com/kb/281341

From the 3 work arrounds they propose i can use only the 2nd one since the column fpa is not integer but double 0.19 , 0.21 ect.

Store the sum in a variable first, and use the variable in the formula

When i read this i understand that i should make a query without the sum inside it , and after to use the SUM() function within the page it self using the recordset created by dreamweaver.

So i created this :

SELECT (((kinisis_1c + kinisis_1e + ((kinisis_1c / kinisis_1b) * kinisis_1a))/(1 + fpa)) * 1.005) AS kinisis_1_total, (((100c + 100e + ((100c / 100b)* 100a)) / (1 + fpa)) *1.005) AS 100ara_total, (((super_1c  + super_1e + ((super_1c / super_1b)* super_1a)) / (1 + fpa)) *1.005) AS super_1_total, (((95_1c + 95_1e + ((95_1c / 95_1b)* 95_1a)) / (1 + fpa)) *1.005) AS 95_1_total, (((95_2c + 95_2e + ((95_2c / 95_2b)*  95_2a)) / (1 + fpa)) *1.005) AS 95_2_total, (((super_2c + super_2e + ((super_2c / super_2b) * super_2a)) / (1 + fpa)) *1.005) AS super_2_total, (((kinisis_2c + kinisis_2e + ((kinisis_2c / kinisis_2b) * kinisis_2a)) / (1 + fpa)) *1.005) AS kinisis_2_total
FROM kiniseis
WHERE `date` BETWEEN '$_GET[date1]' AND '$_GET[date2]'

The problem i have now is that i know only in mysql how to type the correct syntax for the sum function in php


<?php 
$i1 = 'SUM($row_i_totals[kinisis_1_total])';
?>

And because this is a string i dont know how to output it correctly :frowning:

I excpect between the dates 2006-10-30 and 2006-12-05 (the 1st 57 records) to give me a result
$i1 = 93665.11 .

Any suggestions , modifications ? :slight_smile:

Thank you very much again :slight_smile:

okay, that’s great

i ran this query to examine the data –

SELECT kinisis_1a , kinisis_1b , kinisis_1c , kinisis_1e , fpa
     , (kinisis_1c / kinisis_1b) as d
     , (kinisis_1c / kinisis_1b) * kinisis_1a as e
     , (kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa) as f
     , (kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)* 1.005 as g
  FROM kiniseis
 WHERE id_kiniseon < 21

this produced the following…

kinisis_1a   kinisis_1b   kinisis_1c   kinisis_1e      fpa       d        e              f              g
         0         2100         1888         1527     0.19    0.90        0        2766.15     2779.98075
         0          979          876          768     0.19    0.89        0        1331.64      1338.2982
        53         3334         1185         1178     0.19    0.36    18.84    1929.288563    1938.935006
         0         1696         1518          804     0.19    0.90        0        1880.82      1890.2241
         0         2863         2562            0     0.19    0.89        0        2075.22      2085.5961
         0          227          203            0     0.19    0.89        0         164.43      165.25215
        22          613          548          297     0.19    0.89    19.67    700.3804405    703.8823427
         0         1099          983          330     0.19    0.89        0        1063.53     1068.84765
         0         1214         1087          454     0.19    0.90        0        1248.21     1254.45105
         0         1706         1527          693     0.19    0.90        0         1798.2       1807.191
         0          770          689          965     0.19    0.89        0        1339.74      1346.4387
         0          306          274           41     0.19    0.90        0         255.15      256.42575
         0         1272         1138          200     0.19    0.89        0        1083.78      1089.1989
         0         2321         2077            0     0.19    0.89        0        1682.37     1690.78185
        23         2193         1962            0     0.19    0.89    20.58    1605.887606    1613.917044
         0         2385         2134            0     0.19    0.89        0        1728.54      1737.1827
         0         3475         3110            0     0.19    0.89        0         2519.1      2531.6955
        56         1117         1000            0     0.19    0.90    50.13    850.6087735    854.8618174
         0         1350         1208            0     0.19    0.89        0         978.48       983.3724
         0         3497         3130            0     0.19    0.90        0         2535.3      2547.9765

i also pasted these results into excel and i got the following number for the sum of the last column: 29684.50951

then i ran this query:

SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a)  * (1-fpa)*1.005) AS x
  FROM kiniseis
 WHERE id_kiniseon < 21

and here’s the result from this query: 29684.50951018

my conclusion is that you don’t gots a problem

:cool:

[QUOTE=r937;4632844]extra column? no

why don’t you dump the table and give us the CREATE TABLE statement as well as a few INSERT statements so that we can try to reproduce the results and perhaps see what’s causing it or how to fix it[/QUOTE]

Create table statement

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.1.41


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema gas_station
--

CREATE DATABASE IF NOT EXISTS gas_station;
USE gas_station;

--
-- Definition of table `kiniseis`
--

DROP TABLE IF EXISTS `kiniseis`;
CREATE TABLE `kiniseis` (
  `id_kiniseon` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `kinisis_1a` int(10) unsigned NOT NULL,
  `100a` int(10) unsigned NOT NULL,
  `super_1a` int(10) unsigned NOT NULL,
  `95_1a` int(10) unsigned NOT NULL,
  `95_2a` int(10) unsigned NOT NULL,
  `super_2a` int(10) unsigned NOT NULL,
  `kinisis_2a` int(10) unsigned NOT NULL,
  `kinisis_1b` int(10) unsigned NOT NULL,
  `100b` int(10) unsigned NOT NULL,
  `super_1b` int(10) unsigned NOT NULL,
  `95_1b` int(10) unsigned NOT NULL,
  `95_2b` int(10) unsigned NOT NULL,
  `super_2b` int(10) unsigned NOT NULL,
  `kinisis_2b` int(10) unsigned NOT NULL,
  `kinisis_1c` int(10) unsigned NOT NULL,
  `100c` int(10) unsigned NOT NULL,
  `super_1c` int(10) unsigned NOT NULL,
  `95_1c` int(10) unsigned NOT NULL,
  `95_2c` int(10) unsigned NOT NULL,
  `super_2c` int(10) unsigned NOT NULL,
  `kinisis_2c` int(10) unsigned NOT NULL,
  `kinisis_1d` int(10) unsigned NOT NULL,
  `100d` int(10) unsigned NOT NULL,
  `super_1d` int(10) unsigned NOT NULL,
  `95_1d` int(10) unsigned NOT NULL,
  `95_2d` int(10) unsigned NOT NULL,
  `super_2d` int(10) unsigned NOT NULL,
  `kinisis_2d` int(10) unsigned NOT NULL,
  `kinisis_1e` int(10) unsigned NOT NULL,
  `100e` int(10) unsigned NOT NULL,
  `super_1e` int(10) unsigned NOT NULL,
  `95_1e` int(10) unsigned NOT NULL,
  `95_2e` int(10) unsigned NOT NULL,
  `super_2e` int(10) unsigned NOT NULL,
  `kinisis_2e` int(10) unsigned NOT NULL,
  `kinisis_a` int(10) unsigned DEFAULT NULL,
  `100_a` int(10) unsigned DEFAULT NULL,
  `95_a` int(10) unsigned DEFAULT NULL,
  `super_a` int(10) unsigned DEFAULT NULL,
  `kinisis_b` decimal(11,2) DEFAULT NULL,
  `100_b` decimal(11,2) DEFAULT NULL,
  `95_b` decimal(11,2) DEFAULT NULL,
  `super_b` decimal(11,2) DEFAULT NULL,
  `date` date NOT NULL,
  `fpa` double NOT NULL,
  PRIMARY KEY (`id_kiniseon`)
) ENGINE=InnoDB AUTO_INCREMENT=409 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `kiniseis`
--

/*!40000 ALTER TABLE `kiniseis` DISABLE KEYS */;
INSERT INTO `kiniseis` (`id_kiniseon`,`kinisis_1a`,`100a`,`super_1a`,`95_1a`,`95_2a`,`super_2a`,`kinisis_2a`,`kinisis_1b`,`100b`,`super_1b`,`95_1b`,`95_2b`,`super_2b`,`kinisis_2b`,`kinisis_1c`,`100c`,`super_1c`,`95_1c`,`95_2c`,`super_2c`,`kinisis_2c`,`kinisis_1d`,`100d`,`super_1d`,`95_1d`,`95_2d`,`super_2d`,`kinisis_2d`,`kinisis_1e`,`100e`,`super_1e`,`95_1e`,`95_2e`,`super_2e`,`kinisis_2e`,`kinisis_a`,`100_a`,`95_a`,`super_a`,`kinisis_b`,`100_b`,`95_b`,`super_b`,`date`,`fpa`) VALUES 
 (1,0,0,0,0,0,0,0,2100,218,333,804,849,144,1039,1888,231,319,728,769,138,930,1706,60,84,754,493,122,548,1527,64,80,683,446,117,490,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-03',0.19),
 (2,0,0,0,0,38,0,0,979,52,65,1077,563,42,779,876,55,62,975,510,40,697,859,74,0,480,422,0,131,768,79,434,382,0,117,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-04',0.19),
 (3,53,0,0,33,11,0,0,3334,49,213,927,740,126,691,1185,52,204,840,670,120,618,1313,92,46,425,522,15,295,1178,98,44,385,473,15,264,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-05',0.19),
 (4,0,0,0,0,0,0,0,1696,69,284,825,553,70,714,1518,73,272,747,501,67,639,899,115,156,912,615,15,478,804,122,149,826,557,14,427,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-06',0.19),
 (5,0,119,34,153,321,0,218,2863,359,204,1533,1663,49,808,2562,381,195,1389,1506,47,723,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-07',0.19),
 (6,0,0,5,33,0,0,0,227,143,56,1022,490,35,787,203,152,53,926,444,33,704,725,56,55,476,311,2,378,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-09',0.19),
 (7,22,0,0,0,47,0,0,613,250,189,965,557,96,968,548,265,181,874,505,92,866,332,66,63,647,489,41,422,297,70,60,586,443,40,378,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-10',0.19),
 (8,0,0,0,28,95,0,0,1099,197,104,1003,649,24,693,983,209,99,908,588,23,620,369,169,15,566,522,33,504,330,180,14,513,473,31,451,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-11',0.19),
 (9,0,0,0,0,0,0,0,1214,120,112,917,614,108,868,1087,127,107,830,556,103,777,508,75,88,600,515,58,293,454,80,84,543,467,55,262,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-12',0.19),
 (10,0,0,0,11,27,0,40,1706,111,122,530,576,55,517,1527,118,116,480,521,53,463,774,112,24,929,622,9,574,693,119,23,841,563,8,513,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-13',0.19),
 (11,0,0,0,0,0,0,0,770,333,71,1030,729,32,533,689,353,68,933,660,31,477,1078,173,142,1219,1009,41,601,965,184,136,1104,914,39,537,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-14',0.19),
 (12,0,0,0,99,85,0,56,306,323,135,1089,1101,144,411,274,343,129,986,997,138,368,46,321,70,1236,1291,34,437,41,341,67,1120,1170,32,391,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-15',0.19),
 (13,0,0,0,55,61,0,0,1272,121,145,916,733,75,820,1138,128,139,830,664,72,734,224,119,52,631,624,9,321,200,126,50,572,565,9,287,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-16',0.19),
 (14,0,0,34,39,0,0,0,2321,254,230,1721,1035,141,1231,2077,270,220,1559,938,135,1102,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-17',0.19),
 (15,23,0,0,66,11,0,52,2193,243,308,1352,999,84,1173,1962,258,295,1225,905,80,1050,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-18',0.19),
 (16,0,0,0,0,0,0,45,2385,138,232,1556,1242,210,1224,2134,146,222,1410,1125,201,1095,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-19',0.19),
 (17,0,0,0,33,80,0,45,3475,433,291,1763,1513,73,1313,3110,459,279,1597,1371,70,1176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-20',0.19),
 (18,56,0,0,0,55,0,94,1117,476,257,1228,1223,53,976,1000,505,246,1112,1108,51,873,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-21',0.19),
 (19,0,0,31,53,22,0,0,1350,268,246,1315,1023,171,751,1208,285,235,1191,926,163,672,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-23',0.19),
 (20,0,0,11,0,13,0,45,3497,238,406,1504,1013,58,1206,3130,252,388,1362,918,55,1080,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-24',0.19),
 (21,86,0,0,45,22,0,0,2344,70,268,1545,1207,83,998,2098,74,256,1400,1093,80,893,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-25',0.19),
 (22,0,0,20,0,6,0,23,1618,320,112,1721,1479,110,160,1448,340,107,1559,1340,105,1110,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-26',0.19),
 (23,0,0,0,11,22,0,32,3041,270,277,1882,1391,183,989,2721,286,265,1705,1260,175,885,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-27',0.19),
 (24,332,0,0,0,22,0,0,556,365,223,1456,983,48,727,497,387,213,1319,890,46,650,78,74,84,1316,1213,31,420,70,79,80,1192,1099,29,376,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-29',0.19),
 (25,223,0,0,31,0,0,22,909,165,83,803,667,40,978,813,175,79,727,604,38,875,780,113,50,248,219,35,261,698,120,48,224,198,34,233,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-30',0.19),
 (26,0,0,0,0,0,0,0,2387,85,223,1049,735,11,966,2136,90,213,950,666,10,865,908,0,84,528,495,28,432,812,0,80,478,449,27,386,0,0,0,0,'0.00','0.00','0.00','0.00','2006-10-31',0.19),
 (27,0,0,42,33,0,0,23,1136,107,195,894,766,136,932,1016,113,186,810,694,130,834,1363,88,35,334,445,10,259,1220,93,33,302,403,10,232,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-01',0.19),
 (28,0,46,0,124,139,0,44,4442,101,143,668,449,82,353,1290,107,136,605,406,78,316,794,67,21,582,389,32,262,710,71,20,532,352,30,234,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-02',0.19),
 (29,0,0,0,22,107,0,49,1363,127,150,908,611,70,810,1220,135,143,822,553,67,725,989,94,53,989,741,31,407,855,100,51,896,671,29,364,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-03',0.19),
 (30,34,32,9,50,111,0,28,2184,160,198,1070,737,49,514,1954,170,189,969,667,47,460,241,180,42,624,652,73,560,215,191,40,565,590,70,501,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-04',0.19),
 (31,825,29,0,65,92,0,33,1825,218,63,1156,623,67,758,1633,231,60,1044,564,64,678,332,105,65,525,499,0,626,297,111,62,475,452,0,560,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-06',0.19),
 (32,0,0,0,44,0,0,0,3093,138,159,901,794,81,926,2768,146,152,816,719,77,829,1295,50,175,582,461,96,425,1159,53,167,527,417,92,380,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-07',0.19),
 (33,512,38,27,199,268,10,133,1631,175,190,776,626,126,883,1460,185,181,703,567,120,790,779,171,83,624,416,0,486,697,181,80,565,377,0,435,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-08',0.19),
 (34,0,0,21,0,66,0,67,1609,46,124,1013,654,146,676,1440,49,118,918,592,139,605,714,221,110,831,403,13,470,639,234,105,752,365,13,420,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-09',0.19),
 (35,0,0,0,115,11,0,4,1590,136,129,697,875,35,741,1423,144,123,631,792,34,663,506,88,106,716,596,2,456,453,93,101,648,540,2,408,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-10',0.19),
 (36,0,42,0,94,88,0,17,1643,127,107,772,904,53,546,1470,135,102,699,819,51,488,999,389,87,769,634,56,425,894,413,83,697,574,53,380,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-11',0.19),
 (37,129,0,0,22,99,0,0,2118,52,219,1381,896,20,1014,1898,55,210,1251,812,19,907,750,60,100,538,562,31,300,671,64,95,487,509,30,268,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-13',0.19),
 (38,0,19,8,71,77,0,33,1505,152,224,960,396,127,1010,1347,161,214,870,359,121,904,1397,105,37,443,491,10,603,1250,111,35,401,445,10,539,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-14',0.19),
 (39,0,0,0,11,106,0,44,999,231,127,768,678,76,776,894,245,121,696,614,73,694,1377,144,91,506,573,46,489,1232,153,87,458,519,44,437,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-15',0.19),
 (40,11,0,0,0,16,0,0,1367,42,278,875,704,31,546,1223,44,266,792,638,30,488,1160,85,34,734,568,1,649,1038,90,32,665,515,1,580,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-16',0.19),
 (41,0,0,0,17,89,0,22,1008,204,63,937,593,72,753,902,216,60,849,537,69,674,1505,159,99,853,730,53,609,1347,169,95,772,661,50,545,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-17',0.19),
 (42,0,0,0,44,74,0,0,1440,285,141,914,973,47,752,1289,302,135,828,881,45,673,726,136,75,831,821,89,437,650,144,71,753,744,85,391,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-18',0.19),
 (43,0,0,10,0,34,0,0,250,289,158,1226,924,51,383,223,307,151,1110,837,49,342,0,129,36,1377,607,72,607,0,137,34,1247,550,69,543,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-19',0.19),
 (44,335,0,15,383,185,0,115,923,100,110,872,570,73,792,826,106,105,790,516,70,709,1348,66,82,623,491,73,575,1206,70,78,564,444,70,514,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-20',0.19),
 (45,631,0,0,11,79,21,56,657,104,71,585,497,38,627,588,110,68,530,450,36,561,1004,135,149,500,893,31,1001,898,143,142,453,809,30,896,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-21',0.19),
 (46,0,0,0,45,0,0,23,1685,38,118,795,687,42,671,1508,40,113,720,622,40,600,738,132,34,514,422,33,601,660,140,32,465,382,32,538,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-22',0.19),
 (47,0,0,0,91,53,0,0,1519,147,180,671,757,34,804,1359,156,172,608,686,32,719,112,123,0,651,249,54,465,100,130,0,590,225,51,416,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-23',0.19),
 (48,0,0,0,89,22,0,80,1502,163,128,830,722,107,793,1344,173,122,752,654,102,709,598,47,26,840,715,10,269,535,50,25,761,647,10,240,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-24',0.19),
 (49,0,0,0,28,22,0,28,998,115,105,803,809,77,779,893,122,100,727,733,73,697,347,82,50,918,758,87,342,310,87,48,831,686,83,306,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-25',0.19),
 (50,17,116,52,393,370,42,58,1199,122,147,835,821,97,571,1073,129,140,756,743,93,511,548,19,42,734,329,63,657,490,20,40,665,298,60,588,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-27',0.19),
 (51,111,0,0,45,67,0,78,1491,176,193,913,776,143,988,1333,187,185,826,702,137,883,784,78,73,642,431,95,501,701,83,70,581,390,91,448,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-28',0.19),
 (52,0,0,21,59,49,0,45,1857,148,152,678,826,0,817,1662,157,145,614,748,0,731,717,18,58,660,581,52,593,641,19,55,598,526,50,530,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-29',0.19),
 (53,0,0,0,0,22,0,45,1240,0,73,830,581,26,549,1110,0,70,752,526,25,491,129,111,21,598,456,18,510,115,118,20,541,413,17,456,0,0,0,0,'0.00','0.00','0.00','0.00','2006-11-30',0.19),
 (54,0,0,0,209,22,0,22,1926,269,185,951,556,0,1284,1723,285,177,861,503,0,1149,787,218,65,912,818,48,480,704,231,62,826,741,46,429,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-01',0.19),
 (55,0,28,21,423,244,35,89,873,70,166,915,953,108,675,871,74,159,829,863,103,604,336,192,21,562,440,50,394,300,204,20,509,398,48,352,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-02',0.19),
 (56,0,14,0,22,87,0,0,1100,111,101,950,766,97,1193,984,118,96,860,694,93,1067,639,38,56,828,497,46,294,572,40,53,750,450,44,563,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-04',0.19),
 (57,0,0,0,0,22,0,11,1100,0,155,795,696,86,1000,993,0,148,720,630,82,895,112,150,89,563,465,86,434,100,159,85,510,421,82,388,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-05',0.19),
 (58,0,0,0,55,44,0,67,1036,67,138,1035,655,59,925,927,71,123,937,593,56,828,914,95,57,654,560,21,363,818,101,54,592,507,20,325,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-06',0.19),
 (59,0,57,0,44,22,0,67,1930,63,49,838,685,36,901,1727,67,47,759,260,34,806,430,256,45,772,439,10,485,385,272,43,699,397,10,434,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-07',0.19),
 (60,0,77,0,180,60,10,23,3432,103,73,701,453,39,744,1281,109,70,635,410,37,666,855,190,94,1027,735,43,726,765,201,90,930,666,41,650,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-08',0.19),
 (61,0,46,0,87,34,0,0,903,171,117,1202,908,125,683,808,181,112,1089,822,119,611,47,139,147,690,472,5,449,42,147,140,625,427,5,402,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-09',0.19),
 (62,0,0,0,66,106,0,0,84,89,105,1176,624,9,580,75,94,100,1065,565,9,519,293,84,31,1137,943,52,562,262,89,29,1030,854,50,503,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-10',0.19),
 (63,0,0,0,11,22,24,67,1440,47,143,747,710,56,706,1289,50,137,676,643,53,632,646,28,21,535,510,73,533,578,30,20,484,462,70,477,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-11',0.19),
 (64,0,0,0,78,17,0,45,1992,19,123,709,585,93,970,1783,20,188,642,530,89,868,112,57,42,577,332,92,367,100,60,40,522,300,88,328,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-12',0.19),
 (65,0,0,0,74,94,0,0,1306,201,35,845,986,45,785,1169,213,33,765,893,44,702,660,29,16,579,586,28,621,590,30,15,524,531,27,555,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-13',0.19),
 (66,0,18,0,162,206,25,86,1276,94,21,800,478,23,730,1142,100,20,725,433,22,653,1252,103,11,1143,486,16,485,1120,109,10,1035,440,15,434,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-14',0.19),
 (67,0,0,0,16,27,0,0,1427,144,111,1043,670,99,830,1277,153,106,945,607,89,743,503,94,89,803,531,37,401,450,100,85,727,481,35,359,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-15',0.19),
 (68,0,49,26,39,33,0,0,494,178,61,1097,725,60,400,442,189,58,994,656,57,358,984,41,109,777,646,64,480,880,43,104,704,585,585,430,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-16',0.19),
 (69,0,0,42,78,158,0,106,988,96,133,1100,636,79,572,884,102,127,996,576,75,673,760,117,40,658,601,21,707,680,124,38,596,544,20,632,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-18',0.19),
 (70,0,14,16,0,49,0,0,843,62,136,996,674,74,829,754,66,145,902,610,71,742,166,76,96,694,628,41,527,150,81,93,635,575,40,477,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-19',0.19),
 (71,0,14,20,466,159,0,162,1011,107,118,697,688,51,711,915,114,115,638,630,50,643,491,87,41,375,403,67,288,444,93,40,343,369,65,260,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-20',0.19),
 (72,0,0,0,24,49,0,0,1561,212,79,1232,715,130,786,1412,227,77,1128,655,127,711,811,237,45,576,566,13,572,734,254,44,527,518,12,517,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-21',0.19),
 (73,0,19,0,20,11,0,78,3205,205,154,1031,1008,8,1031,1995,219,150,944,923,8,933,538,284,65,700,501,25,699,487,304,54,641,459,24,632,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-22',0.19),
 (74,0,0,0,99,93,0,35,1776,343,117,1279,1108,143,426,1607,367,114,1171,1015,139,385,331,66,41,780,537,54,442,300,70,40,714,492,52,400,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-23',0.19),
 (75,0,0,0,22,28,0,0,133,326,179,1339,736,114,670,120,349,174,1226,674,110,606,144,88,20,967,810,138,394,130,94,20,885,742,134,356,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-24',0.19),
 (76,0,0,0,476,594,0,203,0,196,104,1125,1001,73,462,0,210,101,1030,917,71,418,99,194,100,1292,885,71,407,90,208,97,1183,810,69,368,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-26',0.19),
 (77,332,0,0,44,65,0,77,579,143,98,1009,739,26,781,524,153,95,924,677,25,707,637,117,103,791,580,37,250,576,125,100,724,531,36,226,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-27',0.19),
 (78,587,0,0,91,55,0,0,587,150,169,1000,811,52,718,531,160,165,916,742,50,650,1002,67,138,728,468,20,365,907,72,134,666,428,20,330,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-28',0.19),
 (79,352,46,0,44,44,0,44,425,102,138,1246,865,59,807,384,109,134,1141,792,57,730,644,162,0,848,581,9,583,583,173,0,776,532,9,527,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-29',0.19),
 (80,11,0,0,91,0,0,83,1411,69,114,1064,915,56,515,1277,74,111,974,838,54,466,0,425,40,693,654,30,483,0,455,39,634,599,30,437,0,0,0,0,'0.00','0.00','0.00','0.00','2006-12-30',0.19),
 (81,0,37,51,597,502,0,236,1109,56,126,864,673,75,689,1003,60,123,791,616,73,623,458,134,61,581,330,24,214,414,143,59,532,302,23,193,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-02',0.19),
 (82,0,0,0,0,0,0,0,1009,115,148,985,863,41,443,913,123,144,902,790,40,401,451,47,47,625,337,21,547,408,50,46,572,308,20,495,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-03',0.19),
 (83,0,0,0,22,10,0,22,1718,92,92,901,585,134,601,1554,98,89,825,535,130,544,699,14,79,444,617,21,265,632,15,77,406,565,20,240,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-04',0.19),
 (84,0,0,0,0,0,0,0,1705,104,121,880,482,30,438,1543,111,118,806,441,29,396,626,284,67,904,762,0,512,566,304,65,828,698,0,463,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-05',0.19),
 (85,0,0,0,0,42,0,0,0,141,31,1708,896,86,360,0,151,30,1564,820,84,325,0,175,151,1563,1162,21,521,0,187,147,1431,1064,20,471,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-06',0.19),
 (86,0,106,0,524,462,0,93,878,121,97,1145,778,38,1039,794,129,94,1049,712,37,940,576,52,21,762,363,20,363,521,55,20,698,360,19,328,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-08',0.19),
 (87,0,0,0,91,10,0,38,889,93,226,743,743,90,636,804,100,220,680,680,88,575,1044,23,107,674,591,89,314,945,24,104,617,541,87,284,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-09',0.19),
 (88,0,28,0,16,38,0,50,830,42,158,650,943,65,635,751,45,154,595,864,63,574,652,90,68,572,624,31,265,590,96,66,524,571,30,240,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-10',0.19),
 (89,0,59,86,11,41,0,66,226,38,86,560,565,82,1212,204,40,84,513,517,80,1096,690,44,46,519,493,35,206,624,47,45,475,451,34,186,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-11',0.19),
 (90,115,0,0,0,56,21,0,1516,129,88,564,753,42,497,1357,137,85,511,682,40,444,285,59,52,673,744,27,481,255,62,50,609,674,26,430,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-12',0.19),
 (91,0,0,0,204,327,0,46,430,269,127,953,608,66,648,385,285,122,863,550,63,580,553,237,98,869,885,94,223,495,251,94,787,801,91,199,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-13',0.19),
 (92,0,0,0,44,121,0,67,1921,67,167,781,882,61,678,1569,71,159,699,790,58,606,777,33,21,560,693,23,327,695,35,20,501,621,22,292,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-15',0.19),
 (93,0,0,10,0,0,0,0,489,134,158,711,947,123,183,437,142,151,637,848,117,93,502,66,26,691,506,26,462,449,70,25,619,453,25,413,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-16',0.19),
 (94,0,0,21,23,29,0,0,984,161,108,1035,589,22,529,851,171,103,899,512,21,457,445,47,126,912,480,9,614,385,50,122,792,417,8,531,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-17',0.19),
 (95,0,0,0,52,12,0,0,564,308,239,1083,917,16,842,488,324,223,941,885,15,728,475,49,32,640,296,11,318,410,51,30,556,257,10,275,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-18',0.19),
 (96,34,21,11,85,98,0,69,1391,112,177,958,780,146,1092,1203,118,165,832,678,136,944,1259,173,129,695,480,21,287,1089,182,120,604,417,19,248,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-19',0.19),
 (97,0,0,0,0,52,0,41,940,22,122,866,847,33,730,813,23,114,752,736,31,631,420,164,43,886,678,20,259,363,172,40,770,589,19,224,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-20',0.19),
 (98,0,0,0,81,33,0,24,58,184,89,1341,930,9,313,50,193,83,1165,808,8,270,0,72,53,882,692,45,458,0,75,50,768,601,42,396,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-21',0.19),
 (99,0,14,16,23,71,0,23,719,47,69,928,772,47,713,622,49,64,806,670,44,616,1598,46,43,786,545,8,427,1382,48,40,683,473,8,369,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-22',0.19),
 (100,0,0,0,49,23,0,0,321,165,172,1244,721,52,651,277,170,157,1068,619,47,563,458,29,33,605,586,61,368,396,30,30,519,503,56,318,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-23',0.19),
 (101,0,0,0,12,12,0,0,1348,138,78,744,590,11,601,1166,142,71,639,507,10,520,752,136,55,358,534,36,379,650,140,50,823,458,33,328,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-24',0.19),
 (102,0,7,0,162,125,0,0,682,54,58,990,788,25,690,590,56,53,850,677,23,597,849,133,22,1106,521,33,346,734,137,20,950,447,30,299,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-25',0.19),
 (103,94,0,22,46,117,26,46,770,150,85,1039,439,46,738,666,155,78,903,381,42,638,1112,70,102,559,792,81,410,962,72,93,485,688,74,354,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-26',0.19),
 (104,0,0,0,17,11,0,0,202,163,159,1008,708,22,466,174,168,145,876,615,20,403,231,153,0,1027,849,0,326,200,158,0,892,737,0,282,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-27',0.19),
 (105,0,8,0,12,83,0,27,1139,58,27,823,919,77,496,985,60,24,715,798,70,429,712,100,11,601,335,1,252,616,105,10,534,298,1,218,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-29',0.19),
 (106,0,0,0,0,0,0,11,416,77,127,672,539,42,851,360,81,118,597,479,39,736,840,55,118,764,455,0,254,726,58,110,679,404,0,220,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-30',0.19),
 (107,23,0,10,101,115,0,41,1849,97,64,768,519,28,420,1599,102,60,682,461,26,363,1028,19,54,762,374,69,489,889,20,50,677,332,65,423,0,0,0,0,'0.00','0.00','0.00','0.00','2007-01-31',0.19),
 (108,0,0,16,0,0,0,0,722,106,69,1198,716,16,739,624,111,68,1065,636,15,639,1467,47,22,537,576,82,282,1269,50,20,472,512,77,244,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-01',0.19),
 (109,0,0,0,0,0,0,0,1047,19,217,763,686,43,668,905,20,203,678,610,40,578,1375,185,65,1012,870,32,313,1189,194,61,899,773,30,270,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-02',0.19),
 (110,0,38,0,22,95,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,158,16,715,533,22,503,0,166,15,635,474,20,435,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-03',0.19),
 (111,0,38,0,22,95,0,0,1700,151,110,1032,720,76,1142,1504,162,105,928,647,72,1010,1278,40,85,614,622,21,287,1131,43,81,552,559,20,254,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-05',0.19),
 (112,214,37,0,255,181,18,204,1102,56,173,680,584,81,557,975,60,165,611,525,77,493,644,82,47,627,572,23,405,570,88,45,563,514,22,358,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-06',0.19),
 (113,0,0,0,75,67,0,28,1112,28,186,1234,432,38,711,984,30,178,1109,388,36,629,1727,74,72,995,594,0,276,1528,79,69,894,534,0,244,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-07',0.19),
 (114,23,0,0,45,89,0,136,520,65,47,970,605,47,625,460,700,45,870,544,45,553,692,47,0,749,675,15,502,612,50,0,673,607,15,444,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-08',0.19),
 (115,0,0,0,0,0,0,0,914,18,84,934,710,63,702,809,19,80,839,638,60,621,792,19,44,813,599,23,338,701,20,42,731,538,22,299,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-09',0.19),
 (116,0,47,0,22,28,0,0,601,97,138,988,872,45,481,532,104,132,888,784,43,425,221,242,42,696,568,39,321,195,259,40,625,510,37,284,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-10',0.19),
 (117,0,70,0,84,42,0,0,0,115,70,896,654,111,405,0,123,67,805,588,106,358,226,237,47,1016,806,41,269,200,254,45,913,724,39,238,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-11',0.19),
 (118,23,81,0,152,39,11,56,1459,58,63,923,841,0,552,1291,62,60,830,756,0,488,0,19,31,710,612,0,487,0,20,30,638,550,0,431,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-12',0.19),
 (119,0,0,0,0,67,0,45,462,114,116,1025,739,15,942,409,122,111,921,664,14,833,933,62,57,840,341,61,550,826,66,54,755,306,58,487,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-13',0.19),
 (120,0,0,11,35,23,0,0,1556,161,50,928,1009,102,925,1377,172,48,834,907,97,818,1027,87,67,1052,887,27,826,909,83,64,945,797,26,731,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-14',0.19),
 (121,0,0,0,19,33,0,34,389,78,20,1149,657,139,493,344,83,19,1033,590,133,436,1405,97,21,814,534,10,373,1243,104,20,731,480,10,330,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-15',0.19),
 (122,0,0,0,0,0,0,0,615,267,40,777,770,52,409,544,286,38,698,692,50,362,1825,110,86,956,885,83,706,1615,118,82,859,795,79,624,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-16',0.19),
 (123,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,793,221,38,1025,839,21,558,693,237,36,921,754,20,494,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-17',0.19),
 (124,1009,142,16,804,440,21,134,1813,115,138,1350,918,124,825,1604,123,132,1214,825,118,730,630,67,62,1078,562,20,676,557,72,59,969,505,20,598,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-20',0.19),
 (125,0,28,0,17,16,0,47,1245,61,56,856,818,74,536,1102,65,54,769,735,71,474,1616,84,99,1039,718,63,284,1430,90,95,934,645,60,251,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-21',0.19),
 (126,0,0,0,61,61,0,0,730,158,195,709,613,52,714,646,169,186,637,551,50,632,932,65,59,682,551,33,367,825,69,56,613,495,31,235,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-22',0.19),
 (127,0,0,0,16,0,0,17,754,177,88,903,611,77,700,667,190,84,812,549,74,619,2184,56,63,872,667,15,638,1933,60,60,801,613,15,564,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-23',0.19),
 (128,69,0,0,234,183,0,96,200,140,152,1052,951,53,640,177,150,145,966,874,50,566,0,69,11,549,514,0,324,0,74,10,504,472,0,287,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-24',0.19),
 (129,0,0,0,27,0,0,0,249,170,77,1071,753,81,419,220,182,74,984,692,77,371,0,267,94,1321,1014,36,336,0,286,90,1214,932,34,297,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-25',0.19),
 (130,0,0,26,21,22,10,0,1465,95,137,1021,694,116,720,1296,102,131,938,638,111,637,1010,80,10,653,504,87,440,694,86,10,600,463,83,389,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-26',0.19),
 (131,0,0,0,33,0,0,0,804,37,82,810,519,68,498,711,40,78,744,477,65,441,440,108,61,508,800,42,491,389,115,58,467,735,40,434,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-27',0.19),
 (132,226,19,0,52,11,0,0,1123,18,126,700,499,21,609,994,20,120,643,458,20,539,708,19,0,973,430,62,142,626,20,0,894,395,59,125,0,0,0,0,'0.00','0.00','0.00','0.00','2007-02-28',0.19),
 (133,0,0,0,22,22,0,0,900,73,105,826,638,23,340,814,80,102,747,577,22,307,1010,84,94,908,409,38,465,914,92,92,852,384,37,421,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-01',0.19),
 (134,0,0,21,201,96,0,72,1460,115,115,1109,844,99,580,1321,125,112,1041,792,96,525,438,95,20,655,753,37,357,400,104,19,621,714,36,326,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-02',0.19),
 (135,0,28,0,0,37,0,0,1041,153,90,870,539,30,568,952,167,88,825,511,30,520,33,301,263,1959,1492,88,925,30,330,250,1857,1415,85,845,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-03',0.19),
 (136,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,595,23,36,549,563,2,556,544,25,35,521,534,2,509,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-05',0.19),
 (137,0,0,0,15,21,0,11,851,227,245,768,796,20,900,778,248,239,728,755,20,824,867,98,5,767,302,5,309,793,107,5,728,286,5,283,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-06',0.19),
 (138,0,0,0,0,21,0,0,960,26,115,938,860,32,513,878,28,112,890,816,31,469,1348,156,30,680,470,41,438,1233,170,29,645,446,40,400,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-07',0.19),
 (139,0,3,30,280,121,0,85,1027,52,141,980,562,40,862,940,56,138,930,533,39,788,232,68,93,927,927,46,408,212,74,91,880,575,45,373,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-08',0.19),
 (140,109,0,0,52,32,5,54,1480,232,77,1000,808,38,436,1354,253,75,949,766,37,399,601,189,33,955,695,4,429,550,206,32,906,659,4,392,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-09',0.19),
 (141,110,0,45,33,0,0,0,1502,32,92,931,586,107,447,1374,35,90,883,556,104,409,573,46,21,1046,505,41,244,524,50,20,989,479,40,223,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-10',0.19),
 (142,11,0,0,100,37,0,55,421,96,142,1027,737,142,690,385,105,138,974,699,138,631,2135,282,57,640,531,8,347,1953,308,55,620,514,8,317,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-12',0.19),
 (143,164,0,0,21,10,0,0,1254,50,225,738,720,11,745,1147,55,219,715,697,10,681,357,51,72,810,622,0,583,326,55,70,785,603,0,533,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-13',0.19),
 (144,0,0,0,92,191,0,0,1576,122,104,830,495,31,409,1442,133,101,804,480,30,374,903,186,41,459,498,33,566,826,203,40,445,482,32,518,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-14',0.19),
 (145,0,0,0,0,31,0,0,1149,103,72,868,1001,71,833,1051,112,70,841,970,69,762,207,6,62,676,489,31,238,189,6,60,655,474,30,218,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-15',0.19),
 (146,0,0,0,0,0,0,0,1320,112,35,941,657,65,827,1195,122,34,912,636,63,748,914,83,0,744,756,43,397,827,90,0,721,732,42,359,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-16',0.19),
 (147,0,0,0,31,21,0,0,1083,27,70,662,524,75,353,980,30,68,641,508,73,319,0,196,102,653,603,4,276,0,214,100,632,584,4,250,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-17',0.19),
 (148,0,0,0,31,0,0,0,82,110,21,962,1096,65,564,75,120,20,932,1062,63,510,0,84,9,900,1080,0,755,0,92,9,872,1048,0,683,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-18',0.19),
 (149,0,0,0,0,0,0,0,1103,115,176,1072,585,67,601,998,125,172,1039,567,65,544,1166,34,30,701,533,57,240,1055,37,29,679,516,55,217,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-19',0.19),
 (150,582,43,51,214,323,16,248,1957,55,226,971,615,55,1054,1771,60,220,941,596,53,954,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-20',0.19),
 (151,221,49,62,379,165,4,340,464,168,41,642,590,9,687,420,183,40,622,572,9,622,442,26,34,496,402,0,256,400,28,33,480,389,0,231,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-21',0.19),
 (152,0,0,0,21,0,6,11,1446,20,101,607,599,83,831,1309,22,98,588,580,81,752,911,65,26,390,439,57,203,824,71,25,374,421,55,184,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-22',0.19),
 (153,220,9,0,0,43,0,99,612,240,172,1097,943,61,744,554,262,168,1052,904,59,673,133,91,66,629,565,49,301,120,99,65,603,542,48,272,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-23',0.19),
 (154,0,0,0,99,14,0,0,924,203,165,1156,623,90,868,836,221,161,1108,601,88,785,28,156,87,719,592,9,549,25,170,85,689,568,9,497,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-24',0.19),
 (155,22,30,0,670,458,99,209,1194,193,111,1186,865,47,562,1080,210,108,1137,829,46,508,1283,51,20,489,441,31,589,1161,55,20,469,423,30,533,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-26',0.19),
 (156,56,0,0,85,93,0,33,889,32,212,972,576,63,863,804,35,207,932,552,61,781,546,18,20,972,628,15,450,500,20,20,942,608,15,411,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-27',0.19),
 (157,0,0,0,8,21,0,0,1177,138,46,618,650,104,567,1077,150,45,599,630,101,519,1428,115,79,626,318,10,326,1306,125,77,606,308,10,298,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-28',0.19),
 (158,0,0,0,0,26,0,36,992,95,120,744,736,26,555,908,104,117,721,713,25,508,954,115,55,634,307,5,456,873,130,55,633,306,5,417,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-29',0.19),
 (159,0,0,4,75,124,0,55,795,47,107,698,743,39,932,727,53,107,698,743,39,853,749,88,20,578,748,62,355,685,99,20,578,748,62,325,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-30',0.19),
 (160,0,0,0,33,0,0,33,999,167,52,941,723,63,851,914,189,52,940,722,63,778,567,162,110,842,707,20,466,524,183,110,841,706,20,431,0,0,0,0,'0.00','0.00','0.00','0.00','2007-03-31',0.19),
 (161,214,104,0,440,371,63,193,1997,103,148,783,848,63,641,1107,116,149,782,847,63,593,605,17,75,730,627,22,301,559,19,75,729,626,22,278,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-02',0.19),
 (162,0,0,0,55,75,0,0,1732,167,203,858,926,10,937,1602,189,204,857,925,10,866,676,110,136,799,649,27,552,625,124,137,798,648,27,510,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-03',0.19),
 (163,0,0,0,63,30,0,87,806,182,166,793,662,77,545,745,206,166,792,661,77,504,378,133,22,739,694,48,469,350,150,22,738,693,48,434,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-04',0.19),
 (164,0,0,0,80,130,0,133,1237,186,88,868,823,109,729,1144,210,88,867,822,109,674,560,207,107,924,760,2,397,529,238,110,923,759,2,375,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-05',0.19),
 (165,21,0,0,101,71,10,0,349,17,42,1162,928,58,481,330,20,43,1161,927,59,454,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-06',0.19),
 (166,0,193,39,1297,726,49,287,125,362,140,1171,1174,26,334,118,417,143,1170,1173,26,315,106,181,35,757,947,16,440,100,208,36,756,946,16,416,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-07',0.19),
 (167,53,406,98,1788,1279,20,720,1884,180,185,894,675,33,933,1780,207,190,893,674,34,881,821,55,73,881,738,84,318,776,63,75,880,737,86,300,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-10',0.19),
 (168,0,0,0,33,20,0,0,1276,84,160,782,502,96,749,1206,97,164,781,501,98,708,496,0,78,520,527,0,198,469,0,80,519,526,0,187,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-11',0.19),
 (169,0,0,0,10,100,0,0,893,43,100,756,806,85,682,844,49,102,755,805,90,644,1090,105,68,933,553,22,337,1030,121,70,932,552,22,318,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-12',0.19),
 (170,0,54,0,243,160,0,65,245,82,47,658,547,147,610,231,94,48,668,555,151,576,167,97,63,663,814,34,375,158,112,64,673,826,35,354,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-13',0.19),
 (171,0,0,0,41,29,0,32,1762,189,104,1053,526,58,502,1665,218,107,1069,534,59,474,351,194,74,766,682,59,336,331,223,75,777,692,60,317,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-14',0.19),
 (172,0,18,0,54,108,24,32,0,165,141,820,891,44,647,0,190,145,832,904,45,611,126,70,78,967,651,13,492,119,80,80,982,661,13,465,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-16',0.19),
 (173,0,0,56,10,49,0,35,0,136,105,745,549,64,1098,0,156,107,756,557,65,1037,362,175,128,576,797,102,604,342,201,131,584,809,105,571,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-17',0.19),
 (174,0,0,0,30,29,0,32,1595,103,137,732,794,25,520,1507,119,140,743,806,26,491,584,43,19,726,383,59,188,552,50,20,737,389,61,177,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-18',0.19),
 (175,0,8,0,79,120,24,128,1210,100,20,631,768,42,535,1143,115,20,640,779,44,505,254,210,53,509,550,39,271,240,242,55,516,558,40,256,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-19',0.19),
 (176,0,0,9,34,19,0,35,379,78,194,746,813,90,576,358,90,201,757,825,93,544,1381,104,39,833,819,20,564,1305,120,40,845,831,21,533,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-20',0.19),
 (177,32,0,43,90,54,0,72,1590,170,96,716,548,43,591,1502,196,99,726,556,45,558,487,121,88,1017,723,32,630,460,139,91,1032,734,33,595,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-21',0.19),
 (178,0,0,0,20,0,0,0,60,226,64,1062,841,70,253,57,260,66,1078,853,72,239,0,174,196,897,799,39,470,0,200,203,910,811,40,444,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-22',0.19),
 (179,0,0,0,111,69,0,0,1041,101,53,813,662,35,460,984,116,55,825,672,36,435,1016,50,109,670,346,29,262,960,58,113,680,351,30,247,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-23',0.19),
 (180,0,0,0,61,61,0,16,830,49,196,864,920,80,883,784,56,203,877,934,83,834,914,152,124,766,543,24,377,854,175,128,777,551,25,356,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-24',0.19),
 (181,0,87,0,139,168,0,210,1604,78,105,750,515,51,784,1515,90,109,761,523,53,741,1314,68,0,494,525,47,335,1241,78,0,501,533,48,316,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-25',0.19),
 (182,0,0,0,39,39,0,11,1062,170,127,689,770,32,388,1003,196,131,699,781,33,366,370,86,48,1052,347,50,428,350,99,50,1067,352,52,404,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-26',0.19),
 (183,212,0,0,20,92,0,52,1374,34,85,849,621,28,861,1298,70,90,887,649,30,813,1019,256,75,578,715,86,443,963,305,80,604,747,91,418,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-27',0.19),
 (184,0,0,0,0,0,22,32,1741,82,63,995,1052,30,535,1645,98,67,1040,1099,32,505,37,88,45,497,433,62,292,35,105,48,519,452,66,276,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-28',0.19),
 (185,53,0,0,34,15,0,128,435,282,185,780,890,86,950,411,336,196,815,930,92,898,799,16,54,1166,850,87,760,755,19,57,1218,888,92,718,0,0,0,0,'0.00','0.00','0.00','0.00','2007-04-30',0.19),
 (186,0,213,0,451,477,12,50,724,25,111,834,758,47,528,684,30,118,872,792,50,499,1078,88,57,647,445,19,390,1019,105,60,676,465,20,368,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-02',0.19),
 (187,0,0,9,14,0,0,0,868,138,61,719,427,49,574,820,164,65,751,446,52,540,719,179,59,689,772,31,540,679,213,63,720,807,33,510,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-03',0.19),
 (188,0,0,0,30,0,0,58,466,52,149,1186,834,90,830,440,63,161,1263,888,97,784,2111,97,19,702,507,57,511,1995,117,20,748,540,62,483,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-04',0.19),
 (189,0,0,0,6,19,8,74,1572,154,169,749,722,51,554,1485,187,183,797,769,55,523,530,137,56,804,807,32,552,501,166,60,856,859,35,522,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-05',0.19),
 (190,0,8,0,144,101,0,21,0,8,56,862,800,31,334,0,10,60,918,852,34,315,0,101,42,1191,783,109,357,0,122,45,1268,834,118,337,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-06',0.19),
 (191,0,0,0,284,231,14,90,1141,66,51,663,669,23,552,1362,80,55,706,712,25,521,476,201,56,804,404,74,363,450,243,60,856,80,80,343,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-07',0.19),
 (192,0,0,0,29,83,0,0,575,16,192,941,697,102,895,543,20,208,1002,742,110,846,1048,62,46,485,493,38,717,990,75,50,516,525,41,677,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-08',0.19),
 (193,0,0,0,0,0,0,0,666,33,109,703,711,40,346,629,40,118,748,757,43,327,530,106,187,652,582,74,450,501,128,116,694,620,80,425,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-09',0.19),
 (194,0,0,0,28,0,0,18,848,76,37,558,614,40,740,801,92,40,594,654,43,699,956,80,186,754,520,29,440,903,97,201,803,554,31,416,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-10',0.19),
 (195,0,0,0,47,19,0,0,1538,47,101,684,675,14,490,1453,57,109,728,719,15,463,1547,134,39,1053,879,3,706,1462,162,42,1121,936,4,667,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-11',0.19),
 (196,0,33,10,71,24,0,53,866,116,153,978,783,76,529,818,140,165,1042,834,82,500,370,120,66,788,1095,48,454,350,145,71,839,1166,52,429,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-12',0.19),
 (197,22,8,0,216,174,0,85,771,25,166,873,901,89,714,728,30,180,930,959,96,675,834,74,56,761,511,28,440,788,90,61,810,544,30,416,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-14',0.19),
 (198,0,0,0,9,103,0,0,1148,157,160,968,659,160,748,1085,190,173,1031,702,173,707,978,120,74,617,489,45,726,924,145,80,657,521,49,686,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-15',0.19),
 (199,32,0,4,71,0,26,0,2280,200,162,699,627,107,655,2154,242,175,744,667,116,619,503,53,0,703,751,0,492,475,64,0,748,800,0,465,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-16',0.19),
 (200,0,0,0,0,0,0,104,984,124,34,783,718,64,799,930,150,37,834,765,69,755,1386,160,102,803,795,29,562,1310,194,110,855,846,32,531,0,0,0,0,'0.00','0.00','0.00','0.00','2007-05-17',0.19);
 
/*!40000 ALTER TABLE `kiniseis` ENABLE KEYS */;




/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

Insert record statement

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "insert_form")) {
  $insertSQL = sprintf("INSERT INTO kiniseis (kinisis_1a, `100a`, super_1a, `95_1a`, `95_2a`, super_2a, kinisis_2a, kinisis_1b, `100b`, super_1b, `95_1b`, `95_2b`, super_2b, kinisis_2b, kinisis_1c, `100c`, super_1c, `95_1c`, `95_2c`, super_2c, kinisis_2c, kinisis_1d, `100d`, super_1d, `95_1d`, `95_2d`, super_2d, kinisis_2d, kinisis_1e, `100e`, super_1e, `95_1e`, `95_2e`, super_2e, kinisis_2e, kinisis_a, `100_a`, `95_a`, super_a, kinisis_b, `100_b`, `95_b`, super_b, `date`, fpa) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['1'], "double"),
                       GetSQLValueString($_POST['2'], "double"),
                       GetSQLValueString($_POST['3'], "double"),
                       GetSQLValueString($_POST['4'], "double"),
                       GetSQLValueString($_POST['5'], "double"),
                       GetSQLValueString($_POST['6'], "double"),
                       GetSQLValueString($_POST['7'], "double"),
                       GetSQLValueString($_POST['8'], "double"),
                       GetSQLValueString($_POST['9'], "double"),
                       GetSQLValueString($_POST['10'], "double"),
                       GetSQLValueString($_POST['11'], "double"),
                       GetSQLValueString($_POST['12'], "double"),
                       GetSQLValueString($_POST['13'], "double"),
                       GetSQLValueString($_POST['14'], "double"),
                       GetSQLValueString($_POST['15'], "double"),
                       GetSQLValueString($_POST['16'], "double"),
                       GetSQLValueString($_POST['17'], "double"),
                       GetSQLValueString($_POST['18'], "double"),
                       GetSQLValueString($_POST['19'], "double"),
                       GetSQLValueString($_POST['20'], "double"),
                       GetSQLValueString($_POST['21'], "double"),
                       GetSQLValueString($_POST['22'], "double"),
                       GetSQLValueString($_POST['23'], "double"),
                       GetSQLValueString($_POST['24'], "double"),
                       GetSQLValueString($_POST['25'], "double"),
                       GetSQLValueString($_POST['26'], "double"),
                       GetSQLValueString($_POST['27'], "double"),
                       GetSQLValueString($_POST['28'], "double"),
                       GetSQLValueString($_POST['29'], "double"),
                       GetSQLValueString($_POST['30'], "double"),
                       GetSQLValueString($_POST['31'], "double"),
                       GetSQLValueString($_POST['32'], "double"),
                       GetSQLValueString($_POST['33'], "double"),
                       GetSQLValueString($_POST['34'], "double"),
                       GetSQLValueString($_POST['35'], "double"),
                       GetSQLValueString($_POST['36'], "double"),
                       GetSQLValueString($_POST['37'], "double"),
                       GetSQLValueString($_POST['38'], "double"),
                       GetSQLValueString($_POST['39'], "double"),
                       GetSQLValueString($_POST['40'], "double"),
                       GetSQLValueString($_POST['41'], "double"),
                       GetSQLValueString($_POST['42'], "double"),
                       GetSQLValueString($_POST['43'], "double"),
                       GetSQLValueString($_POST['date'], "date"),
                       GetSQLValueString($_POST['select_fpa'], "double"));

If is there anything else you might need, tell me :slight_smile:

Thank you again :slight_smile:

I think i should try to put one more column in the database table that will contain the ( kinisis_1c / kinisis_1b ) * kinisis_1a result, so the sum not be simplified and not make roundings cause i think there is the problem.

What you think?

Ah that explains it.

extra column? no

why don’t you dump the table and give us the CREATE TABLE statement as well as a few INSERT statements so that we can try to reproduce the results and perhaps see what’s causing it or how to fix it

It didnt worked :frowning:

Thanks for your responce :slight_smile:

Basicly in the insert data page, all the the values to be inserted are integers,i changed the fields to INT(10) , (except date column,fpa column i changed it to double since its always 0.21) but still no change :frowning:

You think the problem is in the field types?

I show you the complete mysql code in case i have a mistake i don’t see there

SELECT SUM((kinisis_1c + kinisis_1e + (kinisis_1c / kinisis_1b)* kinisis_1a) * (1-fpa)*1.005),SUM((100c + 100e + (100c / 100b)* 100a) * (1-fpa)*1.005),SUM((super_1c  + super_1e + (super_1c / super_1b)* super_1a) * (1-fpa)*1.005),SUM((95_1c + 95_1e + (95_1c / 95_1b)* 95_1a) * (1-fpa)*1.005),SUM((95_2c + 95_2e + (95_2c / 95_2b)*  95_2a) * (1-fpa)*1.005),SUM((super_2c + super_2e + (super_2c / super_2b)* super_2a) * (1-fpa)*1.005),SUM((kinisis_2c + kinisis_2e + (kinisis_2c / kinisis_2b)*  kinisis_2a) * (1-fpa)*1.005)
FROM kiniseis
WHERE `date` BETWEEN '$_GET[date1]' AND '$_GET[date2]'

perhaps you can try ( kinisis_1c * 1.000 / kinisis_1b ) instead

:slight_smile:

since the numbers themselves are DECIMAL(11,0), it’s not surprising that a calculation involving them would also not have any decimal places

perhaps you can try ( kinisis_1c * 1.000 / kinisis_1b ) instead