explain SELECT "comunidades_archivo"."id", "comunidades_archivo"."archivo", "comunidades_archivo"."comunidad", "comunidades_archivo"."cod_propio", "comunidades_archivo"."prod_propio_id", "archivo_com_traslapadas"."id", "archivo_com_traslapadas"."comunidad_traslapada", "productos_propios"."id", "productos_propios"."nombre_archivo", "productos_propios"."nombre_producto", "productos_propios"."prod_id", "productos_propios"."cod_propio", "archivo_productos"."id", "archivo_productos"."productos", "dim_producto"."prod_id", "dim_producto"."prod_nkey", "dim_producto"."prod_nombre", "dim_producto"."prod_familia", "dim_producto"."prod_linea", "dim_producto"."prod_sublinea", "dim_producto"."prod_proveedor_rut", "dim_producto"."prod_proveedor_nombre", "dim_producto"."prod_cis", "dim_producto"."prod_umb", "dim_producto"."prod_fvt", "dim_producto"."prod_todo", "dim_producto"."prod_area_negocio", "dim_producto"."prov_id" FROM "comunidades_archivo" INNER JOIN "archivo_com_traslapadas" ON ("comunidades_archivo"."archivo" = "archivo_com_traslapadas"."id") INNER JOIN "productos_propios" ON ("comunidades_archivo"."prod_propio_id" = "productos_propios"."id") INNER JOIN "archivo_productos" ON ("productos_propios"."nombre_archivo" = "archivo_productos"."id") INNER JOIN "dim_producto" ON ("productos_propios"."prod_id" = "dim_producto"."prod_id") WHERE "comunidades_archivo"."archivo" = 32714; +--------------------------------------------------------------------------------------------------------------------------------+ | mal | +================================================================================================================================+ | function user.s1_2{autoCommit=true}(A0:int):void; | | X_1370:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1423:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1476:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1530:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1600:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1628:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1649:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1670:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1691:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1712:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1733:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1371:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1424:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1478:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1531:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1602:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1629:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1650:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1671:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1692:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1713:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1734:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1372:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1425:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1479:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1532:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1604:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1630:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1651:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1672:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1693:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1714:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1735:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1373:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1426:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1480:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1533:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1606:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1631:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1652:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1673:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1694:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1715:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1736:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1374:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1427:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1481:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1534:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1608:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1632:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1653:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1674:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1695:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1716:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1737:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1375:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1428:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1482:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1535:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1610:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1633:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1654:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1675:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1696:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1717:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1738:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1376:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1429:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1483:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1536:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1612:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1634:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1655:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1676:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1697:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1718:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1739:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1377:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1430:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1484:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1537:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1614:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1635:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1656:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1677:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1698:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1719:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1740:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1378:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1431:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1485:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1538:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1615:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1637:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1658:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1679:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1700:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1721:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1742:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_111 := nil:bat[:oid,:int]; | | X_2066 := nil:bat[:oid,:int]; | | X_2065 := nil:bat[:oid,:int]; | | X_2063 := nil:bat[:oid,:int]; | | X_2062 := nil:bat[:oid,:int]; | | X_2061 := nil:bat[:oid,:int]; | | X_2060 := nil:bat[:oid,:int]; | | X_2059 := nil:bat[:oid,:int]; | | X_2058 := nil:bat[:oid,:int]; | | X_2057 := nil:bat[:oid,:int]; | | X_2054 := nil:bat[:oid,:str]; | | X_2053 := nil:bat[:oid,:str]; | | X_2052 := nil:bat[:oid,:str]; | | X_2050 := nil:bat[:oid,:str]; | | X_2048 := nil:bat[:oid,:str]; | | X_2046 := nil:bat[:oid,:str]; | | X_2044 := nil:bat[:oid,:str]; | | X_2042 := nil:bat[:oid,:str]; | | X_2040 := nil:bat[:oid,:str]; | | X_2037 := nil:bat[:oid,:str]; | | X_2035 := nil:bat[:oid,:str]; | | X_2034 := nil:bat[:oid,:str]; | | X_2033 := nil:bat[:oid,:str]; | | X_2032 := nil:bat[:oid,:str]; | | X_2031 := nil:bat[:oid,:str]; | | X_2030 := nil:bat[:oid,:str]; | | X_2029 := nil:bat[:oid,:str]; | | X_2028 := nil:bat[:oid,:str]; | | X_2027 := nil:bat[:oid,:str]; | | X_2026 := nil:bat[:oid,:str]; | | X_2024 := nil:bat[:oid,:str]; | | X_2023 := nil:bat[:oid,:str]; | | X_2022 := nil:bat[:oid,:str]; | | X_2021 := nil:bat[:oid,:str]; | | X_2020 := nil:bat[:oid,:str]; | | X_2019 := nil:bat[:oid,:str]; | | X_2018 := nil:bat[:oid,:str]; | | X_2015 := nil:bat[:oid,:str]; | | X_2014 := nil:bat[:oid,:str]; | | X_2013 := nil:bat[:oid,:str]; | | X_2011 := nil:bat[:oid,:str]; | | X_2009 := nil:bat[:oid,:str]; | | X_2007 := nil:bat[:oid,:str]; | | X_2005 := nil:bat[:oid,:str]; | | X_2003 := nil:bat[:oid,:str]; | | X_2001 := nil:bat[:oid,:str]; | | X_1998 := nil:bat[:oid,:str]; | | X_1996 := nil:bat[:oid,:str]; | | X_1995 := nil:bat[:oid,:str]; | | X_1994 := nil:bat[:oid,:str]; | | X_1993 := nil:bat[:oid,:str]; | | X_1992 := nil:bat[:oid,:str]; | | X_1991 := nil:bat[:oid,:str]; | | X_1990 := nil:bat[:oid,:str]; | | X_1989 := nil:bat[:oid,:str]; | | X_1988 := nil:bat[:oid,:str]; | | X_1987 := nil:bat[:oid,:str]; | | X_1985 := nil:bat[:oid,:str]; | | X_1984 := nil:bat[:oid,:str]; | | X_1983 := nil:bat[:oid,:str]; | | X_1982 := nil:bat[:oid,:str]; | | X_1981 := nil:bat[:oid,:str]; | | X_1980 := nil:bat[:oid,:str]; | | X_1979 := nil:bat[:oid,:str]; | | X_1976 := nil:bat[:oid,:str]; | | X_1975 := nil:bat[:oid,:str]; | | X_1974 := nil:bat[:oid,:str]; | | X_1972 := nil:bat[:oid,:str]; | | X_1970 := nil:bat[:oid,:str]; | | X_1968 := nil:bat[:oid,:str]; | | X_1966 := nil:bat[:oid,:str]; | | X_1964 := nil:bat[:oid,:str]; | | X_1962 := nil:bat[:oid,:str]; | | X_1959 := nil:bat[:oid,:str]; | | X_1957 := nil:bat[:oid,:str]; | | X_1956 := nil:bat[:oid,:str]; | | X_1955 := nil:bat[:oid,:str]; | | X_1954 := nil:bat[:oid,:str]; | | X_1953 := nil:bat[:oid,:str]; | | X_1952 := nil:bat[:oid,:str]; | | X_1951 := nil:bat[:oid,:str]; | | X_1950 := nil:bat[:oid,:str]; | | X_1949 := nil:bat[:oid,:str]; | | X_1948 := nil:bat[:oid,:str]; | | X_1946 := nil:bat[:oid,:str]; | | X_1945 := nil:bat[:oid,:str]; | | X_1944 := nil:bat[:oid,:str]; | | X_1943 := nil:bat[:oid,:str]; | | X_1942 := nil:bat[:oid,:str]; | | X_1941 := nil:bat[:oid,:str]; | | X_1940 := nil:bat[:oid,:str]; | | X_1937 := nil:bat[:oid,:str]; | | X_1936 := nil:bat[:oid,:str]; | | X_1935 := nil:bat[:oid,:str]; | | X_1933 := nil:bat[:oid,:str]; | | X_1931 := nil:bat[:oid,:str]; | | X_1929 := nil:bat[:oid,:str]; | | X_1927 := nil:bat[:oid,:str]; | | X_1925 := nil:bat[:oid,:str]; | | X_1923 := nil:bat[:oid,:str]; | | X_1920 := nil:bat[:oid,:str]; | | X_1918 := nil:bat[:oid,:str]; | | X_1917 := nil:bat[:oid,:str]; | | X_1916 := nil:bat[:oid,:str]; | | X_1915 := nil:bat[:oid,:str]; | | X_1914 := nil:bat[:oid,:str]; | | X_1913 := nil:bat[:oid,:str]; | | X_1912 := nil:bat[:oid,:str]; | | X_1911 := nil:bat[:oid,:str]; | | X_1910 := nil:bat[:oid,:str]; | | X_1909 := nil:bat[:oid,:str]; | | X_1907 := nil:bat[:oid,:str]; | | X_1906 := nil:bat[:oid,:str]; | | X_1905 := nil:bat[:oid,:str]; | | X_1904 := nil:bat[:oid,:str]; | | X_1903 := nil:bat[:oid,:str]; | | X_1902 := nil:bat[:oid,:str]; | | X_1901 := nil:bat[:oid,:str]; | | X_1898 := nil:bat[:oid,:int]; | | X_1897 := nil:bat[:oid,:int]; | | X_1896 := nil:bat[:oid,:int]; | | X_1894 := nil:bat[:oid,:int]; | | X_1892 := nil:bat[:oid,:int]; | | X_1890 := nil:bat[:oid,:int]; | | X_1888 := nil:bat[:oid,:int]; | | X_1886 := nil:bat[:oid,:int]; | | X_1884 := nil:bat[:oid,:int]; | | X_1812:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1830:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1810:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1829:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1809:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1827:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1808:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1825:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1807:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1823:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1806:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1821:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1805:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1819:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1804:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1817:bat[:oid,:str] := nil:bat[:oid,:str]; | | X_1802:bat[:oid,:int] := nil:bat[:oid,:int]; | | X_1815:bat[:oid,:str] := nil:bat[:oid,:str]; | | barrier X_2103 := language.dataflow(); | | X_3 := sql.mvc(); | | X_503:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,0,8); | | X_762 := algebra.uselect(X_503,A0); | | X_528:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,0,8); | | X_774 := algebra.kdifference(X_762,X_528); | | X_786 := algebra.uselect(X_528,A0); | | X_795 := algebra.kunion(X_774,X_786); | | X_12:bat[:oid,:oid] := sql.bind_dbat(X_3,"sys","comunidades_archivo",1); | | X_13 := bat.reverse(X_12); | | X_808 := algebra.kdifference(X_795,X_13); | | X_821 := algebra.markT(X_808,9,0); | | X_855 := bat.reverse(X_821); | | X_541:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,0,8); | | X_565:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,0,8); | | X_871 := algebra.kdifference(X_541,X_565); | | X_882 := algebra.kunion(X_871,X_565); | | X_893 := algebra.kdifference(X_882,X_13); | | X_906 := algebra.leftjoin(X_855,X_893); | | X_16:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_com_traslapadas","id",0); | | X_21:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_com_traslapadas","id",2); | | X_23 := algebra.kdifference(X_16,X_21); | | X_24 := algebra.kunion(X_23,X_21); | | X_25:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_com_traslapadas","id",1); | | X_27 := algebra.kunion(X_24,X_25); | | X_28:bat[:oid,:oid] := sql.bind_dbat(X_3,"sys","archivo_com_traslapadas",1); | | X_29 := bat.reverse(X_28); | | X_30 := algebra.kdifference(X_27,X_29); | | X_31 := bat.mirror(X_30); | | X_32 := bat.reverse(X_31); | | X_927 := algebra.join(X_906,X_32); | | X_936 := algebra.markT(X_927,9,0); | | X_964 := bat.reverse(X_936); | | X_2067 := algebra.leftjoin(X_964,X_855); | | X_578:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,0,8); | | X_603:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,0,8); | | X_974 := algebra.kdifference(X_578,X_603); | | X_990 := algebra.kunion(X_974,X_603); | | X_37:bat[:oid,:oid] := sql.bind_dbat(X_3,"sys","comunidades_archivo",1); | | X_38 := bat.reverse(X_37); | | X_1000 := algebra.kdifference(X_990,X_38); | | X_1018:bat[:oid,:oid] := algebra.leftjoin(X_2067,X_1000); | | X_39:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","id",0); | | X_43:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","id",2); | | X_45 := algebra.kdifference(X_39,X_43); | | X_46 := algebra.kunion(X_45,X_43); | | X_47:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","id",1); | | X_49 := algebra.kunion(X_46,X_47); | | X_50:bat[:oid,:oid] := sql.bind_dbat(X_3,"sys","productos_propios",1); | | X_51 := bat.reverse(X_50); | | X_52 := algebra.kdifference(X_49,X_51); | | X_53 := bat.mirror(X_52); | | X_54 := bat.reverse(X_53); | | X_1030 := algebra.join(X_1018,X_54); | | X_615:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,0,8); | | X_641:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,0,8); | | X_1272 := algebra.kdifference(X_615,X_641); | | X_1289 := algebra.kunion(X_1272,X_641); | | X_1326 := algebra.kdifference(X_503,X_528); | | X_1342 := algebra.kunion(X_1326,X_528); | | X_652:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,0,8); | | X_678:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,0,8); | | X_1379 := algebra.kdifference(X_652,X_678); | | X_1395 := algebra.kunion(X_1379,X_678); | | X_689:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,0,8); | | X_715:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,0,8); | | X_1432 := algebra.kdifference(X_689,X_715); | | X_1449 := algebra.kunion(X_1432,X_715); | | X_726:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,0,8); | | X_752:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,0,8); | | X_1486 := algebra.kdifference(X_726,X_752); | | X_1502 := algebra.kunion(X_1486,X_752); | | X_1039 := bat.reverse(X_1030); | | X_1057 := algebra.markT(X_1039,9,0); | | X_1078 := bat.reverse(X_1057); | | X_55:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","productos_propios","productos_propios_nombre_archivo_fkey",0); | | X_58:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","productos_propios","productos_propios_nombre_archivo_fkey",2); | | X_59 := algebra.kdifference(X_55,X_58); | | X_60 := algebra.kunion(X_59,X_58); | | X_61:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","productos_propios","productos_propios_nombre_archivo_fkey",1); | | X_63 := algebra.kunion(X_60,X_61); | | X_64 := algebra.kdifference(X_63,X_51); | | X_1099 := algebra.leftjoin(X_1078,X_64); | | X_65:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_productos","id",0); | | X_69:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_productos","id",2); | | X_71 := algebra.kdifference(X_65,X_69); | | X_72 := algebra.kunion(X_71,X_69); | | X_73:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_productos","id",1); | | X_75 := algebra.kunion(X_72,X_73); | | X_76:bat[:oid,:oid] := sql.bind_dbat(X_3,"sys","archivo_productos",1); | | X_77 := bat.reverse(X_76); | | X_78 := algebra.kdifference(X_75,X_77); | | X_79 := bat.mirror(X_78); | | X_80 := bat.reverse(X_79); | | X_1110 := algebra.join(X_1099,X_80); | | X_1127 := algebra.markT(X_1110,9,0); | | X_1148 := bat.reverse(X_1127); | | X_2076 := algebra.leftjoin(X_1148,X_1078); | | X_81:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","productos_propios","productos_propios_prod_id_fkey",0); | | X_85:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","productos_propios","productos_propios_prod_id_fkey",2); | | X_86 := algebra.kdifference(X_81,X_85); | | X_87 := algebra.kunion(X_86,X_85); | | X_88:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","productos_propios","productos_propios_prod_id_fkey",1); | | X_89 := algebra.kunion(X_87,X_88); | | X_90 := algebra.kdifference(X_89,X_51); | | X_1167:bat[:oid,:oid] := algebra.leftjoin(X_2076,X_90); | | X_91:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prod_id",0); | | X_95:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prod_id",2); | | X_97 := algebra.kdifference(X_91,X_95); | | X_98 := algebra.kunion(X_97,X_95); | | X_99:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prod_id",1); | | X_101 := algebra.kunion(X_98,X_99); | | X_102:bat[:oid,:oid] := sql.bind_dbat(X_3,"sys","dim_producto",1); | | X_104 := bat.reverse(X_102); | | X_105 := algebra.kdifference(X_101,X_104); | | X_106 := bat.mirror(X_105); | | X_107 := bat.reverse(X_106); | | X_1180 := algebra.join(X_1167,X_107); | | X_153:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","id",0); | | X_157:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","id",2); | | X_158 := algebra.kdifference(X_153,X_157); | | X_159 := algebra.kunion(X_158,X_157); | | X_160:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","id",1); | | X_161 := algebra.kunion(X_159,X_160); | | X_163:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","nombre_archivo",0); | | X_166:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","nombre_archivo",2); | | X_168 := algebra.kdifference(X_163,X_166); | | X_169 := algebra.kunion(X_168,X_166); | | X_170:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","nombre_archivo",1); | | X_172 := algebra.kunion(X_169,X_170); | | X_175:bat[:oid,:str] := sql.bind(X_3,"sys","productos_propios","nombre_producto",0); | | X_178:bat[:oid,:str] := sql.bind(X_3,"sys","productos_propios","nombre_producto",2); | | X_179 := algebra.kdifference(X_175,X_178); | | X_180 := algebra.kunion(X_179,X_178); | | X_181:bat[:oid,:str] := sql.bind(X_3,"sys","productos_propios","nombre_producto",1); | | X_182 := algebra.kunion(X_180,X_181); | | X_184:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","prod_id",0); | | X_187:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","prod_id",2); | | X_189 := algebra.kdifference(X_184,X_187); | | X_190 := algebra.kunion(X_189,X_187); | | X_191:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","prod_id",1); | | X_194 := algebra.kunion(X_190,X_191); | | X_196:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","cod_propio",0); | | X_199:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","cod_propio",2); | | X_200 := algebra.kdifference(X_196,X_199); | | X_201 := algebra.kunion(X_200,X_199); | | X_202:bat[:oid,:int] := sql.bind(X_3,"sys","productos_propios","cod_propio",1); | | X_203 := algebra.kunion(X_201,X_202); | | X_1197 := algebra.markT(X_1180,9,0); | | X_1218 := bat.reverse(X_1197); | | X_2085 := algebra.leftjoin(X_1218,X_1148); | | X_1234 := algebra.markT(X_1030,9,0); | | X_1256 := bat.reverse(X_1234); | | X_1316:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1256,X_964,X_855,X_1289); | | X_1370:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1256,X_964,X_855,X_1342); | | X_1423:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1256,X_964,X_855,X_1395); | | X_1476:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1256,X_964,X_855,X_1449); | | X_1530:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1256,X_964,X_855,X_1502); | | X_1539 := bat.reverse(X_927); | | X_1550 := algebra.markT(X_1539,9,0); | | X_1580 := bat.reverse(X_1550); | | X_132:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_com_traslapadas","id",0); | | X_135:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_com_traslapadas","id",2); | | X_137 := algebra.kdifference(X_132,X_135); | | X_138 := algebra.kunion(X_137,X_135); | | X_139:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_com_traslapadas","id",1); | | X_140 := algebra.kunion(X_138,X_139); | | X_1600:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1256,X_1580,X_140); | | X_142:bat[:oid,:str] := sql.bind(X_3,"sys","archivo_com_traslapadas","comunidad_traslapada",0); | | X_145:bat[:oid,:str] := sql.bind(X_3,"sys","archivo_com_traslapadas","comunidad_traslapada",2); | | X_147 := algebra.kdifference(X_142,X_145); | | X_148 := algebra.kunion(X_147,X_145); | | X_149:bat[:oid,:str] := sql.bind(X_3,"sys","archivo_com_traslapadas","comunidad_traslapada",1); | | X_151 := algebra.kunion(X_148,X_149); | | X_1628:bat[:oid,:str] := algebra.leftjoinPath(X_2085,X_1256,X_1580,X_151); | | X_1649:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1078,X_161); | | X_1670:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1078,X_172); | | X_1691:bat[:oid,:str] := algebra.leftjoinPath(X_2085,X_1078,X_182); | | X_1712:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1078,X_194); | | X_1733:bat[:oid,:int] := algebra.leftjoinPath(X_2085,X_1078,X_203); | | X_508:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,1,8); | | X_764 := algebra.uselect(X_508,A0); | | X_530:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,1,8); | | X_775 := algebra.kdifference(X_764,X_530); | | X_788 := algebra.uselect(X_530,A0); | | X_797 := algebra.kunion(X_775,X_788); | | X_809 := algebra.kdifference(X_797,X_13); | | X_826 := algebra.markT(X_809,9,1); | | X_859 := bat.reverse(X_826); | | X_545:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,1,8); | | X_567:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,1,8); | | X_872 := algebra.kdifference(X_545,X_567); | | X_883 := algebra.kunion(X_872,X_567); | | X_895 := algebra.kdifference(X_883,X_13); | | X_908 := algebra.leftjoin(X_859,X_895); | | X_928 := algebra.join(X_908,X_32); | | X_939 := algebra.markT(X_928,9,1); | | X_966 := bat.reverse(X_939); | | X_2068 := algebra.leftjoin(X_966,X_859); | | X_582:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,1,8); | | X_606:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,1,8); | | X_976 := algebra.kdifference(X_582,X_606); | | X_991 := algebra.kunion(X_976,X_606); | | X_1001 := algebra.kdifference(X_991,X_38); | | X_1019:bat[:oid,:oid] := algebra.leftjoin(X_2068,X_1001); | | X_1031 := algebra.join(X_1019,X_54); | | X_619:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,1,8); | | X_643:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,1,8); | | X_1275 := algebra.kdifference(X_619,X_643); | | X_1290 := algebra.kunion(X_1275,X_643); | | X_1328 := algebra.kdifference(X_508,X_530); | | X_1343 := algebra.kunion(X_1328,X_530); | | X_656:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,1,8); | | X_680:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,1,8); | | X_1381 := algebra.kdifference(X_656,X_680); | | X_1397 := algebra.kunion(X_1381,X_680); | | X_693:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,1,8); | | X_717:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,1,8); | | X_1435 := algebra.kdifference(X_693,X_717); | | X_1450 := algebra.kunion(X_1435,X_717); | | X_730:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,1,8); | | X_754:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,1,8); | | X_1488 := algebra.kdifference(X_730,X_754); | | X_1503 := algebra.kunion(X_1488,X_754); | | X_1041 := bat.reverse(X_1031); | | X_1061 := algebra.markT(X_1041,9,1); | | X_1080 := bat.reverse(X_1061); | | X_1100 := algebra.leftjoin(X_1080,X_64); | | X_1111 := algebra.join(X_1100,X_80); | | X_1130 := algebra.markT(X_1111,9,1); | | X_1150 := bat.reverse(X_1130); | | X_2077 := algebra.leftjoin(X_1150,X_1080); | | X_1168:bat[:oid,:oid] := algebra.leftjoin(X_2077,X_90); | | X_1182 := algebra.join(X_1168,X_107); | | X_1200 := algebra.markT(X_1182,9,1); | | X_1220 := bat.reverse(X_1200); | | X_2086 := algebra.leftjoin(X_1220,X_1150); | | X_1238 := algebra.markT(X_1031,9,1); | | X_1258 := bat.reverse(X_1238); | | X_1318:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1258,X_966,X_859,X_1290); | | X_1371:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1258,X_966,X_859,X_1343); | | X_1424:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1258,X_966,X_859,X_1397); | | X_1478:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1258,X_966,X_859,X_1450); | | X_1531:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1258,X_966,X_859,X_1503); | | X_1541 := bat.reverse(X_928); | | X_1554 := algebra.markT(X_1541,9,1); | | X_1581 := bat.reverse(X_1554); | | X_1602:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1258,X_1581,X_140); | | X_1629:bat[:oid,:str] := algebra.leftjoinPath(X_2086,X_1258,X_1581,X_151); | | X_1650:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1080,X_161); | | X_1671:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1080,X_172); | | X_1692:bat[:oid,:str] := algebra.leftjoinPath(X_2086,X_1080,X_182); | | X_1713:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1080,X_194); | | X_1734:bat[:oid,:int] := algebra.leftjoinPath(X_2086,X_1080,X_203); | | X_511:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,2,8); | | X_766 := algebra.uselect(X_511,A0); | | X_531:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,2,8); | | X_776 := algebra.kdifference(X_766,X_531); | | X_789 := algebra.uselect(X_531,A0); | | X_799 := algebra.kunion(X_776,X_789); | | X_810 := algebra.kdifference(X_799,X_13); | | X_829 := algebra.markT(X_810,9,2); | | X_860 := bat.reverse(X_829); | | X_548:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,2,8); | | X_569:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,2,8); | | X_874 := algebra.kdifference(X_548,X_569); | | X_884 := algebra.kunion(X_874,X_569); | | X_896 := algebra.kdifference(X_884,X_13); | | X_910 := algebra.leftjoin(X_860,X_896); | | X_929 := algebra.join(X_910,X_32); | | X_943 := algebra.markT(X_929,9,2); | | X_967 := bat.reverse(X_943); | | X_2069 := algebra.leftjoin(X_967,X_860); | | X_585:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,2,8); | | X_607:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,2,8); | | X_978 := algebra.kdifference(X_585,X_607); | | X_992 := algebra.kunion(X_978,X_607); | | X_1002 := algebra.kdifference(X_992,X_38); | | X_1020:bat[:oid,:oid] := algebra.leftjoin(X_2069,X_1002); | | X_1032 := algebra.join(X_1020,X_54); | | X_622:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,2,8); | | X_644:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,2,8); | | X_1277 := algebra.kdifference(X_622,X_644); | | X_1291 := algebra.kunion(X_1277,X_644); | | X_1330 := algebra.kdifference(X_511,X_531); | | X_1344 := algebra.kunion(X_1330,X_531); | | X_659:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,2,8); | | X_681:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,2,8); | | X_1383 := algebra.kdifference(X_659,X_681); | | X_1398 := algebra.kunion(X_1383,X_681); | | X_696:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,2,8); | | X_718:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,2,8); | | X_1437 := algebra.kdifference(X_696,X_718); | | X_1451 := algebra.kunion(X_1437,X_718); | | X_733:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,2,8); | | X_755:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,2,8); | | X_1490 := algebra.kdifference(X_733,X_755); | | X_1504 := algebra.kunion(X_1490,X_755); | | X_1043 := bat.reverse(X_1032); | | X_1064 := algebra.markT(X_1043,9,2); | | X_1082 := bat.reverse(X_1064); | | X_1101 := algebra.leftjoin(X_1082,X_64); | | X_1113 := algebra.join(X_1101,X_80); | | X_1132 := algebra.markT(X_1113,9,2); | | X_1152 := bat.reverse(X_1132); | | X_2078 := algebra.leftjoin(X_1152,X_1082); | | X_1169:bat[:oid,:oid] := algebra.leftjoin(X_2078,X_90); | | X_1184 := algebra.join(X_1169,X_107); | | X_1202 := algebra.markT(X_1184,9,2); | | X_1222 := bat.reverse(X_1202); | | X_2087 := algebra.leftjoin(X_1222,X_1152); | | X_1240 := algebra.markT(X_1032,9,2); | | X_1260 := bat.reverse(X_1240); | | X_1319:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1260,X_967,X_860,X_1291); | | X_1372:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1260,X_967,X_860,X_1344); | | X_1425:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1260,X_967,X_860,X_1398); | | X_1479:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1260,X_967,X_860,X_1451); | | X_1532:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1260,X_967,X_860,X_1504); | | X_1542 := bat.reverse(X_929); | | X_1557 := algebra.markT(X_1542,9,2); | | X_1582 := bat.reverse(X_1557); | | X_1604:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1260,X_1582,X_140); | | X_1630:bat[:oid,:str] := algebra.leftjoinPath(X_2087,X_1260,X_1582,X_151); | | X_1651:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1082,X_161); | | X_1672:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1082,X_172); | | X_1693:bat[:oid,:str] := algebra.leftjoinPath(X_2087,X_1082,X_182); | | X_1714:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1082,X_194); | | X_1735:bat[:oid,:int] := algebra.leftjoinPath(X_2087,X_1082,X_203); | | X_514:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,3,8); | | X_768 := algebra.uselect(X_514,A0); | | X_532:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,3,8); | | X_777 := algebra.kdifference(X_768,X_532); | | X_790 := algebra.uselect(X_532,A0); | | X_801 := algebra.kunion(X_777,X_790); | | X_811 := algebra.kdifference(X_801,X_13); | | X_833 := algebra.markT(X_811,9,3); | | X_862 := bat.reverse(X_833); | | X_551:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,3,8); | | X_570:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,3,8); | | X_876 := algebra.kdifference(X_551,X_570); | | X_885 := algebra.kunion(X_876,X_570); | | X_897 := algebra.kdifference(X_885,X_13); | | X_912 := algebra.leftjoin(X_862,X_897); | | X_930 := algebra.join(X_912,X_32); | | X_946 := algebra.markT(X_930,9,3); | | X_968 := bat.reverse(X_946); | | X_2070 := algebra.leftjoin(X_968,X_862); | | X_588:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,3,8); | | X_608:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,3,8); | | X_980 := algebra.kdifference(X_588,X_608); | | X_993 := algebra.kunion(X_980,X_608); | | X_1003 := algebra.kdifference(X_993,X_38); | | X_1021:bat[:oid,:oid] := algebra.leftjoin(X_2070,X_1003); | | X_1033 := algebra.join(X_1021,X_54); | | X_625:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,3,8); | | X_645:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,3,8); | | X_1279 := algebra.kdifference(X_625,X_645); | | X_1292 := algebra.kunion(X_1279,X_645); | | X_1332 := algebra.kdifference(X_514,X_532); | | X_1345 := algebra.kunion(X_1332,X_532); | | X_662:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,3,8); | | X_682:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,3,8); | | X_1385 := algebra.kdifference(X_662,X_682); | | X_1399 := algebra.kunion(X_1385,X_682); | | X_699:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,3,8); | | X_719:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,3,8); | | X_1439 := algebra.kdifference(X_699,X_719); | | X_1452 := algebra.kunion(X_1439,X_719); | | X_736:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,3,8); | | X_756:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,3,8); | | X_1492 := algebra.kdifference(X_736,X_756); | | X_1505 := algebra.kunion(X_1492,X_756); | | X_1045 := bat.reverse(X_1033); | | X_1066 := algebra.markT(X_1045,9,3); | | X_1084 := bat.reverse(X_1066); | | X_1102 := algebra.leftjoin(X_1084,X_64); | | X_1115 := algebra.join(X_1102,X_80); | | X_1134 := algebra.markT(X_1115,9,3); | | X_1154 := bat.reverse(X_1134); | | X_2079 := algebra.leftjoin(X_1154,X_1084); | | X_1170:bat[:oid,:oid] := algebra.leftjoin(X_2079,X_90); | | X_1186 := algebra.join(X_1170,X_107); | | X_1204 := algebra.markT(X_1186,9,3); | | X_1224 := bat.reverse(X_1204); | | X_2088 := algebra.leftjoin(X_1224,X_1154); | | X_1242 := algebra.markT(X_1033,9,3); | | X_1262 := bat.reverse(X_1242); | | X_1320:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1262,X_968,X_862,X_1292); | | X_1373:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1262,X_968,X_862,X_1345); | | X_1426:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1262,X_968,X_862,X_1399); | | X_1480:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1262,X_968,X_862,X_1452); | | X_1533:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1262,X_968,X_862,X_1505); | | X_1543 := bat.reverse(X_930); | | X_1560 := algebra.markT(X_1543,9,3); | | X_1583 := bat.reverse(X_1560); | | X_1606:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1262,X_1583,X_140); | | X_1631:bat[:oid,:str] := algebra.leftjoinPath(X_2088,X_1262,X_1583,X_151); | | X_1652:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1084,X_161); | | X_1673:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1084,X_172); | | X_1694:bat[:oid,:str] := algebra.leftjoinPath(X_2088,X_1084,X_182); | | X_1715:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1084,X_194); | | X_1736:bat[:oid,:int] := algebra.leftjoinPath(X_2088,X_1084,X_203); | | X_517:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,4,8); | | X_769 := algebra.uselect(X_517,A0); | | X_533:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,4,8); | | X_778 := algebra.kdifference(X_769,X_533); | | X_791 := algebra.uselect(X_533,A0); | | X_803 := algebra.kunion(X_778,X_791); | | X_812 := algebra.kdifference(X_803,X_13); | | X_838 := algebra.markT(X_812,9,4); | | X_863 := bat.reverse(X_838); | | X_554:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,4,8); | | X_572:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,4,8); | | X_878 := algebra.kdifference(X_554,X_572); | | X_886 := algebra.kunion(X_878,X_572); | | X_898 := algebra.kdifference(X_886,X_13); | | X_914 := algebra.leftjoin(X_863,X_898); | | X_931 := algebra.join(X_914,X_32); | | X_949 := algebra.markT(X_931,9,4); | | X_969 := bat.reverse(X_949); | | X_2071 := algebra.leftjoin(X_969,X_863); | | X_591:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,4,8); | | X_609:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,4,8); | | X_982 := algebra.kdifference(X_591,X_609); | | X_994 := algebra.kunion(X_982,X_609); | | X_1004 := algebra.kdifference(X_994,X_38); | | X_1022:bat[:oid,:oid] := algebra.leftjoin(X_2071,X_1004); | | X_1034 := algebra.join(X_1022,X_54); | | X_628:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,4,8); | | X_646:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,4,8); | | X_1281 := algebra.kdifference(X_628,X_646); | | X_1293 := algebra.kunion(X_1281,X_646); | | X_1334 := algebra.kdifference(X_517,X_533); | | X_1346 := algebra.kunion(X_1334,X_533); | | X_665:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,4,8); | | X_683:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,4,8); | | X_1387 := algebra.kdifference(X_665,X_683); | | X_1400 := algebra.kunion(X_1387,X_683); | | X_702:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,4,8); | | X_720:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,4,8); | | X_1441 := algebra.kdifference(X_702,X_720); | | X_1453 := algebra.kunion(X_1441,X_720); | | X_740:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,4,8); | | X_757:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,4,8); | | X_1494 := algebra.kdifference(X_740,X_757); | | X_1506 := algebra.kunion(X_1494,X_757); | | X_1047 := bat.reverse(X_1034); | | X_1068 := algebra.markT(X_1047,9,4); | | X_1086 := bat.reverse(X_1068); | | X_1103 := algebra.leftjoin(X_1086,X_64); | | X_1117 := algebra.join(X_1103,X_80); | | X_1136 := algebra.markT(X_1117,9,4); | | X_1156 := bat.reverse(X_1136); | | X_2080 := algebra.leftjoin(X_1156,X_1086); | | X_1171:bat[:oid,:oid] := algebra.leftjoin(X_2080,X_90); | | X_1189 := algebra.join(X_1171,X_107); | | X_1206 := algebra.markT(X_1189,9,4); | | X_1226 := bat.reverse(X_1206); | | X_2089 := algebra.leftjoin(X_1226,X_1156); | | X_1244 := algebra.markT(X_1034,9,4); | | X_1264 := bat.reverse(X_1244); | | X_1321:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1264,X_969,X_863,X_1293); | | X_1374:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1264,X_969,X_863,X_1346); | | X_1427:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1264,X_969,X_863,X_1400); | | X_1481:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1264,X_969,X_863,X_1453); | | X_1534:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1264,X_969,X_863,X_1506); | | X_1544 := bat.reverse(X_931); | | X_1563 := algebra.markT(X_1544,9,4); | | X_1584 := bat.reverse(X_1563); | | X_1608:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1264,X_1584,X_140); | | X_1632:bat[:oid,:str] := algebra.leftjoinPath(X_2089,X_1264,X_1584,X_151); | | X_1653:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1086,X_161); | | X_1674:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1086,X_172); | | X_1695:bat[:oid,:str] := algebra.leftjoinPath(X_2089,X_1086,X_182); | | X_1716:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1086,X_194); | | X_1737:bat[:oid,:int] := algebra.leftjoinPath(X_2089,X_1086,X_203); | | X_520:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,5,8); | | X_771 := algebra.uselect(X_520,A0); | | X_534:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,5,8); | | X_780 := algebra.kdifference(X_771,X_534); | | X_792 := algebra.uselect(X_534,A0); | | X_804 := algebra.kunion(X_780,X_792); | | X_814 := algebra.kdifference(X_804,X_13); | | X_841 := algebra.markT(X_814,9,5); | | X_865 := bat.reverse(X_841); | | X_557:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,5,8); | | X_573:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,5,8); | | X_879 := algebra.kdifference(X_557,X_573); | | X_887 := algebra.kunion(X_879,X_573); | | X_900 := algebra.kdifference(X_887,X_13); | | X_916 := algebra.leftjoin(X_865,X_900); | | X_932 := algebra.join(X_916,X_32); | | X_952 := algebra.markT(X_932,9,5); | | X_970 := bat.reverse(X_952); | | X_2072 := algebra.leftjoin(X_970,X_865); | | X_594:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,5,8); | | X_610:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,5,8); | | X_984 := algebra.kdifference(X_594,X_610); | | X_995 := algebra.kunion(X_984,X_610); | | X_1005 := algebra.kdifference(X_995,X_38); | | X_1023:bat[:oid,:oid] := algebra.leftjoin(X_2072,X_1005); | | X_1035 := algebra.join(X_1023,X_54); | | X_631:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,5,8); | | X_647:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,5,8); | | X_1283 := algebra.kdifference(X_631,X_647); | | X_1294 := algebra.kunion(X_1283,X_647); | | X_1336 := algebra.kdifference(X_520,X_534); | | X_1347 := algebra.kunion(X_1336,X_534); | | X_668:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,5,8); | | X_684:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,5,8); | | X_1389 := algebra.kdifference(X_668,X_684); | | X_1401 := algebra.kunion(X_1389,X_684); | | X_706:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,5,8); | | X_721:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,5,8); | | X_1443 := algebra.kdifference(X_706,X_721); | | X_1454 := algebra.kunion(X_1443,X_721); | | X_744:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,5,8); | | X_758:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,5,8); | | X_1496 := algebra.kdifference(X_744,X_758); | | X_1507 := algebra.kunion(X_1496,X_758); | | X_1049 := bat.reverse(X_1035); | | X_1070 := algebra.markT(X_1049,9,5); | | X_1088 := bat.reverse(X_1070); | | X_1104 := algebra.leftjoin(X_1088,X_64); | | X_1119 := algebra.join(X_1104,X_80); | | X_1138 := algebra.markT(X_1119,9,5); | | X_1158 := bat.reverse(X_1138); | | X_2081 := algebra.leftjoin(X_1158,X_1088); | | X_1172:bat[:oid,:oid] := algebra.leftjoin(X_2081,X_90); | | X_1191 := algebra.join(X_1172,X_107); | | X_1208 := algebra.markT(X_1191,9,5); | | X_1228 := bat.reverse(X_1208); | | X_2090 := algebra.leftjoin(X_1228,X_1158); | | X_1246 := algebra.markT(X_1035,9,5); | | X_1266 := bat.reverse(X_1246); | | X_1322:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1266,X_970,X_865,X_1294); | | X_1375:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1266,X_970,X_865,X_1347); | | X_1428:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1266,X_970,X_865,X_1401); | | X_1482:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1266,X_970,X_865,X_1454); | | X_1535:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1266,X_970,X_865,X_1507); | | X_1546 := bat.reverse(X_932); | | X_1566 := algebra.markT(X_1546,9,5); | | X_1585 := bat.reverse(X_1566); | | X_1610:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1266,X_1585,X_140); | | X_1633:bat[:oid,:str] := algebra.leftjoinPath(X_2090,X_1266,X_1585,X_151); | | X_1654:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1088,X_161); | | X_1675:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1088,X_172); | | X_1696:bat[:oid,:str] := algebra.leftjoinPath(X_2090,X_1088,X_182); | | X_1717:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1088,X_194); | | X_1738:bat[:oid,:int] := algebra.leftjoinPath(X_2090,X_1088,X_203); | | X_523:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,6,8); | | X_772 := algebra.uselect(X_523,A0); | | X_536:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,6,8); | | X_782 := algebra.kdifference(X_772,X_536); | | X_793 := algebra.uselect(X_536,A0); | | X_805 := algebra.kunion(X_782,X_793); | | X_816 := algebra.kdifference(X_805,X_13); | | X_844 := algebra.markT(X_816,9,6); | | X_867 := bat.reverse(X_844); | | X_560:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,6,8); | | X_574:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,6,8); | | X_880 := algebra.kdifference(X_560,X_574); | | X_888 := algebra.kunion(X_880,X_574); | | X_902 := algebra.kdifference(X_888,X_13); | | X_918 := algebra.leftjoin(X_867,X_902); | | X_933 := algebra.join(X_918,X_32); | | X_955 := algebra.markT(X_933,9,6); | | X_971 := bat.reverse(X_955); | | X_2073 := algebra.leftjoin(X_971,X_867); | | X_597:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,6,8); | | X_611:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,6,8); | | X_986 := algebra.kdifference(X_597,X_611); | | X_996 := algebra.kunion(X_986,X_611); | | X_1006 := algebra.kdifference(X_996,X_38); | | X_1024:bat[:oid,:oid] := algebra.leftjoin(X_2073,X_1006); | | X_1036 := algebra.join(X_1024,X_54); | | X_634:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,6,8); | | X_648:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,6,8); | | X_1285 := algebra.kdifference(X_634,X_648); | | X_1295 := algebra.kunion(X_1285,X_648); | | X_1338 := algebra.kdifference(X_523,X_536); | | X_1348 := algebra.kunion(X_1338,X_536); | | X_672:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,6,8); | | X_685:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,6,8); | | X_1391 := algebra.kdifference(X_672,X_685); | | X_1402 := algebra.kunion(X_1391,X_685); | | X_710:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,6,8); | | X_722:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,6,8); | | X_1445 := algebra.kdifference(X_710,X_722); | | X_1455 := algebra.kunion(X_1445,X_722); | | X_747:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,6,8); | | X_759:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,6,8); | | X_1498 := algebra.kdifference(X_747,X_759); | | X_1508 := algebra.kunion(X_1498,X_759); | | X_1051 := bat.reverse(X_1036); | | X_1072 := algebra.markT(X_1051,9,6); | | X_1090 := bat.reverse(X_1072); | | X_1105 := algebra.leftjoin(X_1090,X_64); | | X_1121 := algebra.join(X_1105,X_80); | | X_1140 := algebra.markT(X_1121,9,6); | | X_1160 := bat.reverse(X_1140); | | X_2082 := algebra.leftjoin(X_1160,X_1090); | | X_1173:bat[:oid,:oid] := algebra.leftjoin(X_2082,X_90); | | X_1193 := algebra.join(X_1173,X_107); | | X_1210 := algebra.markT(X_1193,9,6); | | X_1230 := bat.reverse(X_1210); | | X_2091 := algebra.leftjoin(X_1230,X_1160); | | X_1248 := algebra.markT(X_1036,9,6); | | X_1268 := bat.reverse(X_1248); | | X_1323:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1268,X_971,X_867,X_1295); | | X_1376:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1268,X_971,X_867,X_1348); | | X_1429:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1268,X_971,X_867,X_1402); | | X_1483:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1268,X_971,X_867,X_1455); | | X_1536:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1268,X_971,X_867,X_1508); | | X_1547 := bat.reverse(X_933); | | X_1569 := algebra.markT(X_1547,9,6); | | X_1586 := bat.reverse(X_1569); | | X_1612:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1268,X_1586,X_140); | | X_1634:bat[:oid,:str] := algebra.leftjoinPath(X_2091,X_1268,X_1586,X_151); | | X_1655:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1090,X_161); | | X_1676:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1090,X_172); | | X_1697:bat[:oid,:str] := algebra.leftjoinPath(X_2091,X_1090,X_182); | | X_1718:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1090,X_194); | | X_1739:bat[:oid,:int] := algebra.leftjoinPath(X_2091,X_1090,X_203); | | X_526:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",0,7,8); | | X_773 := algebra.uselect(X_526,A0); | | X_539:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",2,7,8); | | X_784 := algebra.kdifference(X_773,X_539); | | X_794 := algebra.uselect(X_539,A0); | | X_806 := algebra.kunion(X_784,X_794); | | X_818 := algebra.kdifference(X_806,X_13); | | X_847 := algebra.markT(X_818,9,7); | | X_869 := bat.reverse(X_847); | | X_563:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",0,7,8); | | X_576:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",2,7,8); | | X_881 := algebra.kdifference(X_563,X_576); | | X_889 := algebra.kunion(X_881,X_576); | | X_904 := algebra.kdifference(X_889,X_13); | | X_920 := algebra.leftjoin(X_869,X_904); | | X_934 := algebra.join(X_920,X_32); | | X_958 := algebra.markT(X_934,9,7); | | X_972 := bat.reverse(X_958); | | X_2074 := algebra.leftjoin(X_972,X_869); | | X_600:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",0,7,8); | | X_613:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",2,7,8); | | X_988 := algebra.kdifference(X_600,X_613); | | X_997 := algebra.kunion(X_988,X_613); | | X_1007 := algebra.kdifference(X_997,X_38); | | X_1025:bat[:oid,:oid] := algebra.leftjoin(X_2074,X_1007); | | X_1037 := algebra.join(X_1025,X_54); | | X_638:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",0,7,8); | | X_650:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",2,7,8); | | X_1287 := algebra.kdifference(X_638,X_650); | | X_1296 := algebra.kunion(X_1287,X_650); | | X_1340 := algebra.kdifference(X_526,X_539); | | X_1349 := algebra.kunion(X_1340,X_539); | | X_676:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",0,7,8); | | X_687:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",2,7,8); | | X_1393 := algebra.kdifference(X_676,X_687); | | X_1403 := algebra.kunion(X_1393,X_687); | | X_713:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",0,7,8); | | X_724:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",2,7,8); | | X_1447 := algebra.kdifference(X_713,X_724); | | X_1456 := algebra.kunion(X_1447,X_724); | | X_750:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",0,7,8); | | X_761:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",2,7,8); | | X_1500 := algebra.kdifference(X_750,X_761); | | X_1509 := algebra.kunion(X_1500,X_761); | | X_1053 := bat.reverse(X_1037); | | X_1074 := algebra.markT(X_1053,9,7); | | X_1092 := bat.reverse(X_1074); | | X_1106 := algebra.leftjoin(X_1092,X_64); | | X_1123 := algebra.join(X_1106,X_80); | | X_1142 := algebra.markT(X_1123,9,7); | | X_1162 := bat.reverse(X_1142); | | X_2083 := algebra.leftjoin(X_1162,X_1092); | | X_1174:bat[:oid,:oid] := algebra.leftjoin(X_2083,X_90); | | X_1195 := algebra.join(X_1174,X_107); | | X_1212 := algebra.markT(X_1195,9,7); | | X_1232 := bat.reverse(X_1212); | | X_2092 := algebra.leftjoin(X_1232,X_1162); | | X_1250 := algebra.markT(X_1037,9,7); | | X_1270 := bat.reverse(X_1250); | | X_1324:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1270,X_972,X_869,X_1296); | | X_1377:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1270,X_972,X_869,X_1349); | | X_1430:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1270,X_972,X_869,X_1403); | | X_1484:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1270,X_972,X_869,X_1456); | | X_1537:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1270,X_972,X_869,X_1509); | | X_1548 := bat.reverse(X_934); | | X_1572 := algebra.markT(X_1548,9,7); | | X_1587 := bat.reverse(X_1572); | | X_1614:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1270,X_1587,X_140); | | X_1635:bat[:oid,:str] := algebra.leftjoinPath(X_2092,X_1270,X_1587,X_151); | | X_1656:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1092,X_161); | | X_1677:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1092,X_172); | | X_1698:bat[:oid,:str] := algebra.leftjoinPath(X_2092,X_1092,X_182); | | X_1719:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1092,X_194); | | X_1740:bat[:oid,:int] := algebra.leftjoinPath(X_2092,X_1092,X_203); | | X_9:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","archivo",1); | | X_11 := algebra.uselect(X_9,A0); | | X_820 := algebra.kdifference(X_11,X_13); | | X_850 := algebra.markT(X_820,9,8); | | X_870 := bat.reverse(X_850); | | X_15:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_archivo_fkey",1); | | X_905 := algebra.kdifference(X_15,X_13); | | X_922 := algebra.leftjoin(X_870,X_905); | | X_935 := algebra.join(X_922,X_32); | | X_961 := algebra.markT(X_935,9,8); | | X_973 := bat.reverse(X_961); | | X_2075 := algebra.leftjoin(X_973,X_870); | | X_35:bat[:oid,:oid] := sql.bind_idxbat(X_3,"sys","comunidades_archivo","comunidades_archivo_prod_propio_id_fkey",1); | | X_1008 := algebra.kdifference(X_35,X_38); | | X_1026:bat[:oid,:oid] := algebra.leftjoin(X_2075,X_1008); | | X_1038 := algebra.join(X_1026,X_54); | | X_110:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","id",1); | | X_118:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","comunidad",1); | | X_123:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","cod_propio",1); | | X_129:bat[:oid,:int] := sql.bind(X_3,"sys","comunidades_archivo","prod_propio_id",1); | | X_1055 := bat.reverse(X_1038); | | X_1076 := algebra.markT(X_1055,9,8); | | X_1095 := bat.reverse(X_1076); | | X_1107 := algebra.leftjoin(X_1095,X_64); | | X_1125 := algebra.join(X_1107,X_80); | | X_1145 := algebra.markT(X_1125,9,8); | | X_1163 := bat.reverse(X_1145); | | X_2084 := algebra.leftjoin(X_1163,X_1095); | | X_1176:bat[:oid,:oid] := algebra.leftjoin(X_2084,X_90); | | X_1196 := algebra.join(X_1176,X_107); | | X_1215 := algebra.markT(X_1196,9,8); | | X_1233 := bat.reverse(X_1215); | | X_2093 := algebra.leftjoin(X_1233,X_1163); | | X_1253 := algebra.markT(X_1038,9,8); | | X_1271 := bat.reverse(X_1253); | | X_1325:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1271,X_973,X_870,X_110); | | X_1378:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1271,X_973,X_870,X_9); | | X_1431:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1271,X_973,X_870,X_118); | | X_1485:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1271,X_973,X_870,X_123); | | X_1538:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1271,X_973,X_870,X_129); | | X_1549 := bat.reverse(X_935); | | X_1576 := algebra.markT(X_1549,9,8); | | X_1588 := bat.reverse(X_1576); | | X_1615:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1271,X_1588,X_140); | | X_1637:bat[:oid,:str] := algebra.leftjoinPath(X_2093,X_1271,X_1588,X_151); | | X_1658:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1095,X_161); | | X_1679:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1095,X_172); | | X_1700:bat[:oid,:str] := algebra.leftjoinPath(X_2093,X_1095,X_182); | | X_1721:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1095,X_194); | | X_1742:bat[:oid,:int] := algebra.leftjoinPath(X_2093,X_1095,X_203); | | X_111 := mat.pack(X_1316,X_1318,X_1319,X_1320,X_1321,X_1322,X_1323,X_1324,X_1325); | | X_1842 := bat.reverse(X_1196); | | X_1870 := algebra.markT(X_1842,9,8); | | X_1881 := bat.reverse(X_1870); | | X_356:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prov_id",0); | | X_358:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prov_id",2); | | X_359 := algebra.kdifference(X_356,X_358); | | X_360 := algebra.kunion(X_359,X_358); | | X_361:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prov_id",1); | | X_363 := algebra.kunion(X_360,X_361); | | X_2066 := algebra.leftjoin(X_1881,X_363); | | X_1840 := bat.reverse(X_1195); | | X_1868 := algebra.markT(X_1840,9,7); | | X_1879 := bat.reverse(X_1868); | | X_2065 := algebra.leftjoin(X_1879,X_363); | | X_1839 := bat.reverse(X_1193); | | X_1863 := algebra.markT(X_1839,9,6); | | X_1878 := bat.reverse(X_1863); | | X_2063 := algebra.leftjoin(X_1878,X_363); | | X_1838 := bat.reverse(X_1191); | | X_1860 := algebra.markT(X_1838,9,5); | | X_1877 := bat.reverse(X_1860); | | X_2062 := algebra.leftjoin(X_1877,X_363); | | X_1837 := bat.reverse(X_1189); | | X_1857 := algebra.markT(X_1837,9,4); | | X_1876 := bat.reverse(X_1857); | | X_2061 := algebra.leftjoin(X_1876,X_363); | | X_1836 := bat.reverse(X_1186); | | X_1854 := algebra.markT(X_1836,9,3); | | X_1875 := bat.reverse(X_1854); | | X_2060 := algebra.leftjoin(X_1875,X_363); | | X_1835 := bat.reverse(X_1184); | | X_1850 := algebra.markT(X_1835,9,2); | | X_1874 := bat.reverse(X_1850); | | X_2059 := algebra.leftjoin(X_1874,X_363); | | X_1834 := bat.reverse(X_1182); | | X_1847 := algebra.markT(X_1834,9,1); | | X_1873 := bat.reverse(X_1847); | | X_2058 := algebra.leftjoin(X_1873,X_363); | | X_1831 := bat.reverse(X_1180); | | X_1844 := algebra.markT(X_1831,9,0); | | X_1872 := bat.reverse(X_1844); | | X_2057 := algebra.leftjoin(X_1872,X_363); | | X_344:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_area_negocio",0); | | X_347:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_area_negocio",2); | | X_350 := algebra.kdifference(X_344,X_347); | | X_351 := algebra.kunion(X_350,X_347); | | X_352:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_area_negocio",1); | | X_354 := algebra.kunion(X_351,X_352); | | X_2054 := algebra.leftjoin(X_1881,X_354); | | X_2053 := algebra.leftjoin(X_1879,X_354); | | X_2052 := algebra.leftjoin(X_1878,X_354); | | X_2050 := algebra.leftjoin(X_1877,X_354); | | X_2048 := algebra.leftjoin(X_1876,X_354); | | X_2046 := algebra.leftjoin(X_1875,X_354); | | X_2044 := algebra.leftjoin(X_1874,X_354); | | X_2042 := algebra.leftjoin(X_1873,X_354); | | X_2040 := algebra.leftjoin(X_1872,X_354); | | X_335:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_todo",0); | | X_338:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_todo",2); | | X_339 := algebra.kdifference(X_335,X_338); | | X_340 := algebra.kunion(X_339,X_338); | | X_341:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_todo",1); | | X_342 := algebra.kunion(X_340,X_341); | | X_2037 := algebra.leftjoin(X_1881,X_342); | | X_2035 := algebra.leftjoin(X_1879,X_342); | | X_2034 := algebra.leftjoin(X_1878,X_342); | | X_2033 := algebra.leftjoin(X_1877,X_342); | | X_2032 := algebra.leftjoin(X_1876,X_342); | | X_2031 := algebra.leftjoin(X_1875,X_342); | | X_2030 := algebra.leftjoin(X_1874,X_342); | | X_2029 := algebra.leftjoin(X_1873,X_342); | | X_2028 := algebra.leftjoin(X_1872,X_342); | | X_327:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_fvt",0); | | X_329:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_fvt",2); | | X_330 := algebra.kdifference(X_327,X_329); | | X_331 := algebra.kunion(X_330,X_329); | | X_332:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_fvt",1); | | X_333 := algebra.kunion(X_331,X_332); | | X_2027 := algebra.leftjoin(X_1881,X_333); | | X_2026 := algebra.leftjoin(X_1879,X_333); | | X_2024 := algebra.leftjoin(X_1878,X_333); | | X_2023 := algebra.leftjoin(X_1877,X_333); | | X_2022 := algebra.leftjoin(X_1876,X_333); | | X_2021 := algebra.leftjoin(X_1875,X_333); | | X_2020 := algebra.leftjoin(X_1874,X_333); | | X_2019 := algebra.leftjoin(X_1873,X_333); | | X_2018 := algebra.leftjoin(X_1872,X_333); | | X_315:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_umb",0); | | X_318:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_umb",2); | | X_320 := algebra.kdifference(X_315,X_318); | | X_321 := algebra.kunion(X_320,X_318); | | X_322:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_umb",1); | | X_324 := algebra.kunion(X_321,X_322); | | X_2015 := algebra.leftjoin(X_1881,X_324); | | X_2014 := algebra.leftjoin(X_1879,X_324); | | X_2013 := algebra.leftjoin(X_1878,X_324); | | X_2011 := algebra.leftjoin(X_1877,X_324); | | X_2009 := algebra.leftjoin(X_1876,X_324); | | X_2007 := algebra.leftjoin(X_1875,X_324); | | X_2005 := algebra.leftjoin(X_1874,X_324); | | X_2003 := algebra.leftjoin(X_1873,X_324); | | X_2001 := algebra.leftjoin(X_1872,X_324); | | X_306:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_cis",0); | | X_308:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_cis",2); | | X_309 := algebra.kdifference(X_306,X_308); | | X_310 := algebra.kunion(X_309,X_308); | | X_311:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_cis",1); | | X_313 := algebra.kunion(X_310,X_311); | | X_1998 := algebra.leftjoin(X_1881,X_313); | | X_1996 := algebra.leftjoin(X_1879,X_313); | | X_1995 := algebra.leftjoin(X_1878,X_313); | | X_1994 := algebra.leftjoin(X_1877,X_313); | | X_1993 := algebra.leftjoin(X_1876,X_313); | | X_1992 := algebra.leftjoin(X_1875,X_313); | | X_1991 := algebra.leftjoin(X_1874,X_313); | | X_1990 := algebra.leftjoin(X_1873,X_313); | | X_1989 := algebra.leftjoin(X_1872,X_313); | | X_297:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_proveedor_nombre",0); | | X_299:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_proveedor_nombre",2); | | X_301 := algebra.kdifference(X_297,X_299); | | X_302 := algebra.kunion(X_301,X_299); | | X_303:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_proveedor_nombre",1); | | X_304 := algebra.kunion(X_302,X_303); | | X_1988 := algebra.leftjoin(X_1881,X_304); | | X_1987 := algebra.leftjoin(X_1879,X_304); | | X_1985 := algebra.leftjoin(X_1878,X_304); | | X_1984 := algebra.leftjoin(X_1877,X_304); | | X_1983 := algebra.leftjoin(X_1876,X_304); | | X_1982 := algebra.leftjoin(X_1875,X_304); | | X_1981 := algebra.leftjoin(X_1874,X_304); | | X_1980 := algebra.leftjoin(X_1873,X_304); | | X_1979 := algebra.leftjoin(X_1872,X_304); | | X_285:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_proveedor_rut",0); | | X_289:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_proveedor_rut",2); | | X_291 := algebra.kdifference(X_285,X_289); | | X_292 := algebra.kunion(X_291,X_289); | | X_293:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_proveedor_rut",1); | | X_295 := algebra.kunion(X_292,X_293); | | X_1976 := algebra.leftjoin(X_1881,X_295); | | X_1975 := algebra.leftjoin(X_1879,X_295); | | X_1974 := algebra.leftjoin(X_1878,X_295); | | X_1972 := algebra.leftjoin(X_1877,X_295); | | X_1970 := algebra.leftjoin(X_1876,X_295); | | X_1968 := algebra.leftjoin(X_1875,X_295); | | X_1966 := algebra.leftjoin(X_1874,X_295); | | X_1964 := algebra.leftjoin(X_1873,X_295); | | X_1962 := algebra.leftjoin(X_1872,X_295); | | X_277:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_sublinea",0); | | X_279:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_sublinea",2); | | X_280 := algebra.kdifference(X_277,X_279); | | X_281 := algebra.kunion(X_280,X_279); | | X_282:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_sublinea",1); | | X_283 := algebra.kunion(X_281,X_282); | | X_1959 := algebra.leftjoin(X_1881,X_283); | | X_1957 := algebra.leftjoin(X_1879,X_283); | | X_1956 := algebra.leftjoin(X_1878,X_283); | | X_1955 := algebra.leftjoin(X_1877,X_283); | | X_1954 := algebra.leftjoin(X_1876,X_283); | | X_1953 := algebra.leftjoin(X_1875,X_283); | | X_1952 := algebra.leftjoin(X_1874,X_283); | | X_1951 := algebra.leftjoin(X_1873,X_283); | | X_1950 := algebra.leftjoin(X_1872,X_283); | | X_268:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_linea",0); | | X_270:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_linea",2); | | X_271 := algebra.kdifference(X_268,X_270); | | X_272 := algebra.kunion(X_271,X_270); | | X_273:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_linea",1); | | X_274 := algebra.kunion(X_272,X_273); | | X_1949 := algebra.leftjoin(X_1881,X_274); | | X_1948 := algebra.leftjoin(X_1879,X_274); | | X_1946 := algebra.leftjoin(X_1878,X_274); | | X_1945 := algebra.leftjoin(X_1877,X_274); | | X_1944 := algebra.leftjoin(X_1876,X_274); | | X_1943 := algebra.leftjoin(X_1875,X_274); | | X_1942 := algebra.leftjoin(X_1874,X_274); | | X_1941 := algebra.leftjoin(X_1873,X_274); | | X_1940 := algebra.leftjoin(X_1872,X_274); | | X_256:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_familia",0); | | X_259:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_familia",2); | | X_261 := algebra.kdifference(X_256,X_259); | | X_262 := algebra.kunion(X_261,X_259); | | X_263:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_familia",1); | | X_266 := algebra.kunion(X_262,X_263); | | X_1937 := algebra.leftjoin(X_1881,X_266); | | X_1936 := algebra.leftjoin(X_1879,X_266); | | X_1935 := algebra.leftjoin(X_1878,X_266); | | X_1933 := algebra.leftjoin(X_1877,X_266); | | X_1931 := algebra.leftjoin(X_1876,X_266); | | X_1929 := algebra.leftjoin(X_1875,X_266); | | X_1927 := algebra.leftjoin(X_1874,X_266); | | X_1925 := algebra.leftjoin(X_1873,X_266); | | X_1923 := algebra.leftjoin(X_1872,X_266); | | X_247:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_nombre",0); | | X_249:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_nombre",2); | | X_250 := algebra.kdifference(X_247,X_249); | | X_251 := algebra.kunion(X_250,X_249); | | X_252:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_nombre",1); | | X_254 := algebra.kunion(X_251,X_252); | | X_1920 := algebra.leftjoin(X_1881,X_254); | | X_1918 := algebra.leftjoin(X_1879,X_254); | | X_1917 := algebra.leftjoin(X_1878,X_254); | | X_1916 := algebra.leftjoin(X_1877,X_254); | | X_1915 := algebra.leftjoin(X_1876,X_254); | | X_1914 := algebra.leftjoin(X_1875,X_254); | | X_1913 := algebra.leftjoin(X_1874,X_254); | | X_1912 := algebra.leftjoin(X_1873,X_254); | | X_1911 := algebra.leftjoin(X_1872,X_254); | | X_238:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_nkey",0); | | X_241:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_nkey",2); | | X_242 := algebra.kdifference(X_238,X_241); | | X_243 := algebra.kunion(X_242,X_241); | | X_244:bat[:oid,:str] := sql.bind(X_3,"sys","dim_producto","prod_nkey",1); | | X_245 := algebra.kunion(X_243,X_244); | | X_1910 := algebra.leftjoin(X_1881,X_245); | | X_1909 := algebra.leftjoin(X_1879,X_245); | | X_1907 := algebra.leftjoin(X_1878,X_245); | | X_1906 := algebra.leftjoin(X_1877,X_245); | | X_1905 := algebra.leftjoin(X_1876,X_245); | | X_1904 := algebra.leftjoin(X_1875,X_245); | | X_1903 := algebra.leftjoin(X_1874,X_245); | | X_1902 := algebra.leftjoin(X_1873,X_245); | | X_1901 := algebra.leftjoin(X_1872,X_245); | | X_226:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prod_id",0); | | X_230:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prod_id",2); | | X_232 := algebra.kdifference(X_226,X_230); | | X_233 := algebra.kunion(X_232,X_230); | | X_234:bat[:oid,:int] := sql.bind(X_3,"sys","dim_producto","prod_id",1); | | X_236 := algebra.kunion(X_233,X_234); | | X_1898 := algebra.leftjoin(X_1881,X_236); | | X_1897 := algebra.leftjoin(X_1879,X_236); | | X_1896 := algebra.leftjoin(X_1878,X_236); | | X_1894 := algebra.leftjoin(X_1877,X_236); | | X_1892 := algebra.leftjoin(X_1876,X_236); | | X_1890 := algebra.leftjoin(X_1875,X_236); | | X_1888 := algebra.leftjoin(X_1874,X_236); | | X_1886 := algebra.leftjoin(X_1873,X_236); | | X_1884 := algebra.leftjoin(X_1872,X_236); | | X_1754 := bat.reverse(X_1125); | | X_1782 := algebra.markT(X_1754,9,8); | | X_1793 := bat.reverse(X_1782); | | X_2102 := algebra.leftjoin(X_1233,X_1793); | | X_205:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_productos","id",0); | | X_209:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_productos","id",2); | | X_211 := algebra.kdifference(X_205,X_209); | | X_212 := algebra.kunion(X_211,X_209); | | X_213:bat[:oid,:int] := sql.bind(X_3,"sys","archivo_productos","id",1); | | X_215 := algebra.kunion(X_212,X_213); | | X_1812:bat[:oid,:int] := algebra.leftjoin(X_2102,X_215); | | X_217:bat[:oid,:str] := sql.bind(X_3,"sys","archivo_productos","productos",0); | | X_220:bat[:oid,:str] := sql.bind(X_3,"sys","archivo_productos","productos",2); | | X_221 := algebra.kdifference(X_217,X_220); | | X_222 := algebra.kunion(X_221,X_220); | | X_223:bat[:oid,:str] := sql.bind(X_3,"sys","archivo_productos","productos",1); | | X_224 := algebra.kunion(X_222,X_223); | | X_1830:bat[:oid,:str] := algebra.leftjoin(X_2102,X_224); | | X_1753 := bat.reverse(X_1123); | | X_1777 := algebra.markT(X_1753,9,7); | | X_1792 := bat.reverse(X_1777); | | X_2101 := algebra.leftjoin(X_1232,X_1792); | | X_1810:bat[:oid,:int] := algebra.leftjoin(X_2101,X_215); | | X_1829:bat[:oid,:str] := algebra.leftjoin(X_2101,X_224); | | X_1752 := bat.reverse(X_1121); | | X_1774 := algebra.markT(X_1752,9,6); | | X_1791 := bat.reverse(X_1774); | | X_2100 := algebra.leftjoin(X_1230,X_1791); | | X_1809:bat[:oid,:int] := algebra.leftjoin(X_2100,X_215); | | X_1827:bat[:oid,:str] := algebra.leftjoin(X_2100,X_224); | | X_1751 := bat.reverse(X_1119); | | X_1771 := algebra.markT(X_1751,9,5); | | X_1790 := bat.reverse(X_1771); | | X_2099 := algebra.leftjoin(X_1228,X_1790); | | X_1808:bat[:oid,:int] := algebra.leftjoin(X_2099,X_215); | | X_1825:bat[:oid,:str] := algebra.leftjoin(X_2099,X_224); | | X_1750 := bat.reverse(X_1117); | | X_1768 := algebra.markT(X_1750,9,4); | | X_1789 := bat.reverse(X_1768); | | X_2098 := algebra.leftjoin(X_1226,X_1789); | | X_1807:bat[:oid,:int] := algebra.leftjoin(X_2098,X_215); | | X_1823:bat[:oid,:str] := algebra.leftjoin(X_2098,X_224); | | X_1749 := bat.reverse(X_1115); | | X_1765 := algebra.markT(X_1749,9,3); | | X_1788 := bat.reverse(X_1765); | | X_2097 := algebra.leftjoin(X_1224,X_1788); | | X_1806:bat[:oid,:int] := algebra.leftjoin(X_2097,X_215); | | X_1821:bat[:oid,:str] := algebra.leftjoin(X_2097,X_224); | | X_1748 := bat.reverse(X_1113); | | X_1762 := algebra.markT(X_1748,9,2); | | X_1787 := bat.reverse(X_1762); | | X_2096 := algebra.leftjoin(X_1222,X_1787); | | X_1805:bat[:oid,:int] := algebra.leftjoin(X_2096,X_215); | | X_1819:bat[:oid,:str] := algebra.leftjoin(X_2096,X_224); | | X_1747 := bat.reverse(X_1111); | | X_1759 := algebra.markT(X_1747,9,1); | | X_1786 := bat.reverse(X_1759); | | X_2095 := algebra.leftjoin(X_1220,X_1786); | | X_1804:bat[:oid,:int] := algebra.leftjoin(X_2095,X_215); | | X_1817:bat[:oid,:str] := algebra.leftjoin(X_2095,X_224); | | X_1744 := bat.reverse(X_1110); | | X_1755 := algebra.markT(X_1744,9,0); | | X_1785 := bat.reverse(X_1755); | | X_2094 := algebra.leftjoin(X_1218,X_1785); | | X_1802:bat[:oid,:int] := algebra.leftjoin(X_2094,X_215); | | X_1815:bat[:oid,:str] := algebra.leftjoin(X_2094,X_224); | | exit X_2103; | | X_365 := sql.resultSet(28,1,X_111); | | sql.rsColumn(X_365,"sys.comunidades_archivo","id","int",32,0,X_111); | | X_113 := mat.pack(X_1370,X_1371,X_1372,X_1373,X_1374,X_1375,X_1376,X_1377,X_1378); | | sql.rsColumn(X_365,"sys.comunidades_archivo","archivo","int",32,0,X_113); | | X_120 := mat.pack(X_1423,X_1424,X_1425,X_1426,X_1427,X_1428,X_1429,X_1430,X_1431); | | sql.rsColumn(X_365,"sys.comunidades_archivo","comunidad","int",32,0,X_120); | | X_124 := mat.pack(X_1476,X_1478,X_1479,X_1480,X_1481,X_1482,X_1483,X_1484,X_1485); | | sql.rsColumn(X_365,"sys.comunidades_archivo","cod_propio","int",32,0,X_124); | | X_131 := mat.pack(X_1530,X_1531,X_1532,X_1533,X_1534,X_1535,X_1536,X_1537,X_1538); | | sql.rsColumn(X_365,"sys.comunidades_archivo","prod_propio_id","int",32,0,X_131); | | X_141 := mat.pack(X_1600,X_1602,X_1604,X_1606,X_1608,X_1610,X_1612,X_1614,X_1615); | | sql.rsColumn(X_365,"sys.archivo_com_traslapadas","id","int",32,0,X_141); | | X_152 := mat.pack(X_1628,X_1629,X_1630,X_1631,X_1632,X_1633,X_1634,X_1635,X_1637); | | sql.rsColumn(X_365,"sys.archivo_com_traslapadas","comunidad_traslapada","varchar",200,0,X_152); | | X_162 := mat.pack(X_1649,X_1650,X_1651,X_1652,X_1653,X_1654,X_1655,X_1656,X_1658); | | sql.rsColumn(X_365,"sys.productos_propios","id","int",32,0,X_162); | | X_174 := mat.pack(X_1670,X_1671,X_1672,X_1673,X_1674,X_1675,X_1676,X_1677,X_1679); | | sql.rsColumn(X_365,"sys.productos_propios","nombre_archivo","int",32,0,X_174); | | X_183 := mat.pack(X_1691,X_1692,X_1693,X_1694,X_1695,X_1696,X_1697,X_1698,X_1700); | | sql.rsColumn(X_365,"sys.productos_propios","nombre_producto","varchar",200,0,X_183); | | X_195 := mat.pack(X_1712,X_1713,X_1714,X_1715,X_1716,X_1717,X_1718,X_1719,X_1721); | | sql.rsColumn(X_365,"sys.productos_propios","prod_id","int",32,0,X_195); | | X_204 := mat.pack(X_1733,X_1734,X_1735,X_1736,X_1737,X_1738,X_1739,X_1740,X_1742); | | sql.rsColumn(X_365,"sys.productos_propios","cod_propio","int",32,0,X_204); | | X_216 := mat.pack(X_1802,X_1804,X_1805,X_1806,X_1807,X_1808,X_1809,X_1810,X_1812); | | sql.rsColumn(X_365,"sys.archivo_productos","id","int",32,0,X_216); | | X_225 := mat.pack(X_1815,X_1817,X_1819,X_1821,X_1823,X_1825,X_1827,X_1829,X_1830); | | sql.rsColumn(X_365,"sys.archivo_productos","productos","varchar",200,0,X_225); | | X_237 := mat.pack(X_1884,X_1886,X_1888,X_1890,X_1892,X_1894,X_1896,X_1897,X_1898); | | sql.rsColumn(X_365,"sys.dim_producto","prod_id","int",32,0,X_237); | | X_246 := mat.pack(X_1901,X_1902,X_1903,X_1904,X_1905,X_1906,X_1907,X_1909,X_1910); | | sql.rsColumn(X_365,"sys.dim_producto","prod_nkey","varchar",18,0,X_246); | | X_255 := mat.pack(X_1911,X_1912,X_1913,X_1914,X_1915,X_1916,X_1917,X_1918,X_1920); | | sql.rsColumn(X_365,"sys.dim_producto","prod_nombre","varchar",100,0,X_255); | | X_267 := mat.pack(X_1923,X_1925,X_1927,X_1929,X_1931,X_1933,X_1935,X_1936,X_1937); | | sql.rsColumn(X_365,"sys.dim_producto","prod_familia","varchar",100,0,X_267); | | X_275 := mat.pack(X_1940,X_1941,X_1942,X_1943,X_1944,X_1945,X_1946,X_1948,X_1949); | | sql.rsColumn(X_365,"sys.dim_producto","prod_linea","varchar",100,0,X_275); | | X_284 := mat.pack(X_1950,X_1951,X_1952,X_1953,X_1954,X_1955,X_1956,X_1957,X_1959); | | sql.rsColumn(X_365,"sys.dim_producto","prod_sublinea","varchar",100,0,X_284); | | X_296 := mat.pack(X_1962,X_1964,X_1966,X_1968,X_1970,X_1972,X_1974,X_1975,X_1976); | | sql.rsColumn(X_365,"sys.dim_producto","prod_proveedor_rut","varchar",13,0,X_296); | | X_305 := mat.pack(X_1979,X_1980,X_1981,X_1982,X_1983,X_1984,X_1985,X_1987,X_1988); | | sql.rsColumn(X_365,"sys.dim_producto","prod_proveedor_nombre","varchar",100,0,X_305); | | X_314 := mat.pack(X_1989,X_1990,X_1991,X_1992,X_1993,X_1994,X_1995,X_1996,X_1998); | | sql.rsColumn(X_365,"sys.dim_producto","prod_cis","varchar",100,0,X_314); | | X_325 := mat.pack(X_2001,X_2003,X_2005,X_2007,X_2009,X_2011,X_2013,X_2014,X_2015); | | sql.rsColumn(X_365,"sys.dim_producto","prod_umb","varchar",100,0,X_325); | | X_334 := mat.pack(X_2018,X_2019,X_2020,X_2021,X_2022,X_2023,X_2024,X_2026,X_2027); | | sql.rsColumn(X_365,"sys.dim_producto","prod_fvt","varchar",100,0,X_334); | | X_343 := mat.pack(X_2028,X_2029,X_2030,X_2031,X_2032,X_2033,X_2034,X_2035,X_2037); | | sql.rsColumn(X_365,"sys.dim_producto","prod_todo","varchar",100,0,X_343); | | X_355 := mat.pack(X_2040,X_2042,X_2044,X_2046,X_2048,X_2050,X_2052,X_2053,X_2054); | | sql.rsColumn(X_365,"sys.dim_producto","prod_area_negocio","varchar",255,0,X_355); | | X_364 := mat.pack(X_2057,X_2058,X_2059,X_2060,X_2061,X_2062,X_2063,X_2065,X_2066); | | sql.rsColumn(X_365,"sys.dim_producto","prov_id","int",32,0,X_364); | | X_436 := io.stdout(); | | sql.exportResult(X_436,X_365); | | end s1_2; | +--------------------------------------------------------------------------------------------------------------------------------+ 1357 tuples (2.7s) sql>