Hi,

I have the following problem. I have a table with the following
schema:

CREATE TABLE FOO
( "WP" VARCHAR2(10 BYTE),
"VALUE_GROUP" NUMBER(4,0),
"CURR_MS" NUMBER(38,0),
"VALUE_1" NUMBER(13,3),
"VALUE_2" NUMBER(13,3),
"VALUE_3" NUMBER(13,3),
"VALUE_4" NUMBER(13,3),
"VALUE_5" NUMBER(13,3),
"VALUE_6" NUMBER(13,3),
"VALUE_7" NUMBER(13,3),
"VALUE_8" NUMBER(13,3),
"VALUE_9" NUMBER(13,3),
"VALUE_10" NUMBER(13,3)
);

The PK is WP, VALUE_GROUP, CURR_MS.

In this table there are several datasets which are grouped by CURR_MS.
And sets with this unique ID should be selected to be shown in one
line.
This would be no problem if there would be always the same number of
lines grouped by one uniquely id (CURR_MS). The following statement
does this job:

This one consists of 3 values:

select a.*, b.*, c.* from foo a, foo b, foo c
where a.wp = '418'
and a.value_group = 11 and b.value_group = 21 and c.value_group =
22
and a.curr_ms = 28144336
and a.curr_ms = curr_ms
and a.curr_ms = curr_ms
and a.wp = b.wp
and a.wp = c.wp
;

But there are several groups which consists solely of 1 or 2 lines. Is
it possible to get them also with the same statement? Your help would
be greatly appreciated. Thanks in advance.

Regards

Roman

roman.morokutti (AT) googlemail (DOT) com wrote:
One look at the table design is enough to convince me that your problem
is not writing a SQL statement rather it is understanding basic
relational concepts.

Turn:

Into:

VAL_NUM 1 through 10
VALUE the value

Think vertically not horizontally.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Wed, 10 Oct 2007 00:07:11 -0700, roman.morokutti (AT) googlemail (DOT) com
wrote:

For a quick solution, you could use a UNION ALL, and a WHERE NOT
EXISTS on each one.

I fail to see how do you know that: a.value_group = 11 and
b.value_group = 21 and c.value_group = 22. And if you do know there
separate values, why not just write separate queries?

B.

Hi,

thank you for your help. Could you give me an example of how such
a statement could look?




This is as I stated above that it is not clear how many lines to
expect.
The example shows a query where I definitely know the current count
of lines. The lines indicate a process flow or think of a pipeline
where
a piece comes in and goes through the stages. The initial stage
creates
the unique time stamp and sets the value_group to 11. The next stage
takes the same time stamp and sets value_group to 21 and so on till
the last stage and this has the value_group id 25.

But if the processing in one stage before the last may fails I have
occasionally not the full count of entries. And this is exactly the
problem.
To select all them regardless of on what stage they may have been
failed.

Regards
Roman

Hi,

thank you for your suggestions. The table design is not from me.
I am only the poor guy who has to create a statement on its entities.
I will keep your sentence in mind although:

Think vertically.

Regards
Roman

On Thu, 11 Oct 2007 00:29:30 -0700, roman.morokutti (AT) googlemail (DOT) com
wrote:


select * from foo where wp = '418' and curr_ms = 28144336 and
value_group = 11
UNION ALL
select * from foo where wp = '418' and and curr_ms = 28144336 and
value_group = 21
UNION ALL
select * from foo where wp = '418' and curr_ms = 28144336 and
c.value_group = 22

Of course a standard IN() would work as well.

I still do not understand. What defines if another record should be
searched? What denotes failure?

B.

