Subject: invalid tuple received from server, got 138 columns, expected 476, ignoring
From: Anthony Damico <[email-masked]>
To: [email-masked]
Date: Fri, 28 Sep 2012 13:36:37 -0400

Hi everyone, I just wanted to follow-up on a previous post (available at
http://mail.monetdb.org/pipermail/users-list/2012-September/005773.html)
about an odd 'invalid tuple received' problem with a bit more detail and a
simplified way to replicate everything.  I've attached the results of PLAN
and EXPLAIN in case that's of any value.  The behavior of MonetDB seems
strange, since I am able to select count(*) from table; and select every
individual column from the table, but not select * from table;

I am using the alaska household file from the 2010 american community
survey.  This file can be downloaded from:

http://www2.census.gov/acs2010_1yr/pums/csv_hak.zip

Out of all of the commands posted below, only

sql>select * from household limit 5 ;

gives an error.  It says:

invalid tuple received from server, got 138 columns, expected 202, ignoring

I assume this is a windows-related problem?  I am using this in windows 7,
x64.

Any help would be appreciated! Thanks!!!

Here are my SQL commands verbatim:

drop table household;

create table household ( RT VARCHAR(255), SERIALNO INT, DIVISION INT, PUMA
INT, REGION INT, ST INT, ADJHSG INT, ADJINC INT, WGTP INT, NP INT, ZZZZ
INT, ACR INT, AGS INT, BATH INT, BDSP INT, BLD INT, BUS INT, CONP INT, ELEP
INT, FS INT, FULP INT, GASP INT, HFL INT, INSP INT, MHP INT, MRGI INT, MRGP
INT, MRGT INT, MRGX INT, REFR INT, RMSP INT, RNTM INT, RNTP INT, RWAT INT,
SINK INT, SMP INT, STOV INT, TEL INT, TEN INT, TOIL INT, VACS INT, VALP
INT, VEH INT, WATP INT, YBL INT, FES INT, FINCP INT, FPARC INT, GRNTP INT,
GRPIP INT, HHL INT, HHT INT, HINCP INT, HUGCL INT, HUPAC INT, HUPAOC INT,
HUPARC INT, KIT INT, LNGI INT, MULTG INT, MV INT, NOC INT, NPF INT, NPP
INT, NR INT, NRC INT, OCPIP INT, PARTNER INT, PLM INT, PSF INT, R18 INT,
R60 INT, R65 INT, RESMODE INT, SMOCP INT, SMX INT, SRNT INT, SVAL INT, TAXP
INT, WIF INT, WKEXREL INT, WORKSTAT INT, FACRP INT, FAGSP INT, FBATHP INT,
FBDSP INT, FBLDP INT, FBUSP INT, FCONP INT, FELEP INT, FFSP INT, FFULP INT,
FGASP INT, FHFLP INT, FINSP INT, FKITP INT, FMHP INT, FMRGIP INT, FMRGP
INT, FMRGTP INT, FMRGXP INT, FMVP INT, FPLMP INT, FREFRP INT, FRMSP INT,
FRNTMP INT, FRNTP INT, FRWATP INT, FSINKP INT, FSMP INT, FSMXHP INT, FSMXSP
INT, FSTOVP INT, FTAXP INT, FTELP INT, FTENP INT, FTOILP INT, FVACSP INT,
FVALP INT, FVEHP INT, FWATP INT, FYBLP INT, wgtp1 INT, wgtp2 INT, wgtp3
INT, wgtp4 INT, wgtp5 INT, wgtp6 INT, wgtp7 INT, wgtp8 INT, wgtp9 INT,
wgtp10 INT, wgtp11 INT, wgtp12 INT, wgtp13 INT, wgtp14 INT, wgtp15 INT,
wgtp16 INT, wgtp17 INT, wgtp18 INT, wgtp19 INT, wgtp20 INT, wgtp21 INT,
wgtp22 INT, wgtp23 INT, wgtp24 INT, wgtp25 INT, wgtp26 INT, wgtp27 INT,
wgtp28 INT, wgtp29 INT, wgtp30 INT, wgtp31 INT, wgtp32 INT, wgtp33 INT,
wgtp34 INT, wgtp35 INT, wgtp36 INT, wgtp37 INT, wgtp38 INT, wgtp39 INT,
wgtp40 INT, wgtp41 INT, wgtp42 INT, wgtp43 INT, wgtp44 INT, wgtp45 INT,
wgtp46 INT, wgtp47 INT, wgtp48 INT, wgtp49 INT, wgtp50 INT, wgtp51 INT,
wgtp52 INT, wgtp53 INT, wgtp54 INT, wgtp55 INT, wgtp56 INT, wgtp57 INT,
wgtp58 INT, wgtp59 INT, wgtp60 INT, wgtp61 INT, wgtp62 INT, wgtp63 INT,
wgtp64 INT, wgtp65 INT, wgtp66 INT, wgtp67 INT, wgtp68 INT, wgtp69 INT,
wgtp70 INT, wgtp71 INT, wgtp72 INT, wgtp73 INT, wgtp74 INT, wgtp75 INT,
wgtp76 INT, wgtp77 INT, wgtp78 INT, wgtp79 INT, wgtp80 INT );

copy 5000 offset 2 records into household from
'C:\Users\AnthonyD\Desktop\ss10hak.csv' using delimiters ',','\n','"' NULL
as '' ;

\w-1

select count(*) from household;
select * from household limit 5 ;
PLAN select * from household limit 5 ;
EXPLAIN select * from household limit 5 ;

select RT, SERIALNO, DIVISION, PUMA, REGION, ST, ADJHSG, ADJINC, WGTP, NP,
ZZZZ, ACR, AGS, BATH, BDSP, BLD, BUS, CONP, ELEP, FS, FULP, GASP, HFL,
INSP, MHP, MRGI, MRGP, MRGT, MRGX, REFR, RMSP, RNTM, RNTP, RWAT, SINK, SMP,
STOV, TEL, TEN, TOIL, VACS, VALP, VEH, WATP, YBL, FES, FINCP, FPARC, GRNTP,
GRPIP, HHL, HHT, HINCP, HUGCL, HUPAC, HUPAOC, HUPARC, KIT, LNGI, MULTG, MV,
NOC, NPF, NPP, NR, NRC, OCPIP, PARTNER, PLM, PSF, R18, R60, R65, RESMODE,
SMOCP, SMX, SRNT, SVAL, TAXP, WIF, WKEXREL, WORKSTAT, FACRP, FAGSP, FBATHP,
FBDSP, FBLDP, FBUSP, FCONP, FELEP, FFSP, FFULP, FGASP, FHFLP, FINSP, FKITP,
FMHP, FMRGIP, FMRGP, FMRGTP, FMRGXP, FMVP, FPLMP, FREFRP, FRMSP, FRNTMP,
FRNTP, FRWATP, FSINKP, FSMP, FSMXHP, FSMXSP, FSTOVP, FTAXP, FTELP, FTENP,
FTOILP, FVACSP, FVALP, FVEHP, FWATP, FYBLP, wgtp1, wgtp2, wgtp3, wgtp4,
wgtp5, wgtp6, wgtp7, wgtp8, wgtp9, wgtp10, wgtp11, wgtp12, wgtp13, wgtp14,
wgtp15, wgtp16, wgtp17, wgtp18, wgtp19, wgtp20, wgtp21, wgtp22, wgtp23,
wgtp24, wgtp25, wgtp26, wgtp27, wgtp28, wgtp29, wgtp30, wgtp31, wgtp32,
wgtp33, wgtp34, wgtp35, wgtp36, wgtp37, wgtp38, wgtp39, wgtp40, wgtp41,
wgtp42, wgtp43, wgtp44, wgtp45, wgtp46, wgtp47, wgtp48, wgtp49, wgtp50,
wgtp51, wgtp52, wgtp53, wgtp54, wgtp55, wgtp56, wgtp57, wgtp58, wgtp59,
wgtp60, wgtp61, wgtp62, wgtp63, wgtp64, wgtp65, wgtp66, wgtp67, wgtp68,
wgtp69, wgtp70, wgtp71, wgtp72, wgtp73, wgtp74, wgtp75, wgtp76, wgtp77,
wgtp78, wgtp79, wgtp80 from household limit 5;

select RT, SERIALNO, DIVISION, PUMA, REGION, ST, ADJHSG, ADJINC, WGTP, NP,
ZZZZ, ACR, AGS, BATH, BDSP, BLD, BUS, CONP, ELEP, FS, FULP, GASP, HFL,
INSP, MHP, MRGI, MRGP, MRGT, MRGX, REFR, RMSP, RNTM, RNTP, RWAT, SINK, SMP,
STOV, TEL, TEN, TOIL, VACS, VALP, VEH, WATP, YBL, FES, FINCP, FPARC, GRNTP,
GRPIP, HHL, HHT, HINCP, HUGCL, HUPAC, HUPAOC, HUPARC, KIT, LNGI, MULTG, MV,
NOC, NPF, NPP, NR, NRC, OCPIP, PARTNER, PLM, PSF, R18, R60, R65, RESMODE,
SMOCP, SMX, SRNT, SVAL, TAXP, WIF, WKEXREL, WORKSTAT, FACRP, FAGSP, FBATHP,
FBDSP, FBLDP, FBUSP, FCONP, FELEP, FFSP, FFULP, FGASP, FHFLP, FINSP, FKITP,
FMHP, FMRGIP, FMRGP, FMRGTP, FMRGXP, FMVP, FPLMP, FREFRP, FRMSP, FRNTMP,
FRNTP, FRWATP, FSINKP, FSMP, FSMXHP, FSMXSP, FSTOVP, FTAXP, FTELP, FTENP,
FTOILP, FVACSP, FVALP, FVEHP, FWATP, FYBLP from household limit 5;

select wgtp1, wgtp2, wgtp3, wgtp4, wgtp5, wgtp6, wgtp7, wgtp8, wgtp9,
wgtp10, wgtp11, wgtp12, wgtp13, wgtp14, wgtp15, wgtp16, wgtp17, wgtp18,
wgtp19, wgtp20, wgtp21, wgtp22, wgtp23, wgtp24, wgtp25, wgtp26, wgtp27,
wgtp28, wgtp29, wgtp30, wgtp31, wgtp32, wgtp33, wgtp34, wgtp35, wgtp36,
wgtp37, wgtp38, wgtp39, wgtp40, wgtp41, wgtp42, wgtp43, wgtp44, wgtp45,
wgtp46, wgtp47, wgtp48, wgtp49, wgtp50, wgtp51, wgtp52, wgtp53, wgtp54,
wgtp55, wgtp56, wgtp57, wgtp58, wgtp59, wgtp60, wgtp61, wgtp62, wgtp63,
wgtp64, wgtp65, wgtp66, wgtp67, wgtp68, wgtp69, wgtp70, wgtp71, wgtp72,
wgtp73, wgtp74, wgtp75, wgtp76, wgtp77, wgtp78, wgtp79, wgtp80 from
household limit 5;

Here's the output of PLAN and EXPLAIN:

operation successful (62.733ms)
operation successful (88.682ms)
3335 affected rows (21.1s)
+------+
| L1   |
+======+
| 3335 |
+------+
+------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
| rt   | serialno | division | puma | region | st   | adjhsg  | adjinc  |
wgtp | np   | zzzz | acr  | ags  | bath | bdsp | bld  | bus  | conp | elep
| fs   | fulp | gasp | hfl  | insp | mhp  | mrgi | mrgp | mrgt | mrgx |
refr | rmsp | rntm | rntp | rwat | sink | smp  | stov | tel  | ten  | toil
| vacs | valp   | veh  | watp | ybl  | fes  | fincp | fparc | grntp | grpip
| hhl  | hht  | hincp | hugcl | hupac | hupaoc | huparc | kit  | lngi |
multg | mv   | noc  | npf  | npp  | nr   | nrc  | ocpip | partner | plm  |
psf  | r18  | r60  | r65  | resmode | smocp | smx  | srnt | sval | taxp |
wif  | wkexrel | workstat | facrp | fagsp | fbathp | fbdsp | fbldp | fbusp
| fconp | felep | ffsp | ffulp | fgasp | fhflp | finsp | fkitp | fmhp |
fmrgip | fmrgp | fmrgtp | fmrgxp | fmvp | fplmp | frefrp | frmsp | frntmp |
frntp | frwatp | fsinkp | fsmp | fsmxhp | fsmxsp | fstovp | ftaxp | ftelp |
ftenp | ftoilp | fvacsp | fvalp | fvehp | fwatp | fyblp | wgtp1 | wgtp2 |
wgtp3 | wgtp4 | wgtp5 | wgtp6 | wgtp7 | wgtp8 | wgtp9 | wgtp10 | wgtp11 |
wgtp12 | wgtp13 | wgtp14 | wgtp15 | wgtp16 | wgtp17 | wgtp18 | wgtp19 |
wgtp20 | wgtp21 | wgtp22 | wgtp23 | wgtp24 | wgtp25 | wgtp26 | wgtp27 |
wgtp28 | wgtp29 | wgtp30 | wgtp31 | wgtp32 | wgtp33 | wgtp34 | wgtp35 |
wgtp36 | wgtp37 | wgtp38 | wgtp39 | wgtp40 | wgtp41 | wgtp42 | wgtp43 |
wgtp44 | wgtp45 | wgtp46 | wgtp47 | wgtp48 | wgtp49 | wgtp50 | wgtp51 |
wgtp52 | wgtp53 | wgtp54 | wgtp55 | wgtp56 | wgtp57 | wgtp58 | wgtp59 |
wgtp60 | wgtp61 | wgtp62 | wgtp63 | wgtp64 | wgtp65 | wgtp66 | wgtp67 |
wgtp68 | wgtp69 | wgtp70 | wgtp71 | wgtp72 | wgtp73 | wgtp74 | wgtp75 |
wgtp76 | wgtp77 | wgtp78 | wgtp79 | wgtp80 |
+======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+
| H    |     1890 |        9 |  400 |      4 |    2 | 1000000 | 1007624 |
46 |    2 |    1 | null | null |    1 |    1 |    6 | null | null |    1
|    2 |    1 |    3 |    4 | null | null | null | null | null | null |
1 |    2 |    2 |  600 |    1 |    1 | null |    1 |    1 |    3 |    1 |
null |   null |    1 |    1 |    3 | null |  null |  null |   600 |    21
|    1 |    7 | 34700 |     0 |     4 |      4 |      4 |    1 |    1 |
1 |    3 |    0 | null |    0 |    1 |    0 |  null |       0 |    1 |    0
|    0 |    0 |    0 |       2 |  null | null |    1 |    0 | null | null
|    null |     null |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     0 |    0 |     0 |     0 |     0 |     0 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     0 |     0 |     0
|      0 |      0 |     0 |     0 |     0 |     1 |    10 |    16 |    10
|    42 |    61 |    44 |    54 |    45 |    71 |     67 |    112 |     50
|     15 |     41 |    111 |     79 |     37 |     67 |     38 |     40
|     81 |     95 |     70 |     81 |     51 |     40 |     38 |     47
|     15 |     22 |     18 |     34 |     95 |     55 |     14 |     51
|     48 |     18 |     43 |     12 |      7 |     13 |     15 |     57
|     72 |     55 |     48 |     50 |     75 |     80 |    116 |     51
|     14 |     38 |    126 |     57 |     30 |     93 |     29 |     53
|     80 |     55 |     71 |     46 |     38 |     57 |     39 |     47
|     16 |     16 |     20 |     50 |     91 |     58 |     20 |     72
|     43 |     11 |     48 |      9 |
| H    |     2029 |        9 |  101 |      4 |    2 | 1000000 | 1007624 |
269 |    4 |    1 |    1 | null |    1 |    4 |    2 |    2 | null |   80
|    2 |    2 |   80 |    1 | 1500 | null |    1 |  920 |    1 |    1 |
1 |    7 | null | null |    1 |    1 | null |    1 |    1 |    1 |    1 |
null | 200000 |    1 |  200 |    4 |    8 | 47100 |     2 |  null |  null
|    1 |    3 | 47100 |     1 |     2 |      4 |      2 |    1 |    1 |
2 |    7 |    0 |    4 |    0 |    0 |    2 |    28 |       0 |    1 |    1
|    1 |    1 |    1 |       2 |  1097 |    3 |    0 |    1 |   34 |    1
|      15 |       15 |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     1 |    0 |     0 |     1 |     0 |     1 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     1 |     0 |     0
|      0 |      0 |     0 |     0 |     1 |     0 |   252 |   470 |   264
|   430 |   228 |   243 |   192 |   107 |   265 |     79 |    266 |    268
|     68 |    335 |    503 |    116 |     95 |    389 |    228 |    114
|    254 |     71 |    225 |    116 |    289 |    291 |    233 |    539
|    310 |    423 |    262 |    346 |    511 |    235 |     79 |    407
|    420 |    121 |    223 |     90 |    250 |     70 |    240 |    101
|    259 |    326 |    245 |    461 |    241 |    480 |    315 |    275
|    286 |    338 |    118 |    363 |    409 |     87 |    238 |    418
|    278 |    322 |    297 |    486 |    376 |    262 |    198 |     95
|    259 |    104 |    238 |    309 |    135 |    230 |    408 |    117
|     83 |    497 |    244 |    418 |
+------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
rel
|
+=========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================+
| top N
(
|
| | project
(
|
| | | table(sys.household) [ household.rt, household.serialno,
household.division, household.puma, household.region, household.st,
household.adjhsg, household.adjinc, household.wgtp, household.np,
household.zzzz, household.acr, household.ags, household.bath,
household.bdsp, household.bld, household.bus, household.conp,
household.elep, household.fs, household.fulp, household.gasp,
household.hfl, household.insp, household.mhp, household.mrgi,
household.mrgp, household.mrgt, household.mrgx, household.refr,
household.rmsp, household.rntm, household.rntp, household.rwat,
household.sink, household.smp, household.stov, household.tel,
household.ten, household.toil, household.vacs, household.valp,
household.veh, household.watp, household.ybl, household.fes,
household.fincp, household.fparc, household.grntp, household.grpip,
household.hhl, household.hht, household.hincp, household.hugcl,
household.hupac, household.hupaoc, household.huparc, household.kit,
household.lngi, household.multg, household.mv, household.noc,
household.npf, household.npp, household.nr, household.nrc, household.ocpip,
household.partner, household.plm, household.psf, household.r18,
household.r60, household.r65, household.resmode, household.smocp,
household.smx, household.srnt, household.sval, household.taxp,
household.wif, household.wkexrel, household.workstat, household.facrp,
household.fagsp, household.fbathp, household.fbdsp, household.fbldp,
household.fbusp, household.fconp, household.felep, household.ffsp,
household.ffulp, household.fgasp, household.fhflp, household.finsp,
household.fkitp, household.fmhp, household.fmrgip, household.fmrgp,
household.fmrgtp, household.fmrgxp, household.fmvp, household.fplmp,
household.frefrp, household.frmsp, household.frntmp, household.frntp,
household.frwatp, household.fsinkp, household.fsmp, household.fsmxhp,
household.fsmxsp, household.fstovp, household.ftaxp, household.ftelp,
household.ftenp, household.ftoilp, household.fvacsp, household.fvalp,
household.fvehp, household.fwatp, household.fyblp, household.wgtp1,
household.wgtp2, household.wgtp3, household.wgtp4, household.wgtp5,
household.wgtp6, household.wgtp7, household.wgtp8, household.wgtp9,
household.wgtp10, household.wgtp11, household.wgtp12, household.wgtp13,
household.wgtp14, household.wgtp15, household.wgtp16, household.wgtp17,
household.wgtp18, household.wgtp19, household.wgtp20, household.wgtp21,
household.wgtp22, household.wgtp23, household.wgtp24, household.wgtp25,
household.wgtp26, household.wgtp27, household.wgtp28, household.wgtp29,
household.wgtp30, household.wgtp31, household.wgtp32, household.wgtp33,
household.wgtp34, household.wgtp35, household.wgtp36, household.wgtp37,
household.wgtp38, household.wgtp39, household.wgtp40, household.wgtp41,
household.wgtp42, household.wgtp43, household.wgtp44, household.wgtp45,
household.wgtp46, household.wgtp47, household.wgtp48, household.wgtp49,
household.wgtp50, household.wgtp51, household.wgtp52, household.wgtp53,
household.wgtp54, household.wgtp55, household.wgtp56, household.wgtp57,
household.wgtp58, household.wgtp59, household.wgtp60, household.wgtp61,
household.wgtp62, household.wgtp63, household.wgtp64, household.wgtp65,
household.wgtp66, household.wgtp67, household.wgtp68, household.wgtp69,
household.wgtp70, household.wgtp71, household.wgtp72, household.wgtp73,
household.wgtp74, household.wgtp75, household.wgtp76, household.wgtp77,
household.wgtp78, household.wgtp79, household.wgtp80, household.%TID% NOT
NULL ] COUNT  |
| | ) [ household.rt, household.serialno, household.division,
household.puma, household.region, household.st, household.adjhsg,
household.adjinc, household.wgtp, household.np, household.zzzz,
household.acr, household.ags, household.bath, household.bdsp,
household.bld, household.bus, household.conp, household.elep, household.fs,
household.fulp, household.gasp, household.hfl, household.insp,
household.mhp, household.mrgi, household.mrgp, household.mrgt,
household.mrgx, household.refr, household.rmsp, household.rntm,
household.rntp, household.rwat, household.sink, household.smp,
household.stov, household.tel, household.ten, household.toil,
household.vacs, household.valp, household.veh, household.watp,
household.ybl, household.fes, household.fincp, household.fparc,
household.grntp, household.grpip, household.hhl, household.hht,
household.hincp, household.hugcl, household.hupac, household.hupaoc,
household.huparc, household.kit, household.lngi, household.multg,
household.mv, household.noc, household.npf, household.npp, household.nr,
household.nrc, household.ocpip, household.partner, household.plm,
household.psf, household.r18, household.r60, household.r65,
household.resmode, household.smocp, household.smx, household.srnt,
household.sval, household.taxp, household.wif, household.wkexrel,
household.workstat, household.facrp, household.fagsp, household.fbathp,
household.fbdsp, household.fbldp, household.fbusp, household.fconp,
household.felep, household.ffsp, household.ffulp, household.fgasp,
household.fhflp, household.finsp, household.fkitp, household.fmhp,
household.fmrgip, household.fmrgp, household.fmrgtp, household.fmrgxp,
household.fmvp, household.fplmp, household.frefrp, household.frmsp,
household.frntmp, household.frntp, household.frwatp, household.fsinkp,
household.fsmp, household.fsmxhp, household.fsmxsp, household.fstovp,
household.ftaxp, household.ftelp, household.ftenp, household.ftoilp,
household.fvacsp, household.fvalp, household.fvehp, household.fwatp,
household.fyblp, household.wgtp1, household.wgtp2, household.wgtp3,
household.wgtp4, household.wgtp5, household.wgtp6, household.wgtp7,
household.wgtp8, household.wgtp9, household.wgtp10, household.wgtp11,
household.wgtp12, household.wgtp13, household.wgtp14, household.wgtp15,
household.wgtp16, household.wgtp17, household.wgtp18, household.wgtp19,
household.wgtp20, household.wgtp21, household.wgtp22, household.wgtp23,
household.wgtp24, household.wgtp25, household.wgtp26, household.wgtp27,
household.wgtp28, household.wgtp29, household.wgtp30, household.wgtp31,
household.wgtp32, household.wgtp33, household.wgtp34, household.wgtp35,
household.wgtp36, household.wgtp37, household.wgtp38, household.wgtp39,
household.wgtp40, household.wgtp41, household.wgtp42, household.wgtp43,
household.wgtp44, household.wgtp45, household.wgtp46, household.wgtp47,
household.wgtp48, household.wgtp49, household.wgtp50, household.wgtp51,
household.wgtp52, household.wgtp53, household.wgtp54, household.wgtp55,
household.wgtp56, household.wgtp57, household.wgtp58, household.wgtp59,
household.wgtp60, household.wgtp61, household.wgtp62, household.wgtp63,
household.wgtp64, household.wgtp65, household.wgtp66, household.wgtp67,
household.wgtp68, household.wgtp69, household.wgtp70, household.wgtp71,
household.wgtp72, household.wgtp73, household.wgtp74, household.wgtp75,
household.wgtp76, household.wgtp77, household.wgtp78, household.wgtp79,
household.wgtp80 ]                                                       |
| ) [ wrd "5"
]
|
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+----------------------------------------------------------------------------+
|
mal                                                                        |
+============================================================================+
| function
user.s4_1{autoCommit=true}():void;                                |
|     X_16 :=
nil:bat[:oid,:oid];                                            |
|     X_19 :=
nil:bat[:oid,:oid];                                            |
|     X_20 :=
nil:bat[:oid,:str];                                            |
| barrier X_3105 :=
language.dataflow();                                     |
|     X_2 :=
sql.mvc();                                                      |
|     X_3:bat[:oid,:str]  :=
sql.bind(X_2,"sys","household","rt",0);         |
|     X_8:bat[:oid,:str]  :=
sql.bind(X_2,"sys","household","rt",2);         |
|     X_10 :=
algebra.kdifference(X_3,X_8);                                  |
|     X_11 :=
algebra.kunion(X_10,X_8);                                      |
|     X_12:bat[:oid,:str]  :=
sql.bind(X_2,"sys","household","rt",1);        |
|     X_14 :=
algebra.kunion(X_11,X_12);                                     |
|     X_15:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);        |
|     X_16 :=
bat.reverse(X_15);                                             |
|     X_17 :=
algebra.kdifference(X_14,X_16);                                |
|     X_18 :=
algebra.slice(X_17,0:wrd,4:wrd);                               |
|     X_19 :=
bat.mirror(X_18);                                              |
|     X_20 :=
algebra.leftjoin(X_19,X_17);                                   |
| exit
X_3105;                                                               |
|     X_2396 :=
sql.resultSet(202,1,X_20);                                   |
|     X_31 :=
nil:bat[:oid,:int];                                            |
|     X_43 :=
nil:bat[:oid,:int];                                            |
|     X_54 :=
nil:bat[:oid,:int];                                            |
|     X_67 :=
nil:bat[:oid,:int];                                            |
|     X_77 :=
nil:bat[:oid,:int];                                            |
|     X_90 :=
nil:bat[:oid,:int];                                            |
|     X_100 :=
nil:bat[:oid,:int];                                           |
|     X_115 :=
nil:bat[:oid,:int];                                           |
|     X_125 :=
nil:bat[:oid,:int];                                           |
|     X_138 :=
nil:bat[:oid,:int];                                           |
|     X_149 :=
nil:bat[:oid,:int];                                           |
|     X_161 :=
nil:bat[:oid,:int];                                           |
|     X_172 :=
nil:bat[:oid,:int];                                           |
|     X_184 :=
nil:bat[:oid,:int];                                           |
|     X_195 :=
nil:bat[:oid,:int];                                           |
|     X_210 :=
nil:bat[:oid,:int];                                           |
|     X_220 :=
nil:bat[:oid,:int];                                           |
|     X_233 :=
nil:bat[:oid,:int];                                           |
|     X_243 :=
nil:bat[:oid,:int];                                           |
|     X_256 :=
nil:bat[:oid,:int];                                           |
|     X_266 :=
nil:bat[:oid,:int];                                           |
|     X_279 :=
nil:bat[:oid,:int];                                           |
|     X_289 :=
nil:bat[:oid,:int];                                           |
|     X_304 :=
nil:bat[:oid,:int];                                           |
|     X_315 :=
nil:bat[:oid,:int];                                           |
|     X_327 :=
nil:bat[:oid,:int];                                           |
|     X_338 :=
nil:bat[:oid,:int];                                           |
|     X_350 :=
nil:bat[:oid,:int];                                           |
|     X_361 :=
nil:bat[:oid,:int];                                           |
|     X_374 :=
nil:bat[:oid,:int];                                           |
|     X_384 :=
nil:bat[:oid,:int];                                           |
|     X_399 :=
nil:bat[:oid,:int];                                           |
|     X_409 :=
nil:bat[:oid,:int];                                           |
|     X_422 :=
nil:bat[:oid,:int];                                           |
|     X_432 :=
nil:bat[:oid,:int];                                           |
|     X_445 :=
nil:bat[:oid,:int];                                           |
|     X_455 :=
nil:bat[:oid,:int];                                           |
|     X_468 :=
nil:bat[:oid,:int];                                           |
|     X_479 :=
nil:bat[:oid,:int];                                           |
|     X_493 :=
nil:bat[:oid,:int];                                           |
|     X_504 :=
nil:bat[:oid,:int];                                           |
|     X_516 :=
nil:bat[:oid,:int];                                           |
|     X_527 :=
nil:bat[:oid,:int];                                           |
|     X_540 :=
nil:bat[:oid,:int];                                           |
|     X_550 :=
nil:bat[:oid,:int];                                           |
|     X_563 :=
nil:bat[:oid,:int];                                           |
|     X_573 :=
nil:bat[:oid,:int];                                           |
|     X_588 :=
nil:bat[:oid,:int];                                           |
|     X_598 :=
nil:bat[:oid,:int];                                           |
|     X_611 :=
nil:bat[:oid,:int];                                           |
|     X_621 :=
nil:bat[:oid,:int];                                           |
|     X_634 :=
nil:bat[:oid,:int];                                           |
|     X_645 :=
nil:bat[:oid,:int];                                           |
|     X_657 :=
nil:bat[:oid,:int];                                           |
|     X_668 :=
nil:bat[:oid,:int];                                           |
|     X_682 :=
nil:bat[:oid,:int];                                           |
|     X_693 :=
nil:bat[:oid,:int];                                           |
|     X_706 :=
nil:bat[:oid,:int];                                           |
|     X_716 :=
nil:bat[:oid,:int];                                           |
|     X_729 :=
nil:bat[:oid,:int];                                           |
|     X_739 :=
nil:bat[:oid,:int];                                           |
|     X_752 :=
nil:bat[:oid,:int];                                           |
|     X_762 :=
nil:bat[:oid,:int];                                           |
|     X_777 :=
nil:bat[:oid,:int];                                           |
|     X_787 :=
nil:bat[:oid,:int];                                           |
|     X_800 :=
nil:bat[:oid,:int];                                           |
|     X_811 :=
nil:bat[:oid,:int];                                           |
|     X_823 :=
nil:bat[:oid,:int];                                           |
|     X_834 :=
nil:bat[:oid,:int];                                           |
|     X_846 :=
nil:bat[:oid,:int];                                           |
|     X_857 :=
nil:bat[:oid,:int];                                           |
|     X_872 :=
nil:bat[:oid,:int];                                           |
|     X_882 :=
nil:bat[:oid,:int];                                           |
|     X_895 :=
nil:bat[:oid,:int];                                           |
|     X_905 :=
nil:bat[:oid,:int];                                           |
|     X_918 :=
nil:bat[:oid,:int];                                           |
|     X_928 :=
nil:bat[:oid,:int];                                           |
|     X_941 :=
nil:bat[:oid,:int];                                           |
|     X_951 :=
nil:bat[:oid,:int];                                           |
|     X_966 :=
nil:bat[:oid,:int];                                           |
|     X_977 :=
nil:bat[:oid,:int];                                           |
|     X_989 :=
nil:bat[:oid,:int];                                           |
|     X_1000 :=
nil:bat[:oid,:int];                                          |
|     X_1012 :=
nil:bat[:oid,:int];                                          |
|     X_1023 :=
nil:bat[:oid,:int];                                          |
|     X_1036 :=
nil:bat[:oid,:int];                                          |
|     X_1046 :=
nil:bat[:oid,:int];                                          |
|     X_1061 :=
nil:bat[:oid,:int];                                          |
|     X_1071 :=
nil:bat[:oid,:int];                                          |
|     X_1084 :=
nil:bat[:oid,:int];                                          |
|     X_1094 :=
nil:bat[:oid,:int];                                          |
|     X_1107 :=
nil:bat[:oid,:int];                                          |
|     X_1117 :=
nil:bat[:oid,:int];                                          |
|     X_1130 :=
nil:bat[:oid,:int];                                          |
|     X_1141 :=
nil:bat[:oid,:int];                                          |
|     X_1155 :=
nil:bat[:oid,:int];                                          |
|     X_1166 :=
nil:bat[:oid,:int];                                          |
|     X_1178 :=
nil:bat[:oid,:int];                                          |
|     X_1189 :=
nil:bat[:oid,:int];                                          |
|     X_1202 :=
nil:bat[:oid,:int];                                          |
|     X_1212 :=
nil:bat[:oid,:int];                                          |
|     X_1225 :=
nil:bat[:oid,:int];                                          |
|     X_1235 :=
nil:bat[:oid,:int];                                          |
|     X_1250 :=
nil:bat[:oid,:int];                                          |
|     X_1260 :=
nil:bat[:oid,:int];                                          |
|     X_1273 :=
nil:bat[:oid,:int];                                          |
|     X_1283 :=
nil:bat[:oid,:int];                                          |
|     X_1296 :=
nil:bat[:oid,:int];                                          |
|     X_1307 :=
nil:bat[:oid,:int];                                          |
|     X_1319 :=
nil:bat[:oid,:int];                                          |
|     X_1330 :=
nil:bat[:oid,:int];                                          |
|     X_1344 :=
nil:bat[:oid,:int];                                          |
|     X_1355 :=
nil:bat[:oid,:int];                                          |
|     X_1368 :=
nil:bat[:oid,:int];                                          |
|     X_1378 :=
nil:bat[:oid,:int];                                          |
|     X_1391 :=
nil:bat[:oid,:int];                                          |
|     X_1401 :=
nil:bat[:oid,:int];                                          |
|     X_1414 :=
nil:bat[:oid,:int];                                          |
|     X_1424 :=
nil:bat[:oid,:int];                                          |
|     X_1439 :=
nil:bat[:oid,:int];                                          |
|     X_1449 :=
nil:bat[:oid,:int];                                          |
|     X_1462 :=
nil:bat[:oid,:int];                                          |
|     X_1473 :=
nil:bat[:oid,:int];                                          |
|     X_1485 :=
nil:bat[:oid,:int];                                          |
|     X_1496 :=
nil:bat[:oid,:int];                                          |
|     X_1508 :=
nil:bat[:oid,:int];                                          |
|     X_1519 :=
nil:bat[:oid,:int];                                          |
|     X_1534 :=
nil:bat[:oid,:int];                                          |
|     X_1544 :=
nil:bat[:oid,:int];                                          |
|     X_1557 :=
nil:bat[:oid,:int];                                          |
|     X_1567 :=
nil:bat[:oid,:int];                                          |
|     X_1580 :=
nil:bat[:oid,:int];                                          |
|     X_1590 :=
nil:bat[:oid,:int];                                          |
|     X_1603 :=
nil:bat[:oid,:int];                                          |
|     X_1613 :=
nil:bat[:oid,:int];                                          |
|     X_1628 :=
nil:bat[:oid,:int];                                          |
|     X_1639 :=
nil:bat[:oid,:int];                                          |
|     X_1651 :=
nil:bat[:oid,:int];                                          |
|     X_1662 :=
nil:bat[:oid,:int];                                          |
|     X_1674 :=
nil:bat[:oid,:int];                                          |
|     X_1685 :=
nil:bat[:oid,:int];                                          |
|     X_1698 :=
nil:bat[:oid,:int];                                          |
|     X_1708 :=
nil:bat[:oid,:int];                                          |
|     X_1723 :=
nil:bat[:oid,:int];                                          |
|     X_1733 :=
nil:bat[:oid,:int];                                          |
|     X_1746 :=
nil:bat[:oid,:int];                                          |
|     X_1756 :=
nil:bat[:oid,:int];                                          |
|     X_1769 :=
nil:bat[:oid,:int];                                          |
|     X_1779 :=
nil:bat[:oid,:int];                                          |
|     X_1792 :=
nil:bat[:oid,:int];                                          |
|     X_1803 :=
nil:bat[:oid,:int];                                          |
|     X_1817 :=
nil:bat[:oid,:int];                                          |
|     X_1828 :=
nil:bat[:oid,:int];                                          |
|     X_1840 :=
nil:bat[:oid,:int];                                          |
|     X_1851 :=
nil:bat[:oid,:int];                                          |
|     X_1864 :=
nil:bat[:oid,:int];                                          |
|     X_1874 :=
nil:bat[:oid,:int];                                          |
|     X_1887 :=
nil:bat[:oid,:int];                                          |
|     X_1897 :=
nil:bat[:oid,:int];                                          |
|     X_1912 :=
nil:bat[:oid,:int];                                          |
|     X_1922 :=
nil:bat[:oid,:int];                                          |
|     X_1935 :=
nil:bat[:oid,:int];                                          |
|     X_1945 :=
nil:bat[:oid,:int];                                          |
|     X_1958 :=
nil:bat[:oid,:int];                                          |
|     X_1969 :=
nil:bat[:oid,:int];                                          |
|     X_1981 :=
nil:bat[:oid,:int];                                          |
|     X_1992 :=
nil:bat[:oid,:int];                                          |
|     X_2006 :=
nil:bat[:oid,:int];                                          |
|     X_2017 :=
nil:bat[:oid,:int];                                          |
|     X_2030 :=
nil:bat[:oid,:int];                                          |
|     X_2040 :=
nil:bat[:oid,:int];                                          |
|     X_2053 :=
nil:bat[:oid,:int];                                          |
|     X_2063 :=
nil:bat[:oid,:int];                                          |
|     X_2076 :=
nil:bat[:oid,:int];                                          |
|     X_2086 :=
nil:bat[:oid,:int];                                          |
|     X_2101 :=
nil:bat[:oid,:int];                                          |
|     X_2111 :=
nil:bat[:oid,:int];                                          |
|     X_2124 :=
nil:bat[:oid,:int];                                          |
|     X_2135 :=
nil:bat[:oid,:int];                                          |
|     X_2147 :=
nil:bat[:oid,:int];                                          |
|     X_2158 :=
nil:bat[:oid,:int];                                          |
|     X_2170 :=
nil:bat[:oid,:int];                                          |
|     X_2181 :=
nil:bat[:oid,:int];                                          |
|     X_2196 :=
nil:bat[:oid,:int];                                          |
|     X_2206 :=
nil:bat[:oid,:int];                                          |
|     X_2219 :=
nil:bat[:oid,:int];                                          |
|     X_2229 :=
nil:bat[:oid,:int];                                          |
|     X_2242 :=
nil:bat[:oid,:int];                                          |
|     X_2252 :=
nil:bat[:oid,:int];                                          |
|     X_2265 :=
nil:bat[:oid,:int];                                          |
|     X_2275 :=
nil:bat[:oid,:int];                                          |
|     X_2290 :=
nil:bat[:oid,:int];                                          |
|     X_2301 :=
nil:bat[:oid,:int];                                          |
|     X_2313 :=
nil:bat[:oid,:int];                                          |
|     X_2324 :=
nil:bat[:oid,:int];                                          |
|     X_2336 :=
nil:bat[:oid,:int];                                          |
|     X_2347 :=
nil:bat[:oid,:int];                                          |
|     X_2360 :=
nil:bat[:oid,:int];                                          |
|     X_2370 :=
nil:bat[:oid,:int];                                          |
|     X_2385 :=
nil:bat[:oid,:int];                                          |
|     X_2395 :=
nil:bat[:oid,:int];                                          |
| barrier X_3114 :=
language.dataflow();                                     |
|     X_21:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","serialno",0);  |
|     X_23:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","serialno",2);  |
|     X_26 :=
algebra.kdifference(X_21,X_23);                                |
|     X_27 :=
algebra.kunion(X_26,X_23);                                     |
|     X_28:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","serialno",1);  |
|     X_29 :=
algebra.kunion(X_27,X_28);                                     |
|     X_30 :=
algebra.kdifference(X_29,X_16);                                |
|     X_31 :=
algebra.leftjoin(X_19,X_30);                                   |
|     X_32:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","division",0);  |
|     X_35:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","division",2);  |
|     X_37 :=
algebra.kdifference(X_32,X_35);                                |
|     X_38 :=
algebra.kunion(X_37,X_35);                                     |
|     X_39:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","division",1);  |
|     X_41 :=
algebra.kunion(X_38,X_39);                                     |
|     X_42 :=
algebra.kdifference(X_41,X_16);                                |
|     X_43 :=
algebra.leftjoin(X_19,X_42);                                   |
|     X_45:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","puma",0);      |
|     X_48:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","puma",2);      |
|     X_49 :=
algebra.kdifference(X_45,X_48);                                |
|     X_50 :=
algebra.kunion(X_49,X_48);                                     |
|     X_51:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","puma",1);      |
|     X_52 :=
algebra.kunion(X_50,X_51);                                     |
|     X_53 :=
algebra.kdifference(X_52,X_16);                                |
|     X_54 :=
algebra.leftjoin(X_19,X_53);                                   |
|     X_55:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","region",0);    |
|     X_58:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","region",2);    |
|     X_60 :=
algebra.kdifference(X_55,X_58);                                |
|     X_61 :=
algebra.kunion(X_60,X_58);                                     |
|     X_62:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","region",1);    |
|     X_64 :=
algebra.kunion(X_61,X_62);                                     |
|     X_65 :=
algebra.kdifference(X_64,X_16);                                |
|     X_67 :=
algebra.leftjoin(X_19,X_65);                                   |
|     X_68:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","st",0);        |
|     X_71:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","st",2);        |
|     X_72 :=
algebra.kdifference(X_68,X_71);                                |
|     X_73 :=
algebra.kunion(X_72,X_71);                                     |
|     X_74:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","st",1);        |
|     X_75 :=
algebra.kunion(X_73,X_74);                                     |
|     X_76 :=
algebra.kdifference(X_75,X_16);                                |
|     X_77 :=
algebra.leftjoin(X_19,X_76);                                   |
|     X_78:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","adjhsg",0);    |
|     X_81:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","adjhsg",2);    |
|     X_83 :=
algebra.kdifference(X_78,X_81);                                |
|     X_84 :=
algebra.kunion(X_83,X_81);                                     |
|     X_85:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","adjhsg",1);    |
|     X_88 :=
algebra.kunion(X_84,X_85);                                     |
|     X_89 :=
algebra.kdifference(X_88,X_16);                                |
|     X_90 :=
algebra.leftjoin(X_19,X_89);                                   |
|     X_91:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","adjinc",0);    |
|     X_94:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","adjinc",2);    |
|     X_95 :=
algebra.kdifference(X_91,X_94);                                |
|     X_96 :=
algebra.kunion(X_95,X_94);                                     |
|     X_97:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","adjinc",1);    |
|     X_98 :=
algebra.kunion(X_96,X_97);                                     |
|     X_99 :=
algebra.kdifference(X_98,X_16);                                |
|     X_100 :=
algebra.leftjoin(X_19,X_99);                                  |
|     X_101:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp",0);     |
|     X_104:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp",2);     |
|     X_107 :=
algebra.kdifference(X_101,X_104);                             |
|     X_108 :=
algebra.kunion(X_107,X_104);                                  |
|     X_109:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp",1);     |
|     X_111 :=
algebra.kunion(X_108,X_109);                                  |
|     X_112:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_113 :=
bat.reverse(X_112);                                           |
|     X_114 :=
algebra.kdifference(X_111,X_113);                             |
|     X_115 :=
algebra.leftjoin(X_19,X_114);                                 |
|     X_116:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","np",0);       |
|     X_119:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","np",2);       |
|     X_120 :=
algebra.kdifference(X_116,X_119);                             |
|     X_121 :=
algebra.kunion(X_120,X_119);                                  |
|     X_122:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","np",1);       |
|     X_123 :=
algebra.kunion(X_121,X_122);                                  |
|     X_124 :=
algebra.kdifference(X_123,X_113);                             |
|     X_125 :=
algebra.leftjoin(X_19,X_124);                                 |
|     X_127:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","zzzz",0);     |
|     X_130:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","zzzz",2);     |
|     X_132 :=
algebra.kdifference(X_127,X_130);                             |
|     X_133 :=
algebra.kunion(X_132,X_130);                                  |
|     X_134:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","zzzz",1);     |
|     X_136 :=
algebra.kunion(X_133,X_134);                                  |
|     X_137 :=
algebra.kdifference(X_136,X_113);                             |
|     X_138 :=
algebra.leftjoin(X_19,X_137);                                 |
|     X_139:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","acr",0);      |
|     X_142:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","acr",2);      |
|     X_143 :=
algebra.kdifference(X_139,X_142);                             |
|     X_144 :=
algebra.kunion(X_143,X_142);                                  |
|     X_145:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","acr",1);      |
|     X_146 :=
algebra.kunion(X_144,X_145);                                  |
|     X_147 :=
algebra.kdifference(X_146,X_113);                             |
|     X_149 :=
algebra.leftjoin(X_19,X_147);                                 |
|     X_150:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ags",0);      |
|     X_153:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ags",2);      |
|     X_155 :=
algebra.kdifference(X_150,X_153);                             |
|     X_156 :=
algebra.kunion(X_155,X_153);                                  |
|     X_157:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ags",1);      |
|     X_159 :=
algebra.kunion(X_156,X_157);                                  |
|     X_160 :=
algebra.kdifference(X_159,X_113);                             |
|     X_161 :=
algebra.leftjoin(X_19,X_160);                                 |
|     X_162:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bath",0);     |
|     X_165:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bath",2);     |
|     X_166 :=
algebra.kdifference(X_162,X_165);                             |
|     X_167 :=
algebra.kunion(X_166,X_165);                                  |
|     X_168:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bath",1);     |
|     X_170 :=
algebra.kunion(X_167,X_168);                                  |
|     X_171 :=
algebra.kdifference(X_170,X_113);                             |
|     X_172 :=
algebra.leftjoin(X_19,X_171);                                 |
|     X_173:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bdsp",0);     |
|     X_176:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bdsp",2);     |
|     X_178 :=
algebra.kdifference(X_173,X_176);                             |
|     X_179 :=
algebra.kunion(X_178,X_176);                                  |
|     X_180:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bdsp",1);     |
|     X_182 :=
algebra.kunion(X_179,X_180);                                  |
|     X_183 :=
algebra.kdifference(X_182,X_113);                             |
|     X_184 :=
algebra.leftjoin(X_19,X_183);                                 |
|     X_185:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bld",0);      |
|     X_189:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bld",2);      |
|     X_190 :=
algebra.kdifference(X_185,X_189);                             |
|     X_191 :=
algebra.kunion(X_190,X_189);                                  |
|     X_192:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bld",1);      |
|     X_193 :=
algebra.kunion(X_191,X_192);                                  |
|     X_194 :=
algebra.kdifference(X_193,X_113);                             |
|     X_195 :=
algebra.leftjoin(X_19,X_194);                                 |
|     X_196:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bus",0);      |
|     X_199:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bus",2);      |
|     X_201 :=
algebra.kdifference(X_196,X_199);                             |
|     X_202 :=
algebra.kunion(X_201,X_199);                                  |
|     X_203:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","bus",1);      |
|     X_205 :=
algebra.kunion(X_202,X_203);                                  |
|     X_206:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_207 :=
bat.reverse(X_206);                                           |
|     X_208 :=
algebra.kdifference(X_205,X_207);                             |
|     X_210 :=
algebra.leftjoin(X_19,X_208);                                 |
|     X_211:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","conp",0);     |
|     X_214:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","conp",2);     |
|     X_215 :=
algebra.kdifference(X_211,X_214);                             |
|     X_216 :=
algebra.kunion(X_215,X_214);                                  |
|     X_217:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","conp",1);     |
|     X_218 :=
algebra.kunion(X_216,X_217);                                  |
|     X_219 :=
algebra.kdifference(X_218,X_207);                             |
|     X_220 :=
algebra.leftjoin(X_19,X_219);                                 |
|     X_221:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","elep",0);     |
|     X_224:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","elep",2);     |
|     X_226 :=
algebra.kdifference(X_221,X_224);                             |
|     X_227 :=
algebra.kunion(X_226,X_224);                                  |
|     X_228:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","elep",1);     |
|     X_230 :=
algebra.kunion(X_227,X_228);                                  |
|     X_232 :=
algebra.kdifference(X_230,X_207);                             |
|     X_233 :=
algebra.leftjoin(X_19,X_232);                                 |
|     X_234:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fs",0);       |
|     X_237:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fs",2);       |
|     X_238 :=
algebra.kdifference(X_234,X_237);                             |
|     X_239 :=
algebra.kunion(X_238,X_237);                                  |
|     X_240:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fs",1);       |
|     X_241 :=
algebra.kunion(X_239,X_240);                                  |
|     X_242 :=
algebra.kdifference(X_241,X_207);                             |
|     X_243 :=
algebra.leftjoin(X_19,X_242);                                 |
|     X_244:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fulp",0);     |
|     X_247:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fulp",2);     |
|     X_249 :=
algebra.kdifference(X_244,X_247);                             |
|     X_250 :=
algebra.kunion(X_249,X_247);                                  |
|     X_251:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fulp",1);     |
|     X_254 :=
algebra.kunion(X_250,X_251);                                  |
|     X_255 :=
algebra.kdifference(X_254,X_207);                             |
|     X_256 :=
algebra.leftjoin(X_19,X_255);                                 |
|     X_257:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","gasp",0);     |
|     X_260:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","gasp",2);     |
|     X_261 :=
algebra.kdifference(X_257,X_260);                             |
|     X_262 :=
algebra.kunion(X_261,X_260);                                  |
|     X_263:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","gasp",1);     |
|     X_264 :=
algebra.kunion(X_262,X_263);                                  |
|     X_265 :=
algebra.kdifference(X_264,X_207);                             |
|     X_266 :=
algebra.leftjoin(X_19,X_265);                                 |
|     X_267:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hfl",0);      |
|     X_270:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hfl",2);      |
|     X_273 :=
algebra.kdifference(X_267,X_270);                             |
|     X_274 :=
algebra.kunion(X_273,X_270);                                  |
|     X_275:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hfl",1);      |
|     X_277 :=
algebra.kunion(X_274,X_275);                                  |
|     X_278 :=
algebra.kdifference(X_277,X_207);                             |
|     X_279 :=
algebra.leftjoin(X_19,X_278);                                 |
|     X_280:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","insp",0);     |
|     X_283:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","insp",2);     |
|     X_284 :=
algebra.kdifference(X_280,X_283);                             |
|     X_285 :=
algebra.kunion(X_284,X_283);                                  |
|     X_286:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","insp",1);     |
|     X_287 :=
algebra.kunion(X_285,X_286);                                  |
|     X_288 :=
algebra.kdifference(X_287,X_207);                             |
|     X_289 :=
algebra.leftjoin(X_19,X_288);                                 |
|     X_291:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mhp",0);      |
|     X_294:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mhp",2);      |
|     X_296 :=
algebra.kdifference(X_291,X_294);                             |
|     X_297 :=
algebra.kunion(X_296,X_294);                                  |
|     X_298:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mhp",1);      |
|     X_300 :=
algebra.kunion(X_297,X_298);                                  |
|     X_301:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_302 :=
bat.reverse(X_301);                                           |
|     X_303 :=
algebra.kdifference(X_300,X_302);                             |
|     X_304 :=
algebra.leftjoin(X_19,X_303);                                 |
|     X_305:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgi",0);     |
|     X_308:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgi",2);     |
|     X_309 :=
algebra.kdifference(X_305,X_308);                             |
|     X_310 :=
algebra.kunion(X_309,X_308);                                  |
|     X_311:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgi",1);     |
|     X_312 :=
algebra.kunion(X_310,X_311);                                  |
|     X_313 :=
algebra.kdifference(X_312,X_302);                             |
|     X_315 :=
algebra.leftjoin(X_19,X_313);                                 |
|     X_316:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgp",0);     |
|     X_319:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgp",2);     |
|     X_321 :=
algebra.kdifference(X_316,X_319);                             |
|     X_322 :=
algebra.kunion(X_321,X_319);                                  |
|     X_323:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgp",1);     |
|     X_325 :=
algebra.kunion(X_322,X_323);                                  |
|     X_326 :=
algebra.kdifference(X_325,X_302);                             |
|     X_327 :=
algebra.leftjoin(X_19,X_326);                                 |
|     X_328:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgt",0);     |
|     X_331:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgt",2);     |
|     X_332 :=
algebra.kdifference(X_328,X_331);                             |
|     X_333 :=
algebra.kunion(X_332,X_331);                                  |
|     X_334:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgt",1);     |
|     X_336 :=
algebra.kunion(X_333,X_334);                                  |
|     X_337 :=
algebra.kdifference(X_336,X_302);                             |
|     X_338 :=
algebra.leftjoin(X_19,X_337);                                 |
|     X_339:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgx",0);     |
|     X_342:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgx",2);     |
|     X_344 :=
algebra.kdifference(X_339,X_342);                             |
|     X_345 :=
algebra.kunion(X_344,X_342);                                  |
|     X_346:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mrgx",1);     |
|     X_348 :=
algebra.kunion(X_345,X_346);                                  |
|     X_349 :=
algebra.kdifference(X_348,X_302);                             |
|     X_350 :=
algebra.leftjoin(X_19,X_349);                                 |
|     X_351:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","refr",0);     |
|     X_355:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","refr",2);     |
|     X_356 :=
algebra.kdifference(X_351,X_355);                             |
|     X_357 :=
algebra.kunion(X_356,X_355);                                  |
|     X_358:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","refr",1);     |
|     X_359 :=
algebra.kunion(X_357,X_358);                                  |
|     X_360 :=
algebra.kdifference(X_359,X_302);                             |
|     X_361 :=
algebra.leftjoin(X_19,X_360);                                 |
|     X_362:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rmsp",0);     |
|     X_365:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rmsp",2);     |
|     X_367 :=
algebra.kdifference(X_362,X_365);                             |
|     X_368 :=
algebra.kunion(X_367,X_365);                                  |
|     X_369:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rmsp",1);     |
|     X_371 :=
algebra.kunion(X_368,X_369);                                  |
|     X_372 :=
algebra.kdifference(X_371,X_302);                             |
|     X_374 :=
algebra.leftjoin(X_19,X_372);                                 |
|     X_375:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rntm",0);     |
|     X_378:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rntm",2);     |
|     X_379 :=
algebra.kdifference(X_375,X_378);                             |
|     X_380 :=
algebra.kunion(X_379,X_378);                                  |
|     X_381:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rntm",1);     |
|     X_382 :=
algebra.kunion(X_380,X_381);                                  |
|     X_383 :=
algebra.kdifference(X_382,X_302);                             |
|     X_384 :=
algebra.leftjoin(X_19,X_383);                                 |
|     X_385:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rntp",0);     |
|     X_388:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rntp",2);     |
|     X_390 :=
algebra.kdifference(X_385,X_388);                             |
|     X_391 :=
algebra.kunion(X_390,X_388);                                  |
|     X_392:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rntp",1);     |
|     X_394 :=
algebra.kunion(X_391,X_392);                                  |
|     X_395:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_397 :=
bat.reverse(X_395);                                           |
|     X_398 :=
algebra.kdifference(X_394,X_397);                             |
|     X_399 :=
algebra.leftjoin(X_19,X_398);                                 |
|     X_400:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rwat",0);     |
|     X_403:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rwat",2);     |
|     X_404 :=
algebra.kdifference(X_400,X_403);                             |
|     X_405 :=
algebra.kunion(X_404,X_403);                                  |
|     X_406:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","rwat",1);     |
|     X_407 :=
algebra.kunion(X_405,X_406);                                  |
|     X_408 :=
algebra.kdifference(X_407,X_397);                             |
|     X_409 :=
algebra.leftjoin(X_19,X_408);                                 |
|     X_410:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","sink",0);     |
|     X_413:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","sink",2);     |
|     X_415 :=
algebra.kdifference(X_410,X_413);                             |
|     X_416 :=
algebra.kunion(X_415,X_413);                                  |
|     X_417:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","sink",1);     |
|     X_420 :=
algebra.kunion(X_416,X_417);                                  |
|     X_421 :=
algebra.kdifference(X_420,X_397);                             |
|     X_422 :=
algebra.leftjoin(X_19,X_421);                                 |
|     X_423:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smp",0);      |
|     X_426:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smp",2);      |
|     X_427 :=
algebra.kdifference(X_423,X_426);                             |
|     X_428 :=
algebra.kunion(X_427,X_426);                                  |
|     X_429:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smp",1);      |
|     X_430 :=
algebra.kunion(X_428,X_429);                                  |
|     X_431 :=
algebra.kdifference(X_430,X_397);                             |
|     X_432 :=
algebra.leftjoin(X_19,X_431);                                 |
|     X_433:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","stov",0);     |
|     X_436:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","stov",2);     |
|     X_439 :=
algebra.kdifference(X_433,X_436);                             |
|     X_440 :=
algebra.kunion(X_439,X_436);                                  |
|     X_441:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","stov",1);     |
|     X_443 :=
algebra.kunion(X_440,X_441);                                  |
|     X_444 :=
algebra.kdifference(X_443,X_397);                             |
|     X_445 :=
algebra.leftjoin(X_19,X_444);                                 |
|     X_446:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","tel",0);      |
|     X_449:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","tel",2);      |
|     X_450 :=
algebra.kdifference(X_446,X_449);                             |
|     X_451 :=
algebra.kunion(X_450,X_449);                                  |
|     X_452:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","tel",1);      |
|     X_453 :=
algebra.kunion(X_451,X_452);                                  |
|     X_454 :=
algebra.kdifference(X_453,X_397);                             |
|     X_455 :=
algebra.leftjoin(X_19,X_454);                                 |
|     X_457:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ten",0);      |
|     X_460:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ten",2);      |
|     X_462 :=
algebra.kdifference(X_457,X_460);                             |
|     X_463 :=
algebra.kunion(X_462,X_460);                                  |
|     X_464:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ten",1);      |
|     X_466 :=
algebra.kunion(X_463,X_464);                                  |
|     X_467 :=
algebra.kdifference(X_466,X_397);                             |
|     X_468 :=
algebra.leftjoin(X_19,X_467);                                 |
|     X_469:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","toil",0);     |
|     X_472:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","toil",2);     |
|     X_473 :=
algebra.kdifference(X_469,X_472);                             |
|     X_474 :=
algebra.kunion(X_473,X_472);                                  |
|     X_475:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","toil",1);     |
|     X_476 :=
algebra.kunion(X_474,X_475);                                  |
|     X_477 :=
algebra.kdifference(X_476,X_397);                             |
|     X_479 :=
algebra.leftjoin(X_19,X_477);                                 |
|     X_480:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","vacs",0);     |
|     X_483:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","vacs",2);     |
|     X_485 :=
algebra.kdifference(X_480,X_483);                             |
|     X_486 :=
algebra.kunion(X_485,X_483);                                  |
|     X_487:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","vacs",1);     |
|     X_489 :=
algebra.kunion(X_486,X_487);                                  |
|     X_490:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_491 :=
bat.reverse(X_490);                                           |
|     X_492 :=
algebra.kdifference(X_489,X_491);                             |
|     X_493 :=
algebra.leftjoin(X_19,X_492);                                 |
|     X_494:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","valp",0);     |
|     X_497:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","valp",2);     |
|     X_498 :=
algebra.kdifference(X_494,X_497);                             |
|     X_499 :=
algebra.kunion(X_498,X_497);                                  |
|     X_500:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","valp",1);     |
|     X_502 :=
algebra.kunion(X_499,X_500);                                  |
|     X_503 :=
algebra.kdifference(X_502,X_491);                             |
|     X_504 :=
algebra.leftjoin(X_19,X_503);                                 |
|     X_505:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","veh",0);      |
|     X_508:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","veh",2);      |
|     X_510 :=
algebra.kdifference(X_505,X_508);                             |
|     X_511 :=
algebra.kunion(X_510,X_508);                                  |
|     X_512:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","veh",1);      |
|     X_514 :=
algebra.kunion(X_511,X_512);                                  |
|     X_515 :=
algebra.kdifference(X_514,X_491);                             |
|     X_516 :=
algebra.leftjoin(X_19,X_515);                                 |
|     X_517:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","watp",0);     |
|     X_521:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","watp",2);     |
|     X_522 :=
algebra.kdifference(X_517,X_521);                             |
|     X_523 :=
algebra.kunion(X_522,X_521);                                  |
|     X_524:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","watp",1);     |
|     X_525 :=
algebra.kunion(X_523,X_524);                                  |
|     X_526 :=
algebra.kdifference(X_525,X_491);                             |
|     X_527 :=
algebra.leftjoin(X_19,X_526);                                 |
|     X_528:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ybl",0);      |
|     X_531:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ybl",2);      |
|     X_533 :=
algebra.kdifference(X_528,X_531);                             |
|     X_534 :=
algebra.kunion(X_533,X_531);                                  |
|     X_535:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ybl",1);      |
|     X_537 :=
algebra.kunion(X_534,X_535);                                  |
|     X_538 :=
algebra.kdifference(X_537,X_491);                             |
|     X_540 :=
algebra.leftjoin(X_19,X_538);                                 |
|     X_541:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fes",0);      |
|     X_544:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fes",2);      |
|     X_545 :=
algebra.kdifference(X_541,X_544);                             |
|     X_546 :=
algebra.kunion(X_545,X_544);                                  |
|     X_547:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fes",1);      |
|     X_548 :=
algebra.kunion(X_546,X_547);                                  |
|     X_549 :=
algebra.kdifference(X_548,X_491);                             |
|     X_550 :=
algebra.leftjoin(X_19,X_549);                                 |
|     X_551:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fincp",0);    |
|     X_554:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fincp",2);    |
|     X_556 :=
algebra.kdifference(X_551,X_554);                             |
|     X_557 :=
algebra.kunion(X_556,X_554);                                  |
|     X_558:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fincp",1);    |
|     X_560 :=
algebra.kunion(X_557,X_558);                                  |
|     X_562 :=
algebra.kdifference(X_560,X_491);                             |
|     X_563 :=
algebra.leftjoin(X_19,X_562);                                 |
|     X_564:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fparc",0);    |
|     X_567:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fparc",2);    |
|     X_568 :=
algebra.kdifference(X_564,X_567);                             |
|     X_569 :=
algebra.kunion(X_568,X_567);                                  |
|     X_570:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fparc",1);    |
|     X_571 :=
algebra.kunion(X_569,X_570);                                  |
|     X_572 :=
algebra.kdifference(X_571,X_491);                             |
|     X_573 :=
algebra.leftjoin(X_19,X_572);                                 |
|     X_574:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","grntp",0);    |
|     X_577:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","grntp",2);    |
|     X_579 :=
algebra.kdifference(X_574,X_577);                             |
|     X_580 :=
algebra.kunion(X_579,X_577);                                  |
|     X_581:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","grntp",1);    |
|     X_584 :=
algebra.kunion(X_580,X_581);                                  |
|     X_585:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_586 :=
bat.reverse(X_585);                                           |
|     X_587 :=
algebra.kdifference(X_584,X_586);                             |
|     X_588 :=
algebra.leftjoin(X_19,X_587);                                 |
|     X_589:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","grpip",0);    |
|     X_592:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","grpip",2);    |
|     X_593 :=
algebra.kdifference(X_589,X_592);                             |
|     X_594 :=
algebra.kunion(X_593,X_592);                                  |
|     X_595:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","grpip",1);    |
|     X_596 :=
algebra.kunion(X_594,X_595);                                  |
|     X_597 :=
algebra.kdifference(X_596,X_586);                             |
|     X_598 :=
algebra.leftjoin(X_19,X_597);                                 |
|     X_599:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hhl",0);      |
|     X_602:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hhl",2);      |
|     X_605 :=
algebra.kdifference(X_599,X_602);                             |
|     X_606 :=
algebra.kunion(X_605,X_602);                                  |
|     X_607:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hhl",1);      |
|     X_609 :=
algebra.kunion(X_606,X_607);                                  |
|     X_610 :=
algebra.kdifference(X_609,X_586);                             |
|     X_611 :=
algebra.leftjoin(X_19,X_610);                                 |
|     X_612:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hht",0);      |
|     X_615:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hht",2);      |
|     X_616 :=
algebra.kdifference(X_612,X_615);                             |
|     X_617 :=
algebra.kunion(X_616,X_615);                                  |
|     X_618:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hht",1);      |
|     X_619 :=
algebra.kunion(X_617,X_618);                                  |
|     X_620 :=
algebra.kdifference(X_619,X_586);                             |
|     X_621 :=
algebra.leftjoin(X_19,X_620);                                 |
|     X_623:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hincp",0);    |
|     X_626:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hincp",2);    |
|     X_628 :=
algebra.kdifference(X_623,X_626);                             |
|     X_629 :=
algebra.kunion(X_628,X_626);                                  |
|     X_630:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hincp",1);    |
|     X_632 :=
algebra.kunion(X_629,X_630);                                  |
|     X_633 :=
algebra.kdifference(X_632,X_586);                             |
|     X_634 :=
algebra.leftjoin(X_19,X_633);                                 |
|     X_635:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hugcl",0);    |
|     X_638:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hugcl",2);    |
|     X_639 :=
algebra.kdifference(X_635,X_638);                             |
|     X_640 :=
algebra.kunion(X_639,X_638);                                  |
|     X_641:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hugcl",1);    |
|     X_642 :=
algebra.kunion(X_640,X_641);                                  |
|     X_643 :=
algebra.kdifference(X_642,X_586);                             |
|     X_645 :=
algebra.leftjoin(X_19,X_643);                                 |
|     X_646:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hupac",0);    |
|     X_649:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hupac",2);    |
|     X_651 :=
algebra.kdifference(X_646,X_649);                             |
|     X_652 :=
algebra.kunion(X_651,X_649);                                  |
|     X_653:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hupac",1);    |
|     X_655 :=
algebra.kunion(X_652,X_653);                                  |
|     X_656 :=
algebra.kdifference(X_655,X_586);                             |
|     X_657 :=
algebra.leftjoin(X_19,X_656);                                 |
|     X_658:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hupaoc",0);   |
|     X_661:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hupaoc",2);   |
|     X_662 :=
algebra.kdifference(X_658,X_661);                             |
|     X_663 :=
algebra.kunion(X_662,X_661);                                  |
|     X_664:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","hupaoc",1);   |
|     X_666 :=
algebra.kunion(X_663,X_664);                                  |
|     X_667 :=
algebra.kdifference(X_666,X_586);                             |
|     X_668 :=
algebra.leftjoin(X_19,X_667);                                 |
|     X_669:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","huparc",0);   |
|     X_672:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","huparc",2);   |
|     X_674 :=
algebra.kdifference(X_669,X_672);                             |
|     X_675 :=
algebra.kunion(X_674,X_672);                                  |
|     X_676:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","huparc",1);   |
|     X_678 :=
algebra.kunion(X_675,X_676);                                  |
|     X_679:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_680 :=
bat.reverse(X_679);                                           |
|     X_681 :=
algebra.kdifference(X_678,X_680);                             |
|     X_682 :=
algebra.leftjoin(X_19,X_681);                                 |
|     X_683:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","kit",0);      |
|     X_687:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","kit",2);      |
|     X_688 :=
algebra.kdifference(X_683,X_687);                             |
|     X_689 :=
algebra.kunion(X_688,X_687);                                  |
|     X_690:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","kit",1);      |
|     X_691 :=
algebra.kunion(X_689,X_690);                                  |
|     X_692 :=
algebra.kdifference(X_691,X_680);                             |
|     X_693 :=
algebra.leftjoin(X_19,X_692);                                 |
|     X_694:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","lngi",0);     |
|     X_697:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","lngi",2);     |
|     X_699 :=
algebra.kdifference(X_694,X_697);                             |
|     X_700 :=
algebra.kunion(X_699,X_697);                                  |
|     X_701:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","lngi",1);     |
|     X_703 :=
algebra.kunion(X_700,X_701);                                  |
|     X_704 :=
algebra.kdifference(X_703,X_680);                             |
|     X_706 :=
algebra.leftjoin(X_19,X_704);                                 |
|     X_707:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","multg",0);    |
|     X_710:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","multg",2);    |
|     X_711 :=
algebra.kdifference(X_707,X_710);                             |
|     X_712 :=
algebra.kunion(X_711,X_710);                                  |
|     X_713:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","multg",1);    |
|     X_714 :=
algebra.kunion(X_712,X_713);                                  |
|     X_715 :=
algebra.kdifference(X_714,X_680);                             |
|     X_716 :=
algebra.leftjoin(X_19,X_715);                                 |
|     X_717:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mv",0);       |
|     X_720:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mv",2);       |
|     X_722 :=
algebra.kdifference(X_717,X_720);                             |
|     X_723 :=
algebra.kunion(X_722,X_720);                                  |
|     X_724:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","mv",1);       |
|     X_726 :=
algebra.kunion(X_723,X_724);                                  |
|     X_728 :=
algebra.kdifference(X_726,X_680);                             |
|     X_729 :=
algebra.leftjoin(X_19,X_728);                                 |
|     X_730:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","noc",0);      |
|     X_733:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","noc",2);      |
|     X_734 :=
algebra.kdifference(X_730,X_733);                             |
|     X_735 :=
algebra.kunion(X_734,X_733);                                  |
|     X_736:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","noc",1);      |
|     X_737 :=
algebra.kunion(X_735,X_736);                                  |
|     X_738 :=
algebra.kdifference(X_737,X_680);                             |
|     X_739 :=
algebra.leftjoin(X_19,X_738);                                 |
|     X_740:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","npf",0);      |
|     X_743:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","npf",2);      |
|     X_745 :=
algebra.kdifference(X_740,X_743);                             |
|     X_746 :=
algebra.kunion(X_745,X_743);                                  |
|     X_747:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","npf",1);      |
|     X_750 :=
algebra.kunion(X_746,X_747);                                  |
|     X_751 :=
algebra.kdifference(X_750,X_680);                             |
|     X_752 :=
algebra.leftjoin(X_19,X_751);                                 |
|     X_753:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","npp",0);      |
|     X_756:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","npp",2);      |
|     X_757 :=
algebra.kdifference(X_753,X_756);                             |
|     X_758 :=
algebra.kunion(X_757,X_756);                                  |
|     X_759:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","npp",1);      |
|     X_760 :=
algebra.kunion(X_758,X_759);                                  |
|     X_761 :=
algebra.kdifference(X_760,X_680);                             |
|     X_762 :=
algebra.leftjoin(X_19,X_761);                                 |
|     X_763:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","nr",0);       |
|     X_766:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","nr",2);       |
|     X_769 :=
algebra.kdifference(X_763,X_766);                             |
|     X_770 :=
algebra.kunion(X_769,X_766);                                  |
|     X_771:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","nr",1);       |
|     X_773 :=
algebra.kunion(X_770,X_771);                                  |
|     X_774:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_775 :=
bat.reverse(X_774);                                           |
|     X_776 :=
algebra.kdifference(X_773,X_775);                             |
|     X_777 :=
algebra.leftjoin(X_19,X_776);                                 |
|     X_778:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","nrc",0);      |
|     X_781:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","nrc",2);      |
|     X_782 :=
algebra.kdifference(X_778,X_781);                             |
|     X_783 :=
algebra.kunion(X_782,X_781);                                  |
|     X_784:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","nrc",1);      |
|     X_785 :=
algebra.kunion(X_783,X_784);                                  |
|     X_786 :=
algebra.kdifference(X_785,X_775);                             |
|     X_787 :=
algebra.leftjoin(X_19,X_786);                                 |
|     X_789:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ocpip",0);    |
|     X_792:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ocpip",2);    |
|     X_794 :=
algebra.kdifference(X_789,X_792);                             |
|     X_795 :=
algebra.kunion(X_794,X_792);                                  |
|     X_796:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ocpip",1);    |
|     X_798 :=
algebra.kunion(X_795,X_796);                                  |
|     X_799 :=
algebra.kdifference(X_798,X_775);                             |
|     X_800 :=
algebra.leftjoin(X_19,X_799);                                 |
|     X_801:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","partner",0);  |
|     X_804:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","partner",2);  |
|     X_805 :=
algebra.kdifference(X_801,X_804);                             |
|     X_806 :=
algebra.kunion(X_805,X_804);                                  |
|     X_807:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","partner",1);  |
|     X_808 :=
algebra.kunion(X_806,X_807);                                  |
|     X_809 :=
algebra.kdifference(X_808,X_775);                             |
|     X_811 :=
algebra.leftjoin(X_19,X_809);                                 |
|     X_812:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","plm",0);      |
|     X_815:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","plm",2);      |
|     X_817 :=
algebra.kdifference(X_812,X_815);                             |
|     X_818 :=
algebra.kunion(X_817,X_815);                                  |
|     X_819:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","plm",1);      |
|     X_821 :=
algebra.kunion(X_818,X_819);                                  |
|     X_822 :=
algebra.kdifference(X_821,X_775);                             |
|     X_823 :=
algebra.leftjoin(X_19,X_822);                                 |
|     X_824:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","psf",0);      |
|     X_827:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","psf",2);      |
|     X_828 :=
algebra.kdifference(X_824,X_827);                             |
|     X_829 :=
algebra.kunion(X_828,X_827);                                  |
|     X_830:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","psf",1);      |
|     X_832 :=
algebra.kunion(X_829,X_830);                                  |
|     X_833 :=
algebra.kdifference(X_832,X_775);                             |
|     X_834 :=
algebra.leftjoin(X_19,X_833);                                 |
|     X_835:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r18",0);      |
|     X_838:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r18",2);      |
|     X_840 :=
algebra.kdifference(X_835,X_838);                             |
|     X_841 :=
algebra.kunion(X_840,X_838);                                  |
|     X_842:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r18",1);      |
|     X_844 :=
algebra.kunion(X_841,X_842);                                  |
|     X_845 :=
algebra.kdifference(X_844,X_775);                             |
|     X_846 :=
algebra.leftjoin(X_19,X_845);                                 |
|     X_847:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r60",0);      |
|     X_851:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r60",2);      |
|     X_852 :=
algebra.kdifference(X_847,X_851);                             |
|     X_853 :=
algebra.kunion(X_852,X_851);                                  |
|     X_854:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r60",1);      |
|     X_855 :=
algebra.kunion(X_853,X_854);                                  |
|     X_856 :=
algebra.kdifference(X_855,X_775);                             |
|     X_857 :=
algebra.leftjoin(X_19,X_856);                                 |
|     X_858:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r65",0);      |
|     X_861:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r65",2);      |
|     X_863 :=
algebra.kdifference(X_858,X_861);                             |
|     X_864 :=
algebra.kunion(X_863,X_861);                                  |
|     X_865:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","r65",1);      |
|     X_867 :=
algebra.kunion(X_864,X_865);                                  |
|     X_868:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_869 :=
bat.reverse(X_868);                                           |
|     X_870 :=
algebra.kdifference(X_867,X_869);                             |
|     X_872 :=
algebra.leftjoin(X_19,X_870);                                 |
|     X_873:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","resmode",0);  |
|     X_876:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","resmode",2);  |
|     X_877 :=
algebra.kdifference(X_873,X_876);                             |
|     X_878 :=
algebra.kunion(X_877,X_876);                                  |
|     X_879:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","resmode",1);  |
|     X_880 :=
algebra.kunion(X_878,X_879);                                  |
|     X_881 :=
algebra.kdifference(X_880,X_869);                             |
|     X_882 :=
algebra.leftjoin(X_19,X_881);                                 |
|     X_883:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smocp",0);    |
|     X_886:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smocp",2);    |
|     X_888 :=
algebra.kdifference(X_883,X_886);                             |
|     X_889 :=
algebra.kunion(X_888,X_886);                                  |
|     X_890:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smocp",1);    |
|     X_892 :=
algebra.kunion(X_889,X_890);                                  |
|     X_894 :=
algebra.kdifference(X_892,X_869);                             |
|     X_895 :=
algebra.leftjoin(X_19,X_894);                                 |
|     X_896:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smx",0);      |
|     X_899:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smx",2);      |
|     X_900 :=
algebra.kdifference(X_896,X_899);                             |
|     X_901 :=
algebra.kunion(X_900,X_899);                                  |
|     X_902:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","smx",1);      |
|     X_903 :=
algebra.kunion(X_901,X_902);                                  |
|     X_904 :=
algebra.kdifference(X_903,X_869);                             |
|     X_905 :=
algebra.leftjoin(X_19,X_904);                                 |
|     X_906:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","srnt",0);     |
|     X_909:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","srnt",2);     |
|     X_911 :=
algebra.kdifference(X_906,X_909);                             |
|     X_912 :=
algebra.kunion(X_911,X_909);                                  |
|     X_913:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","srnt",1);     |
|     X_916 :=
algebra.kunion(X_912,X_913);                                  |
|     X_917 :=
algebra.kdifference(X_916,X_869);                             |
|     X_918 :=
algebra.leftjoin(X_19,X_917);                                 |
|     X_919:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","sval",0);     |
|     X_922:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","sval",2);     |
|     X_923 :=
algebra.kdifference(X_919,X_922);                             |
|     X_924 :=
algebra.kunion(X_923,X_922);                                  |
|     X_925:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","sval",1);     |
|     X_926 :=
algebra.kunion(X_924,X_925);                                  |
|     X_927 :=
algebra.kdifference(X_926,X_869);                             |
|     X_928 :=
algebra.leftjoin(X_19,X_927);                                 |
|     X_929:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","taxp",0);     |
|     X_932:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","taxp",2);     |
|     X_935 :=
algebra.kdifference(X_929,X_932);                             |
|     X_936 :=
algebra.kunion(X_935,X_932);                                  |
|     X_937:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","taxp",1);     |
|     X_939 :=
algebra.kunion(X_936,X_937);                                  |
|     X_940 :=
algebra.kdifference(X_939,X_869);                             |
|     X_941 :=
algebra.leftjoin(X_19,X_940);                                 |
|     X_942:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wif",0);      |
|     X_945:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wif",2);      |
|     X_946 :=
algebra.kdifference(X_942,X_945);                             |
|     X_947 :=
algebra.kunion(X_946,X_945);                                  |
|     X_948:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wif",1);      |
|     X_949 :=
algebra.kunion(X_947,X_948);                                  |
|     X_950 :=
algebra.kdifference(X_949,X_869);                             |
|     X_951 :=
algebra.leftjoin(X_19,X_950);                                 |
|     X_953:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wkexrel",0);  |
|     X_956:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wkexrel",2);  |
|     X_958 :=
algebra.kdifference(X_953,X_956);                             |
|     X_959 :=
algebra.kunion(X_958,X_956);                                  |
|     X_960:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wkexrel",1);  |
|     X_962 :=
algebra.kunion(X_959,X_960);                                  |
|     X_963:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);       |
|     X_964 :=
bat.reverse(X_963);                                           |
|     X_965 :=
algebra.kdifference(X_962,X_964);                             |
|     X_966 :=
algebra.leftjoin(X_19,X_965);                                 |
|     X_967:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","workstat",0); |
|     X_970:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","workstat",2); |
|     X_971 :=
algebra.kdifference(X_967,X_970);                             |
|     X_972 :=
algebra.kunion(X_971,X_970);                                  |
|     X_973:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","workstat",1); |
|     X_974 :=
algebra.kunion(X_972,X_973);                                  |
|     X_975 :=
algebra.kdifference(X_974,X_964);                             |
|     X_977 :=
algebra.leftjoin(X_19,X_975);                                 |
|     X_978:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","facrp",0);    |
|     X_981:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","facrp",2);    |
|     X_983 :=
algebra.kdifference(X_978,X_981);                             |
|     X_984 :=
algebra.kunion(X_983,X_981);                                  |
|     X_985:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","facrp",1);    |
|     X_987 :=
algebra.kunion(X_984,X_985);                                  |
|     X_988 :=
algebra.kdifference(X_987,X_964);                             |
|     X_989 :=
algebra.leftjoin(X_19,X_988);                                 |
|     X_990:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fagsp",0);    |
|     X_993:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fagsp",2);    |
|     X_994 :=
algebra.kdifference(X_990,X_993);                             |
|     X_995 :=
algebra.kunion(X_994,X_993);                                  |
|     X_996:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fagsp",1);    |
|     X_998 :=
algebra.kunion(X_995,X_996);                                  |
|     X_999 :=
algebra.kdifference(X_998,X_964);                             |
|     X_1000 :=
algebra.leftjoin(X_19,X_999);                                |
|     X_1001:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbathp",0);  |
|     X_1004:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbathp",2);  |
|     X_1006 :=
algebra.kdifference(X_1001,X_1004);                          |
|     X_1007 :=
algebra.kunion(X_1006,X_1004);                               |
|     X_1008:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbathp",1);  |
|     X_1010 :=
algebra.kunion(X_1007,X_1008);                               |
|     X_1011 :=
algebra.kdifference(X_1010,X_964);                           |
|     X_1012 :=
algebra.leftjoin(X_19,X_1011);                               |
|     X_1013:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbdsp",0);   |
|     X_1017:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbdsp",2);   |
|     X_1018 :=
algebra.kdifference(X_1013,X_1017);                          |
|     X_1019 :=
algebra.kunion(X_1018,X_1017);                               |
|     X_1020:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbdsp",1);   |
|     X_1021 :=
algebra.kunion(X_1019,X_1020);                               |
|     X_1022 :=
algebra.kdifference(X_1021,X_964);                           |
|     X_1023 :=
algebra.leftjoin(X_19,X_1022);                               |
|     X_1024:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbldp",0);   |
|     X_1027:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbldp",2);   |
|     X_1029 :=
algebra.kdifference(X_1024,X_1027);                          |
|     X_1030 :=
algebra.kunion(X_1029,X_1027);                               |
|     X_1031:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbldp",1);   |
|     X_1033 :=
algebra.kunion(X_1030,X_1031);                               |
|     X_1034 :=
algebra.kdifference(X_1033,X_964);                           |
|     X_1036 :=
algebra.leftjoin(X_19,X_1034);                               |
|     X_1037:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbusp",0);   |
|     X_1040:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbusp",2);   |
|     X_1041 :=
algebra.kdifference(X_1037,X_1040);                          |
|     X_1042 :=
algebra.kunion(X_1041,X_1040);                               |
|     X_1043:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fbusp",1);   |
|     X_1044 :=
algebra.kunion(X_1042,X_1043);                               |
|     X_1045 :=
algebra.kdifference(X_1044,X_964);                           |
|     X_1046 :=
algebra.leftjoin(X_19,X_1045);                               |
|     X_1047:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fconp",0);   |
|     X_1050:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fconp",2);   |
|     X_1052 :=
algebra.kdifference(X_1047,X_1050);                          |
|     X_1053 :=
algebra.kunion(X_1052,X_1050);                               |
|     X_1054:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fconp",1);   |
|     X_1056 :=
algebra.kunion(X_1053,X_1054);                               |
|     X_1057:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1059 :=
bat.reverse(X_1057);                                         |
|     X_1060 :=
algebra.kdifference(X_1056,X_1059);                          |
|     X_1061 :=
algebra.leftjoin(X_19,X_1060);                               |
|     X_1062:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","felep",0);   |
|     X_1065:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","felep",2);   |
|     X_1066 :=
algebra.kdifference(X_1062,X_1065);                          |
|     X_1067 :=
algebra.kunion(X_1066,X_1065);                               |
|     X_1068:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","felep",1);   |
|     X_1069 :=
algebra.kunion(X_1067,X_1068);                               |
|     X_1070 :=
algebra.kdifference(X_1069,X_1059);                          |
|     X_1071 :=
algebra.leftjoin(X_19,X_1070);                               |
|     X_1072:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ffsp",0);    |
|     X_1075:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ffsp",2);    |
|     X_1077 :=
algebra.kdifference(X_1072,X_1075);                          |
|     X_1078 :=
algebra.kunion(X_1077,X_1075);                               |
|     X_1079:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ffsp",1);    |
|     X_1082 :=
algebra.kunion(X_1078,X_1079);                               |
|     X_1083 :=
algebra.kdifference(X_1082,X_1059);                          |
|     X_1084 :=
algebra.leftjoin(X_19,X_1083);                               |
|     X_1085:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ffulp",0);   |
|     X_1088:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ffulp",2);   |
|     X_1089 :=
algebra.kdifference(X_1085,X_1088);                          |
|     X_1090 :=
algebra.kunion(X_1089,X_1088);                               |
|     X_1091:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ffulp",1);   |
|     X_1092 :=
algebra.kunion(X_1090,X_1091);                               |
|     X_1093 :=
algebra.kdifference(X_1092,X_1059);                          |
|     X_1094 :=
algebra.leftjoin(X_19,X_1093);                               |
|     X_1095:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fgasp",0);   |
|     X_1098:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fgasp",2);   |
|     X_1101 :=
algebra.kdifference(X_1095,X_1098);                          |
|     X_1102 :=
algebra.kunion(X_1101,X_1098);                               |
|     X_1103:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fgasp",1);   |
|     X_1105 :=
algebra.kunion(X_1102,X_1103);                               |
|     X_1106 :=
algebra.kdifference(X_1105,X_1059);                          |
|     X_1107 :=
algebra.leftjoin(X_19,X_1106);                               |
|     X_1108:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fhflp",0);   |
|     X_1111:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fhflp",2);   |
|     X_1112 :=
algebra.kdifference(X_1108,X_1111);                          |
|     X_1113 :=
algebra.kunion(X_1112,X_1111);                               |
|     X_1114:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fhflp",1);   |
|     X_1115 :=
algebra.kunion(X_1113,X_1114);                               |
|     X_1116 :=
algebra.kdifference(X_1115,X_1059);                          |
|     X_1117 :=
algebra.leftjoin(X_19,X_1116);                               |
|     X_1119:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","finsp",0);   |
|     X_1122:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","finsp",2);   |
|     X_1124 :=
algebra.kdifference(X_1119,X_1122);                          |
|     X_1125 :=
algebra.kunion(X_1124,X_1122);                               |
|     X_1126:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","finsp",1);   |
|     X_1128 :=
algebra.kunion(X_1125,X_1126);                               |
|     X_1129 :=
algebra.kdifference(X_1128,X_1059);                          |
|     X_1130 :=
algebra.leftjoin(X_19,X_1129);                               |
|     X_1131:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fkitp",0);   |
|     X_1134:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fkitp",2);   |
|     X_1135 :=
algebra.kdifference(X_1131,X_1134);                          |
|     X_1136 :=
algebra.kunion(X_1135,X_1134);                               |
|     X_1137:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fkitp",1);   |
|     X_1138 :=
algebra.kunion(X_1136,X_1137);                               |
|     X_1139 :=
algebra.kdifference(X_1138,X_1059);                          |
|     X_1141 :=
algebra.leftjoin(X_19,X_1139);                               |
|     X_1142:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmhp",0);    |
|     X_1145:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmhp",2);    |
|     X_1147 :=
algebra.kdifference(X_1142,X_1145);                          |
|     X_1148 :=
algebra.kunion(X_1147,X_1145);                               |
|     X_1149:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmhp",1);    |
|     X_1151 :=
algebra.kunion(X_1148,X_1149);                               |
|     X_1152:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1153 :=
bat.reverse(X_1152);                                         |
|     X_1154 :=
algebra.kdifference(X_1151,X_1153);                          |
|     X_1155 :=
algebra.leftjoin(X_19,X_1154);                               |
|     X_1156:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgip",0);  |
|     X_1159:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgip",2);  |
|     X_1160 :=
algebra.kdifference(X_1156,X_1159);                          |
|     X_1161 :=
algebra.kunion(X_1160,X_1159);                               |
|     X_1162:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgip",1);  |
|     X_1164 :=
algebra.kunion(X_1161,X_1162);                               |
|     X_1165 :=
algebra.kdifference(X_1164,X_1153);                          |
|     X_1166 :=
algebra.leftjoin(X_19,X_1165);                               |
|     X_1167:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgp",0);   |
|     X_1170:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgp",2);   |
|     X_1172 :=
algebra.kdifference(X_1167,X_1170);                          |
|     X_1173 :=
algebra.kunion(X_1172,X_1170);                               |
|     X_1174:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgp",1);   |
|     X_1176 :=
algebra.kunion(X_1173,X_1174);                               |
|     X_1177 :=
algebra.kdifference(X_1176,X_1153);                          |
|     X_1178 :=
algebra.leftjoin(X_19,X_1177);                               |
|     X_1179:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgtp",0);  |
|     X_1183:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgtp",2);  |
|     X_1184 :=
algebra.kdifference(X_1179,X_1183);                          |
|     X_1185 :=
algebra.kunion(X_1184,X_1183);                               |
|     X_1186:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgtp",1);  |
|     X_1187 :=
algebra.kunion(X_1185,X_1186);                               |
|     X_1188 :=
algebra.kdifference(X_1187,X_1153);                          |
|     X_1189 :=
algebra.leftjoin(X_19,X_1188);                               |
|     X_1190:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgxp",0);  |
|     X_1193:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgxp",2);  |
|     X_1195 :=
algebra.kdifference(X_1190,X_1193);                          |
|     X_1196 :=
algebra.kunion(X_1195,X_1193);                               |
|     X_1197:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmrgxp",1);  |
|     X_1199 :=
algebra.kunion(X_1196,X_1197);                               |
|     X_1200 :=
algebra.kdifference(X_1199,X_1153);                          |
|     X_1202 :=
algebra.leftjoin(X_19,X_1200);                               |
|     X_1203:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmvp",0);    |
|     X_1206:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmvp",2);    |
|     X_1207 :=
algebra.kdifference(X_1203,X_1206);                          |
|     X_1208 :=
algebra.kunion(X_1207,X_1206);                               |
|     X_1209:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fmvp",1);    |
|     X_1210 :=
algebra.kunion(X_1208,X_1209);                               |
|     X_1211 :=
algebra.kdifference(X_1210,X_1153);                          |
|     X_1212 :=
algebra.leftjoin(X_19,X_1211);                               |
|     X_1213:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fplmp",0);   |
|     X_1216:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fplmp",2);   |
|     X_1218 :=
algebra.kdifference(X_1213,X_1216);                          |
|     X_1219 :=
algebra.kunion(X_1218,X_1216);                               |
|     X_1220:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fplmp",1);   |
|     X_1222 :=
algebra.kunion(X_1219,X_1220);                               |
|     X_1224 :=
algebra.kdifference(X_1222,X_1153);                          |
|     X_1225 :=
algebra.leftjoin(X_19,X_1224);                               |
|     X_1226:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frefrp",0);  |
|     X_1229:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frefrp",2);  |
|     X_1230 :=
algebra.kdifference(X_1226,X_1229);                          |
|     X_1231 :=
algebra.kunion(X_1230,X_1229);                               |
|     X_1232:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frefrp",1);  |
|     X_1233 :=
algebra.kunion(X_1231,X_1232);                               |
|     X_1234 :=
algebra.kdifference(X_1233,X_1153);                          |
|     X_1235 :=
algebra.leftjoin(X_19,X_1234);                               |
|     X_1236:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frmsp",0);   |
|     X_1239:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frmsp",2);   |
|     X_1241 :=
algebra.kdifference(X_1236,X_1239);                          |
|     X_1242 :=
algebra.kunion(X_1241,X_1239);                               |
|     X_1243:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frmsp",1);   |
|     X_1246 :=
algebra.kunion(X_1242,X_1243);                               |
|     X_1247:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1248 :=
bat.reverse(X_1247);                                         |
|     X_1249 :=
algebra.kdifference(X_1246,X_1248);                          |
|     X_1250 :=
algebra.leftjoin(X_19,X_1249);                               |
|     X_1251:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frntmp",0);  |
|     X_1254:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frntmp",2);  |
|     X_1255 :=
algebra.kdifference(X_1251,X_1254);                          |
|     X_1256 :=
algebra.kunion(X_1255,X_1254);                               |
|     X_1257:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frntmp",1);  |
|     X_1258 :=
algebra.kunion(X_1256,X_1257);                               |
|     X_1259 :=
algebra.kdifference(X_1258,X_1248);                          |
|     X_1260 :=
algebra.leftjoin(X_19,X_1259);                               |
|     X_1261:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frntp",0);   |
|     X_1264:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frntp",2);   |
|     X_1267 :=
algebra.kdifference(X_1261,X_1264);                          |
|     X_1268 :=
algebra.kunion(X_1267,X_1264);                               |
|     X_1269:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frntp",1);   |
|     X_1271 :=
algebra.kunion(X_1268,X_1269);                               |
|     X_1272 :=
algebra.kdifference(X_1271,X_1248);                          |
|     X_1273 :=
algebra.leftjoin(X_19,X_1272);                               |
|     X_1274:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frwatp",0);  |
|     X_1277:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frwatp",2);  |
|     X_1278 :=
algebra.kdifference(X_1274,X_1277);                          |
|     X_1279 :=
algebra.kunion(X_1278,X_1277);                               |
|     X_1280:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","frwatp",1);  |
|     X_1281 :=
algebra.kunion(X_1279,X_1280);                               |
|     X_1282 :=
algebra.kdifference(X_1281,X_1248);                          |
|     X_1283 :=
algebra.leftjoin(X_19,X_1282);                               |
|     X_1285:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsinkp",0);  |
|     X_1288:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsinkp",2);  |
|     X_1290 :=
algebra.kdifference(X_1285,X_1288);                          |
|     X_1291 :=
algebra.kunion(X_1290,X_1288);                               |
|     X_1292:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsinkp",1);  |
|     X_1294 :=
algebra.kunion(X_1291,X_1292);                               |
|     X_1295 :=
algebra.kdifference(X_1294,X_1248);                          |
|     X_1296 :=
algebra.leftjoin(X_19,X_1295);                               |
|     X_1297:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmp",0);    |
|     X_1300:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmp",2);    |
|     X_1301 :=
algebra.kdifference(X_1297,X_1300);                          |
|     X_1302 :=
algebra.kunion(X_1301,X_1300);                               |
|     X_1303:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmp",1);    |
|     X_1304 :=
algebra.kunion(X_1302,X_1303);                               |
|     X_1305 :=
algebra.kdifference(X_1304,X_1248);                          |
|     X_1307 :=
algebra.leftjoin(X_19,X_1305);                               |
|     X_1308:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmxhp",0);  |
|     X_1311:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmxhp",2);  |
|     X_1313 :=
algebra.kdifference(X_1308,X_1311);                          |
|     X_1314 :=
algebra.kunion(X_1313,X_1311);                               |
|     X_1315:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmxhp",1);  |
|     X_1317 :=
algebra.kunion(X_1314,X_1315);                               |
|     X_1318 :=
algebra.kdifference(X_1317,X_1248);                          |
|     X_1319 :=
algebra.leftjoin(X_19,X_1318);                               |
|     X_1320:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmxsp",0);  |
|     X_1323:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmxsp",2);  |
|     X_1324 :=
algebra.kdifference(X_1320,X_1323);                          |
|     X_1325 :=
algebra.kunion(X_1324,X_1323);                               |
|     X_1326:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fsmxsp",1);  |
|     X_1328 :=
algebra.kunion(X_1325,X_1326);                               |
|     X_1329 :=
algebra.kdifference(X_1328,X_1248);                          |
|     X_1330 :=
algebra.leftjoin(X_19,X_1329);                               |
|     X_1331:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fstovp",0);  |
|     X_1334:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fstovp",2);  |
|     X_1336 :=
algebra.kdifference(X_1331,X_1334);                          |
|     X_1337 :=
algebra.kunion(X_1336,X_1334);                               |
|     X_1338:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fstovp",1);  |
|     X_1340 :=
algebra.kunion(X_1337,X_1338);                               |
|     X_1341:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1342 :=
bat.reverse(X_1341);                                         |
|     X_1343 :=
algebra.kdifference(X_1340,X_1342);                          |
|     X_1344 :=
algebra.leftjoin(X_19,X_1343);                               |
|     X_1345:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftaxp",0);   |
|     X_1349:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftaxp",2);   |
|     X_1350 :=
algebra.kdifference(X_1345,X_1349);                          |
|     X_1351 :=
algebra.kunion(X_1350,X_1349);                               |
|     X_1352:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftaxp",1);   |
|     X_1353 :=
algebra.kunion(X_1351,X_1352);                               |
|     X_1354 :=
algebra.kdifference(X_1353,X_1342);                          |
|     X_1355 :=
algebra.leftjoin(X_19,X_1354);                               |
|     X_1356:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftelp",0);   |
|     X_1359:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftelp",2);   |
|     X_1361 :=
algebra.kdifference(X_1356,X_1359);                          |
|     X_1362 :=
algebra.kunion(X_1361,X_1359);                               |
|     X_1363:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftelp",1);   |
|     X_1365 :=
algebra.kunion(X_1362,X_1363);                               |
|     X_1366 :=
algebra.kdifference(X_1365,X_1342);                          |
|     X_1368 :=
algebra.leftjoin(X_19,X_1366);                               |
|     X_1369:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftenp",0);   |
|     X_1372:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftenp",2);   |
|     X_1373 :=
algebra.kdifference(X_1369,X_1372);                          |
|     X_1374 :=
algebra.kunion(X_1373,X_1372);                               |
|     X_1375:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftenp",1);   |
|     X_1376 :=
algebra.kunion(X_1374,X_1375);                               |
|     X_1377 :=
algebra.kdifference(X_1376,X_1342);                          |
|     X_1378 :=
algebra.leftjoin(X_19,X_1377);                               |
|     X_1379:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftoilp",0);  |
|     X_1382:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftoilp",2);  |
|     X_1384 :=
algebra.kdifference(X_1379,X_1382);                          |
|     X_1385 :=
algebra.kunion(X_1384,X_1382);                               |
|     X_1386:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","ftoilp",1);  |
|     X_1388 :=
algebra.kunion(X_1385,X_1386);                               |
|     X_1390 :=
algebra.kdifference(X_1388,X_1342);                          |
|     X_1391 :=
algebra.leftjoin(X_19,X_1390);                               |
|     X_1392:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvacsp",0);  |
|     X_1395:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvacsp",2);  |
|     X_1396 :=
algebra.kdifference(X_1392,X_1395);                          |
|     X_1397 :=
algebra.kunion(X_1396,X_1395);                               |
|     X_1398:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvacsp",1);  |
|     X_1399 :=
algebra.kunion(X_1397,X_1398);                               |
|     X_1400 :=
algebra.kdifference(X_1399,X_1342);                          |
|     X_1401 :=
algebra.leftjoin(X_19,X_1400);                               |
|     X_1402:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvalp",0);   |
|     X_1405:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvalp",2);   |
|     X_1407 :=
algebra.kdifference(X_1402,X_1405);                          |
|     X_1408 :=
algebra.kunion(X_1407,X_1405);                               |
|     X_1409:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvalp",1);   |
|     X_1412 :=
algebra.kunion(X_1408,X_1409);                               |
|     X_1413 :=
algebra.kdifference(X_1412,X_1342);                          |
|     X_1414 :=
algebra.leftjoin(X_19,X_1413);                               |
|     X_1415:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvehp",0);   |
|     X_1418:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvehp",2);   |
|     X_1419 :=
algebra.kdifference(X_1415,X_1418);                          |
|     X_1420 :=
algebra.kunion(X_1419,X_1418);                               |
|     X_1421:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fvehp",1);   |
|     X_1422 :=
algebra.kunion(X_1420,X_1421);                               |
|     X_1423 :=
algebra.kdifference(X_1422,X_1342);                          |
|     X_1424 :=
algebra.leftjoin(X_19,X_1423);                               |
|     X_1425:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fwatp",0);   |
|     X_1428:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fwatp",2);   |
|     X_1431 :=
algebra.kdifference(X_1425,X_1428);                          |
|     X_1432 :=
algebra.kunion(X_1431,X_1428);                               |
|     X_1433:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fwatp",1);   |
|     X_1435 :=
algebra.kunion(X_1432,X_1433);                               |
|     X_1436:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1437 :=
bat.reverse(X_1436);                                         |
|     X_1438 :=
algebra.kdifference(X_1435,X_1437);                          |
|     X_1439 :=
algebra.leftjoin(X_19,X_1438);                               |
|     X_1440:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fyblp",0);   |
|     X_1443:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fyblp",2);   |
|     X_1444 :=
algebra.kdifference(X_1440,X_1443);                          |
|     X_1445 :=
algebra.kunion(X_1444,X_1443);                               |
|     X_1446:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","fyblp",1);   |
|     X_1447 :=
algebra.kunion(X_1445,X_1446);                               |
|     X_1448 :=
algebra.kdifference(X_1447,X_1437);                          |
|     X_1449 :=
algebra.leftjoin(X_19,X_1448);                               |
|     X_1451:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp1",0);   |
|     X_1454:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp1",2);   |
|     X_1456 :=
algebra.kdifference(X_1451,X_1454);                          |
|     X_1457 :=
algebra.kunion(X_1456,X_1454);                               |
|     X_1458:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp1",1);   |
|     X_1460 :=
algebra.kunion(X_1457,X_1458);                               |
|     X_1461 :=
algebra.kdifference(X_1460,X_1437);                          |
|     X_1462 :=
algebra.leftjoin(X_19,X_1461);                               |
|     X_1463:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp2",0);   |
|     X_1466:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp2",2);   |
|     X_1467 :=
algebra.kdifference(X_1463,X_1466);                          |
|     X_1468 :=
algebra.kunion(X_1467,X_1466);                               |
|     X_1469:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp2",1);   |
|     X_1470 :=
algebra.kunion(X_1468,X_1469);                               |
|     X_1471 :=
algebra.kdifference(X_1470,X_1437);                          |
|     X_1473 :=
algebra.leftjoin(X_19,X_1471);                               |
|     X_1474:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp3",0);   |
|     X_1477:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp3",2);   |
|     X_1479 :=
algebra.kdifference(X_1474,X_1477);                          |
|     X_1480 :=
algebra.kunion(X_1479,X_1477);                               |
|     X_1481:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp3",1);   |
|     X_1483 :=
algebra.kunion(X_1480,X_1481);                               |
|     X_1484 :=
algebra.kdifference(X_1483,X_1437);                          |
|     X_1485 :=
algebra.leftjoin(X_19,X_1484);                               |
|     X_1486:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp4",0);   |
|     X_1489:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp4",2);   |
|     X_1490 :=
algebra.kdifference(X_1486,X_1489);                          |
|     X_1491 :=
algebra.kunion(X_1490,X_1489);                               |
|     X_1492:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp4",1);   |
|     X_1494 :=
algebra.kunion(X_1491,X_1492);                               |
|     X_1495 :=
algebra.kdifference(X_1494,X_1437);                          |
|     X_1496 :=
algebra.leftjoin(X_19,X_1495);                               |
|     X_1497:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp5",0);   |
|     X_1500:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp5",2);   |
|     X_1502 :=
algebra.kdifference(X_1497,X_1500);                          |
|     X_1503 :=
algebra.kunion(X_1502,X_1500);                               |
|     X_1504:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp5",1);   |
|     X_1506 :=
algebra.kunion(X_1503,X_1504);                               |
|     X_1507 :=
algebra.kdifference(X_1506,X_1437);                          |
|     X_1508 :=
algebra.leftjoin(X_19,X_1507);                               |
|     X_1509:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp6",0);   |
|     X_1513:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp6",2);   |
|     X_1514 :=
algebra.kdifference(X_1509,X_1513);                          |
|     X_1515 :=
algebra.kunion(X_1514,X_1513);                               |
|     X_1516:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp6",1);   |
|     X_1517 :=
algebra.kunion(X_1515,X_1516);                               |
|     X_1518 :=
algebra.kdifference(X_1517,X_1437);                          |
|     X_1519 :=
algebra.leftjoin(X_19,X_1518);                               |
|     X_1520:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp7",0);   |
|     X_1523:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp7",2);   |
|     X_1525 :=
algebra.kdifference(X_1520,X_1523);                          |
|     X_1526 :=
algebra.kunion(X_1525,X_1523);                               |
|     X_1527:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp7",1);   |
|     X_1529 :=
algebra.kunion(X_1526,X_1527);                               |
|     X_1530:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1531 :=
bat.reverse(X_1530);                                         |
|     X_1532 :=
algebra.kdifference(X_1529,X_1531);                          |
|     X_1534 :=
algebra.leftjoin(X_19,X_1532);                               |
|     X_1535:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp8",0);   |
|     X_1538:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp8",2);   |
|     X_1539 :=
algebra.kdifference(X_1535,X_1538);                          |
|     X_1540 :=
algebra.kunion(X_1539,X_1538);                               |
|     X_1541:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp8",1);   |
|     X_1542 :=
algebra.kunion(X_1540,X_1541);                               |
|     X_1543 :=
algebra.kdifference(X_1542,X_1531);                          |
|     X_1544 :=
algebra.leftjoin(X_19,X_1543);                               |
|     X_1545:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp9",0);   |
|     X_1548:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp9",2);   |
|     X_1550 :=
algebra.kdifference(X_1545,X_1548);                          |
|     X_1551 :=
algebra.kunion(X_1550,X_1548);                               |
|     X_1552:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp9",1);   |
|     X_1554 :=
algebra.kunion(X_1551,X_1552);                               |
|     X_1556 :=
algebra.kdifference(X_1554,X_1531);                          |
|     X_1557 :=
algebra.leftjoin(X_19,X_1556);                               |
|     X_1558:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp10",0);  |
|     X_1561:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp10",2);  |
|     X_1562 :=
algebra.kdifference(X_1558,X_1561);                          |
|     X_1563 :=
algebra.kunion(X_1562,X_1561);                               |
|     X_1564:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp10",1);  |
|     X_1565 :=
algebra.kunion(X_1563,X_1564);                               |
|     X_1566 :=
algebra.kdifference(X_1565,X_1531);                          |
|     X_1567 :=
algebra.leftjoin(X_19,X_1566);                               |
|     X_1568:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp11",0);  |
|     X_1571:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp11",2);  |
|     X_1573 :=
algebra.kdifference(X_1568,X_1571);                          |
|     X_1574 :=
algebra.kunion(X_1573,X_1571);                               |
|     X_1575:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp11",1);  |
|     X_1578 :=
algebra.kunion(X_1574,X_1575);                               |
|     X_1579 :=
algebra.kdifference(X_1578,X_1531);                          |
|     X_1580 :=
algebra.leftjoin(X_19,X_1579);                               |
|     X_1581:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp12",0);  |
|     X_1584:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp12",2);  |
|     X_1585 :=
algebra.kdifference(X_1581,X_1584);                          |
|     X_1586 :=
algebra.kunion(X_1585,X_1584);                               |
|     X_1587:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp12",1);  |
|     X_1588 :=
algebra.kunion(X_1586,X_1587);                               |
|     X_1589 :=
algebra.kdifference(X_1588,X_1531);                          |
|     X_1590 :=
algebra.leftjoin(X_19,X_1589);                               |
|     X_1591:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp13",0);  |
|     X_1594:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp13",2);  |
|     X_1597 :=
algebra.kdifference(X_1591,X_1594);                          |
|     X_1598 :=
algebra.kunion(X_1597,X_1594);                               |
|     X_1599:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp13",1);  |
|     X_1601 :=
algebra.kunion(X_1598,X_1599);                               |
|     X_1602 :=
algebra.kdifference(X_1601,X_1531);                          |
|     X_1603 :=
algebra.leftjoin(X_19,X_1602);                               |
|     X_1604:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp14",0);  |
|     X_1607:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp14",2);  |
|     X_1608 :=
algebra.kdifference(X_1604,X_1607);                          |
|     X_1609 :=
algebra.kunion(X_1608,X_1607);                               |
|     X_1610:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp14",1);  |
|     X_1611 :=
algebra.kunion(X_1609,X_1610);                               |
|     X_1612 :=
algebra.kdifference(X_1611,X_1531);                          |
|     X_1613 :=
algebra.leftjoin(X_19,X_1612);                               |
|     X_1615:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp15",0);  |
|     X_1618:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp15",2);  |
|     X_1620 :=
algebra.kdifference(X_1615,X_1618);                          |
|     X_1621 :=
algebra.kunion(X_1620,X_1618);                               |
|     X_1622:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp15",1);  |
|     X_1624 :=
algebra.kunion(X_1621,X_1622);                               |
|     X_1625:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1626 :=
bat.reverse(X_1625);                                         |
|     X_1627 :=
algebra.kdifference(X_1624,X_1626);                          |
|     X_1628 :=
algebra.leftjoin(X_19,X_1627);                               |
|     X_1629:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp16",0);  |
|     X_1632:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp16",2);  |
|     X_1633 :=
algebra.kdifference(X_1629,X_1632);                          |
|     X_1634 :=
algebra.kunion(X_1633,X_1632);                               |
|     X_1635:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp16",1);  |
|     X_1636 :=
algebra.kunion(X_1634,X_1635);                               |
|     X_1637 :=
algebra.kdifference(X_1636,X_1626);                          |
|     X_1639 :=
algebra.leftjoin(X_19,X_1637);                               |
|     X_1640:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp17",0);  |
|     X_1643:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp17",2);  |
|     X_1645 :=
algebra.kdifference(X_1640,X_1643);                          |
|     X_1646 :=
algebra.kunion(X_1645,X_1643);                               |
|     X_1647:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp17",1);  |
|     X_1649 :=
algebra.kunion(X_1646,X_1647);                               |
|     X_1650 :=
algebra.kdifference(X_1649,X_1626);                          |
|     X_1651 :=
algebra.leftjoin(X_19,X_1650);                               |
|     X_1652:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp18",0);  |
|     X_1655:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp18",2);  |
|     X_1656 :=
algebra.kdifference(X_1652,X_1655);                          |
|     X_1657 :=
algebra.kunion(X_1656,X_1655);                               |
|     X_1658:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp18",1);  |
|     X_1660 :=
algebra.kunion(X_1657,X_1658);                               |
|     X_1661 :=
algebra.kdifference(X_1660,X_1626);                          |
|     X_1662 :=
algebra.leftjoin(X_19,X_1661);                               |
|     X_1663:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp19",0);  |
|     X_1666:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp19",2);  |
|     X_1668 :=
algebra.kdifference(X_1663,X_1666);                          |
|     X_1669 :=
algebra.kunion(X_1668,X_1666);                               |
|     X_1670:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp19",1);  |
|     X_1672 :=
algebra.kunion(X_1669,X_1670);                               |
|     X_1673 :=
algebra.kdifference(X_1672,X_1626);                          |
|     X_1674 :=
algebra.leftjoin(X_19,X_1673);                               |
|     X_1675:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp20",0);  |
|     X_1679:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp20",2);  |
|     X_1680 :=
algebra.kdifference(X_1675,X_1679);                          |
|     X_1681 :=
algebra.kunion(X_1680,X_1679);                               |
|     X_1682:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp20",1);  |
|     X_1683 :=
algebra.kunion(X_1681,X_1682);                               |
|     X_1684 :=
algebra.kdifference(X_1683,X_1626);                          |
|     X_1685 :=
algebra.leftjoin(X_19,X_1684);                               |
|     X_1686:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp21",0);  |
|     X_1689:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp21",2);  |
|     X_1691 :=
algebra.kdifference(X_1686,X_1689);                          |
|     X_1692 :=
algebra.kunion(X_1691,X_1689);                               |
|     X_1693:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp21",1);  |
|     X_1695 :=
algebra.kunion(X_1692,X_1693);                               |
|     X_1696 :=
algebra.kdifference(X_1695,X_1626);                          |
|     X_1698 :=
algebra.leftjoin(X_19,X_1696);                               |
|     X_1699:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp22",0);  |
|     X_1702:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp22",2);  |
|     X_1703 :=
algebra.kdifference(X_1699,X_1702);                          |
|     X_1704 :=
algebra.kunion(X_1703,X_1702);                               |
|     X_1705:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp22",1);  |
|     X_1706 :=
algebra.kunion(X_1704,X_1705);                               |
|     X_1707 :=
algebra.kdifference(X_1706,X_1626);                          |
|     X_1708 :=
algebra.leftjoin(X_19,X_1707);                               |
|     X_1709:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp23",0);  |
|     X_1712:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp23",2);  |
|     X_1714 :=
algebra.kdifference(X_1709,X_1712);                          |
|     X_1715 :=
algebra.kunion(X_1714,X_1712);                               |
|     X_1716:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp23",1);  |
|     X_1718 :=
algebra.kunion(X_1715,X_1716);                               |
|     X_1719:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1721 :=
bat.reverse(X_1719);                                         |
|     X_1722 :=
algebra.kdifference(X_1718,X_1721);                          |
|     X_1723 :=
algebra.leftjoin(X_19,X_1722);                               |
|     X_1724:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp24",0);  |
|     X_1727:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp24",2);  |
|     X_1728 :=
algebra.kdifference(X_1724,X_1727);                          |
|     X_1729 :=
algebra.kunion(X_1728,X_1727);                               |
|     X_1730:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp24",1);  |
|     X_1731 :=
algebra.kunion(X_1729,X_1730);                               |
|     X_1732 :=
algebra.kdifference(X_1731,X_1721);                          |
|     X_1733 :=
algebra.leftjoin(X_19,X_1732);                               |
|     X_1734:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp25",0);  |
|     X_1737:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp25",2);  |
|     X_1739 :=
algebra.kdifference(X_1734,X_1737);                          |
|     X_1740 :=
algebra.kunion(X_1739,X_1737);                               |
|     X_1741:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp25",1);  |
|     X_1744 :=
algebra.kunion(X_1740,X_1741);                               |
|     X_1745 :=
algebra.kdifference(X_1744,X_1721);                          |
|     X_1746 :=
algebra.leftjoin(X_19,X_1745);                               |
|     X_1747:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp26",0);  |
|     X_1750:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp26",2);  |
|     X_1751 :=
algebra.kdifference(X_1747,X_1750);                          |
|     X_1752 :=
algebra.kunion(X_1751,X_1750);                               |
|     X_1753:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp26",1);  |
|     X_1754 :=
algebra.kunion(X_1752,X_1753);                               |
|     X_1755 :=
algebra.kdifference(X_1754,X_1721);                          |
|     X_1756 :=
algebra.leftjoin(X_19,X_1755);                               |
|     X_1757:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp27",0);  |
|     X_1760:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp27",2);  |
|     X_1763 :=
algebra.kdifference(X_1757,X_1760);                          |
|     X_1764 :=
algebra.kunion(X_1763,X_1760);                               |
|     X_1765:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp27",1);  |
|     X_1767 :=
algebra.kunion(X_1764,X_1765);                               |
|     X_1768 :=
algebra.kdifference(X_1767,X_1721);                          |
|     X_1769 :=
algebra.leftjoin(X_19,X_1768);                               |
|     X_1770:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp28",0);  |
|     X_1773:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp28",2);  |
|     X_1774 :=
algebra.kdifference(X_1770,X_1773);                          |
|     X_1775 :=
algebra.kunion(X_1774,X_1773);                               |
|     X_1776:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp28",1);  |
|     X_1777 :=
algebra.kunion(X_1775,X_1776);                               |
|     X_1778 :=
algebra.kdifference(X_1777,X_1721);                          |
|     X_1779 :=
algebra.leftjoin(X_19,X_1778);                               |
|     X_1781:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp29",0);  |
|     X_1784:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp29",2);  |
|     X_1786 :=
algebra.kdifference(X_1781,X_1784);                          |
|     X_1787 :=
algebra.kunion(X_1786,X_1784);                               |
|     X_1788:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp29",1);  |
|     X_1790 :=
algebra.kunion(X_1787,X_1788);                               |
|     X_1791 :=
algebra.kdifference(X_1790,X_1721);                          |
|     X_1792 :=
algebra.leftjoin(X_19,X_1791);                               |
|     X_1793:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp30",0);  |
|     X_1796:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp30",2);  |
|     X_1797 :=
algebra.kdifference(X_1793,X_1796);                          |
|     X_1798 :=
algebra.kunion(X_1797,X_1796);                               |
|     X_1799:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp30",1);  |
|     X_1800 :=
algebra.kunion(X_1798,X_1799);                               |
|     X_1801 :=
algebra.kdifference(X_1800,X_1721);                          |
|     X_1803 :=
algebra.leftjoin(X_19,X_1801);                               |
|     X_1804:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp31",0);  |
|     X_1807:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp31",2);  |
|     X_1809 :=
algebra.kdifference(X_1804,X_1807);                          |
|     X_1810 :=
algebra.kunion(X_1809,X_1807);                               |
|     X_1811:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp31",1);  |
|     X_1813 :=
algebra.kunion(X_1810,X_1811);                               |
|     X_1814:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1815 :=
bat.reverse(X_1814);                                         |
|     X_1816 :=
algebra.kdifference(X_1813,X_1815);                          |
|     X_1817 :=
algebra.leftjoin(X_19,X_1816);                               |
|     X_1818:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp32",0);  |
|     X_1821:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp32",2);  |
|     X_1822 :=
algebra.kdifference(X_1818,X_1821);                          |
|     X_1823 :=
algebra.kunion(X_1822,X_1821);                               |
|     X_1824:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp32",1);  |
|     X_1826 :=
algebra.kunion(X_1823,X_1824);                               |
|     X_1827 :=
algebra.kdifference(X_1826,X_1815);                          |
|     X_1828 :=
algebra.leftjoin(X_19,X_1827);                               |
|     X_1829:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp33",0);  |
|     X_1832:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp33",2);  |
|     X_1834 :=
algebra.kdifference(X_1829,X_1832);                          |
|     X_1835 :=
algebra.kunion(X_1834,X_1832);                               |
|     X_1836:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp33",1);  |
|     X_1838 :=
algebra.kunion(X_1835,X_1836);                               |
|     X_1839 :=
algebra.kdifference(X_1838,X_1815);                          |
|     X_1840 :=
algebra.leftjoin(X_19,X_1839);                               |
|     X_1841:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp34",0);  |
|     X_1845:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp34",2);  |
|     X_1846 :=
algebra.kdifference(X_1841,X_1845);                          |
|     X_1847 :=
algebra.kunion(X_1846,X_1845);                               |
|     X_1848:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp34",1);  |
|     X_1849 :=
algebra.kunion(X_1847,X_1848);                               |
|     X_1850 :=
algebra.kdifference(X_1849,X_1815);                          |
|     X_1851 :=
algebra.leftjoin(X_19,X_1850);                               |
|     X_1852:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp35",0);  |
|     X_1855:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp35",2);  |
|     X_1857 :=
algebra.kdifference(X_1852,X_1855);                          |
|     X_1858 :=
algebra.kunion(X_1857,X_1855);                               |
|     X_1859:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp35",1);  |
|     X_1861 :=
algebra.kunion(X_1858,X_1859);                               |
|     X_1862 :=
algebra.kdifference(X_1861,X_1815);                          |
|     X_1864 :=
algebra.leftjoin(X_19,X_1862);                               |
|     X_1865:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp36",0);  |
|     X_1868:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp36",2);  |
|     X_1869 :=
algebra.kdifference(X_1865,X_1868);                          |
|     X_1870 :=
algebra.kunion(X_1869,X_1868);                               |
|     X_1871:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp36",1);  |
|     X_1872 :=
algebra.kunion(X_1870,X_1871);                               |
|     X_1873 :=
algebra.kdifference(X_1872,X_1815);                          |
|     X_1874 :=
algebra.leftjoin(X_19,X_1873);                               |
|     X_1875:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp37",0);  |
|     X_1878:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp37",2);  |
|     X_1880 :=
algebra.kdifference(X_1875,X_1878);                          |
|     X_1881 :=
algebra.kunion(X_1880,X_1878);                               |
|     X_1882:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp37",1);  |
|     X_1884 :=
algebra.kunion(X_1881,X_1882);                               |
|     X_1886 :=
algebra.kdifference(X_1884,X_1815);                          |
|     X_1887 :=
algebra.leftjoin(X_19,X_1886);                               |
|     X_1888:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp38",0);  |
|     X_1891:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp38",2);  |
|     X_1892 :=
algebra.kdifference(X_1888,X_1891);                          |
|     X_1893 :=
algebra.kunion(X_1892,X_1891);                               |
|     X_1894:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp38",1);  |
|     X_1895 :=
algebra.kunion(X_1893,X_1894);                               |
|     X_1896 :=
algebra.kdifference(X_1895,X_1815);                          |
|     X_1897 :=
algebra.leftjoin(X_19,X_1896);                               |
|     X_1898:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp39",0);  |
|     X_1901:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp39",2);  |
|     X_1903 :=
algebra.kdifference(X_1898,X_1901);                          |
|     X_1904 :=
algebra.kunion(X_1903,X_1901);                               |
|     X_1905:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp39",1);  |
|     X_1908 :=
algebra.kunion(X_1904,X_1905);                               |
|     X_1909:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_1910 :=
bat.reverse(X_1909);                                         |
|     X_1911 :=
algebra.kdifference(X_1908,X_1910);                          |
|     X_1912 :=
algebra.leftjoin(X_19,X_1911);                               |
|     X_1913:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp40",0);  |
|     X_1916:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp40",2);  |
|     X_1917 :=
algebra.kdifference(X_1913,X_1916);                          |
|     X_1918 :=
algebra.kunion(X_1917,X_1916);                               |
|     X_1919:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp40",1);  |
|     X_1920 :=
algebra.kunion(X_1918,X_1919);                               |
|     X_1921 :=
algebra.kdifference(X_1920,X_1910);                          |
|     X_1922 :=
algebra.leftjoin(X_19,X_1921);                               |
|     X_1923:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp41",0);  |
|     X_1926:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp41",2);  |
|     X_1929 :=
algebra.kdifference(X_1923,X_1926);                          |
|     X_1930 :=
algebra.kunion(X_1929,X_1926);                               |
|     X_1931:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp41",1);  |
|     X_1933 :=
algebra.kunion(X_1930,X_1931);                               |
|     X_1934 :=
algebra.kdifference(X_1933,X_1910);                          |
|     X_1935 :=
algebra.leftjoin(X_19,X_1934);                               |
|     X_1936:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp42",0);  |
|     X_1939:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp42",2);  |
|     X_1940 :=
algebra.kdifference(X_1936,X_1939);                          |
|     X_1941 :=
algebra.kunion(X_1940,X_1939);                               |
|     X_1942:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp42",1);  |
|     X_1943 :=
algebra.kunion(X_1941,X_1942);                               |
|     X_1944 :=
algebra.kdifference(X_1943,X_1910);                          |
|     X_1945 :=
algebra.leftjoin(X_19,X_1944);                               |
|     X_1947:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp43",0);  |
|     X_1950:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp43",2);  |
|     X_1952 :=
algebra.kdifference(X_1947,X_1950);                          |
|     X_1953 :=
algebra.kunion(X_1952,X_1950);                               |
|     X_1954:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp43",1);  |
|     X_1956 :=
algebra.kunion(X_1953,X_1954);                               |
|     X_1957 :=
algebra.kdifference(X_1956,X_1910);                          |
|     X_1958 :=
algebra.leftjoin(X_19,X_1957);                               |
|     X_1959:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp44",0);  |
|     X_1962:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp44",2);  |
|     X_1963 :=
algebra.kdifference(X_1959,X_1962);                          |
|     X_1964 :=
algebra.kunion(X_1963,X_1962);                               |
|     X_1965:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp44",1);  |
|     X_1966 :=
algebra.kunion(X_1964,X_1965);                               |
|     X_1967 :=
algebra.kdifference(X_1966,X_1910);                          |
|     X_1969 :=
algebra.leftjoin(X_19,X_1967);                               |
|     X_1970:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp45",0);  |
|     X_1973:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp45",2);  |
|     X_1975 :=
algebra.kdifference(X_1970,X_1973);                          |
|     X_1976 :=
algebra.kunion(X_1975,X_1973);                               |
|     X_1977:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp45",1);  |
|     X_1979 :=
algebra.kunion(X_1976,X_1977);                               |
|     X_1980 :=
algebra.kdifference(X_1979,X_1910);                          |
|     X_1981 :=
algebra.leftjoin(X_19,X_1980);                               |
|     X_1982:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp46",0);  |
|     X_1985:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp46",2);  |
|     X_1986 :=
algebra.kdifference(X_1982,X_1985);                          |
|     X_1987 :=
algebra.kunion(X_1986,X_1985);                               |
|     X_1988:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp46",1);  |
|     X_1990 :=
algebra.kunion(X_1987,X_1988);                               |
|     X_1991 :=
algebra.kdifference(X_1990,X_1910);                          |
|     X_1992 :=
algebra.leftjoin(X_19,X_1991);                               |
|     X_1993:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp47",0);  |
|     X_1996:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp47",2);  |
|     X_1998 :=
algebra.kdifference(X_1993,X_1996);                          |
|     X_1999 :=
algebra.kunion(X_1998,X_1996);                               |
|     X_2000:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp47",1);  |
|     X_2002 :=
algebra.kunion(X_1999,X_2000);                               |
|     X_2003:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_2004 :=
bat.reverse(X_2003);                                         |
|     X_2005 :=
algebra.kdifference(X_2002,X_2004);                          |
|     X_2006 :=
algebra.leftjoin(X_19,X_2005);                               |
|     X_2007:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp48",0);  |
|     X_2011:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp48",2);  |
|     X_2012 :=
algebra.kdifference(X_2007,X_2011);                          |
|     X_2013 :=
algebra.kunion(X_2012,X_2011);                               |
|     X_2014:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp48",1);  |
|     X_2015 :=
algebra.kunion(X_2013,X_2014);                               |
|     X_2016 :=
algebra.kdifference(X_2015,X_2004);                          |
|     X_2017 :=
algebra.leftjoin(X_19,X_2016);                               |
|     X_2018:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp49",0);  |
|     X_2021:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp49",2);  |
|     X_2023 :=
algebra.kdifference(X_2018,X_2021);                          |
|     X_2024 :=
algebra.kunion(X_2023,X_2021);                               |
|     X_2025:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp49",1);  |
|     X_2027 :=
algebra.kunion(X_2024,X_2025);                               |
|     X_2028 :=
algebra.kdifference(X_2027,X_2004);                          |
|     X_2030 :=
algebra.leftjoin(X_19,X_2028);                               |
|     X_2031:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp50",0);  |
|     X_2034:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp50",2);  |
|     X_2035 :=
algebra.kdifference(X_2031,X_2034);                          |
|     X_2036 :=
algebra.kunion(X_2035,X_2034);                               |
|     X_2037:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp50",1);  |
|     X_2038 :=
algebra.kunion(X_2036,X_2037);                               |
|     X_2039 :=
algebra.kdifference(X_2038,X_2004);                          |
|     X_2040 :=
algebra.leftjoin(X_19,X_2039);                               |
|     X_2041:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp51",0);  |
|     X_2044:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp51",2);  |
|     X_2046 :=
algebra.kdifference(X_2041,X_2044);                          |
|     X_2047 :=
algebra.kunion(X_2046,X_2044);                               |
|     X_2048:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp51",1);  |
|     X_2050 :=
algebra.kunion(X_2047,X_2048);                               |
|     X_2052 :=
algebra.kdifference(X_2050,X_2004);                          |
|     X_2053 :=
algebra.leftjoin(X_19,X_2052);                               |
|     X_2054:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp52",0);  |
|     X_2057:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp52",2);  |
|     X_2058 :=
algebra.kdifference(X_2054,X_2057);                          |
|     X_2059 :=
algebra.kunion(X_2058,X_2057);                               |
|     X_2060:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp52",1);  |
|     X_2061 :=
algebra.kunion(X_2059,X_2060);                               |
|     X_2062 :=
algebra.kdifference(X_2061,X_2004);                          |
|     X_2063 :=
algebra.leftjoin(X_19,X_2062);                               |
|     X_2064:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp53",0);  |
|     X_2067:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp53",2);  |
|     X_2069 :=
algebra.kdifference(X_2064,X_2067);                          |
|     X_2070 :=
algebra.kunion(X_2069,X_2067);                               |
|     X_2071:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp53",1);  |
|     X_2074 :=
algebra.kunion(X_2070,X_2071);                               |
|     X_2075 :=
algebra.kdifference(X_2074,X_2004);                          |
|     X_2076 :=
algebra.leftjoin(X_19,X_2075);                               |
|     X_2077:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp54",0);  |
|     X_2080:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp54",2);  |
|     X_2081 :=
algebra.kdifference(X_2077,X_2080);                          |
|     X_2082 :=
algebra.kunion(X_2081,X_2080);                               |
|     X_2083:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp54",1);  |
|     X_2084 :=
algebra.kunion(X_2082,X_2083);                               |
|     X_2085 :=
algebra.kdifference(X_2084,X_2004);                          |
|     X_2086 :=
algebra.leftjoin(X_19,X_2085);                               |
|     X_2087:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp55",0);  |
|     X_2090:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp55",2);  |
|     X_2093 :=
algebra.kdifference(X_2087,X_2090);                          |
|     X_2094 :=
algebra.kunion(X_2093,X_2090);                               |
|     X_2095:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp55",1);  |
|     X_2097 :=
algebra.kunion(X_2094,X_2095);                               |
|     X_2098:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_2099 :=
bat.reverse(X_2098);                                         |
|     X_2100 :=
algebra.kdifference(X_2097,X_2099);                          |
|     X_2101 :=
algebra.leftjoin(X_19,X_2100);                               |
|     X_2102:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp56",0);  |
|     X_2105:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp56",2);  |
|     X_2106 :=
algebra.kdifference(X_2102,X_2105);                          |
|     X_2107 :=
algebra.kunion(X_2106,X_2105);                               |
|     X_2108:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp56",1);  |
|     X_2109 :=
algebra.kunion(X_2107,X_2108);                               |
|     X_2110 :=
algebra.kdifference(X_2109,X_2099);                          |
|     X_2111 :=
algebra.leftjoin(X_19,X_2110);                               |
|     X_2113:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp57",0);  |
|     X_2116:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp57",2);  |
|     X_2118 :=
algebra.kdifference(X_2113,X_2116);                          |
|     X_2119 :=
algebra.kunion(X_2118,X_2116);                               |
|     X_2120:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp57",1);  |
|     X_2122 :=
algebra.kunion(X_2119,X_2120);                               |
|     X_2123 :=
algebra.kdifference(X_2122,X_2099);                          |
|     X_2124 :=
algebra.leftjoin(X_19,X_2123);                               |
|     X_2125:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp58",0);  |
|     X_2128:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp58",2);  |
|     X_2129 :=
algebra.kdifference(X_2125,X_2128);                          |
|     X_2130 :=
algebra.kunion(X_2129,X_2128);                               |
|     X_2131:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp58",1);  |
|     X_2132 :=
algebra.kunion(X_2130,X_2131);                               |
|     X_2133 :=
algebra.kdifference(X_2132,X_2099);                          |
|     X_2135 :=
algebra.leftjoin(X_19,X_2133);                               |
|     X_2136:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp59",0);  |
|     X_2139:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp59",2);  |
|     X_2141 :=
algebra.kdifference(X_2136,X_2139);                          |
|     X_2142 :=
algebra.kunion(X_2141,X_2139);                               |
|     X_2143:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp59",1);  |
|     X_2145 :=
algebra.kunion(X_2142,X_2143);                               |
|     X_2146 :=
algebra.kdifference(X_2145,X_2099);                          |
|     X_2147 :=
algebra.leftjoin(X_19,X_2146);                               |
|     X_2148:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp60",0);  |
|     X_2151:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp60",2);  |
|     X_2152 :=
algebra.kdifference(X_2148,X_2151);                          |
|     X_2153 :=
algebra.kunion(X_2152,X_2151);                               |
|     X_2154:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp60",1);  |
|     X_2156 :=
algebra.kunion(X_2153,X_2154);                               |
|     X_2157 :=
algebra.kdifference(X_2156,X_2099);                          |
|     X_2158 :=
algebra.leftjoin(X_19,X_2157);                               |
|     X_2159:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp61",0);  |
|     X_2162:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp61",2);  |
|     X_2164 :=
algebra.kdifference(X_2159,X_2162);                          |
|     X_2165 :=
algebra.kunion(X_2164,X_2162);                               |
|     X_2166:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp61",1);  |
|     X_2168 :=
algebra.kunion(X_2165,X_2166);                               |
|     X_2169 :=
algebra.kdifference(X_2168,X_2099);                          |
|     X_2170 :=
algebra.leftjoin(X_19,X_2169);                               |
|     X_2171:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp62",0);  |
|     X_2175:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp62",2);  |
|     X_2176 :=
algebra.kdifference(X_2171,X_2175);                          |
|     X_2177 :=
algebra.kunion(X_2176,X_2175);                               |
|     X_2178:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp62",1);  |
|     X_2179 :=
algebra.kunion(X_2177,X_2178);                               |
|     X_2180 :=
algebra.kdifference(X_2179,X_2099);                          |
|     X_2181 :=
algebra.leftjoin(X_19,X_2180);                               |
|     X_2182:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp63",0);  |
|     X_2185:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp63",2);  |
|     X_2187 :=
algebra.kdifference(X_2182,X_2185);                          |
|     X_2188 :=
algebra.kunion(X_2187,X_2185);                               |
|     X_2189:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp63",1);  |
|     X_2191 :=
algebra.kunion(X_2188,X_2189);                               |
|     X_2192:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_2193 :=
bat.reverse(X_2192);                                         |
|     X_2194 :=
algebra.kdifference(X_2191,X_2193);                          |
|     X_2196 :=
algebra.leftjoin(X_19,X_2194);                               |
|     X_2197:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp64",0);  |
|     X_2200:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp64",2);  |
|     X_2201 :=
algebra.kdifference(X_2197,X_2200);                          |
|     X_2202 :=
algebra.kunion(X_2201,X_2200);                               |
|     X_2203:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp64",1);  |
|     X_2204 :=
algebra.kunion(X_2202,X_2203);                               |
|     X_2205 :=
algebra.kdifference(X_2204,X_2193);                          |
|     X_2206 :=
algebra.leftjoin(X_19,X_2205);                               |
|     X_2207:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp65",0);  |
|     X_2210:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp65",2);  |
|     X_2212 :=
algebra.kdifference(X_2207,X_2210);                          |
|     X_2213 :=
algebra.kunion(X_2212,X_2210);                               |
|     X_2214:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp65",1);  |
|     X_2216 :=
algebra.kunion(X_2213,X_2214);                               |
|     X_2218 :=
algebra.kdifference(X_2216,X_2193);                          |
|     X_2219 :=
algebra.leftjoin(X_19,X_2218);                               |
|     X_2220:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp66",0);  |
|     X_2223:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp66",2);  |
|     X_2224 :=
algebra.kdifference(X_2220,X_2223);                          |
|     X_2225 :=
algebra.kunion(X_2224,X_2223);                               |
|     X_2226:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp66",1);  |
|     X_2227 :=
algebra.kunion(X_2225,X_2226);                               |
|     X_2228 :=
algebra.kdifference(X_2227,X_2193);                          |
|     X_2229 :=
algebra.leftjoin(X_19,X_2228);                               |
|     X_2230:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp67",0);  |
|     X_2233:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp67",2);  |
|     X_2235 :=
algebra.kdifference(X_2230,X_2233);                          |
|     X_2236 :=
algebra.kunion(X_2235,X_2233);                               |
|     X_2237:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp67",1);  |
|     X_2240 :=
algebra.kunion(X_2236,X_2237);                               |
|     X_2241 :=
algebra.kdifference(X_2240,X_2193);                          |
|     X_2242 :=
algebra.leftjoin(X_19,X_2241);                               |
|     X_2243:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp68",0);  |
|     X_2246:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp68",2);  |
|     X_2247 :=
algebra.kdifference(X_2243,X_2246);                          |
|     X_2248 :=
algebra.kunion(X_2247,X_2246);                               |
|     X_2249:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp68",1);  |
|     X_2250 :=
algebra.kunion(X_2248,X_2249);                               |
|     X_2251 :=
algebra.kdifference(X_2250,X_2193);                          |
|     X_2252 :=
algebra.leftjoin(X_19,X_2251);                               |
|     X_2253:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp69",0);  |
|     X_2256:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp69",2);  |
|     X_2259 :=
algebra.kdifference(X_2253,X_2256);                          |
|     X_2260 :=
algebra.kunion(X_2259,X_2256);                               |
|     X_2261:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp69",1);  |
|     X_2263 :=
algebra.kunion(X_2260,X_2261);                               |
|     X_2264 :=
algebra.kdifference(X_2263,X_2193);                          |
|     X_2265 :=
algebra.leftjoin(X_19,X_2264);                               |
|     X_2266:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp70",0);  |
|     X_2269:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp70",2);  |
|     X_2270 :=
algebra.kdifference(X_2266,X_2269);                          |
|     X_2271 :=
algebra.kunion(X_2270,X_2269);                               |
|     X_2272:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp70",1);  |
|     X_2273 :=
algebra.kunion(X_2271,X_2272);                               |
|     X_2274 :=
algebra.kdifference(X_2273,X_2193);                          |
|     X_2275 :=
algebra.leftjoin(X_19,X_2274);                               |
|     X_2277:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp71",0);  |
|     X_2280:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp71",2);  |
|     X_2282 :=
algebra.kdifference(X_2277,X_2280);                          |
|     X_2283 :=
algebra.kunion(X_2282,X_2280);                               |
|     X_2284:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp71",1);  |
|     X_2286 :=
algebra.kunion(X_2283,X_2284);                               |
|     X_2287:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_2288 :=
bat.reverse(X_2287);                                         |
|     X_2289 :=
algebra.kdifference(X_2286,X_2288);                          |
|     X_2290 :=
algebra.leftjoin(X_19,X_2289);                               |
|     X_2291:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp72",0);  |
|     X_2294:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp72",2);  |
|     X_2295 :=
algebra.kdifference(X_2291,X_2294);                          |
|     X_2296 :=
algebra.kunion(X_2295,X_2294);                               |
|     X_2297:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp72",1);  |
|     X_2298 :=
algebra.kunion(X_2296,X_2297);                               |
|     X_2299 :=
algebra.kdifference(X_2298,X_2288);                          |
|     X_2301 :=
algebra.leftjoin(X_19,X_2299);                               |
|     X_2302:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp73",0);  |
|     X_2305:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp73",2);  |
|     X_2307 :=
algebra.kdifference(X_2302,X_2305);                          |
|     X_2308 :=
algebra.kunion(X_2307,X_2305);                               |
|     X_2309:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp73",1);  |
|     X_2311 :=
algebra.kunion(X_2308,X_2309);                               |
|     X_2312 :=
algebra.kdifference(X_2311,X_2288);                          |
|     X_2313 :=
algebra.leftjoin(X_19,X_2312);                               |
|     X_2314:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp74",0);  |
|     X_2317:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp74",2);  |
|     X_2318 :=
algebra.kdifference(X_2314,X_2317);                          |
|     X_2319 :=
algebra.kunion(X_2318,X_2317);                               |
|     X_2320:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp74",1);  |
|     X_2322 :=
algebra.kunion(X_2319,X_2320);                               |
|     X_2323 :=
algebra.kdifference(X_2322,X_2288);                          |
|     X_2324 :=
algebra.leftjoin(X_19,X_2323);                               |
|     X_2325:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp75",0);  |
|     X_2328:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp75",2);  |
|     X_2330 :=
algebra.kdifference(X_2325,X_2328);                          |
|     X_2331 :=
algebra.kunion(X_2330,X_2328);                               |
|     X_2332:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp75",1);  |
|     X_2334 :=
algebra.kunion(X_2331,X_2332);                               |
|     X_2335 :=
algebra.kdifference(X_2334,X_2288);                          |
|     X_2336 :=
algebra.leftjoin(X_19,X_2335);                               |
|     X_2337:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp76",0);  |
|     X_2341:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp76",2);  |
|     X_2342 :=
algebra.kdifference(X_2337,X_2341);                          |
|     X_2343 :=
algebra.kunion(X_2342,X_2341);                               |
|     X_2344:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp76",1);  |
|     X_2345 :=
algebra.kunion(X_2343,X_2344);                               |
|     X_2346 :=
algebra.kdifference(X_2345,X_2288);                          |
|     X_2347 :=
algebra.leftjoin(X_19,X_2346);                               |
|     X_2348:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp77",0);  |
|     X_2351:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp77",2);  |
|     X_2353 :=
algebra.kdifference(X_2348,X_2351);                          |
|     X_2354 :=
algebra.kunion(X_2353,X_2351);                               |
|     X_2355:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp77",1);  |
|     X_2357 :=
algebra.kunion(X_2354,X_2355);                               |
|     X_2358 :=
algebra.kdifference(X_2357,X_2288);                          |
|     X_2360 :=
algebra.leftjoin(X_19,X_2358);                               |
|     X_2361:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp78",0);  |
|     X_2364:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp78",2);  |
|     X_2365 :=
algebra.kdifference(X_2361,X_2364);                          |
|     X_2366 :=
algebra.kunion(X_2365,X_2364);                               |
|     X_2367:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp78",1);  |
|     X_2368 :=
algebra.kunion(X_2366,X_2367);                               |
|     X_2369 :=
algebra.kdifference(X_2368,X_2288);                          |
|     X_2370 :=
algebra.leftjoin(X_19,X_2369);                               |
|     X_2371:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp79",0);  |
|     X_2374:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp79",2);  |
|     X_2376 :=
algebra.kdifference(X_2371,X_2374);                          |
|     X_2377 :=
algebra.kunion(X_2376,X_2374);                               |
|     X_2378:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp79",1);  |
|     X_2380 :=
algebra.kunion(X_2377,X_2378);                               |
|     X_2381:bat[:oid,:oid]  :=
sql.bind_dbat(X_2,"sys","household",1);      |
|     X_2383 :=
bat.reverse(X_2381);                                         |
|     X_2384 :=
algebra.kdifference(X_2380,X_2383);                          |
|     X_2385 :=
algebra.leftjoin(X_19,X_2384);                               |
|     X_2386:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp80",0);  |
|     X_2389:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp80",2);  |
|     X_2390 :=
algebra.kdifference(X_2386,X_2389);                          |
|     X_2391 :=
algebra.kunion(X_2390,X_2389);                               |
|     X_2392:bat[:oid,:int]  :=
sql.bind(X_2,"sys","household","wgtp80",1);  |
|     X_2393 :=
algebra.kunion(X_2391,X_2392);                               |
|     X_2394 :=
algebra.kdifference(X_2393,X_2383);                          |
|     X_2395 :=
algebra.leftjoin(X_19,X_2394);                               |
| exit
X_3114;                                                               |
|
sql.rsColumn(X_2396,"sys.household","rt","varchar",255,0,X_20);        |
|
sql.rsColumn(X_2396,"sys.household","serialno","int",32,0,X_31);       |
|
sql.rsColumn(X_2396,"sys.household","division","int",32,0,X_43);       |
|
sql.rsColumn(X_2396,"sys.household","puma","int",32,0,X_54);           |
|
sql.rsColumn(X_2396,"sys.household","region","int",32,0,X_67);         |
|
sql.rsColumn(X_2396,"sys.household","st","int",32,0,X_77);             |
|
sql.rsColumn(X_2396,"sys.household","adjhsg","int",32,0,X_90);         |
|
sql.rsColumn(X_2396,"sys.household","adjinc","int",32,0,X_100);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp","int",32,0,X_115);          |
|
sql.rsColumn(X_2396,"sys.household","np","int",32,0,X_125);            |
|
sql.rsColumn(X_2396,"sys.household","zzzz","int",32,0,X_138);          |
|
sql.rsColumn(X_2396,"sys.household","acr","int",32,0,X_149);           |
|
sql.rsColumn(X_2396,"sys.household","ags","int",32,0,X_161);           |
|
sql.rsColumn(X_2396,"sys.household","bath","int",32,0,X_172);          |
|
sql.rsColumn(X_2396,"sys.household","bdsp","int",32,0,X_184);          |
|
sql.rsColumn(X_2396,"sys.household","bld","int",32,0,X_195);           |
|
sql.rsColumn(X_2396,"sys.household","bus","int",32,0,X_210);           |
|
sql.rsColumn(X_2396,"sys.household","conp","int",32,0,X_220);          |
|
sql.rsColumn(X_2396,"sys.household","elep","int",32,0,X_233);          |
|
sql.rsColumn(X_2396,"sys.household","fs","int",32,0,X_243);            |
|
sql.rsColumn(X_2396,"sys.household","fulp","int",32,0,X_256);          |
|
sql.rsColumn(X_2396,"sys.household","gasp","int",32,0,X_266);          |
|
sql.rsColumn(X_2396,"sys.household","hfl","int",32,0,X_279);           |
|
sql.rsColumn(X_2396,"sys.household","insp","int",32,0,X_289);          |
|
sql.rsColumn(X_2396,"sys.household","mhp","int",32,0,X_304);           |
|
sql.rsColumn(X_2396,"sys.household","mrgi","int",32,0,X_315);          |
|
sql.rsColumn(X_2396,"sys.household","mrgp","int",32,0,X_327);          |
|
sql.rsColumn(X_2396,"sys.household","mrgt","int",32,0,X_338);          |
|
sql.rsColumn(X_2396,"sys.household","mrgx","int",32,0,X_350);          |
|
sql.rsColumn(X_2396,"sys.household","refr","int",32,0,X_361);          |
|
sql.rsColumn(X_2396,"sys.household","rmsp","int",32,0,X_374);          |
|
sql.rsColumn(X_2396,"sys.household","rntm","int",32,0,X_384);          |
|
sql.rsColumn(X_2396,"sys.household","rntp","int",32,0,X_399);          |
|
sql.rsColumn(X_2396,"sys.household","rwat","int",32,0,X_409);          |
|
sql.rsColumn(X_2396,"sys.household","sink","int",32,0,X_422);          |
|
sql.rsColumn(X_2396,"sys.household","smp","int",32,0,X_432);           |
|
sql.rsColumn(X_2396,"sys.household","stov","int",32,0,X_445);          |
|
sql.rsColumn(X_2396,"sys.household","tel","int",32,0,X_455);           |
|
sql.rsColumn(X_2396,"sys.household","ten","int",32,0,X_468);           |
|
sql.rsColumn(X_2396,"sys.household","toil","int",32,0,X_479);          |
|
sql.rsColumn(X_2396,"sys.household","vacs","int",32,0,X_493);          |
|
sql.rsColumn(X_2396,"sys.household","valp","int",32,0,X_504);          |
|
sql.rsColumn(X_2396,"sys.household","veh","int",32,0,X_516);           |
|
sql.rsColumn(X_2396,"sys.household","watp","int",32,0,X_527);          |
|
sql.rsColumn(X_2396,"sys.household","ybl","int",32,0,X_540);           |
|
sql.rsColumn(X_2396,"sys.household","fes","int",32,0,X_550);           |
|
sql.rsColumn(X_2396,"sys.household","fincp","int",32,0,X_563);         |
|
sql.rsColumn(X_2396,"sys.household","fparc","int",32,0,X_573);         |
|
sql.rsColumn(X_2396,"sys.household","grntp","int",32,0,X_588);         |
|
sql.rsColumn(X_2396,"sys.household","grpip","int",32,0,X_598);         |
|
sql.rsColumn(X_2396,"sys.household","hhl","int",32,0,X_611);           |
|
sql.rsColumn(X_2396,"sys.household","hht","int",32,0,X_621);           |
|
sql.rsColumn(X_2396,"sys.household","hincp","int",32,0,X_634);         |
|
sql.rsColumn(X_2396,"sys.household","hugcl","int",32,0,X_645);         |
|
sql.rsColumn(X_2396,"sys.household","hupac","int",32,0,X_657);         |
|
sql.rsColumn(X_2396,"sys.household","hupaoc","int",32,0,X_668);        |
|
sql.rsColumn(X_2396,"sys.household","huparc","int",32,0,X_682);        |
|
sql.rsColumn(X_2396,"sys.household","kit","int",32,0,X_693);           |
|
sql.rsColumn(X_2396,"sys.household","lngi","int",32,0,X_706);          |
|
sql.rsColumn(X_2396,"sys.household","multg","int",32,0,X_716);         |
|
sql.rsColumn(X_2396,"sys.household","mv","int",32,0,X_729);            |
|
sql.rsColumn(X_2396,"sys.household","noc","int",32,0,X_739);           |
|
sql.rsColumn(X_2396,"sys.household","npf","int",32,0,X_752);           |
|
sql.rsColumn(X_2396,"sys.household","npp","int",32,0,X_762);           |
|
sql.rsColumn(X_2396,"sys.household","nr","int",32,0,X_777);            |
|
sql.rsColumn(X_2396,"sys.household","nrc","int",32,0,X_787);           |
|
sql.rsColumn(X_2396,"sys.household","ocpip","int",32,0,X_800);         |
|
sql.rsColumn(X_2396,"sys.household","partner","int",32,0,X_811);       |
|
sql.rsColumn(X_2396,"sys.household","plm","int",32,0,X_823);           |
|
sql.rsColumn(X_2396,"sys.household","psf","int",32,0,X_834);           |
|
sql.rsColumn(X_2396,"sys.household","r18","int",32,0,X_846);           |
|
sql.rsColumn(X_2396,"sys.household","r60","int",32,0,X_857);           |
|
sql.rsColumn(X_2396,"sys.household","r65","int",32,0,X_872);           |
|
sql.rsColumn(X_2396,"sys.household","resmode","int",32,0,X_882);       |
|
sql.rsColumn(X_2396,"sys.household","smocp","int",32,0,X_895);         |
|
sql.rsColumn(X_2396,"sys.household","smx","int",32,0,X_905);           |
|
sql.rsColumn(X_2396,"sys.household","srnt","int",32,0,X_918);          |
|
sql.rsColumn(X_2396,"sys.household","sval","int",32,0,X_928);          |
|
sql.rsColumn(X_2396,"sys.household","taxp","int",32,0,X_941);          |
|
sql.rsColumn(X_2396,"sys.household","wif","int",32,0,X_951);           |
|
sql.rsColumn(X_2396,"sys.household","wkexrel","int",32,0,X_966);       |
|
sql.rsColumn(X_2396,"sys.household","workstat","int",32,0,X_977);      |
|
sql.rsColumn(X_2396,"sys.household","facrp","int",32,0,X_989);         |
|
sql.rsColumn(X_2396,"sys.household","fagsp","int",32,0,X_1000);        |
|
sql.rsColumn(X_2396,"sys.household","fbathp","int",32,0,X_1012);       |
|
sql.rsColumn(X_2396,"sys.household","fbdsp","int",32,0,X_1023);        |
|
sql.rsColumn(X_2396,"sys.household","fbldp","int",32,0,X_1036);        |
|
sql.rsColumn(X_2396,"sys.household","fbusp","int",32,0,X_1046);        |
|
sql.rsColumn(X_2396,"sys.household","fconp","int",32,0,X_1061);        |
|
sql.rsColumn(X_2396,"sys.household","felep","int",32,0,X_1071);        |
|
sql.rsColumn(X_2396,"sys.household","ffsp","int",32,0,X_1084);         |
|
sql.rsColumn(X_2396,"sys.household","ffulp","int",32,0,X_1094);        |
|
sql.rsColumn(X_2396,"sys.household","fgasp","int",32,0,X_1107);        |
|
sql.rsColumn(X_2396,"sys.household","fhflp","int",32,0,X_1117);        |
|
sql.rsColumn(X_2396,"sys.household","finsp","int",32,0,X_1130);        |
|
sql.rsColumn(X_2396,"sys.household","fkitp","int",32,0,X_1141);        |
|
sql.rsColumn(X_2396,"sys.household","fmhp","int",32,0,X_1155);         |
|
sql.rsColumn(X_2396,"sys.household","fmrgip","int",32,0,X_1166);       |
|
sql.rsColumn(X_2396,"sys.household","fmrgp","int",32,0,X_1178);        |
|
sql.rsColumn(X_2396,"sys.household","fmrgtp","int",32,0,X_1189);       |
|
sql.rsColumn(X_2396,"sys.household","fmrgxp","int",32,0,X_1202);       |
|
sql.rsColumn(X_2396,"sys.household","fmvp","int",32,0,X_1212);         |
|
sql.rsColumn(X_2396,"sys.household","fplmp","int",32,0,X_1225);        |
|
sql.rsColumn(X_2396,"sys.household","frefrp","int",32,0,X_1235);       |
|
sql.rsColumn(X_2396,"sys.household","frmsp","int",32,0,X_1250);        |
|
sql.rsColumn(X_2396,"sys.household","frntmp","int",32,0,X_1260);       |
|
sql.rsColumn(X_2396,"sys.household","frntp","int",32,0,X_1273);        |
|
sql.rsColumn(X_2396,"sys.household","frwatp","int",32,0,X_1283);       |
|
sql.rsColumn(X_2396,"sys.household","fsinkp","int",32,0,X_1296);       |
|
sql.rsColumn(X_2396,"sys.household","fsmp","int",32,0,X_1307);         |
|
sql.rsColumn(X_2396,"sys.household","fsmxhp","int",32,0,X_1319);       |
|
sql.rsColumn(X_2396,"sys.household","fsmxsp","int",32,0,X_1330);       |
|
sql.rsColumn(X_2396,"sys.household","fstovp","int",32,0,X_1344);       |
|
sql.rsColumn(X_2396,"sys.household","ftaxp","int",32,0,X_1355);        |
|
sql.rsColumn(X_2396,"sys.household","ftelp","int",32,0,X_1368);        |
|
sql.rsColumn(X_2396,"sys.household","ftenp","int",32,0,X_1378);        |
|
sql.rsColumn(X_2396,"sys.household","ftoilp","int",32,0,X_1391);       |
|
sql.rsColumn(X_2396,"sys.household","fvacsp","int",32,0,X_1401);       |
|
sql.rsColumn(X_2396,"sys.household","fvalp","int",32,0,X_1414);        |
|
sql.rsColumn(X_2396,"sys.household","fvehp","int",32,0,X_1424);        |
|
sql.rsColumn(X_2396,"sys.household","fwatp","int",32,0,X_1439);        |
|
sql.rsColumn(X_2396,"sys.household","fyblp","int",32,0,X_1449);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp1","int",32,0,X_1462);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp2","int",32,0,X_1473);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp3","int",32,0,X_1485);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp4","int",32,0,X_1496);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp5","int",32,0,X_1508);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp6","int",32,0,X_1519);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp7","int",32,0,X_1534);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp8","int",32,0,X_1544);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp9","int",32,0,X_1557);        |
|
sql.rsColumn(X_2396,"sys.household","wgtp10","int",32,0,X_1567);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp11","int",32,0,X_1580);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp12","int",32,0,X_1590);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp13","int",32,0,X_1603);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp14","int",32,0,X_1613);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp15","int",32,0,X_1628);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp16","int",32,0,X_1639);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp17","int",32,0,X_1651);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp18","int",32,0,X_1662);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp19","int",32,0,X_1674);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp20","int",32,0,X_1685);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp21","int",32,0,X_1698);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp22","int",32,0,X_1708);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp23","int",32,0,X_1723);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp24","int",32,0,X_1733);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp25","int",32,0,X_1746);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp26","int",32,0,X_1756);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp27","int",32,0,X_1769);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp28","int",32,0,X_1779);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp29","int",32,0,X_1792);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp30","int",32,0,X_1803);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp31","int",32,0,X_1817);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp32","int",32,0,X_1828);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp33","int",32,0,X_1840);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp34","int",32,0,X_1851);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp35","int",32,0,X_1864);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp36","int",32,0,X_1874);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp37","int",32,0,X_1887);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp38","int",32,0,X_1897);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp39","int",32,0,X_1912);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp40","int",32,0,X_1922);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp41","int",32,0,X_1935);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp42","int",32,0,X_1945);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp43","int",32,0,X_1958);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp44","int",32,0,X_1969);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp45","int",32,0,X_1981);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp46","int",32,0,X_1992);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp47","int",32,0,X_2006);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp48","int",32,0,X_2017);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp49","int",32,0,X_2030);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp50","int",32,0,X_2040);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp51","int",32,0,X_2053);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp52","int",32,0,X_2063);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp53","int",32,0,X_2076);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp54","int",32,0,X_2086);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp55","int",32,0,X_2101);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp56","int",32,0,X_2111);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp57","int",32,0,X_2124);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp58","int",32,0,X_2135);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp59","int",32,0,X_2147);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp60","int",32,0,X_2158);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp61","int",32,0,X_2170);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp62","int",32,0,X_2181);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp63","int",32,0,X_2196);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp64","int",32,0,X_2206);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp65","int",32,0,X_2219);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp66","int",32,0,X_2229);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp67","int",32,0,X_2242);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp68","int",32,0,X_2252);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp69","int",32,0,X_2265);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp70","int",32,0,X_2275);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp71","int",32,0,X_2290);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp72","int",32,0,X_2301);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp73","int",32,0,X_2313);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp74","int",32,0,X_2324);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp75","int",32,0,X_2336);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp76","int",32,0,X_2347);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp77","int",32,0,X_2360);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp78","int",32,0,X_2370);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp79","int",32,0,X_2385);       |
|
sql.rsColumn(X_2396,"sys.household","wgtp80","int",32,0,X_2395);       |
|     X_2861 :=
io.stdout();                                                 |
|
sql.exportResult(X_2861,X_2396);                                       |
| end
s4_1;                                                                  |
+----------------------------------------------------------------------------+
+------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
| rt   | serialno | division | puma | region | st   | adjhsg  | adjinc  |
wgtp | np   | zzzz | acr  | ags  | bath | bdsp | bld  | bus  | conp | elep
| fs   | fulp | gasp | hfl  | insp | mhp  | mrgi | mrgp | mrgt | mrgx |
refr | rmsp | rntm | rntp | rwat | sink | smp  | stov | tel  | ten  | toil
| vacs | valp   | veh  | watp | ybl  | fes  | fincp | fparc | grntp | grpip
| hhl  | hht  | hincp | hugcl | hupac | hupaoc | huparc | kit  | lngi |
multg | mv   | noc  | npf  | npp  | nr   | nrc  | ocpip | partner | plm  |
psf  | r18  | r60  | r65  | resmode | smocp | smx  | srnt | sval | taxp |
wif  | wkexrel | workstat | facrp | fagsp | fbathp | fbdsp | fbldp | fbusp
| fconp | felep | ffsp | ffulp | fgasp | fhflp | finsp | fkitp | fmhp |
fmrgip | fmrgp | fmrgtp | fmrgxp | fmvp | fplmp | frefrp | frmsp | frntmp |
frntp | frwatp | fsinkp | fsmp | fsmxhp | fsmxsp | fstovp | ftaxp | ftelp |
ftenp | ftoilp | fvacsp | fvalp | fvehp | fwatp | fyblp | wgtp1 | wgtp2 |
wgtp3 | wgtp4 | wgtp5 | wgtp6 | wgtp7 | wgtp8 | wgtp9 | wgtp10 | wgtp11 |
wgtp12 | wgtp13 | wgtp14 | wgtp15 | wgtp16 | wgtp17 | wgtp18 | wgtp19 |
wgtp20 | wgtp21 | wgtp22 | wgtp23 | wgtp24 | wgtp25 | wgtp26 | wgtp27 |
wgtp28 | wgtp29 | wgtp30 | wgtp31 | wgtp32 | wgtp33 | wgtp34 | wgtp35 |
wgtp36 | wgtp37 | wgtp38 | wgtp39 | wgtp40 | wgtp41 | wgtp42 | wgtp43 |
wgtp44 | wgtp45 | wgtp46 | wgtp47 | wgtp48 | wgtp49 | wgtp50 | wgtp51 |
wgtp52 | wgtp53 | wgtp54 | wgtp55 | wgtp56 | wgtp57 | wgtp58 | wgtp59 |
wgtp60 | wgtp61 | wgtp62 | wgtp63 | wgtp64 | wgtp65 | wgtp66 | wgtp67 |
wgtp68 | wgtp69 | wgtp70 | wgtp71 | wgtp72 | wgtp73 | wgtp74 | wgtp75 |
wgtp76 | wgtp77 | wgtp78 | wgtp79 | wgtp80 |
+======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+
| H    |     1890 |        9 |  400 |      4 |    2 | 1000000 | 1007624 |
46 |    2 |    1 | null | null |    1 |    1 |    6 | null | null |    1
|    2 |    1 |    3 |    4 | null | null | null | null | null | null |
1 |    2 |    2 |  600 |    1 |    1 | null |    1 |    1 |    3 |    1 |
null |   null |    1 |    1 |    3 | null |  null |  null |   600 |    21
|    1 |    7 | 34700 |     0 |     4 |      4 |      4 |    1 |    1 |
1 |    3 |    0 | null |    0 |    1 |    0 |  null |       0 |    1 |    0
|    0 |    0 |    0 |       2 |  null | null |    1 |    0 | null | null
|    null |     null |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     0 |    0 |     0 |     0 |     0 |     0 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     0 |     0 |     0
|      0 |      0 |     0 |     0 |     0 |     1 |    10 |    16 |    10
|    42 |    61 |    44 |    54 |    45 |    71 |     67 |    112 |     50
|     15 |     41 |    111 |     79 |     37 |     67 |     38 |     40
|     81 |     95 |     70 |     81 |     51 |     40 |     38 |     47
|     15 |     22 |     18 |     34 |     95 |     55 |     14 |     51
|     48 |     18 |     43 |     12 |      7 |     13 |     15 |     57
|     72 |     55 |     48 |     50 |     75 |     80 |    116 |     51
|     14 |     38 |    126 |     57 |     30 |     93 |     29 |     53
|     80 |     55 |     71 |     46 |     38 |     57 |     39 |     47
|     16 |     16 |     20 |     50 |     91 |     58 |     20 |     72
|     43 |     11 |     48 |      9 |
| H    |     2029 |        9 |  101 |      4 |    2 | 1000000 | 1007624 |
269 |    4 |    1 |    1 | null |    1 |    4 |    2 |    2 | null |   80
|    2 |    2 |   80 |    1 | 1500 | null |    1 |  920 |    1 |    1 |
1 |    7 | null | null |    1 |    1 | null |    1 |    1 |    1 |    1 |
null | 200000 |    1 |  200 |    4 |    8 | 47100 |     2 |  null |  null
|    1 |    3 | 47100 |     1 |     2 |      4 |      2 |    1 |    1 |
2 |    7 |    0 |    4 |    0 |    0 |    2 |    28 |       0 |    1 |    1
|    1 |    1 |    1 |       2 |  1097 |    3 |    0 |    1 |   34 |    1
|      15 |       15 |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     1 |    0 |     0 |     1 |     0 |     1 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     1 |     0 |     0
|      0 |      0 |     0 |     0 |     1 |     0 |   252 |   470 |   264
|   430 |   228 |   243 |   192 |   107 |   265 |     79 |    266 |    268
|     68 |    335 |    503 |    116 |     95 |    389 |    228 |    114
|    254 |     71 |    225 |    116 |    289 |    291 |    233 |    539
|    310 |    423 |    262 |    346 |    511 |    235 |     79 |    407
|    420 |    121 |    223 |     90 |    250 |     70 |    240 |    101
|    259 |    326 |    245 |    461 |    241 |    480 |    315 |    275
|    286 |    338 |    118 |    363 |    409 |     87 |    238 |    418
|    278 |    322 |    297 |    486 |    376 |    262 |    198 |     95
|    259 |    104 |    238 |    309 |    135 |    230 |    408 |    117
|     83 |    497 |    244 |    418 |
+------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
+------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+
| rt   | serialno | division | puma | region | st   | adjhsg  | adjinc  |
wgtp | np   | zzzz | acr  | ags  | bath | bdsp | bld  | bus  | conp | elep
| fs   | fulp | gasp | hfl  | insp | mhp  | mrgi | mrgp | mrgt | mrgx |
refr | rmsp | rntm | rntp | rwat | sink | smp  | stov | tel  | ten  | toil
| vacs | valp   | veh  | watp | ybl  | fes  | fincp | fparc | grntp | grpip
| hhl  | hht  | hincp | hugcl | hupac | hupaoc | huparc | kit  | lngi |
multg | mv   | noc  | npf  | npp  | nr   | nrc  | ocpip | partner | plm  |
psf  | r18  | r60  | r65  | resmode | smocp | smx  | srnt | sval | taxp |
wif  | wkexrel | workstat | facrp | fagsp | fbathp | fbdsp | fbldp | fbusp
| fconp | felep | ffsp | ffulp | fgasp | fhflp | finsp | fkitp | fmhp |
fmrgip | fmrgp | fmrgtp | fmrgxp | fmvp | fplmp | frefrp | frmsp | frntmp |
frntp | frwatp | fsinkp | fsmp | fsmxhp | fsmxsp | fstovp | ftaxp | ftelp |
ftenp | ftoilp | fvacsp | fvalp | fvehp | fwatp | fyblp |
+======+==========+==========+======+========+======+=========+=========+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+======+========+======+======+======+======+=======+=======+=======+=======+======+======+=======+=======+=======+========+========+======+======+=======+======+======+======+======+======+======+=======+=========+======+======+======+======+======+=========+=======+======+======+======+======+======+=========+==========+=======+=======+========+=======+=======+=======+=======+=======+======+=======+=======+=======+=======+=======+======+========+=======+========+========+======+=======+========+=======+========+=======+========+========+======+========+========+========+=======+=======+=======+========+========+=======+=======+=======+=======+
| H    |      168 |        9 |  300 |      4 |    2 | 1000000 | 1007624 |
56 |    3 |    1 |    1 | null |    1 |    3 |    2 |    2 | null |  200
|    2 | 3500 |    3 |    4 |  760 | null |    1 | 1800 |    1 |    1 |
1 |    7 | null | null |    1 |    1 | null |    1 |    1 |    1 |    1 |
null | 235000 |    2 | 1600 |    5 |    7 | 89500 |     4 |  null |  null
|    1 |    3 | 89500 |     0 |     4 |      4 |      4 |    1 |    1 |
1 |    6 |    0 |    3 |    0 |    0 |    0 |    33 |       0 |    1 |    0
|    0 |    0 |    0 |       1 |  2425 |    3 |    0 |    1 |   43 |    3
|      14 |       13 |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     0 |    0 |     0 |     0 |     0 |     0 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     0 |     0 |     0
|      0 |      0 |     0 |     0 |     0 |     0 |
| H    |      433 |        9 |  200 |      4 |    2 | 1000000 | 1007624
|    0 |    1 |    2 | null | null | null | null | null | null | null |
null |    2 | null | null | null | null | null | null | null | null | null
| null | null | null | null | null | null | null | null | null | null |
null | null |   null | null | null | null | null |  null |  null |  null |
null | null | null |  null |  null |  null |   null |   null | null | null
|  null |    5 | null | null | null | null | null |  null |    null | null
| null | null | null | null |    null |  null | null | null | null | null |
null |    null |     null |  null |  null |   null |  null |  null |  null
|  null |  null |    0 |  null |  null |  null |  null |  null | null |
null |  null |   null |   null |    0 |  null |   null |  null |   null |
null |   null |   null | null |   null |   null |   null |  null |  null |
null |   null |   null |  null |  null |  null |  null |
| H    |      650 |        9 |  200 |      4 |    2 | 1000000 | 1007624 |
57 |    0 |    1 |    2 | null |    1 |    2 |    2 |    2 | null | null |
null | null | null | null | null | null | null | null | null | null |    1
|    6 | null | null |    1 |    1 | null |    1 | null | null |    1 |
5 |   null | null | null |    7 | null |  null |  null |  null |  null |
null | null |  null |  null |  null |   null |   null |    1 | null |  null
| null | null | null | null | null | null |  null |    null |    1 | null |
null | null | null |       2 |  null | null |    0 |    0 | null | null
|    null |     null |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     0 |    0 |     0 |     0 |     0 |     0 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     0 |     0 |     0
|      0 |      0 |     0 |     0 |     0 |     0 |
| H    |     1890 |        9 |  400 |      4 |    2 | 1000000 | 1007624 |
46 |    2 |    1 | null | null |    1 |    1 |    6 | null | null |    1
|    2 |    1 |    3 |    4 | null | null | null | null | null | null |
1 |    2 |    2 |  600 |    1 |    1 | null |    1 |    1 |    3 |    1 |
null |   null |    1 |    1 |    3 | null |  null |  null |   600 |    21
|    1 |    7 | 34700 |     0 |     4 |      4 |      4 |    1 |    1 |
1 |    3 |    0 | null |    0 |    1 |    0 |  null |       0 |    1 |    0
|    0 |    0 |    0 |       2 |  null | null |    1 |    0 | null | null
|    null |     null |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     0 |    0 |     0 |     0 |     0 |     0 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     0 |     0 |     0
|      0 |      0 |     0 |     0 |     0 |     1 |
| H    |     2029 |        9 |  101 |      4 |    2 | 1000000 | 1007624 |
269 |    4 |    1 |    1 | null |    1 |    4 |    2 |    2 | null |   80
|    2 |    2 |   80 |    1 | 1500 | null |    1 |  920 |    1 |    1 |
1 |    7 | null | null |    1 |    1 | null |    1 |    1 |    1 |    1 |
null | 200000 |    1 |  200 |    4 |    8 | 47100 |     2 |  null |  null
|    1 |    3 | 47100 |     1 |     2 |      4 |      2 |    1 |    1 |
2 |    7 |    0 |    4 |    0 |    0 |    2 |    28 |       0 |    1 |    1
|    1 |    1 |    1 |       2 |  1097 |    3 |    0 |    1 |   34 |    1
|      15 |       15 |     0 |     0 |      0 |     0 |     0 |     0 |
0 |     1 |    0 |     0 |     1 |     0 |     1 |     0 |    0 |      0
|     0 |      0 |      0 |    0 |     0 |      0 |     0 |      0 |     0
|      0 |      0 |    0 |      0 |      0 |      0 |     1 |     0 |     0
|      0 |      0 |     0 |     0 |     1 |     0 |
+------+----------+----------+------+--------+------+---------+---------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+------+--------+------+------+------+------+-------+-------+-------+-------+------+------+-------+-------+-------+--------+--------+------+------+-------+------+------+------+------+------+------+-------+---------+------+------+------+------+------+---------+-------+------+------+------+------+------+---------+----------+-------+-------+--------+-------+-------+-------+-------+-------+------+-------+-------+-------+-------+-------+------+--------+-------+--------+--------+------+-------+--------+-------+--------+-------+--------+--------+------+--------+--------+--------+-------+-------+-------+--------+--------+-------+-------+-------+-------+
+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+
| wgtp1 | wgtp2 | wgtp3 | wgtp4 | wgtp5 | wgtp6 | wgtp7 | wgtp8 | wgtp9 |
wgtp10 | wgtp11 | wgtp12 | wgtp13 | wgtp14 | wgtp15 | wgtp16 | wgtp17 |
wgtp18 | wgtp19 | wgtp20 | wgtp21 | wgtp22 | wgtp23 | wgtp24 | wgtp25 |
wgtp26 | wgtp27 | wgtp28 | wgtp29 | wgtp30 | wgtp31 | wgtp32 | wgtp33 |
wgtp34 | wgtp35 | wgtp36 | wgtp37 | wgtp38 | wgtp39 | wgtp40 | wgtp41 |
wgtp42 | wgtp43 | wgtp44 | wgtp45 | wgtp46 | wgtp47 | wgtp48 | wgtp49 |
wgtp50 | wgtp51 | wgtp52 | wgtp53 | wgtp54 | wgtp55 | wgtp56 | wgtp57 |
wgtp58 | wgtp59 | wgtp60 | wgtp61 | wgtp62 | wgtp63 | wgtp64 | wgtp65 |
wgtp66 | wgtp67 | wgtp68 | wgtp69 | wgtp70 | wgtp71 | wgtp72 | wgtp73 |
wgtp74 | wgtp75 | wgtp76 | wgtp77 | wgtp78 | wgtp79 | wgtp80 |
+=======+=======+=======+=======+=======+=======+=======+=======+=======+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+========+
|    74 |    14 |    62 |    94 |    47 |    55 |    45 |    72 |    60
|    120 |     18 |     58 |     31 |     61 |     54 |     52 |     15
|     20 |     88 |     58 |     20 |     60 |    107 |     57 |    110
|    115 |     16 |     47 |     17 |     72 |     55 |     18 |     63
|     19 |     89 |     70 |     47 |     43 |     56 |     86 |     81
|     20 |     70 |     94 |     68 |     47 |     57 |     94 |     80
|     78 |     39 |     61 |     12 |     51 |     63 |     47 |     21
|     14 |     95 |     72 |     16 |     50 |     79 |     73 |     82
|     79 |     16 |     53 |     24 |     35 |     54 |     16 |     39
|     12 |    118 |    135 |     66 |     47 |     50 |     76 |
|     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0 |     0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |      0
|      0 |      0 |      0 |      0 |      0 |      0 |      0 |
|    60 |    17 |    57 |    16 |    93 |   106 |    59 |    58 |    58
|     17 |     56 |    101 |     54 |    116 |     96 |     18 |     72
|     15 |     61 |     55 |     54 |     18 |     54 |     15 |     96
|     97 |     57 |     65 |     55 |     17 |     49 |     94 |     59
|    113 |     88 |     18 |     59 |     13 |     56 |     50 |     60
|     17 |     59 |     17 |     96 |     98 |     52 |     50 |     50
|     17 |     60 |     93 |     57 |    102 |    101 |     17 |     68
|     20 |     53 |     54 |     66 |     18 |     63 |     19 |     91
|    106 |     56 |     56 |     57 |     20 |     57 |     90 |     54
|     98 |    101 |     16 |     51 |     17 |     61 |     61 |
|    10 |    16 |    10 |    42 |    61 |    44 |    54 |    45 |    71
|     67 |    112 |     50 |     15 |     41 |    111 |     79 |     37
|     67 |     38 |     40 |     81 |     95 |     70 |     81 |     51
|     40 |     38 |     47 |     15 |     22 |     18 |     34 |     95
|     55 |     14 |     51 |     48 |     18 |     43 |     12 |      7
|     13 |     15 |     57 |     72 |     55 |     48 |     50 |     75
|     80 |    116 |     51 |     14 |     38 |    126 |     57 |     30
|     93 |     29 |     53 |     80 |     55 |     71 |     46 |     38
|     57 |     39 |     47 |     16 |     16 |     20 |     50 |     91
|     58 |     20 |     72 |     43 |     11 |     48 |      9 |
|   252 |   470 |   264 |   430 |   228 |   243 |   192 |   107 |   265
|     79 |    266 |    268 |     68 |    335 |    503 |    116 |     95
|    389 |    228 |    114 |    254 |     71 |    225 |    116 |    289
|    291 |    233 |    539 |    310 |    423 |    262 |    346 |    511
|    235 |     79 |    407 |    420 |    121 |    223 |     90 |    250
|     70 |    240 |    101 |    259 |    326 |    245 |    461 |    241
|    480 |    315 |    275 |    286 |    338 |    118 |    363 |    409
|     87 |    238 |    418 |    278 |    322 |    297 |    486 |    376
|    262 |    198 |     95 |    259 |    104 |    238 |    309 |    135
|    230 |    408 |    117 |     83 |    497 |    244 |    418 |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+