API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 27th, 2017
69
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 33.49 KB | None | 0 0
raw download clone embed print report
  1. INFO - EJBContainer already initialized.  CALL ejbContainer.close() TO allow reinitialization
  2. Hibernate:
  3.     /* load ru.simplgroupp.persistence.CreditEntity */ SELECT
  4.         creditenti0_.id AS id1_39_33_,
  5.         creditenti0_.txVersion AS txVersio2_39_33_,
  6.         creditenti0_.bankname AS bankname3_39_33_,
  7.         creditenti0_.creditdatabeg AS creditda4_39_33_,
  8.         creditenti0_.creditdataend AS creditda5_39_33_,
  9.         creditenti0_.creditDateDebt AS creditDa6_39_33_,
  10.         creditenti0_.dateStopCalc AS dateStop7_39_33_,
  11.         creditenti0_.descStopCalc AS descStop8_39_33_,
  12.         creditenti0_.creditsum AS creditsu9_39_33_,
  13.         creditenti0_.creditSumPaid AS creditS10_39_33_,
  14.         creditenti0_.creditMonthlyPayment AS creditM11_39_33_,
  15.         creditenti0_.creditAccount AS creditA12_39_33_,
  16.         creditenti0_.creditmoneyback AS creditm13_39_33_,
  17.         creditenti0_.creditlimitunused AS creditl14_39_33_,
  18.         creditenti0_.creditlong AS creditl15_39_33_,
  19.         creditenti0_.creditsumback AS credits16_39_33_,
  20.         creditenti0_.creditFullCost AS creditF17_39_33_,
  21.         creditenti0_.isover AS isover18_39_33_,
  22.         creditenti0_.maxDelay AS maxDela19_39_33_,
  23.         creditenti0_.id_credit AS id_cred20_39_33_,
  24.         creditenti0_.creditcardlimit AS creditc21_39_33_,
  25.         creditenti0_.issameorg AS issameo22_39_33_,
  26.         creditenti0_.creditsumdebt AS credits23_39_33_,
  27.         creditenti0_.creditpercent AS creditp24_39_33_,
  28.         creditenti0_.delay5 AS delay25_39_33_,
  29.         creditenti0_.delay30 AS delay26_39_33_,
  30.         creditenti0_.delay60 AS delay27_39_33_,
  31.         creditenti0_.delay90 AS delay28_39_33_,
  32.         creditenti0_.delay120 AS delay29_39_33_,
  33.         creditenti0_.delaymore AS delaymo30_39_33_,
  34.         creditenti0_.isactive AS isactiv31_39_33_,
  35.         creditenti0_.currentDebt AS current32_39_33_,
  36.         creditenti0_.maxOverdueDebt AS maxOver33_39_33_,
  37.         creditenti0_.currentOverdueDebt AS current34_39_33_,
  38.         creditenti0_.delayindays AS delayin35_39_33_,
  39.         creditenti0_.payDiscipline AS payDisc36_39_33_,
  40.         creditenti0_.isUploaded AS isUploa37_39_33_,
  41.         creditenti0_.changedSum AS changed38_39_33_,
  42.         creditenti0_.isReceived AS isRecei39_39_33_,
  43.         creditenti0_.datelastupdate AS datelas40_39_33_,
  44.         creditenti0_.creditdataendfact AS creditd41_39_33_,
  45.         creditenti0_.dateStatus AS dateSta42_39_33_,
  46.         creditenti0_.owner AS owner43_39_33_,
  47.         creditenti0_.accounttype_id AS account44_39_33_,
  48.         creditenti0_.creditorganization_id AS credito45_39_33_,
  49.         creditenti0_.credittype_id AS creditt46_39_33_,
  50.         creditenti0_.creditrelation_id AS creditr47_39_33_,
  51.         creditenti0_.creditfreqpayment_id AS creditf48_39_33_,
  52.         creditenti0_.creditstatus_id AS credits49_39_33_,
  53.         creditenti0_.creditpurpose_id AS creditp50_39_33_,
  54.         creditenti0_.overduestate_id AS overdue51_39_33_,
  55.         creditenti0_.worstoverduestate_id AS worstov52_39_33_,
  56.         creditenti0_.worstoverduestate12_id AS worstov53_39_33_,
  57.         creditenti0_.id_currency AS id_curr54_39_33_,
  58.         creditenti0_.peoplemain_id AS peoplem55_39_33_,
  59.         creditenti0_.partners_id AS partner56_39_33_,
  60.         creditenti0_.creditrequest_id AS creditr57_39_33_,
  61.         creditenti0_.products_id AS product58_39_33_,
  62.         referencee1_.id AS id1_108_0_,
  63.         referencee1_.txVersion AS txVersio2_108_0_,
  64.         referencee1_.code AS code3_108_0_,
  65.         referencee1_.codemain AS codemain4_108_0_,
  66.         referencee1_.name AS name5_108_0_,
  67.         referencee1_.codeinteger AS codeinte6_108_0_,
  68.         referencee1_.codeintegermain AS codeinte7_108_0_,
  69.         referencee1_.isactive AS isactive8_108_0_,
  70.         referencee1_.parent_id AS parent_i9_108_0_,
  71.         referencee1_.ref_header_id AS ref_hea10_108_0_,
  72.         referencee1_.ref_header_idmain AS ref_hea11_108_0_,
  73.         organizati2_.id AS id1_67_1_,
  74.         organizati2_.txVersion AS txVersio2_67_1_,
  75.         organizati2_.inn AS inn3_67_1_,
  76.         organizati2_.ogrn AS ogrn4_67_1_,
  77.         organizati2_.name AS name5_67_1_,
  78.         organizati2_.phone AS phone6_67_1_,
  79.         organizati2_.freePhone AS freePhon7_67_1_,
  80.         organizati2_.notificationPhone AS notifica8_67_1_,
  81.         organizati2_.email AS email9_67_1_,
  82.         organizati2_.kpp AS kpp10_67_1_,
  83.         organizati2_.isCreditOrg AS isCredi11_67_1_,
  84.         organizati2_.isactive AS isactiv12_67_1_,
  85.         organizati2_.reg_country AS reg_cou13_67_1_,
  86.         organizati2_.reg_city AS reg_cit14_67_1_,
  87.         organizati2_.reg_address AS reg_add15_67_1_,
  88.         organizati2_.databeg AS databeg16_67_1_,
  89.         organizati2_.dataend AS dataend17_67_1_,
  90.         organizati2_.partners_id AS partner18_67_1_,
  91.         organizati2_.orgtype_id AS orgtype19_67_1_,
  92.         referencee3_.id AS id1_108_2_,
  93.         referencee3_.txVersion AS txVersio2_108_2_,
  94.         referencee3_.code AS code3_108_2_,
  95.         referencee3_.codemain AS codemain4_108_2_,
  96.         referencee3_.name AS name5_108_2_,
  97.         referencee3_.codeinteger AS codeinte6_108_2_,
  98.         referencee3_.codeintegermain AS codeinte7_108_2_,
  99.         referencee3_.isactive AS isactive8_108_2_,
  100.         referencee3_.parent_id AS parent_i9_108_2_,
  101.         referencee3_.ref_header_id AS ref_hea10_108_2_,
  102.         referencee3_.ref_header_idmain AS ref_hea11_108_2_,
  103.         referencee4_.id AS id1_108_3_,
  104.         referencee4_.txVersion AS txVersio2_108_3_,
  105.         referencee4_.code AS code3_108_3_,
  106.         referencee4_.codemain AS codemain4_108_3_,
  107.         referencee4_.name AS name5_108_3_,
  108.         referencee4_.codeinteger AS codeinte6_108_3_,
  109.         referencee4_.codeintegermain AS codeinte7_108_3_,
  110.         referencee4_.isactive AS isactive8_108_3_,
  111.         referencee4_.parent_id AS parent_i9_108_3_,
  112.         referencee4_.ref_header_id AS ref_hea10_108_3_,
  113.         referencee4_.ref_header_idmain AS ref_hea11_108_3_,
  114.         referencee5_.id AS id1_108_4_,
  115.         referencee5_.txVersion AS txVersio2_108_4_,
  116.         referencee5_.code AS code3_108_4_,
  117.         referencee5_.codemain AS codemain4_108_4_,
  118.         referencee5_.name AS name5_108_4_,
  119.         referencee5_.codeinteger AS codeinte6_108_4_,
  120.         referencee5_.codeintegermain AS codeinte7_108_4_,
  121.         referencee5_.isactive AS isactive8_108_4_,
  122.         referencee5_.parent_id AS parent_i9_108_4_,
  123.         referencee5_.ref_header_id AS ref_hea10_108_4_,
  124.         referencee5_.ref_header_idmain AS ref_hea11_108_4_,
  125.         referencee6_.id AS id1_108_5_,
  126.         referencee6_.txVersion AS txVersio2_108_5_,
  127.         referencee6_.code AS code3_108_5_,
  128.         referencee6_.codemain AS codemain4_108_5_,
  129.         referencee6_.name AS name5_108_5_,
  130.         referencee6_.codeinteger AS codeinte6_108_5_,
  131.         referencee6_.codeintegermain AS codeinte7_108_5_,
  132.         referencee6_.isactive AS isactive8_108_5_,
  133.         referencee6_.parent_id AS parent_i9_108_5_,
  134.         referencee6_.ref_header_id AS ref_hea10_108_5_,
  135.         referencee6_.ref_header_idmain AS ref_hea11_108_5_,
  136.         referencee7_.id AS id1_108_6_,
  137.         referencee7_.txVersion AS txVersio2_108_6_,
  138.         referencee7_.code AS code3_108_6_,
  139.         referencee7_.codemain AS codemain4_108_6_,
  140.         referencee7_.name AS name5_108_6_,
  141.         referencee7_.codeinteger AS codeinte6_108_6_,
  142.         referencee7_.codeintegermain AS codeinte7_108_6_,
  143.         referencee7_.isactive AS isactive8_108_6_,
  144.         referencee7_.parent_id AS parent_i9_108_6_,
  145.         referencee7_.ref_header_id AS ref_hea10_108_6_,
  146.         referencee7_.ref_header_idmain AS ref_hea11_108_6_,
  147.         referencee8_.id AS id1_108_7_,
  148.         referencee8_.txVersion AS txVersio2_108_7_,
  149.         referencee8_.code AS code3_108_7_,
  150.         referencee8_.codemain AS codemain4_108_7_,
  151.         referencee8_.name AS name5_108_7_,
  152.         referencee8_.codeinteger AS codeinte6_108_7_,
  153.         referencee8_.codeintegermain AS codeinte7_108_7_,
  154.         referencee8_.isactive AS isactive8_108_7_,
  155.         referencee8_.parent_id AS parent_i9_108_7_,
  156.         referencee8_.ref_header_id AS ref_hea10_108_7_,
  157.         referencee8_.ref_header_idmain AS ref_hea11_108_7_,
  158.         referencee9_.id AS id1_108_8_,
  159.         referencee9_.txVersion AS txVersio2_108_8_,
  160.         referencee9_.code AS code3_108_8_,
  161.         referencee9_.codemain AS codemain4_108_8_,
  162.         referencee9_.name AS name5_108_8_,
  163.         referencee9_.codeinteger AS codeinte6_108_8_,
  164.         referencee9_.codeintegermain AS codeinte7_108_8_,
  165.         referencee9_.isactive AS isactive8_108_8_,
  166.         referencee9_.parent_id AS parent_i9_108_8_,
  167.         referencee9_.ref_header_id AS ref_hea10_108_8_,
  168.         referencee9_.ref_header_idmain AS ref_hea11_108_8_,
  169.         referencee10_.id AS id1_108_9_,
  170.         referencee10_.txVersion AS txVersio2_108_9_,
  171.         referencee10_.code AS code3_108_9_,
  172.         referencee10_.codemain AS codemain4_108_9_,
  173.         referencee10_.name AS name5_108_9_,
  174.         referencee10_.codeinteger AS codeinte6_108_9_,
  175.         referencee10_.codeintegermain AS codeinte7_108_9_,
  176.         referencee10_.isactive AS isactive8_108_9_,
  177.         referencee10_.parent_id AS parent_i9_108_9_,
  178.         referencee10_.ref_header_id AS ref_hea10_108_9_,
  179.         referencee10_.ref_header_idmain AS ref_hea11_108_9_,
  180.         referencee11_.id AS id1_108_10_,
  181.         referencee11_.txVersion AS txVersio2_108_10_,
  182.         referencee11_.code AS code3_108_10_,
  183.         referencee11_.codemain AS codemain4_108_10_,
  184.         referencee11_.name AS name5_108_10_,
  185.         referencee11_.codeinteger AS codeinte6_108_10_,
  186.         referencee11_.codeintegermain AS codeinte7_108_10_,
  187.         referencee11_.isactive AS isactive8_108_10_,
  188.         referencee11_.parent_id AS parent_i9_108_10_,
  189.         referencee11_.ref_header_id AS ref_hea10_108_10_,
  190.         referencee11_.ref_header_idmain AS ref_hea11_108_10_,
  191.         peoplemain12_.id AS id1_82_11_,
  192.         peoplemain12_.txVersion AS txVersio2_82_11_,
  193.         peoplemain12_.snils AS snils3_82_11_,
  194.         peoplemain12_.inn AS inn4_82_11_,
  195.         peoplemain12_.iin AS iin5_82_11_,
  196.         userproper13_.id AS id1_136_12_,
  197.         userproper13_.txVersion AS txVersio2_136_12_,
  198.         userproper13_.peoplemain_id AS peoplema3_136_12_,
  199.         userproper13_.pay_by_bonus AS pay_by_b4_136_12_,
  200.         userproper13_.actiondate AS actionda5_136_12_,
  201.         partnersen14_.id AS id1_69_13_,
  202.         partnersen14_.txVersion AS txVersio2_69_13_,
  203.         partnersen14_.name AS name3_69_13_,
  204.         partnersen14_.uploadVersion AS uploadVe4_69_13_,
  205.         partnersen14_.dateVersion AS dateVers5_69_13_,
  206.         partnersen14_.requestVersion AS requestV6_69_13_,
  207.         partnersen14_.realname AS realname7_69_13_,
  208.         partnersen14_.urltest AS urltest8_69_13_,
  209.         partnersen14_.urlwork AS urlwork9_69_13_,
  210.         partnersen14_.codetest AS codetes10_69_13_,
  211.         partnersen14_.codework AS codewor11_69_13_,
  212.         partnersen14_.logintest AS loginte12_69_13_,
  213.         partnersen14_.loginwork AS loginwo13_69_13_,
  214.         partnersen14_.passwordtest AS passwor14_69_13_,
  215.         partnersen14_.passwordwork AS passwor15_69_13_,
  216.         partnersen14_.applicationId AS applica16_69_13_,
  217.         partnersen14_.groupTest AS groupTe17_69_13_,
  218.         partnersen14_.groupWork AS groupWo18_69_13_,
  219.         partnersen14_.accountnumber AS account19_69_13_,
  220.         partnersen14_.urluploadtest AS urluplo20_69_13_,
  221.         partnersen14_.urluploadwork AS urluplo21_69_13_,
  222.         partnersen14_.uploadinbox AS uploadi22_69_13_,
  223.         partnersen14_.uploadoutbox AS uploado23_69_13_,
  224.         partnersen14_.canMakePayment AS canMake24_69_13_,
  225.         partnersen14_.canMakeCreditHistory AS canMake25_69_13_,
  226.         partnersen14_.canMakeScoring AS canMake26_69_13_,
  227.         partnersen14_.passwordUploadTest AS passwor27_69_13_,
  228.         partnersen14_.passwordUploadWork AS passwor28_69_13_,
  229.         partnersen14_.bik AS bik29_69_13_,
  230.         bankentity15_.bik AS bik1_13_14_,
  231.         bankentity15_.txVersion AS txVersio2_13_14_,
  232.         bankentity15_.name AS name3_13_14_,
  233.         bankentity15_.corAccount AS corAccou4_13_14_,
  234.         bankentity15_.isActive AS isActive5_13_14_,
  235.         bankentity15_.isBank AS isBank6_13_14_,
  236.         bankentity15_.address AS address7_13_14_,
  237.         bankentity15_.country_code AS country_8_13_14_,
  238.         creditrequ16_.id AS id1_43_15_,
  239.         creditrequ16_.txVersion AS txVersio2_43_15_,
  240.         creditrequ16_.contest AS contest3_43_15_,
  241.         creditrequ16_.confirmed AS confirme4_43_15_,
  242.         creditrequ16_.contest_asp AS contest_5_43_15_,
  243.         creditrequ16_.contest_pd AS contest_6_43_15_,
  244.         creditrequ16_.contest_cb AS contest_7_43_15_,
  245.         creditrequ16_.datecontest AS datecont8_43_15_,
  246.         creditrequ16_.dateStatus AS dateStat9_43_15_,
  247.         creditrequ16_.dateSign AS dateSig10_43_15_,
  248.         creditrequ16_.dateFill AS dateFil11_43_15_,
  249.         creditrequ16_.dateDecision AS dateDec12_43_15_,
  250.         creditrequ16_.creditdays AS creditd13_43_15_,
  251.         creditrequ16_.creditdays_initial AS creditd14_43_15_,
  252.         creditrequ16_.creditsum AS credits15_43_15_,
  253.         creditrequ16_.creditsum_initial AS credits16_43_15_,
  254.         creditrequ16_.stake AS stake17_43_15_,
  255.         creditrequ16_.initial_stake AS initial18_43_15_,
  256.         creditrequ16_.comment AS comment19_43_15_,
  257.         creditrequ16_.uniquenomer AS uniquen20_43_15_,
  258.         creditrequ16_.accepted AS accepte21_43_15_,
  259.         creditrequ16_.nomer AS nomer22_43_15_,
  260.         creditrequ16_.city AS city23_43_15_,
  261.         creditrequ16_.smsCode AS smsCode24_43_15_,
  262.         creditrequ16_.isUploaded AS isUploa25_43_15_,
  263.         creditrequ16_.iscontrol AS iscontr26_43_15_,
  264.         creditrequ16_.iscontrol_comment AS iscontr27_43_15_,
  265.         creditrequ16_.iscontrol_peoplemain_id AS iscontr28_43_15_,
  266.         creditrequ16_.verifierComment AS verifie29_43_15_,
  267.         creditrequ16_.clienttimezone AS clientt30_43_15_,
  268.         creditrequ16_.account_id AS account31_43_15_,
  269.         creditrequ16_.partners_id AS partner32_43_15_,
  270.         creditrequ16_.acceptedcredit_id AS accepte33_43_15_,
  271.         creditrequ16_.rejectreason_id AS rejectr34_43_15_,
  272.         creditrequ16_.region AS region35_43_15_,
  273.         creditrequ16_.status_id AS status_36_43_15_,
  274.         creditrequ16_.peoplemain_id AS peoplem37_43_15_,
  275.         creditrequ16_.products_id AS product38_43_15_,
  276.         creditrequ16_.creditpurpose_id AS creditp39_43_15_,
  277.         creditrequ16_.way_id AS way_id40_43_15_,
  278.         creditrequ16_.decisionway_id AS decisio41_43_15_,
  279.         creditrequ16_.workplace_id AS workpla42_43_15_,
  280.         creditrequ16_.user_id AS user_id43_43_15_,
  281.         accountent17_.id AS id1_0_16_,
  282.         accountent17_.txVersion AS txVersio2_0_16_,
  283.         accountent17_.accountnumber AS accountn3_0_16_,
  284.         accountent17_.isactive AS isactive4_0_16_,
  285.         accountent17_.isWork AS isWork5_0_16_,
  286.         accountent17_.swift AS swift6_0_16_,
  287.         accountent17_.bankname AS bankname7_0_16_,
  288.         accountent17_.bik AS bik8_0_16_,
  289.         accountent17_.kpp AS kpp9_0_16_,
  290.         accountent17_.contest AS contest10_0_16_,
  291.         accountent17_.corraccountnumber AS corracc11_0_16_,
  292.         accountent17_.dateAdd AS dateAdd12_0_16_,
  293.         accountent17_.cardname AS cardnam13_0_16_,
  294.         accountent17_.card_synonim AS card_sy14_0_16_,
  295.         accountent17_.cardHolder AS cardHol15_0_16_,
  296.         accountent17_.cardnumber AS cardnum16_0_16_,
  297.         accountent17_.cardmonthend AS cardmon17_0_16_,
  298.         accountent17_.cardyearend AS cardyea18_0_16_,
  299.         accountent17_.card_ref_id AS card_re19_0_16_,
  300.         accountent17_.rnn AS rnn20_0_16_,
  301.         accountent17_.payonline_card_hash AS payonli21_0_16_,
  302.         accountent17_.card_number_masked AS card_nu22_0_16_,
  303.         accountent17_.rebill_anchor AS rebill_23_0_16_,
  304.         accountent17_.accounttype_id AS account24_0_16_,
  305.         accountent17_.point_id AS point_i25_0_16_,
  306.         accountent17_.peoplemain_id AS peoplem26_0_16_,
  307.         accountent17_.organization_id AS organiz27_0_16_,
  308.         referencee18_.id AS id1_108_17_,
  309.         referencee18_.txVersion AS txVersio2_108_17_,
  310.         referencee18_.code AS code3_108_17_,
  311.         referencee18_.codemain AS codemain4_108_17_,
  312.         referencee18_.name AS name5_108_17_,
  313.         referencee18_.codeinteger AS codeinte6_108_17_,
  314.         referencee18_.codeintegermain AS codeinte7_108_17_,
  315.         referencee18_.isactive AS isactive8_108_17_,
  316.         referencee18_.parent_id AS parent_i9_108_17_,
  317.         referencee18_.ref_header_id AS ref_hea10_108_17_,
  318.         referencee18_.ref_header_idmain AS ref_hea11_108_17_,
  319.         contactpoi19_.id AS id1_36_18_,
  320.         contactpoi19_.txVersion AS txVersio2_36_18_,
  321.         contactpoi19_.parent_id AS parent_i3_36_18_,
  322.         contactpoi19_.version AS version4_36_18_,
  323.         contactpoi19_.erased AS erased5_36_18_,
  324.         contactpoi19_.pp_code AS pp_code6_36_18_,
  325.         contactpoi19_.bic AS bic7_36_18_,
  326.         contactpoi19_.name AS name8_36_18_,
  327.         contactpoi19_.city_head AS city_hea9_36_18_,
  328.         contactpoi19_.address1 AS address10_36_18_,
  329.         contactpoi19_.address2 AS address11_36_18_,
  330.         contactpoi19_.address3 AS address12_36_18_,
  331.         contactpoi19_.address4 AS address13_36_18_,
  332.         contactpoi19_.phone AS phone14_36_18_,
  333.         contactpoi19_.name_rus AS name_ru15_36_18_,
  334.         contactpoi19_.country AS country16_36_18_,
  335.         contactpoi19_.deleted AS deleted17_36_18_,
  336.         contactpoi19_.city_lat AS city_la18_36_18_,
  337.         contactpoi19_.addr_lat AS addr_la19_36_18_,
  338.         contactpoi19_.contact AS contact20_36_18_,
  339.         contactpoi19_.region AS region21_36_18_,
  340.         contactpoi19_.can_change AS can_cha22_36_18_,
  341.         contactpoi19_.can_revoke AS can_rev23_36_18_,
  342.         contactpoi19_.get_money AS get_mon24_36_18_,
  343.         contactpoi19_.send_curr AS send_cu25_36_18_,
  344.         contactpoi19_.rec_curr AS rec_cur26_36_18_,
  345.         contactpoi19_.attr_grps AS attr_gr27_36_18_,
  346.         contactpoi19_.city_id AS city_id28_36_18_,
  347.         contactpoi19_.logo_id AS logo_id29_36_18_,
  348.         contactpoi19_.scen_id AS scen_id30_36_18_,
  349.         contactpoi19_.unique_trn AS unique_31_36_18_,
  350.         contactpoi19_.metro AS metro32_36_18_,
  351.         peoplemain20_.id AS id1_82_19_,
  352.         peoplemain20_.txVersion AS txVersio2_82_19_,
  353.         peoplemain20_.snils AS snils3_82_19_,
  354.         peoplemain20_.inn AS inn4_82_19_,
  355.         peoplemain20_.iin AS iin5_82_19_,
  356.         organizati21_.id AS id1_67_20_,
  357.         organizati21_.txVersion AS txVersio2_67_20_,
  358.         organizati21_.inn AS inn3_67_20_,
  359.         organizati21_.ogrn AS ogrn4_67_20_,
  360.         organizati21_.name AS name5_67_20_,
  361.         organizati21_.phone AS phone6_67_20_,
  362.         organizati21_.freePhone AS freePhon7_67_20_,
  363.         organizati21_.notificationPhone AS notifica8_67_20_,
  364.         organizati21_.email AS email9_67_20_,
  365.         organizati21_.kpp AS kpp10_67_20_,
  366.         organizati21_.isCreditOrg AS isCredi11_67_20_,
  367.         organizati21_.isactive AS isactiv12_67_20_,
  368.         organizati21_.reg_country AS reg_cou13_67_20_,
  369.         organizati21_.reg_city AS reg_cit14_67_20_,
  370.         organizati21_.reg_address AS reg_add15_67_20_,
  371.         organizati21_.databeg AS databeg16_67_20_,
  372.         organizati21_.dataend AS dataend17_67_20_,
  373.         organizati21_.partners_id AS partner18_67_20_,
  374.         organizati21_.orgtype_id AS orgtype19_67_20_,
  375.         partnersen22_.id AS id1_69_21_,
  376.         partnersen22_.txVersion AS txVersio2_69_21_,
  377.         partnersen22_.name AS name3_69_21_,
  378.         partnersen22_.uploadVersion AS uploadVe4_69_21_,
  379.         partnersen22_.dateVersion AS dateVers5_69_21_,
  380.         partnersen22_.requestVersion AS requestV6_69_21_,
  381.         partnersen22_.realname AS realname7_69_21_,
  382.         partnersen22_.urltest AS urltest8_69_21_,
  383.         partnersen22_.urlwork AS urlwork9_69_21_,
  384.         partnersen22_.codetest AS codetes10_69_21_,
  385.         partnersen22_.codework AS codewor11_69_21_,
  386.         partnersen22_.logintest AS loginte12_69_21_,
  387.         partnersen22_.loginwork AS loginwo13_69_21_,
  388.         partnersen22_.passwordtest AS passwor14_69_21_,
  389.         partnersen22_.passwordwork AS passwor15_69_21_,
  390.         partnersen22_.applicationId AS applica16_69_21_,
  391.         partnersen22_.groupTest AS groupTe17_69_21_,
  392.         partnersen22_.groupWork AS groupWo18_69_21_,
  393.         partnersen22_.accountnumber AS account19_69_21_,
  394.         partnersen22_.urluploadtest AS urluplo20_69_21_,
  395.         partnersen22_.urluploadwork AS urluplo21_69_21_,
  396.         partnersen22_.uploadinbox AS uploadi22_69_21_,
  397.         partnersen22_.uploadoutbox AS uploado23_69_21_,
  398.         partnersen22_.canMakePayment AS canMake24_69_21_,
  399.         partnersen22_.canMakeCreditHistory AS canMake25_69_21_,
  400.         partnersen22_.canMakeScoring AS canMake26_69_21_,
  401.         partnersen22_.passwordUploadTest AS passwor27_69_21_,
  402.         partnersen22_.passwordUploadWork AS passwor28_69_21_,
  403.         partnersen22_.bik AS bik29_69_21_,
  404.         creditenti23_.id AS id1_39_22_,
  405.         creditenti23_.txVersion AS txVersio2_39_22_,
  406.         creditenti23_.bankname AS bankname3_39_22_,
  407.         creditenti23_.creditdatabeg AS creditda4_39_22_,
  408.         creditenti23_.creditdataend AS creditda5_39_22_,
  409.         creditenti23_.creditDateDebt AS creditDa6_39_22_,
  410.         creditenti23_.dateStopCalc AS dateStop7_39_22_,
  411.         creditenti23_.descStopCalc AS descStop8_39_22_,
  412.         creditenti23_.creditsum AS creditsu9_39_22_,
  413.         creditenti23_.creditSumPaid AS creditS10_39_22_,
  414.         creditenti23_.creditMonthlyPayment AS creditM11_39_22_,
  415.         creditenti23_.creditAccount AS creditA12_39_22_,
  416.         creditenti23_.creditmoneyback AS creditm13_39_22_,
  417.         creditenti23_.creditlimitunused AS creditl14_39_22_,
  418.         creditenti23_.creditlong AS creditl15_39_22_,
  419.         creditenti23_.creditsumback AS credits16_39_22_,
  420.         creditenti23_.creditFullCost AS creditF17_39_22_,
  421.         creditenti23_.isover AS isover18_39_22_,
  422.         creditenti23_.maxDelay AS maxDela19_39_22_,
  423.         creditenti23_.id_credit AS id_cred20_39_22_,
  424.         creditenti23_.creditcardlimit AS creditc21_39_22_,
  425.         creditenti23_.issameorg AS issameo22_39_22_,
  426.         creditenti23_.creditsumdebt AS credits23_39_22_,
  427.         creditenti23_.creditpercent AS creditp24_39_22_,
  428.         creditenti23_.delay5 AS delay25_39_22_,
  429.         creditenti23_.delay30 AS delay26_39_22_,
  430.         creditenti23_.delay60 AS delay27_39_22_,
  431.         creditenti23_.delay90 AS delay28_39_22_,
  432.         creditenti23_.delay120 AS delay29_39_22_,
  433.         creditenti23_.delaymore AS delaymo30_39_22_,
  434.         creditenti23_.isactive AS isactiv31_39_22_,
  435.         creditenti23_.currentDebt AS current32_39_22_,
  436.         creditenti23_.maxOverdueDebt AS maxOver33_39_22_,
  437.         creditenti23_.currentOverdueDebt AS current34_39_22_,
  438.         creditenti23_.delayindays AS delayin35_39_22_,
  439.         creditenti23_.payDiscipline AS payDisc36_39_22_,
  440.         creditenti23_.isUploaded AS isUploa37_39_22_,
  441.         creditenti23_.changedSum AS changed38_39_22_,
  442.         creditenti23_.isReceived AS isRecei39_39_22_,
  443.         creditenti23_.datelastupdate AS datelas40_39_22_,
  444.         creditenti23_.creditdataendfact AS creditd41_39_22_,
  445.         creditenti23_.dateStatus AS dateSta42_39_22_,
  446.         creditenti23_.owner AS owner43_39_22_,
  447.         creditenti23_.accounttype_id AS account44_39_22_,
  448.         creditenti23_.creditorganization_id AS credito45_39_22_,
  449.         creditenti23_.credittype_id AS creditt46_39_22_,
  450.         creditenti23_.creditrelation_id AS creditr47_39_22_,
  451.         creditenti23_.creditfreqpayment_id AS creditf48_39_22_,
  452.         creditenti23_.creditstatus_id AS credits49_39_22_,
  453.         creditenti23_.creditpurpose_id AS creditp50_39_22_,
  454.         creditenti23_.overduestate_id AS overdue51_39_22_,
  455.         creditenti23_.worstoverduestate_id AS worstov52_39_22_,
  456.         creditenti23_.worstoverduestate12_id AS worstov53_39_22_,
  457.         creditenti23_.id_currency AS id_curr54_39_22_,
  458.         creditenti23_.peoplemain_id AS peoplem55_39_22_,
  459.         creditenti23_.partners_id AS partner56_39_22_,
  460.         creditenti23_.creditrequest_id AS creditr57_39_22_,
  461.         creditenti23_.products_id AS product58_39_22_,
  462.         productsen24_.id AS id1_92_23_,
  463.         productsen24_.txVersion AS txVersio2_92_23_,
  464.         productsen24_.name AS name3_92_23_,
  465.         productsen24_.code AS code4_92_23_,
  466.         productsen24_.isActive AS isActive5_92_23_,
  467.         productsen24_.isDefault AS isDefaul6_92_23_,
  468.         productsen24_.description AS descript7_92_23_,
  469.         productsen24_.paymenttype_id AS paymentt8_92_23_,
  470.         referencee25_.id AS id1_108_24_,
  471.         referencee25_.txVersion AS txVersio2_108_24_,
  472.         referencee25_.code AS code3_108_24_,
  473.         referencee25_.codemain AS codemain4_108_24_,
  474.         referencee25_.name AS name5_108_24_,
  475.         referencee25_.codeinteger AS codeinte6_108_24_,
  476.         referencee25_.codeintegermain AS codeinte7_108_24_,
  477.         referencee25_.isactive AS isactive8_108_24_,
  478.         referencee25_.parent_id AS parent_i9_108_24_,
  479.         referencee25_.ref_header_id AS ref_hea10_108_24_,
  480.         referencee25_.ref_header_idmain AS ref_hea11_108_24_,
  481.         refusereas26_.id AS id1_110_25_,
  482.         refusereas26_.txVersion AS txVersio2_110_25_,
  483.         refusereas26_.nameFull AS nameFull3_110_25_,
  484.         refusereas26_.name AS name4_110_25_,
  485.         refusereas26_.constantName AS constant5_110_25_,
  486.         refusereas26_.forDecision AS forDecis6_110_25_,
  487.         refusereas26_.reason_id AS reason_i7_110_25_,
  488.         regionsent27_.code AS code1_111_26_,
  489.         regionsent27_.txVersion AS txVersio2_111_26_,
  490.         regionsent27_.name AS name3_111_26_,
  491.         regionsent27_.codereg AS codereg4_111_26_,
  492.         regionsent27_.codeIso AS codeIso5_111_26_,
  493.         regionsent27_.timezone AS timezone6_111_26_,
  494.         creditstat28_.id AS id1_44_27_,
  495.         creditstat28_.name AS name2_44_27_,
  496.         peoplemain29_.id AS id1_82_28_,
  497.         peoplemain29_.txVersion AS txVersio2_82_28_,
  498.         peoplemain29_.snils AS snils3_82_28_,
  499.         peoplemain29_.inn AS inn4_82_28_,
  500.         peoplemain29_.iin AS iin5_82_28_,
  501.         productsen30_.id AS id1_92_29_,
  502.         productsen30_.txVersion AS txVersio2_92_29_,
  503.         productsen30_.name AS name3_92_29_,
  504.         productsen30_.code AS code4_92_29_,
  505.         productsen30_.isActive AS isActive5_92_29_,
  506.         productsen30_.isDefault AS isDefaul6_92_29_,
  507.         productsen30_.description AS descript7_92_29_,
  508.         productsen30_.paymenttype_id AS paymentt8_92_29_,
  509.         referencee31_.id AS id1_108_30_,
  510.         referencee31_.txVersion AS txVersio2_108_30_,
  511.         referencee31_.code AS code3_108_30_,
  512.         referencee31_.codemain AS codemain4_108_30_,
  513.         referencee31_.name AS name5_108_30_,
  514.         referencee31_.codeinteger AS codeinte6_108_30_,
  515.         referencee31_.codeintegermain AS codeinte7_108_30_,
  516.         referencee31_.isactive AS isactive8_108_30_,
  517.         referencee31_.parent_id AS parent_i9_108_30_,
  518.         referencee31_.ref_header_id AS ref_hea10_108_30_,
  519.         referencee31_.ref_header_idmain AS ref_hea11_108_30_,
  520.         referencee32_.id AS id1_108_31_,
  521.         referencee32_.txVersion AS txVersio2_108_31_,
  522.         referencee32_.code AS code3_108_31_,
  523.         referencee32_.codemain AS codemain4_108_31_,
  524.         referencee32_.name AS name5_108_31_,
  525.         referencee32_.codeinteger AS codeinte6_108_31_,
  526.         referencee32_.codeintegermain AS codeinte7_108_31_,
  527.         referencee32_.isactive AS isactive8_108_31_,
  528.         referencee32_.parent_id AS parent_i9_108_31_,
  529.         referencee32_.ref_header_id AS ref_hea10_108_31_,
  530.         referencee32_.ref_header_idmain AS ref_hea11_108_31_,
  531.         referencee33_.id AS id1_108_32_,
  532.         referencee33_.txVersion AS txVersio2_108_32_,
  533.         referencee33_.code AS code3_108_32_,
  534.         referencee33_.codemain AS codemain4_108_32_,
  535.         referencee33_.name AS name5_108_32_,
  536.         referencee33_.codeinteger AS codeinte6_108_32_,
  537.         referencee33_.codeintegermain AS codeinte7_108_32_,
  538.         referencee33_.isactive AS isactive8_108_32_,
  539.         referencee33_.parent_id AS parent_i9_108_32_,
  540.         referencee33_.ref_header_id AS ref_hea10_108_32_,
  541.         referencee33_.ref_header_idmain AS ref_hea11_108_32_
  542.     FROM
  543.         credit creditenti0_
  544.     LEFT OUTER JOIN
  545.         reference referencee1_
  546.             ON creditenti0_.accounttype_id=referencee1_.id
  547.     LEFT OUTER JOIN
  548.         organization organizati2_
  549.             ON creditenti0_.creditorganization_id=organizati2_.id
  550.     LEFT OUTER JOIN
  551.         reference referencee3_
  552.             ON creditenti0_.credittype_id=referencee3_.id
  553.     LEFT OUTER JOIN
  554.         reference referencee4_
  555.             ON creditenti0_.creditrelation_id=referencee4_.id
  556.     LEFT OUTER JOIN
  557.         reference referencee5_
  558.             ON creditenti0_.creditfreqpayment_id=referencee5_.id
  559.     LEFT OUTER JOIN
  560.         reference referencee6_
  561.             ON creditenti0_.creditstatus_id=referencee6_.id
  562.     LEFT OUTER JOIN
  563.         reference referencee7_
  564.             ON creditenti0_.creditpurpose_id=referencee7_.id
  565.     LEFT OUTER JOIN
  566.         reference referencee8_
  567.             ON creditenti0_.overduestate_id=referencee8_.id
  568.     LEFT OUTER JOIN
  569.         reference referencee9_
  570.             ON creditenti0_.worstoverduestate_id=referencee9_.id
  571.     LEFT OUTER JOIN
  572.         reference referencee10_
  573.             ON creditenti0_.worstoverduestate12_id=referencee10_.id
  574.     LEFT OUTER JOIN
  575.         reference referencee11_
  576.             ON creditenti0_.id_currency=referencee11_.id
  577.     LEFT OUTER JOIN
  578.         peoplemain peoplemain12_
  579.             ON creditenti0_.peoplemain_id=peoplemain12_.id
  580.     LEFT OUTER JOIN
  581.         userproperties userproper13_
  582.             ON peoplemain12_.id=userproper13_.id
  583.     LEFT OUTER JOIN
  584.         partners partnersen14_
  585.             ON creditenti0_.partners_id=partnersen14_.id
  586.     LEFT OUTER JOIN
  587.         bank bankentity15_
  588.             ON partnersen14_.bik=bankentity15_.bik
  589.     LEFT OUTER JOIN
  590.         creditrequest creditrequ16_
  591.             ON creditenti0_.creditrequest_id=creditrequ16_.id
  592.     LEFT OUTER JOIN
  593.         account accountent17_
  594.             ON creditrequ16_.account_id=accountent17_.id
  595.     LEFT OUTER JOIN
  596.         reference referencee18_
  597.             ON accountent17_.accounttype_id=referencee18_.id
  598.     LEFT OUTER JOIN
  599.         contact_points contactpoi19_
  600.             ON accountent17_.point_id=contactpoi19_.id
  601.     LEFT OUTER JOIN
  602.         peoplemain peoplemain20_
  603.             ON accountent17_.peoplemain_id=peoplemain20_.id
  604.     LEFT OUTER JOIN
  605.         organization organizati21_
  606.             ON accountent17_.organization_id=organizati21_.id
  607.     LEFT OUTER JOIN
  608.         partners partnersen22_
  609.             ON creditrequ16_.partners_id=partnersen22_.id
  610.     LEFT OUTER JOIN
  611.         credit creditenti23_
  612.             ON creditrequ16_.acceptedcredit_id=creditenti23_.id
  613.     LEFT OUTER JOIN
  614.         products productsen24_
  615.             ON creditenti23_.products_id=productsen24_.id
  616.     LEFT OUTER JOIN
  617.         reference referencee25_
  618.             ON productsen24_.paymenttype_id=referencee25_.id
  619.     LEFT OUTER JOIN
  620.         refusereason refusereas26_
  621.             ON creditrequ16_.rejectreason_id=refusereas26_.id
  622.     LEFT OUTER JOIN
  623.         regions regionsent27_
  624.             ON creditrequ16_.region=regionsent27_.code
  625.     LEFT OUTER JOIN
  626.         creditstatus creditstat28_
  627.             ON creditrequ16_.status_id=creditstat28_.id
  628.     LEFT OUTER JOIN
  629.         peoplemain peoplemain29_
  630.             ON creditrequ16_.peoplemain_id=peoplemain29_.id
  631.     LEFT OUTER JOIN
  632.         products productsen30_
  633.             ON creditrequ16_.products_id=productsen30_.id
  634.     LEFT OUTER JOIN
  635.         reference referencee31_
  636.             ON creditrequ16_.creditpurpose_id=referencee31_.id
  637.     LEFT OUTER JOIN
  638.         reference referencee32_
  639.             ON creditrequ16_.way_id=referencee32_.id
  640.     LEFT OUTER JOIN
  641.         reference referencee33_
  642.             ON creditrequ16_.decisionway_id=referencee33_.id
  643.     WHERE
  644.         creditenti0_.id=?
  645. Hibernate:
  646.     /* load ru.simplgroupp.persistence.ReferenceEntity */ SELECT
  647.         referencee0_.id AS id1_108_0_,
  648.         referencee0_.txVersion AS txVersio2_108_0_,
  649.         referencee0_.code AS code3_108_0_,
  650.         referencee0_.codemain AS codemain4_108_0_,
  651.         referencee0_.name AS name5_108_0_,
  652.         referencee0_.codeinteger AS codeinte6_108_0_,
  653.         referencee0_.codeintegermain AS codeinte7_108_0_,
  654.         referencee0_.isactive AS isactive8_108_0_,
  655.         referencee0_.parent_id AS parent_i9_108_0_,
  656.         referencee0_.ref_header_id AS ref_hea10_108_0_,
  657.         referencee0_.ref_header_idmain AS ref_hea11_108_0_
  658.     FROM
  659.         reference referencee0_
  660.     WHERE
  661.         referencee0_.id=?
  662. Hibernate:
  663.     /* load ru.simplgroupp.persistence.ReferenceEntity */ SELECT
  664.         referencee0_.id AS id1_108_0_,
  665.         referencee0_.txVersion AS txVersio2_108_0_,
  666.         referencee0_.code AS code3_108_0_,
  667.         referencee0_.codemain AS codemain4_108_0_,
  668.         referencee0_.name AS name5_108_0_,
  669.         referencee0_.codeinteger AS codeinte6_108_0_,
  670.         referencee0_.codeintegermain AS codeinte7_108_0_,
  671.         referencee0_.isactive AS isactive8_108_0_,
  672.         referencee0_.parent_id AS parent_i9_108_0_,
  673.         referencee0_.ref_header_id AS ref_hea10_108_0_,
  674.         referencee0_.ref_header_idmain AS ref_hea11_108_0_
  675.     FROM
  676.         reference referencee0_
  677.     WHERE
  678.         referencee0_.id=?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!