<roman.morokutti (AT) googlemail (DOT) com> schreef in bericht
news:1192000031.838733.84970 (AT) 22g2000hsm (DOT) googlegroups.com...
Maybe a look at this post news:13gt3fjga325n8e (AT) corp (DOT) supernews.com might give
you some ideas. The view kind of 'normalizes' tables like yours, making
queries a lot easier (don't know if it helps, but just take a look...)

Shakespeare

On Oct 11, 2:38 pm, Brian Tkatch <N/A> wrote:
Exactly, if you want all rows where wp = 418 and curr_ms = 28144336
and value_group is in some range then I'm still not seeing a problem.
Possibly it's something to do with the 'datasets' and the columns
named VALUE_1-10, but I can't see a connection. Do you need to pivot
them or something?

On Mon, 15 Oct 2007 02:26:04 -0700, roman.morokutti (AT) googlemail (DOT) com
wrote:

<snip>
OK, now it is beginning to make sense. Let me see if i understand
this.

CREATE TABLE FOO
( "WP" VARCHAR2(10 BYTE),
"VALUE_GROUP" NUMBER(4,0),
"CURR_MS" NUMBER(38,0),
"VALUE_1" NUMBER(13,3),
"VALUE_2" NUMBER(13,3),
"VALUE_3" NUMBER(13,3),
"VALUE_4" NUMBER(13,3),
"VALUE_5" NUMBER(13,3),
"VALUE_6" NUMBER(13,3),
"VALUE_7" NUMBER(13,3),
"VALUE_8" NUMBER(13,3),
"VALUE_9" NUMBER(13,3),
"VALUE_10" NUMBER(13,3)
);

1) TABLE Foo records the progress of a piece through a machine.
2) It has up to six stages.
3) Each stage has 10 values.
4) A unique piece is identified by WP and Curr_MS.
5) Different stages are identified by Value_Group.
6) The requirement is to get the current stages of a given piece.
7) An INNER JOIN query was written to retrieve the data in one record.
8) The query only returned data for pieces that completed all stages.

If that is the case, the solution would be to change the INNER JOIN to
an OUTER JOIN. That would not restrict the data returned to having all
stages with data.

B.

Hi Brian,





But how to make such a query? I have no clue. Maybe you could test
your
thoughts and post it here with this data. Thanks for your help.

Sample data:

