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 |
+-------+-------+-------+-------+-------+-------+-------+-------+-------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+--------+