REM INSERTING into foo
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27715049,999,1255,1255,47,46,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27719532,999,1255,1255,47,46,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27724500,999,1255,1255,47,46,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27729769,999,1255,1255,47,0,1242,1290,0, 0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27734812,999,1255,1255,47,0,1242,1290,0, 0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27740025,999,1255,1255,47,0,1242,1290,0, 0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27745210,999,1255,1255,47,0,1242,1290,0, 0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27750335,999,1255,1255,47,0,1242,1290,0, 0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27755360,1025,1281,1280,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27760425,1066,1322,1309,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27765464,1076,1332,1324,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27770281,1115,1115,1107,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27775205,1147,1147,1140,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27780115,1193,1193,1182,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27784977,1238,1238,1225,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27789859,1261,1261,1249,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27794742,1269,1269,1262,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27799624,1280,1280,1275,47,0,1242,1290,0 ,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27804331,1271,1271,1262,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27809138,1255,1255,1253,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27814001,1259,1259,1253,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27818811,1268,1268,1262,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27823695,1257,1257,1250,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27828487,1258,1258,1248,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27833314,1257,1257,1252,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27838168,1261,1261,1250,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27842974,1267,1267,1257,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27847875,1247,1247,1242,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27852823,1260,1260,1252,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27857611,1254,1254,1246,47,49,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27862504,1246,1246,1244,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27867452,1248,1248,1241,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27872342,1262,1262,1257,47,49,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27877131,1252,1252,1247,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27882102,1267,1267,1258,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27886896,1252,1252,1247,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27891697,1263,1263,1259,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27896561,1266,1266,1262,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27901301,1270,1270,1262,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27906003,1265,1265,1259,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27910907,1271,1271,1259,47,46,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27915709,1263,1263,1258,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27920506,1261,1261,1254,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27925300,1265,1265,1256,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27930001,1258,1258,1252,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27934902,1261,1261,1250,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27939524,1259,1259,1254,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27944163,1255,1255,1251,47,46,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27944163,1255,1255,1251,8,46,1,6432,0,1, 1);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27944163,9987,9987,39,300,350,440,480,50 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27944163,1688,429,33,65397,65405,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27944163,15,304,355,444,483,538,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27944163,480,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27948982,1262,1262,1258,47,46,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27948982,1262,1262,1258,8,46,6,2336,0,1, 1);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27948982,9993,9987,39,300,350,440,480,50 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27948982,1660,417,22,65392,65413,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27948982,15,308,356,446,492,522,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27948982,482,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27953843,1260,1260,1254,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27953843,1260,1260,1254,8,46,11,2336,0,2 ,2);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27953843,10003,9993,24,300,350,440,480,5 00,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27953843,1686,433,42,65395,65409,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27953843,15,303,355,439,500,520,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27953843,484,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27958662,1266,1266,1257,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27958662,1266,1266,1257,8,46,15,2336,0,3 ,3);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27958662,10012,10003,9,300,350,440,480,5 00,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27958662,1691,427,30,65407,65419,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27958662,15,300,356,445,463,507,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27958662,484,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27963529,1269,1269,1261,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27963529,1269,1269,1261,8,46,20,2336,0,4 ,4);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27963529,10019,10012,65530,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27963529,1676,431,32,65417,65420,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27963529,15,301,352,442,441,506,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27963529,478,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27968330,1256,1256,1254,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27968330,1256,1256,1254,8,46,25,6432,0,5 ,5);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27968330,10023,10019,65515,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27968330,1680,444,38,65402,65406,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27968330,10,300,350,441,477,522,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27968330,477,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27973125,1261,1261,1256,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27973125,1261,1261,1256,8,46,30,2336,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27973125,10026,10023,65500,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27973125,1674,435,37,65390,65411,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27973125,10,303,352,440,502,520,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27973125,481,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27977941,1265,1265,1258,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27977941,1265,1265,1258,8,46,34,2336,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27977941,10029,10026,65485,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27977941,1671,437,31,65391,65409,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27977941,10,302,350,448,501,516,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27977941,483,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27982651,1263,1263,1255,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27982651,1263,1263,1255,8,46,39,6432,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27982651,10031,10029,65470,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27982651,1687,434,38,65402,65406,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27982651,10,300,353,439,478,528,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27982651,483,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27987372,1267,1267,1261,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27987372,1267,1267,1261,8,46,44,6432,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27987372,10032,10031,65455,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27987372,1674,436,38,65401,65406,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27987372,10,303,351,439,478,522,0,0,0,0) ;
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27987372,482,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27992172,1265,1265,1259,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27992172,1265,1265,1259,8,46,50,6400,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27992172,10033,10032,65440,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27992172,1674,423,41,65404,65403,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27992172,0,302,358,435,478,530,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27992172,481,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,27996903,1265,1265,1259,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,27996903,1265,1265,1259,8,46,54,6400,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,27996903,10034,10033,65425,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,27996903,1696,441,38,65402,65408,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,27996903,0,299,350,442,480,529,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,27996903,480,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,28001710,1270,1270,1266,47,47,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,28001710,1270,1270,1266,8,46,59,6400,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,28001710,10037,10034,65410,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,28001710,1676,438,40,65402,65404,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,28001710,0,302,351,441,478,526,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,28001710,478,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,28006415,1262,1262,1255,47,48,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,28006415,1262,1262,1255,8,47,4,14592,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,28006415,10038,10037,65395,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,28006415,1700,435,24,65400,65410,0,0,0,0 ,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',24,28006415,0,300,357,455,472,517,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',25,28006415,478,0,0,0,0,0,0,0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',11,28011080,1260,1260,1256,47,46,1242,1290, 0,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',21,28011080,1260,1260,1256,8,47,9,14592,0,6 ,6);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',22,28011080,10039,10038,65380,300,350,440,4 80,500,0,0);
Insert into foo
(WP,VALUE_GROUP,CURR_MS,VALUE_1,VALUE_2,VALUE_3,VA LUE_4,VALUE_5,VALUE_6,VALUE_7,VALUE_8,VALUE_9,VALU E_10)
values ('418',23,28011080,1682,448,49,65407,65407,0,0,0,0 ,0);

Regards
Roman