Untitled
unknown
sql
2 months ago
134 kB
2
Indexable
SELECT outageeven0_.id AS id1_35_97_,
outageeven0_.contactdate AS conta4_35_97_,
outageeven0_.newcontactdate AS newco5_35_97_,
outageeven0_.newcontacttime AS newco6_35_97_,
outageeven0_.contacttime AS conta7_35_97_,
outageeven0_.eventdate AS event8_35_97_,
outageeven0_.eventtime AS event9_35_97_,
outageeven0_.eventreason2 AS even10_35_97_,
outageeven0_.failureid2 AS fail11_35_97_,
outageeven0_.defectid2 AS defe12_35_97_,
outageeven0_.eventreason3 AS even13_35_97_,
outageeven0_.failureid3 AS fail14_35_97_,
outageeven0_.defectid3 AS defe15_35_97_,
outageeven0_.flowamount AS flow16_35_97_,
outageeven0_.regdate AS regd17_35_97_,
outageeven0_.delflg AS delf18_35_97_,
outageeven0_.isscheduled AS issc19_35_97_,
outageeven0_.undistenergy AS undi20_35_97_,
outageeven0_.posx1 AS posx21_35_97_,
outageeven0_.posy1 AS posy22_35_97_,
outageeven0_.posx2 AS posx23_35_97_,
outageeven0_.posy2 AS posy24_35_97_,
outageeven0_.joindate AS join25_35_97_,
outageeven0_.jointime AS join26_35_97_,
outageeven0_.isfeederfailcause AS isfe27_35_97_,
outageeven0_.ishotline AS isho28_35_97_,
outageeven0_.rst AS rst29_35_97_,
outageeven0_.networkpressure AS netw30_35_97_,
outageeven0_.cutposts AS cutp31_35_97_,
outageeven0_.hotlinerecloserstate AS hotl32_35_97_,
outageeven0_.mamoor AS mamo33_35_97_,
outageeven0_.singleconsumer AS sing34_35_97_,
outageeven0_.eventdescp AS even35_35_97_,
outageeven0_.announcerule AS anno36_35_97_,
outageeven0_.eventaddr AS even37_35_97_,
outageeven0_.postfromname AS post38_35_97_,
outageeven0_.posttoname AS post39_35_97_,
outageeven0_.maineventid AS main40_35_97_,
outageeven0_.protectiondo AS prot41_35_97_,
outageeven0_.requestdate AS requ42_35_97_,
outageeven0_.requesttime AS requ43_35_97_,
outageeven0_.subbranch AS subb44_35_97_,
outageeven0_.delayreasonid AS dela45_35_97_,
outageeven0_.regionplace AS regi46_35_97_,
outageeven0_.regionid AS regi47_35_97_,
outageeven0_.soundfileid AS soun48_35_97_,
outageeven0_.predictiontime AS pred49_35_97_,
outageeven0_.predictiondate AS pred50_35_97_,
outageeven0_.noelem AS noel51_35_97_,
outageeven0_.isurgent AS isur52_35_97_,
outageeven0_.latlontype AS latl53_35_97_,
outageeven0_.registerdelay AS regi54_35_97_,
outageeven0_.contactdelay AS cont55_35_97_,
outageeven0_.isoutagetemporarilyon AS isou56_35_97_,
outageeven0_.eventdatetime AS even57_35_97_,
outageeven0_.joindatetime AS join58_35_97_,
outageeven0_.contactdatetime AS cont59_35_97_,
outageeven0_.viewdatetime AS view60_35_97_,
outageeven0_.eventdes AS even61_35_97_,
outageeven0_.takmoshtarak AS takm62_35_97_,
outageeven0_.eventstagecount AS even63_35_97_,
outageeven0_.workpermitnumber AS work64_35_97_,
outageeven0_.repetitiverequestcount AS repe65_35_97_,
outageeven0_.ohmid AS ohmi66_35_97_,
outageeven0_.externalfollowerid AS exte67_35_97_,
outageeven0_.changedversion AS chan68_35_97_,
outageeven0_.shouldbeinformedofnotdonebyteam AS shou69_35_97_,
outageeven0_.ccserverip AS ccse70_35_97_,
outageeven0_.isticket AS isti71_35_97_,
outageeven0_.relayfunctionphase AS rela72_35_97_,
outageeven0_.hotlinesubcontractor AS hotl73_35_97_,
outageeven0_.naturaldisastersid AS natu74_35_97_,
outageeven0_.feederrecloserdeactivedatetime AS feed75_35_97_,
outageeven0_.feederrecloseractivedatetime AS feed76_35_97_,
outageeven0_.linepathdeactivedatetime AS line77_35_97_,
outageeven0_.linepathactivedatetime AS line78_35_97_,
outageeven0_.hotlineeventaddr AS hotl79_35_97_,
outageeven0_.datetemporarilyon AS date80_35_97_,
outageeven0_.normalizationforecast AS norm81_35_97_,
outageeven0_.predectedduration AS pred82_35_97_,
outageeven0_.newpredectedduration AS newp83_35_97_,
outageeven0_.licenserequired AS lice84_35_97_,
outageeven0_.depth AS dept85_35_97_,
outageeven0_.sewagenetworktype AS sewa86_35_97_,
outageeven0_.omurid AS omur87_35_97_,
outageeven0_.recevieduserid AS rece88_35_97_,
outageeven0_.consumerinsid AS cons89_35_97_,
outageeven0_.userid AS user90_35_97_,
outageeven0_.delayuserid AS dela91_35_97_,
outageeven0_.defectcause1 AS defe92_35_97_,
outageeven0_.defectcause2 AS defe93_35_97_,
outageeven0_.eventreason AS even94_35_97_,
outageeven0_.notdonereasonid AS notd95_35_97_,
outageeven0_.eventstatusid AS even96_35_97_,
outageeven0_.eventflowstatusid AS even97_35_97_,
outageeven0_.hvpostid AS hvpo98_35_97_,
outageeven0_.feeder2id AS feed99_35_97_,
outageeven0_.feederid AS fee100_35_97_,
outageeven0_.postid AS pos101_35_97_,
outageeven0_.transid AS tra102_35_97_,
outageeven0_.omurzoneid AS omu103_35_97_,
outageeven0_.cutterelement AS cut104_35_97_,
outageeven0_.failureid AS fai105_35_97_,
outageeven0_.defectid AS def106_35_97_,
outageeven0_.cutterelementins AS cut107_35_97_,
outageeven0_.reporttype AS rep108_35_97_,
outageeven0_.parenteventid AS par109_35_97_,
outageeven0_.subcontractor AS sub110_35_97_,
outageeven0_.priority AS pri111_35_97_,
outageeven0_.protectionopr AS pro112_35_97_,
outageeven0_.scheventactivetypeid AS sch113_35_97_,
outageeven0_.eventdurationinminutes AS eve114_35_97_,
outageeven0_.registersource AS reg115_35_97_,
outageeven0_.diameteractionid AS dia116_35_97_,
outageeven0_.materialactionid AS mat117_35_97_,
outageeven0_.eventcausingfactoractionid AS eve118_35_97_,
outageeven0_.eventcausingreasonactionid AS eve119_35_97_,
outageeven0_.postfromid AS pos120_35_97_,
outageeven0_.posttoid AS pos121_35_97_,
outageeven0_.flowamountbeforinterruption AS flo122_35_97_,
outageeven0_.selectedplace AS sel123_35_97_,
outageeven0_.dispatchedeventtype AS dis124_35_97_,
outageeven0_.tavanirid AS tav125_35_97_,
outageeven0_.updated AS upd126_35_97_,
outageeven0_.numberoflamps AS num127_35_97_,
outageeven0_.policestationid AS pol128_35_97_,
outageeven0_.countofpostoff AS cou129_35_97_,
outageeven0_.prioritizeduserid AS pri130_35_97_,
outageeven0_.valuepriorityevent AS val131_35_97_,
outageeven0_.totalpriceelement AS tot132_35_97_,
outageeven0_.hasbeensenttosanam AS has133_35_97_,
subjectite1_.id AS id1_177_0_,
subjectite1_.subjid AS subj2_177_0_,
subjectite1_.itemnameen AS item3_177_0_,
subjectite1_.itemnamefa AS item4_177_0_,
subjectite1_.ismv AS ismv5_177_0_,
subjectite1_.mark AS mark6_177_0_,
subjectite1_.valuesubjid AS valu7_177_0_,
subject2_.id AS id1_176_1_,
subject2_.subjnameen AS subj2_176_1_,
subject2_.subjnamefa AS subj3_176_1_,
subject2_.subjdescp AS subj4_176_1_,
subjectite3_.id AS id1_177_2_,
subjectite3_.subjid AS subj2_177_2_,
subjectite3_.itemnameen AS item3_177_2_,
subjectite3_.itemnamefa AS item4_177_2_,
subjectite3_.ismv AS ismv5_177_2_,
subjectite3_.mark AS mark6_177_2_,
subjectite3_.valuesubjid AS valu7_177_2_,
subjectite4_.id AS id1_177_3_,
subjectite4_.subjid AS subj2_177_3_,
subjectite4_.itemnameen AS item3_177_3_,
subjectite4_.itemnamefa AS item4_177_3_,
subjectite4_.ismv AS ismv5_177_3_,
subjectite4_.mark AS mark6_177_3_,
subjectite4_.valuesubjid AS valu7_177_3_,
consumerin5_.id AS id1_193_4_,
consumerin5_.latestcontdate AS late2_193_4_,
consumerin5_.omurzoneid AS omur3_193_4_,
consumerin5_.consumeraddr AS cons4_193_4_,
consumerin5_.consumertel AS cons5_193_4_,
consumerin5_.consumername AS cons6_193_4_,
consumerin5_.regdate AS regd7_193_4_,
consumerin5_.delflg AS delf8_193_4_,
consumerin5_.groupid AS grou9_193_4_,
consumerin5_.regionid AS reg10_193_4_,
consumerin5_.consumerlevelid AS con11_193_4_,
consumerin5_.consumerpostid AS con12_193_4_,
consumerin5_.demand AS dem13_193_4_,
consumerin5_.posx AS pos14_193_4_,
consumerin5_.posy AS pos15_193_4_,
consumerin5_.ctype AS cty16_193_4_,
consumerin5_.ereaposttype AS ere17_193_4_,
consumerin5_.consumerno AS con18_193_4_,
consumerin5_.mobileno AS mob19_193_4_,
consumerin5_.email AS ema20_193_4_,
consumerin5_.faxno AS fax21_193_4_,
consumerin5_.zipcode AS zip22_193_4_,
consumerin5_.cntrnumber AS cnt23_193_4_,
consumerin5_.filenumber AS fil24_193_4_,
consumerin5_.plumbnumber AS plu25_193_4_,
consumerin5_.billid AS bil26_193_4_,
consumerin5_.consumerfaznumber AS con27_193_4_,
consumerin5_.useenergy AS use28_193_4_,
consumerin5_.dimand AS dim29_193_4_,
consumerin5_.isdeleted AS isd30_193_4_,
consumerin5_.changedversion AS cha31_193_4_,
consumerin5_.consumertypeid AS con32_193_4_,
consumerin5_.omurid AS omu33_193_4_,
subjectite6_.id AS id1_177_5_,
subjectite6_.subjid AS subj2_177_5_,
subjectite6_.itemnameen AS item3_177_5_,
subjectite6_.itemnamefa AS item4_177_5_,
subjectite6_.ismv AS ismv5_177_5_,
subjectite6_.mark AS mark6_177_5_,
subjectite6_.valuesubjid AS valu7_177_5_,
consumerty7_.id AS id1_23_6_,
consumerty7_.title AS title2_23_6_,
consumerty7_.scheduled AS sched3_23_6_,
consumerty7_.title_en AS title4_23_6_,
omur8_.id AS id1_187_7_,
omur8_.omurname AS omur2_187_7_,
omur8_.showorder AS show3_187_7_,
omur8_.voiceid AS voic4_187_7_,
omur8_.deleted AS dele5_187_7_,
omur8_.code AS code6_187_7_,
omur8_.gisobjectid AS giso7_187_7_,
omur8_.lastobtaineddatetime AS last8_187_7_,
omur8_.taskalloweddistance AS task9_187_7_,
omur8_.tavanirid AS tav10_187_7_,
omur8_.updated AS upd11_187_7_,
omur8_.controllcenterid AS con12_187_7_,
controllce9_.id AS id1_46_8_,
controllce9_.namecenter AS namec2_46_8_,
controllce9_.permitmvid AS permi3_46_8_,
controllce9_.permitlvid AS permi4_46_8_,
controllce9_.permithvid AS permi5_46_8_,
subjectite10_.id AS id1_177_9_,
subjectite10_.subjid AS subj2_177_9_,
subjectite10_.itemnameen AS item3_177_9_,
subjectite10_.itemnamefa AS item4_177_9_,
subjectite10_.ismv AS ismv5_177_9_,
subjectite10_.mark AS mark6_177_9_,
subjectite10_.valuesubjid AS valu7_177_9_,
subjectite11_.id AS id1_177_10_,
subjectite11_.subjid AS subj2_177_10_,
subjectite11_.itemnameen AS item3_177_10_,
subjectite11_.itemnamefa AS item4_177_10_,
subjectite11_.ismv AS ismv5_177_10_,
subjectite11_.mark AS mark6_177_10_,
subjectite11_.valuesubjid AS valu7_177_10_,
region12_.id AS id1_195_11_,
region12_.regionname AS regi2_195_11_,
region12_.omurzoneid AS omur3_195_11_,
region12_.delflag AS delf4_195_11_,
region12_.sortflag AS sort5_195_11_,
region12_.description AS desc6_195_11_,
region12_.parentid AS pare7_195_11_,
region12_.voiceid AS voic8_195_11_,
region12_.tavanirid AS tava9_195_11_,
region12_.updated AS upd10_195_11_,
omurzone13_.id AS id1_197_12_,
omurzone13_.omurid AS omur2_197_12_,
omurzone13_.zonename AS zone3_197_12_,
omurzone13_.tavanirid AS tava4_197_12_,
omurzone13_.updated AS upda5_197_12_,
omur14_.id AS id1_187_13_,
omur14_.omurname AS omur2_187_13_,
omur14_.showorder AS show3_187_13_,
omur14_.voiceid AS voic4_187_13_,
omur14_.deleted AS dele5_187_13_,
omur14_.code AS code6_187_13_,
omur14_.gisobjectid AS giso7_187_13_,
omur14_.lastobtaineddatetime AS last8_187_13_,
omur14_.taskalloweddistance AS task9_187_13_,
omur14_.tavanirid AS tav10_187_13_,
omur14_.updated AS upd11_187_13_,
omur14_.controllcenterid AS con12_187_13_,
post15_.id AS id1_175_14_,
post15_.postname AS post2_175_14_,
post15_.postaddress AS post3_175_14_,
post15_.posttype AS post4_175_14_,
post15_.sensitivetype AS sens5_175_14_,
post15_.voltagelevel1 AS volt6_175_14_,
post15_.voltagelevel2 AS volt7_175_14_,
post15_.postcode AS post8_175_14_,
post15_.postereatype AS post9_175_14_,
post15_.postfusetype AS pos10_175_14_,
post15_.postfuseamper AS pos11_175_14_,
post15_.producedyear AS pro12_175_14_,
post15_.setupdate AS set13_175_14_,
post15_.sortflag AS sor14_175_14_,
post15_.giscode AS gis15_175_14_,
post15_.delflg AS del16_175_14_,
post15_.globalid AS glo17_175_14_,
post15_.lat AS lat18_175_14_,
post15_.lon AS lon19_175_14_,
post15_.post20id AS pos20_175_14_,
post15_.electricresistance AS ele21_175_14_,
post15_.electriclinelength AS ele22_175_14_,
post15_.electricresistancedate AS ele23_175_14_,
post15_.protectionalresistance AS pro24_175_14_,
post15_.protectionallinelength AS pro25_175_14_,
post15_.protectionalresistancedate AS pro26_175_14_,
post15_.apptype AS app27_175_14_,
post15_.isactive AS isa28_175_14_,
post15_.isautomated AS isa29_175_14_,
post15_.ismonitored AS ism30_175_14_,
post15_.omurid2 AS omu31_175_14_,
post15_.zonename AS zon32_175_14_,
post15_.mvfeederid AS mvf33_175_14_,
post15_.postconsumertype AS pos34_175_14_,
post15_.loadtype AS loa35_175_14_,
post15_.omurid AS omu36_175_14_,
post15_.regionid AS reg37_175_14_,
post15_.omurzoneid AS omu38_175_14_,
post15_.tavanirid AS tav39_175_14_,
post15_.updated AS upd40_175_14_,
subjectite16_.id AS id1_177_15_,
subjectite16_.subjid AS subj2_177_15_,
subjectite16_.itemnameen AS item3_177_15_,
subjectite16_.itemnamefa AS item4_177_15_,
subjectite16_.ismv AS ismv5_177_15_,
subjectite16_.mark AS mark6_177_15_,
subjectite16_.valuesubjid AS valu7_177_15_,
subjectite17_.id AS id1_177_16_,
subjectite17_.subjid AS subj2_177_16_,
subjectite17_.itemnameen AS item3_177_16_,
subjectite17_.itemnamefa AS item4_177_16_,
subjectite17_.ismv AS ismv5_177_16_,
subjectite17_.mark AS mark6_177_16_,
subjectite17_.valuesubjid AS valu7_177_16_,
subjectite18_.id AS id1_177_17_,
subjectite18_.subjid AS subj2_177_17_,
subjectite18_.itemnameen AS item3_177_17_,
subjectite18_.itemnamefa AS item4_177_17_,
subjectite18_.ismv AS ismv5_177_17_,
subjectite18_.mark AS mark6_177_17_,
subjectite18_.valuesubjid AS valu7_177_17_,
subjectite19_.id AS id1_177_18_,
subjectite19_.subjid AS subj2_177_18_,
subjectite19_.itemnameen AS item3_177_18_,
subjectite19_.itemnamefa AS item4_177_18_,
subjectite19_.ismv AS ismv5_177_18_,
subjectite19_.mark AS mark6_177_18_,
subjectite19_.valuesubjid AS valu7_177_18_,
mvfeederna20_.id AS id1_178_19_,
mvfeederna20_.mvtransid AS mvtr2_178_19_,
mvfeederna20_.feedername AS feed3_178_19_,
mvfeederna20_.enfeedername AS enfe4_178_19_,
mvfeederna20_.feederdescribtion AS feed5_178_19_,
mvfeederna20_.fcolorr AS fcol6_178_19_,
mvfeederna20_.fcolorg AS fcol7_178_19_,
mvfeederna20_.fcolorb AS fcol8_178_19_,
mvfeederna20_.overheadlinelength AS over9_178_19_,
mvfeederna20_.undergroundlinelength AS und10_178_19_,
mvfeederna20_.mainomurid AS mai11_178_19_,
mvfeederna20_.gisobjectid AS gis12_178_19_,
mvfeederna20_.delflg AS del13_178_19_,
mvfeederna20_.globalid AS glo14_178_19_,
mvfeederna20_.loadpeak AS loa15_178_19_,
mvfeederna20_.owningpercent AS own16_178_19_,
mvfeederna20_.commonwith AS com17_178_19_,
mvfeederna20_.feedercode AS fee18_178_19_,
mvfeederna20_.modammvfeedercode AS mod19_178_19_,
mvfeederna20_.sortflag AS sor20_178_19_,
mvfeederna20_.changedversion AS cha21_178_19_,
mvfeederna20_.updatedatetime AS upd22_178_19_,
mvfeederna20_.feeder20id AS fee23_178_19_,
mvfeederna20_.giscode AS gis24_178_19_,
mvfeederna20_.feedertype AS fee25_178_19_,
mvfeederna20_.sensetivetype AS sen26_178_19_,
mvfeederna20_.consumetype AS con27_178_19_,
mvfeederna20_.isactive AS isa28_178_19_,
mvfeederna20_.isrotation AS isr29_178_19_,
mvfeederna20_.sensetiveplace AS sen30_178_19_,
mvfeederna20_.latitude AS lat31_178_19_,
mvfeederna20_.longitude AS lon32_178_19_,
mvfeederna20_.automatedkeycount AS aut33_178_19_,
mvfeederna20_.errordetectorcount AS err34_178_19_,
mvfeederna20_.operationdate AS ope35_178_19_,
mvfeederna20_.areatype AS are36_178_19_,
mvfeederna20_.outagegroup AS out37_178_19_,
mvfeederna20_.recloser AS rec38_178_19_,
mvfeederna20_.operationstatus AS ope39_178_19_,
mvfeederna20_.loadtype AS loa40_178_19_,
mvfeederna20_.islimitedforoutage AS isl41_178_19_,
mvfeederna20_.domesticsubscriberscount AS dom42_178_19_,
mvfeederna20_.industrialsubscriberscount AS ind43_178_19_,
mvfeederna20_.generalsubscriberscount AS gen44_178_19_,
mvfeederna20_.agriculturalsubscriberscount AS agr45_178_19_,
mvfeederna20_.othersubscriberscount AS oth46_178_19_,
mvfeederna20_.tavanirid AS tav47_178_19_,
mvfeederna20_.updated AS upd48_178_19_,
mvtrans21_.id AS id1_179_20_,
mvtrans21_.mvpostid AS mvpo2_179_20_,
mvtrans21_.naminalcapacity AS nami3_179_20_,
mvtrans21_.availablecapacity AS avai4_179_20_,
mvtrans21_.manufacturename AS manu5_179_20_,
mvtrans21_.transtype AS tran6_179_20_,
mvtrans21_.delflg AS delf7_179_20_,
mvtrans21_.transcode AS tran8_179_20_,
mvtrans21_.loadingper AS load9_179_20_,
mvtrans21_.transname AS tra10_179_20_,
mvtrans21_.modamserialnumber AS mod11_179_20_,
mvtrans21_.globalid AS glo12_179_20_,
mvtrans21_.voltagelevel1 AS vol13_179_20_,
mvtrans21_.voltagelevel2 AS vol14_179_20_,
mvtrans21_.sortflag AS sor15_179_20_,
mvtrans21_.giscode AS gis16_179_20_,
mvtrans21_.tavanirid AS tav17_179_20_,
mvtrans21_.updated AS upd18_179_20_,
mvpost22_.id AS id1_181_21_,
mvpost22_.postname AS post2_181_21_,
mvpost22_.mvposttype AS mvpo3_181_21_,
mvpost22_.postcode AS post4_181_21_,
mvpost22_.sortflag AS sort5_181_21_,
mvpost22_.delflg AS delf6_181_21_,
mvpost22_.globalid AS glob7_181_21_,
mvpost22_.gisobjectid AS giso8_181_21_,
mvpost22_.address AS addr9_181_21_,
mvpost22_.coveragearea AS cov10_181_21_,
mvpost22_.nominalpower AS nom11_181_21_,
mvpost22_.nominalamp AS nom12_181_21_,
mvpost22_.sensitiveplace AS sen13_181_21_,
mvpost22_.sensitivetype AS sen14_181_21_,
mvpost22_.latitude AS lat15_181_21_,
mvpost22_.longitude AS lon16_181_21_,
mvpost22_.omurid AS omu17_181_21_,
mvpost22_.giscode AS gis18_181_21_,
mvpost22_.tavanirid AS tav19_181_21_,
mvpost22_.updated AS upd20_181_21_,
omur23_.id AS id1_187_22_,
omur23_.omurname AS omur2_187_22_,
omur23_.showorder AS show3_187_22_,
omur23_.voiceid AS voic4_187_22_,
omur23_.deleted AS dele5_187_22_,
omur23_.code AS code6_187_22_,
omur23_.gisobjectid AS giso7_187_22_,
omur23_.lastobtaineddatetime AS last8_187_22_,
omur23_.taskalloweddistance AS task9_187_22_,
omur23_.tavanirid AS tav10_187_22_,
omur23_.updated AS upd11_187_22_,
omur23_.controllcenterid AS con12_187_22_,
subjectite24_.id AS id1_177_23_,
subjectite24_.subjid AS subj2_177_23_,
subjectite24_.itemnameen AS item3_177_23_,
subjectite24_.itemnamefa AS item4_177_23_,
subjectite24_.ismv AS ismv5_177_23_,
subjectite24_.mark AS mark6_177_23_,
subjectite24_.valuesubjid AS valu7_177_23_,
subjectite25_.id AS id1_177_24_,
subjectite25_.subjid AS subj2_177_24_,
subjectite25_.itemnameen AS item3_177_24_,
subjectite25_.itemnamefa AS item4_177_24_,
subjectite25_.ismv AS ismv5_177_24_,
subjectite25_.mark AS mark6_177_24_,
subjectite25_.valuesubjid AS valu7_177_24_,
subjectite26_.id AS id1_177_25_,
subjectite26_.subjid AS subj2_177_25_,
subjectite26_.itemnameen AS item3_177_25_,
subjectite26_.itemnamefa AS item4_177_25_,
subjectite26_.ismv AS ismv5_177_25_,
subjectite26_.mark AS mark6_177_25_,
subjectite26_.valuesubjid AS valu7_177_25_,
subjectite27_.id AS id1_177_26_,
subjectite27_.subjid AS subj2_177_26_,
subjectite27_.itemnameen AS item3_177_26_,
subjectite27_.itemnamefa AS item4_177_26_,
subjectite27_.ismv AS ismv5_177_26_,
subjectite27_.mark AS mark6_177_26_,
subjectite27_.valuesubjid AS valu7_177_26_,
subjectite28_.id AS id1_177_27_,
subjectite28_.subjid AS subj2_177_27_,
subjectite28_.itemnameen AS item3_177_27_,
subjectite28_.itemnamefa AS item4_177_27_,
subjectite28_.ismv AS ismv5_177_27_,
subjectite28_.mark AS mark6_177_27_,
subjectite28_.valuesubjid AS valu7_177_27_,
omur29_.id AS id1_187_28_,
omur29_.omurname AS omur2_187_28_,
omur29_.showorder AS show3_187_28_,
omur29_.voiceid AS voic4_187_28_,
omur29_.deleted AS dele5_187_28_,
omur29_.code AS code6_187_28_,
omur29_.gisobjectid AS giso7_187_28_,
omur29_.lastobtaineddatetime AS last8_187_28_,
omur29_.taskalloweddistance AS task9_187_28_,
omur29_.tavanirid AS tav10_187_28_,
omur29_.updated AS upd11_187_28_,
omur29_.controllcenterid AS con12_187_28_,
subjectite30_.id AS id1_177_29_,
subjectite30_.subjid AS subj2_177_29_,
subjectite30_.itemnameen AS item3_177_29_,
subjectite30_.itemnamefa AS item4_177_29_,
subjectite30_.ismv AS ismv5_177_29_,
subjectite30_.mark AS mark6_177_29_,
subjectite30_.valuesubjid AS valu7_177_29_,
subjectite31_.id AS id1_177_30_,
subjectite31_.subjid AS subj2_177_30_,
subjectite31_.itemnameen AS item3_177_30_,
subjectite31_.itemnamefa AS item4_177_30_,
subjectite31_.ismv AS ismv5_177_30_,
subjectite31_.mark AS mark6_177_30_,
subjectite31_.valuesubjid AS valu7_177_30_,
subjectite32_.id AS id1_177_31_,
subjectite32_.subjid AS subj2_177_31_,
subjectite32_.itemnameen AS item3_177_31_,
subjectite32_.itemnamefa AS item4_177_31_,
subjectite32_.ismv AS ismv5_177_31_,
subjectite32_.mark AS mark6_177_31_,
subjectite32_.valuesubjid AS valu7_177_31_,
subjectite33_.id AS id1_177_32_,
subjectite33_.subjid AS subj2_177_32_,
subjectite33_.itemnameen AS item3_177_32_,
subjectite33_.itemnamefa AS item4_177_32_,
subjectite33_.ismv AS ismv5_177_32_,
subjectite33_.mark AS mark6_177_32_,
subjectite33_.valuesubjid AS valu7_177_32_,
subjectite34_.id AS id1_177_33_,
subjectite34_.subjid AS subj2_177_33_,
subjectite34_.itemnameen AS item3_177_33_,
subjectite34_.itemnamefa AS item4_177_33_,
subjectite34_.ismv AS ismv5_177_33_,
subjectite34_.mark AS mark6_177_33_,
subjectite34_.valuesubjid AS valu7_177_33_,
omur35_.id AS id1_187_34_,
omur35_.omurname AS omur2_187_34_,
omur35_.showorder AS show3_187_34_,
omur35_.voiceid AS voic4_187_34_,
omur35_.deleted AS dele5_187_34_,
omur35_.code AS code6_187_34_,
omur35_.gisobjectid AS giso7_187_34_,
omur35_.lastobtaineddatetime AS last8_187_34_,
omur35_.taskalloweddistance AS task9_187_34_,
omur35_.tavanirid AS tav10_187_34_,
omur35_.updated AS upd11_187_34_,
omur35_.controllcenterid AS con12_187_34_,
region36_.id AS id1_195_35_,
region36_.regionname AS regi2_195_35_,
region36_.omurzoneid AS omur3_195_35_,
region36_.delflag AS delf4_195_35_,
region36_.sortflag AS sort5_195_35_,
region36_.description AS desc6_195_35_,
region36_.parentid AS pare7_195_35_,
region36_.voiceid AS voic8_195_35_,
region36_.tavanirid AS tava9_195_35_,
region36_.updated AS upd10_195_35_,
omurzone37_.id AS id1_197_36_,
omurzone37_.omurid AS omur2_197_36_,
omurzone37_.zonename AS zone3_197_36_,
omurzone37_.tavanirid AS tava4_197_36_,
omurzone37_.updated AS upda5_197_36_,
omurzone38_.id AS id1_197_37_,
omurzone38_.omurid AS omur2_197_37_,
omurzone38_.zonename AS zone3_197_37_,
omurzone38_.tavanirid AS tava4_197_37_,
omurzone38_.updated AS upda5_197_37_,
omur39_.id AS id1_187_38_,
omur39_.omurname AS omur2_187_38_,
omur39_.showorder AS show3_187_38_,
omur39_.voiceid AS voic4_187_38_,
omur39_.deleted AS dele5_187_38_,
omur39_.code AS code6_187_38_,
omur39_.gisobjectid AS giso7_187_38_,
omur39_.lastobtaineddatetime AS last8_187_38_,
omur39_.taskalloweddistance AS task9_187_38_,
omur39_.tavanirid AS tav10_187_38_,
omur39_.updated AS upd11_187_38_,
omur39_.controllcenterid AS con12_187_38_,
omurzone40_.id AS id1_197_39_,
omurzone40_.omurid AS omur2_197_39_,
omurzone40_.zonename AS zone3_197_39_,
omurzone40_.tavanirid AS tava4_197_39_,
omurzone40_.updated AS upda5_197_39_,
eventstatu41_.id AS id1_184_40_,
eventstatu41_.statustitle AS stat2_184_40_,
eventstatu41_.statuscolor AS stat3_184_40_,
eventstatu41_.isscheduled AS issc4_184_40_,
eventstatu41_.isnotscheduled AS isno5_184_40_,
eventstatu41_.nameen AS name6_184_40_,
eventflows42_.id AS id1_7_41_,
eventflows42_.flowstatustitle AS flowst2_7_41_,
eventflows42_.flowstatuscolor AS flowst3_7_41_,
eventflows42_.flowstatusconsumertitle AS flowst4_7_41_,
eventflows42_.nameen AS nameen5_7_41_,
outagereas43_.id AS id1_174_42_,
outagereas43_.parentid AS pare2_174_42_,
outagereas43_.itemname_fa AS item3_174_42_,
outagereas43_.itemname_en AS item4_174_42_,
outagereas43_.itemname_en2 AS item5_174_42_,
outagereas43_.itemcode AS item6_174_42_,
outagereas43_.itempath AS item7_174_42_,
outagereas43_.shouldbeshownasnoactionisrequiredreason AS shou8_174_42_,
outagereas43_.firstparentid AS firs9_174_42_,
outagereas43_.secondparentid AS sec10_174_42_,
outagereas43_.sortflag AS sor11_174_42_,
outagereas43_.istransient AS ist12_174_42_,
outagereas43_.isemergency AS ise13_174_42_,
outagereas43_.shouldsendtosanam AS sho14_174_42_,
outagereas43_.parentcolor AS par15_174_42_,
outagereas43_.averagehandlingtime AS ave16_174_42_,
outagereas43_.repairestimatedtime AS rep17_174_42_,
outagereas43_.ismandatoryworkpermit AS ism18_174_42_,
outagereas43_.consumeritemname_fa AS con19_174_42_,
outagereas43_.outageclassid AS out20_174_42_,
outagereas43_.outagegroupid AS out21_174_42_,
outagereas44_.id AS id1_174_43_,
outagereas44_.parentid AS pare2_174_43_,
outagereas44_.itemname_fa AS item3_174_43_,
outagereas44_.itemname_en AS item4_174_43_,
outagereas44_.itemname_en2 AS item5_174_43_,
outagereas44_.itemcode AS item6_174_43_,
outagereas44_.itempath AS item7_174_43_,
outagereas44_.shouldbeshownasnoactionisrequiredreason AS shou8_174_43_,
outagereas44_.firstparentid AS firs9_174_43_,
outagereas44_.secondparentid AS sec10_174_43_,
outagereas44_.sortflag AS sor11_174_43_,
outagereas44_.istransient AS ist12_174_43_,
outagereas44_.isemergency AS ise13_174_43_,
outagereas44_.shouldsendtosanam AS sho14_174_43_,
outagereas44_.parentcolor AS par15_174_43_,
outagereas44_.averagehandlingtime AS ave16_174_43_,
outagereas44_.repairestimatedtime AS rep17_174_43_,
outagereas44_.ismandatoryworkpermit AS ism18_174_43_,
outagereas44_.consumeritemname_fa AS con19_174_43_,
outagereas44_.outageclassid AS out20_174_43_,
outagereas44_.outagegroupid AS out21_174_43_,
outagereas45_.id AS id1_174_44_,
outagereas45_.parentid AS pare2_174_44_,
outagereas45_.itemname_fa AS item3_174_44_,
outagereas45_.itemname_en AS item4_174_44_,
outagereas45_.itemname_en2 AS item5_174_44_,
outagereas45_.itemcode AS item6_174_44_,
outagereas45_.itempath AS item7_174_44_,
outagereas45_.shouldbeshownasnoactionisrequiredreason AS shou8_174_44_,
outagereas45_.firstparentid AS firs9_174_44_,
outagereas45_.secondparentid AS sec10_174_44_,
outagereas45_.sortflag AS sor11_174_44_,
outagereas45_.istransient AS ist12_174_44_,
outagereas45_.isemergency AS ise13_174_44_,
outagereas45_.shouldsendtosanam AS sho14_174_44_,
outagereas45_.parentcolor AS par15_174_44_,
outagereas45_.averagehandlingtime AS ave16_174_44_,
outagereas45_.repairestimatedtime AS rep17_174_44_,
outagereas45_.ismandatoryworkpermit AS ism18_174_44_,
outagereas45_.consumeritemname_fa AS con19_174_44_,
outagereas45_.outageclassid AS out20_174_44_,
outagereas45_.outagegroupid AS out21_174_44_,
outagereas46_.id AS id1_174_45_,
outagereas46_.parentid AS pare2_174_45_,
outagereas46_.itemname_fa AS item3_174_45_,
outagereas46_.itemname_en AS item4_174_45_,
outagereas46_.itemname_en2 AS item5_174_45_,
outagereas46_.itemcode AS item6_174_45_,
outagereas46_.itempath AS item7_174_45_,
outagereas46_.shouldbeshownasnoactionisrequiredreason AS shou8_174_45_,
outagereas46_.firstparentid AS firs9_174_45_,
outagereas46_.secondparentid AS sec10_174_45_,
outagereas46_.sortflag AS sor11_174_45_,
outagereas46_.istransient AS ist12_174_45_,
outagereas46_.isemergency AS ise13_174_45_,
outagereas46_.shouldsendtosanam AS sho14_174_45_,
outagereas46_.parentcolor AS par15_174_45_,
outagereas46_.averagehandlingtime AS ave16_174_45_,
outagereas46_.repairestimatedtime AS rep17_174_45_,
outagereas46_.ismandatoryworkpermit AS ism18_174_45_,
outagereas46_.consumeritemname_fa AS con19_174_45_,
outagereas46_.outageclassid AS out20_174_45_,
outagereas46_.outagegroupid AS out21_174_45_,
subjectite47_.id AS id1_177_46_,
subjectite47_.subjid AS subj2_177_46_,
subjectite47_.itemnameen AS item3_177_46_,
subjectite47_.itemnamefa AS item4_177_46_,
subjectite47_.ismv AS ismv5_177_46_,
subjectite47_.mark AS mark6_177_46_,
subjectite47_.valuesubjid AS valu7_177_46_,
tavanirout48_.id AS id1_27_47_,
tavanirout48_.NAME AS name2_27_47_,
tavanirout48_.tavanirid AS tavan3_27_47_,
tavanirout49_.id AS id1_28_48_,
tavanirout49_.NAME AS name2_28_48_,
tavanirout49_.tavanirid AS tavan3_28_48_,
tavanirout49_.outageclassid AS outag4_28_48_,
tavanirout50_.id AS id1_27_49_,
tavanirout50_.NAME AS name2_27_49_,
tavanirout50_.tavanirid AS tavan3_27_49_,
failure51_.id AS id1_183_50_,
failure51_.parrentid AS parr2_183_50_,
failure51_.failuredescp AS fail3_183_50_,
failure51_.fspecialflow AS fspe4_183_50_,
failure51_.fspecialphase AS fspe5_183_50_,
failure51_.sortflag AS sort6_183_50_,
failure51_.outageproblemid AS outa7_183_50_,
outagereas52_.id AS id1_174_51_,
outagereas52_.parentid AS pare2_174_51_,
outagereas52_.itemname_fa AS item3_174_51_,
outagereas52_.itemname_en AS item4_174_51_,
outagereas52_.itemname_en2 AS item5_174_51_,
outagereas52_.itemcode AS item6_174_51_,
outagereas52_.itempath AS item7_174_51_,
outagereas52_.shouldbeshownasnoactionisrequiredreason AS shou8_174_51_,
outagereas52_.firstparentid AS firs9_174_51_,
outagereas52_.secondparentid AS sec10_174_51_,
outagereas52_.sortflag AS sor11_174_51_,
outagereas52_.istransient AS ist12_174_51_,
outagereas52_.isemergency AS ise13_174_51_,
outagereas52_.shouldsendtosanam AS sho14_174_51_,
outagereas52_.parentcolor AS par15_174_51_,
outagereas52_.averagehandlingtime AS ave16_174_51_,
outagereas52_.repairestimatedtime AS rep17_174_51_,
outagereas52_.ismandatoryworkpermit AS ism18_174_51_,
outagereas52_.consumeritemname_fa AS con19_174_51_,
outagereas52_.outageclassid AS out20_174_51_,
outagereas52_.outagegroupid AS out21_174_51_,
tavanirout53_.id AS id1_29_52_,
tavanirout53_.NAME AS name2_29_52_,
tavanirout53_.tavanirid AS tavan3_29_52_,
tavanirout53_.outagegroupid AS outag4_29_52_,
tavanirout54_.id AS id1_28_53_,
tavanirout54_.NAME AS name2_28_53_,
tavanirout54_.tavanirid AS tavan3_28_53_,
tavanirout54_.outageclassid AS outag4_28_53_,
defect55_.id AS id1_182_54_,
defect55_.parentid AS pare2_182_54_,
defect55_.defectdescp AS defe3_182_54_,
defect55_.sortflag AS sort4_182_54_,
defect55_.outagereasonid AS outa5_182_54_,
outagereas56_.id AS id1_174_55_,
outagereas56_.parentid AS pare2_174_55_,
outagereas56_.itemname_fa AS item3_174_55_,
outagereas56_.itemname_en AS item4_174_55_,
outagereas56_.itemname_en2 AS item5_174_55_,
outagereas56_.itemcode AS item6_174_55_,
outagereas56_.itempath AS item7_174_55_,
outagereas56_.shouldbeshownasnoactionisrequiredreason AS shou8_174_55_,
outagereas56_.firstparentid AS firs9_174_55_,
outagereas56_.secondparentid AS sec10_174_55_,
outagereas56_.sortflag AS sor11_174_55_,
outagereas56_.istransient AS ist12_174_55_,
outagereas56_.isemergency AS ise13_174_55_,
outagereas56_.shouldsendtosanam AS sho14_174_55_,
outagereas56_.parentcolor AS par15_174_55_,
outagereas56_.averagehandlingtime AS ave16_174_55_,
outagereas56_.repairestimatedtime AS rep17_174_55_,
outagereas56_.ismandatoryworkpermit AS ism18_174_55_,
outagereas56_.consumeritemname_fa AS con19_174_55_,
outagereas56_.outageclassid AS out20_174_55_,
outagereas56_.outagegroupid AS out21_174_55_,
tavanirout57_.id AS id1_30_56_,
tavanirout57_.NAME AS name2_30_56_,
tavanirout57_.tavanirid AS tavan3_30_56_,
tavanirout57_.outagegroupid AS outag4_30_56_,
tavanirout58_.id AS id1_28_57_,
tavanirout58_.NAME AS name2_28_57_,
tavanirout58_.tavanirid AS tavan3_28_57_,
tavanirout58_.outageclassid AS outag4_28_57_,
subjectite59_.id AS id1_177_58_,
subjectite59_.subjid AS subj2_177_58_,
subjectite59_.itemnameen AS item3_177_58_,
subjectite59_.itemnamefa AS item4_177_58_,
subjectite59_.ismv AS ismv5_177_58_,
subjectite59_.mark AS mark6_177_58_,
subjectite59_.valuesubjid AS valu7_177_58_,
user60_.id AS id1_190_59_,
user60_.username AS user2_190_59_,
user60_.loginname AS logi3_190_59_,
user60_.loginpasshash AS logi4_190_59_,
user60_.delflg AS delf5_190_59_,
user60_.userno AS user6_190_59_,
user60_.usermobile AS user7_190_59_,
user60_.isvip AS isvi8_190_59_,
user60_.isactive AS isac9_190_59_,
user60_.additionalomurids AS add10_190_59_,
user60_.depid AS dep11_190_59_,
user60_.omurid AS omu12_190_59_,
user60_.profileid AS pro13_190_59_,
omur61_.id AS id1_187_60_,
omur61_.omurname AS omur2_187_60_,
omur61_.showorder AS show3_187_60_,
omur61_.voiceid AS voic4_187_60_,
omur61_.deleted AS dele5_187_60_,
omur61_.code AS code6_187_60_,
omur61_.gisobjectid AS giso7_187_60_,
omur61_.lastobtaineddatetime AS last8_187_60_,
omur61_.taskalloweddistance AS task9_187_60_,
omur61_.tavanirid AS tav10_187_60_,
omur61_.updated AS upd11_187_60_,
omur61_.controllcenterid AS con12_187_60_,
city62_.id AS id1_49_61_,
city62_.profilename AS profi2_49_61_,
city62_.cityid AS cityi3_49_61_,
city62_.active AS activ4_49_61_,
city62_.dbserver AS dbser5_49_61_,
city62_.dbname AS dbnam6_49_61_,
city62_.dbuser AS dbuse7_49_61_,
city62_.dbpass AS dbpas8_49_61_,
city62_.recserver AS recse9_49_61_,
city62_.recfolder AS recf10_49_61_,
city62_.recuser AS recu11_49_61_,
city62_.recpass AS recp12_49_61_,
city62_.ccserver AS ccse13_49_61_,
city62_.ccport AS ccpo14_49_61_,
city62_.ccuser AS ccus15_49_61_,
city62_.ccpass AS ccpa16_49_61_,
city62_.hconfig AS hcon17_49_61_,
city62_.refreshtimesec AS refr18_49_61_,
city62_.companyname AS comp19_49_61_,
city62_.organizationname AS orga20_49_61_,
city62_.softwareversion AS soft21_49_61_,
city62_.proxyport AS prox22_49_61_,
city62_.queue AS queu23_49_61_,
city62_.mainserver AS main24_49_61_,
city62_.maindbn AS main25_49_61_,
city62_.domain AS doma26_49_61_,
city62_.recserverport AS recs27_49_61_,
city62_.omurid AS omur28_49_61_,
omur63_.id AS id1_187_62_,
omur63_.omurname AS omur2_187_62_,
omur63_.showorder AS show3_187_62_,
omur63_.voiceid AS voic4_187_62_,
omur63_.deleted AS dele5_187_62_,
omur63_.code AS code6_187_62_,
omur63_.gisobjectid AS giso7_187_62_,
omur63_.lastobtaineddatetime AS last8_187_62_,
omur63_.taskalloweddistance AS task9_187_62_,
omur63_.tavanirid AS tav10_187_62_,
omur63_.updated AS upd11_187_62_,
omur63_.controllcenterid AS con12_187_62_,
department64_.id AS id1_192_63_,
department64_.parentdepid AS pare2_192_63_,
department64_.depname AS depn3_192_63_,
department64_.delflg AS delf4_192_63_,
department65_.id AS id1_192_64_,
department65_.parentdepid AS pare2_192_64_,
department65_.depname AS depn3_192_64_,
department65_.delflg AS delf4_192_64_,
user66_.id AS id1_190_65_,
user66_.username AS user2_190_65_,
user66_.loginname AS logi3_190_65_,
user66_.loginpasshash AS logi4_190_65_,
user66_.delflg AS delf5_190_65_,
user66_.userno AS user6_190_65_,
user66_.usermobile AS user7_190_65_,
user66_.isvip AS isvi8_190_65_,
user66_.isactive AS isac9_190_65_,
user66_.additionalomurids AS add10_190_65_,
user66_.depid AS dep11_190_65_,
user66_.omurid AS omu12_190_65_,
user66_.profileid AS pro13_190_65_,
user67_.id AS id1_190_66_,
user67_.username AS user2_190_66_,
user67_.loginname AS logi3_190_66_,
user67_.loginpasshash AS logi4_190_66_,
user67_.delflg AS delf5_190_66_,
user67_.userno AS user6_190_66_,
user67_.usermobile AS user7_190_66_,
user67_.isvip AS isvi8_190_66_,
user67_.isactive AS isac9_190_66_,
user67_.additionalomurids AS add10_190_66_,
user67_.depid AS dep11_190_66_,
user67_.omurid AS omu12_190_66_,
user67_.profileid AS pro13_190_66_,
subjectite68_.id AS id1_177_67_,
subjectite68_.subjid AS subj2_177_67_,
subjectite68_.itemnameen AS item3_177_67_,
subjectite68_.itemnamefa AS item4_177_67_,
subjectite68_.ismv AS ismv5_177_67_,
subjectite68_.mark AS mark6_177_67_,
subjectite68_.valuesubjid AS valu7_177_67_,
subjectite69_.id AS id1_177_68_,
subjectite69_.subjid AS subj2_177_68_,
subjectite69_.itemnameen AS item3_177_68_,
subjectite69_.itemnamefa AS item4_177_68_,
subjectite69_.ismv AS ismv5_177_68_,
subjectite69_.mark AS mark6_177_68_,
subjectite69_.valuesubjid AS valu7_177_68_,
disconnect70_.id AS id1_188_69_,
disconnect70_.typeid AS type2_188_69_,
disconnect70_.NAME AS name3_188_69_,
disconnect70_.parentid AS pare4_188_69_,
disconnect70_.code AS code5_188_69_,
disconnect70_.address AS addr6_188_69_,
disconnect70_.comment AS comm7_188_69_,
disconnect70_.feedercode AS feed8_188_69_,
disconnect70_.delflag AS delf9_188_69_,
disconnect70_.globalid AS glo10_188_69_,
disconnect70_.needtoupdate AS nee11_188_69_,
disconnect70_.lat AS lat12_188_69_,
disconnect70_.lon AS lon13_188_69_,
disconnect70_.updatestartdate AS upd14_188_69_,
disconnect70_.updateenddate AS upd15_188_69_,
disconnect70_.giscode AS gis16_188_69_,
disconnect70_.omurid AS omu17_188_69_,
subjectite71_.id AS id1_177_70_,
subjectite71_.subjid AS subj2_177_70_,
subjectite71_.itemnameen AS item3_177_70_,
subjectite71_.itemnamefa AS item4_177_70_,
subjectite71_.ismv AS ismv5_177_70_,
subjectite71_.mark AS mark6_177_70_,
subjectite71_.valuesubjid AS valu7_177_70_,
omur72_.id AS id1_187_71_,
omur72_.omurname AS omur2_187_71_,
omur72_.showorder AS show3_187_71_,
omur72_.voiceid AS voic4_187_71_,
omur72_.deleted AS dele5_187_71_,
omur72_.code AS code6_187_71_,
omur72_.gisobjectid AS giso7_187_71_,
omur72_.lastobtaineddatetime AS last8_187_71_,
omur72_.taskalloweddistance AS task9_187_71_,
omur72_.tavanirid AS tav10_187_71_,
omur72_.updated AS upd11_187_71_,
omur72_.controllcenterid AS con12_187_71_,
post73_.id AS id1_175_72_,
post73_.postname AS post2_175_72_,
post73_.postaddress AS post3_175_72_,
post73_.posttype AS post4_175_72_,
post73_.sensitivetype AS sens5_175_72_,
post73_.voltagelevel1 AS volt6_175_72_,
post73_.voltagelevel2 AS volt7_175_72_,
post73_.postcode AS post8_175_72_,
post73_.postereatype AS post9_175_72_,
post73_.postfusetype AS pos10_175_72_,
post73_.postfuseamper AS pos11_175_72_,
post73_.producedyear AS pro12_175_72_,
post73_.setupdate AS set13_175_72_,
post73_.sortflag AS sor14_175_72_,
post73_.giscode AS gis15_175_72_,
post73_.delflg AS del16_175_72_,
post73_.globalid AS glo17_175_72_,
post73_.lat AS lat18_175_72_,
post73_.lon AS lon19_175_72_,
post73_.post20id AS pos20_175_72_,
post73_.electricresistance AS ele21_175_72_,
post73_.electriclinelength AS ele22_175_72_,
post73_.electricresistancedate AS ele23_175_72_,
post73_.protectionalresistance AS pro24_175_72_,
post73_.protectionallinelength AS pro25_175_72_,
post73_.protectionalresistancedate AS pro26_175_72_,
post73_.apptype AS app27_175_72_,
post73_.isactive AS isa28_175_72_,
post73_.isautomated AS isa29_175_72_,
post73_.ismonitored AS ism30_175_72_,
post73_.omurid2 AS omu31_175_72_,
post73_.zonename AS zon32_175_72_,
post73_.mvfeederid AS mvf33_175_72_,
post73_.postconsumertype AS pos34_175_72_,
post73_.loadtype AS loa35_175_72_,
post73_.omurid AS omu36_175_72_,
post73_.regionid AS reg37_175_72_,
post73_.omurzoneid AS omu38_175_72_,
post73_.tavanirid AS tav39_175_72_,
post73_.updated AS upd40_175_72_,
mvfeederna74_.id AS id1_178_73_,
mvfeederna74_.mvtransid AS mvtr2_178_73_,
mvfeederna74_.feedername AS feed3_178_73_,
mvfeederna74_.enfeedername AS enfe4_178_73_,
mvfeederna74_.feederdescribtion AS feed5_178_73_,
mvfeederna74_.fcolorr AS fcol6_178_73_,
mvfeederna74_.fcolorg AS fcol7_178_73_,
mvfeederna74_.fcolorb AS fcol8_178_73_,
mvfeederna74_.overheadlinelength AS over9_178_73_,
mvfeederna74_.undergroundlinelength AS und10_178_73_,
mvfeederna74_.mainomurid AS mai11_178_73_,
mvfeederna74_.gisobjectid AS gis12_178_73_,
mvfeederna74_.delflg AS del13_178_73_,
mvfeederna74_.globalid AS glo14_178_73_,
mvfeederna74_.loadpeak AS loa15_178_73_,
mvfeederna74_.owningpercent AS own16_178_73_,
mvfeederna74_.commonwith AS com17_178_73_,
mvfeederna74_.feedercode AS fee18_178_73_,
mvfeederna74_.modammvfeedercode AS mod19_178_73_,
mvfeederna74_.sortflag AS sor20_178_73_,
mvfeederna74_.changedversion AS cha21_178_73_,
mvfeederna74_.updatedatetime AS upd22_178_73_,
mvfeederna74_.feeder20id AS fee23_178_73_,
mvfeederna74_.giscode AS gis24_178_73_,
mvfeederna74_.feedertype AS fee25_178_73_,
mvfeederna74_.sensetivetype AS sen26_178_73_,
mvfeederna74_.consumetype AS con27_178_73_,
mvfeederna74_.isactive AS isa28_178_73_,
mvfeederna74_.isrotation AS isr29_178_73_,
mvfeederna74_.sensetiveplace AS sen30_178_73_,
mvfeederna74_.latitude AS lat31_178_73_,
mvfeederna74_.longitude AS lon32_178_73_,
mvfeederna74_.automatedkeycount AS aut33_178_73_,
mvfeederna74_.errordetectorcount AS err34_178_73_,
mvfeederna74_.operationdate AS ope35_178_73_,
mvfeederna74_.areatype AS are36_178_73_,
mvfeederna74_.outagegroup AS out37_178_73_,
mvfeederna74_.recloser AS rec38_178_73_,
mvfeederna74_.operationstatus AS ope39_178_73_,
mvfeederna74_.loadtype AS loa40_178_73_,
mvfeederna74_.islimitedforoutage AS isl41_178_73_,
mvfeederna74_.domesticsubscriberscount AS dom42_178_73_,
mvfeederna74_.industrialsubscriberscount AS ind43_178_73_,
mvfeederna74_.generalsubscriberscount AS gen44_178_73_,
mvfeederna74_.agriculturalsubscriberscount AS agr45_178_73_,
mvfeederna74_.othersubscriberscount AS oth46_178_73_,
mvfeederna74_.tavanirid AS tav47_178_73_,
mvfeederna74_.updated AS upd48_178_73_,
lvfeeder75_.id AS id1_173_74_,
lvfeeder75_.feedername AS feed2_173_74_,
lvfeeder75_.feederdescribtion AS feed3_173_74_,
lvfeeder75_.fcolorr AS fcol4_173_74_,
lvfeeder75_.fcolorg AS fcol5_173_74_,
lvfeeder75_.fcolorb AS fcol6_173_74_,
lvfeeder75_.overheadlinelength AS over7_173_74_,
lvfeeder75_.undergroundlinelength AS unde8_173_74_,
lvfeeder75_.operationstatus AS oper9_173_74_,
lvfeeder75_.loadtype AS loa10_173_74_,
lvfeeder75_.ismonitoring AS ism11_173_74_,
lvfeeder75_.isautomation AS isa12_173_74_,
lvfeeder75_.cablesize AS cab13_173_74_,
lvfeeder75_.cablepath AS cab14_173_74_,
lvfeeder75_.feedertype AS fee15_173_74_,
lvfeeder75_.delflg AS del16_173_74_,
lvfeeder75_.consumetype AS con17_173_74_,
lvfeeder75_.loadpeak AS loa18_173_74_,
lvfeeder75_.owningpercent AS own19_173_74_,
lvfeeder75_.commonwith AS com20_173_74_,
lvfeeder75_.feedercode AS fee21_173_74_,
lvfeeder75_.sortflag AS sor22_173_74_,
lvfeeder75_.globalid AS glo23_173_74_,
lvfeeder75_.lat AS lat24_173_74_,
lvfeeder75_.lon AS lon25_173_74_,
lvfeeder75_.giscode AS gis26_173_74_,
lvfeeder75_.transid AS tra27_173_74_,
lvfeeder75_.tavanirid AS tav28_173_74_,
lvfeeder75_.updated AS upd29_173_74_,
subjectite76_.id AS id1_177_75_,
subjectite76_.subjid AS subj2_177_75_,
subjectite76_.itemnameen AS item3_177_75_,
subjectite76_.itemnamefa AS item4_177_75_,
subjectite76_.ismv AS ismv5_177_75_,
subjectite76_.mark AS mark6_177_75_,
subjectite76_.valuesubjid AS valu7_177_75_,
subjectite77_.id AS id1_177_76_,
subjectite77_.subjid AS subj2_177_76_,
subjectite77_.itemnameen AS item3_177_76_,
subjectite77_.itemnamefa AS item4_177_76_,
subjectite77_.ismv AS ismv5_177_76_,
subjectite77_.mark AS mark6_177_76_,
subjectite77_.valuesubjid AS valu7_177_76_,
trans78_.id AS id1_185_77_,
trans78_.availablecapacity AS avai2_185_77_,
trans78_.manufacturename AS manu3_185_77_,
trans78_.activeload AS acti4_185_77_,
trans78_.reactiveload AS reac5_185_77_,
trans78_.loadingdate AS load6_185_77_,
trans78_.loadingtime AS load7_185_77_,
trans78_.transcode AS tran8_185_77_,
trans78_.loadingper AS load9_185_77_,
trans78_.sortflag AS sor10_185_77_,
trans78_.cabletopanelcount AS cab11_185_77_,
trans78_.cabletopanelsize1id AS cab12_185_77_,
trans78_.cabletopanelsize2id AS cab13_185_77_,
trans78_.cabletopanelsize3id AS cab14_185_77_,
trans78_.cabletopanelmadeid AS cab15_185_77_,
trans78_.serialnumber AS ser16_185_77_,
trans78_.manufactureyear AS man17_185_77_,
trans78_.transcomment AS tra18_185_77_,
trans78_.globalid AS glo19_185_77_,
trans78_.giscode AS gis20_185_77_,
trans78_.transtype AS tra21_185_77_,
trans78_.naminalcapacity AS nam22_185_77_,
trans78_.transconsumertype AS tra23_185_77_,
trans78_.postid AS pos24_185_77_,
trans78_.reformedcapacity AS ref25_185_77_,
trans78_.tavanirid AS tav26_185_77_,
trans78_.updated AS upd27_185_77_,
trans78_.delflg AS del28_185_77_,
trans78_.isactive AS isa29_185_77_,
trans78_.transmodelid AS tra30_185_77_,
trans78_.cabletopanelsize1bid AS cab31_185_77_,
trans78_.cabletopanelsize2bid AS cab32_185_77_,
trans78_.cabletopanelsize1cid AS cab33_185_77_,
trans78_.cabletopanelsize2cid AS cab34_185_77_,
trans78_.cabletopanelsize1did AS cab35_185_77_,
trans78_.cabletopanelsize2did AS cab36_185_77_,
trans78_.cabletopanelcountb AS cab37_185_77_,
trans78_.cabletopanelcountc AS cab38_185_77_,
trans78_.cabletopanelcountd AS cab39_185_77_,
trans78_.cabletopanelncount AS cab40_185_77_,
trans78_.cabletopanelncountb AS cab41_185_77_,
trans78_.cabletopanelncountc AS cab42_185_77_,
trans78_.cabletopanelncountd AS cab43_185_77_,
trans78_.cabletopanelmadebid AS cab44_185_77_,
trans78_.cabletopanelmadecid AS cab45_185_77_,
trans78_.cabletopanelmadedid AS cab46_185_77_,
trans78_.allowedloadingamper AS all47_185_77_,
trans78_.hascapacitor AS has48_185_77_,
trans78_.manufactureid AS man49_185_77_,
trans78_.installdate AS ins50_185_77_,
trans78_.boardcount AS boa51_185_77_,
trans78_.operationdate AS ope52_185_77_,
trans78_.register AS reg53_185_77_,
trans78_.status AS sta54_185_77_,
trans78_.registertype AS reg55_185_77_,
subjectite79_.id AS id1_177_78_,
subjectite79_.subjid AS subj2_177_78_,
subjectite79_.itemnameen AS item3_177_78_,
subjectite79_.itemnamefa AS item4_177_78_,
subjectite79_.ismv AS ismv5_177_78_,
subjectite79_.mark AS mark6_177_78_,
subjectite79_.valuesubjid AS valu7_177_78_,
subjectite80_.id AS id1_177_79_,
subjectite80_.subjid AS subj2_177_79_,
subjectite80_.itemnameen AS item3_177_79_,
subjectite80_.itemnamefa AS item4_177_79_,
subjectite80_.ismv AS ismv5_177_79_,
subjectite80_.mark AS mark6_177_79_,
subjectite80_.valuesubjid AS valu7_177_79_,
subjectite81_.id AS id1_177_80_,
subjectite81_.subjid AS subj2_177_80_,
subjectite81_.itemnameen AS item3_177_80_,
subjectite81_.itemnamefa AS item4_177_80_,
subjectite81_.ismv AS ismv5_177_80_,
subjectite81_.mark AS mark6_177_80_,
subjectite81_.valuesubjid AS valu7_177_80_,
post82_.id AS id1_175_81_,
post82_.postname AS post2_175_81_,
post82_.postaddress AS post3_175_81_,
post82_.posttype AS post4_175_81_,
post82_.sensitivetype AS sens5_175_81_,
post82_.voltagelevel1 AS volt6_175_81_,
post82_.voltagelevel2 AS volt7_175_81_,
post82_.postcode AS post8_175_81_,
post82_.postereatype AS post9_175_81_,
post82_.postfusetype AS pos10_175_81_,
post82_.postfuseamper AS pos11_175_81_,
post82_.producedyear AS pro12_175_81_,
post82_.setupdate AS set13_175_81_,
post82_.sortflag AS sor14_175_81_,
post82_.giscode AS gis15_175_81_,
post82_.delflg AS del16_175_81_,
post82_.globalid AS glo17_175_81_,
post82_.lat AS lat18_175_81_,
post82_.lon AS lon19_175_81_,
post82_.post20id AS pos20_175_81_,
post82_.electricresistance AS ele21_175_81_,
post82_.electriclinelength AS ele22_175_81_,
post82_.electricresistancedate AS ele23_175_81_,
post82_.protectionalresistance AS pro24_175_81_,
post82_.protectionallinelength AS pro25_175_81_,
post82_.protectionalresistancedate AS pro26_175_81_,
post82_.apptype AS app27_175_81_,
post82_.isactive AS isa28_175_81_,
post82_.isautomated AS isa29_175_81_,
post82_.ismonitored AS ism30_175_81_,
post82_.omurid2 AS omu31_175_81_,
post82_.zonename AS zon32_175_81_,
post82_.mvfeederid AS mvf33_175_81_,
post82_.postconsumertype AS pos34_175_81_,
post82_.loadtype AS loa35_175_81_,
post82_.omurid AS omu36_175_81_,
post82_.regionid AS reg37_175_81_,
post82_.omurzoneid AS omu38_175_81_,
post82_.tavanirid AS tav39_175_81_,
post82_.updated AS upd40_175_81_,
trans83_.id AS id1_185_82_,
trans83_.availablecapacity AS avai2_185_82_,
trans83_.manufacturename AS manu3_185_82_,
trans83_.activeload AS acti4_185_82_,
trans83_.reactiveload AS reac5_185_82_,
trans83_.loadingdate AS load6_185_82_,
trans83_.loadingtime AS load7_185_82_,
trans83_.transcode AS tran8_185_82_,
trans83_.loadingper AS load9_185_82_,
trans83_.sortflag AS sor10_185_82_,
trans83_.cabletopanelcount AS cab11_185_82_,
trans83_.cabletopanelsize1id AS cab12_185_82_,
trans83_.cabletopanelsize2id AS cab13_185_82_,
trans83_.cabletopanelsize3id AS cab14_185_82_,
trans83_.cabletopanelmadeid AS cab15_185_82_,
trans83_.serialnumber AS ser16_185_82_,
trans83_.manufactureyear AS man17_185_82_,
trans83_.transcomment AS tra18_185_82_,
trans83_.globalid AS glo19_185_82_,
trans83_.giscode AS gis20_185_82_,
trans83_.transtype AS tra21_185_82_,
trans83_.naminalcapacity AS nam22_185_82_,
trans83_.transconsumertype AS tra23_185_82_,
trans83_.postid AS pos24_185_82_,
trans83_.reformedcapacity AS ref25_185_82_,
trans83_.tavanirid AS tav26_185_82_,
trans83_.updated AS upd27_185_82_,
trans83_.delflg AS del28_185_82_,
trans83_.isactive AS isa29_185_82_,
trans83_.transmodelid AS tra30_185_82_,
trans83_.cabletopanelsize1bid AS cab31_185_82_,
trans83_.cabletopanelsize2bid AS cab32_185_82_,
trans83_.cabletopanelsize1cid AS cab33_185_82_,
trans83_.cabletopanelsize2cid AS cab34_185_82_,
trans83_.cabletopanelsize1did AS cab35_185_82_,
trans83_.cabletopanelsize2did AS cab36_185_82_,
trans83_.cabletopanelcountb AS cab37_185_82_,
trans83_.cabletopanelcountc AS cab38_185_82_,
trans83_.cabletopanelcountd AS cab39_185_82_,
trans83_.cabletopanelncount AS cab40_185_82_,
trans83_.cabletopanelncountb AS cab41_185_82_,
trans83_.cabletopanelncountc AS cab42_185_82_,
trans83_.cabletopanelncountd AS cab43_185_82_,
trans83_.cabletopanelmadebid AS cab44_185_82_,
trans83_.cabletopanelmadecid AS cab45_185_82_,
trans83_.cabletopanelmadedid AS cab46_185_82_,
trans83_.allowedloadingamper AS all47_185_82_,
trans83_.hascapacitor AS has48_185_82_,
trans83_.manufactureid AS man49_185_82_,
trans83_.installdate AS ins50_185_82_,
trans83_.boardcount AS boa51_185_82_,
trans83_.operationdate AS ope52_185_82_,
trans83_.register AS reg53_185_82_,
trans83_.status AS sta54_185_82_,
trans83_.registertype AS reg55_185_82_,
outageeven84_.id AS id1_35_83_,
outageeven84_.contactdate AS conta4_35_83_,
outageeven84_.newcontactdate AS newco5_35_83_,
outageeven84_.newcontacttime AS newco6_35_83_,
outageeven84_.contacttime AS conta7_35_83_,
outageeven84_.eventdate AS event8_35_83_,
outageeven84_.eventtime AS event9_35_83_,
outageeven84_.eventreason2 AS even10_35_83_,
outageeven84_.failureid2 AS fail11_35_83_,
outageeven84_.defectid2 AS defe12_35_83_,
outageeven84_.eventreason3 AS even13_35_83_,
outageeven84_.failureid3 AS fail14_35_83_,
outageeven84_.defectid3 AS defe15_35_83_,
outageeven84_.flowamount AS flow16_35_83_,
outageeven84_.regdate AS regd17_35_83_,
outageeven84_.delflg AS delf18_35_83_,
outageeven84_.isscheduled AS issc19_35_83_,
outageeven84_.undistenergy AS undi20_35_83_,
outageeven84_.posx1 AS posx21_35_83_,
outageeven84_.posy1 AS posy22_35_83_,
outageeven84_.posx2 AS posx23_35_83_,
outageeven84_.posy2 AS posy24_35_83_,
outageeven84_.joindate AS join25_35_83_,
outageeven84_.jointime AS join26_35_83_,
outageeven84_.isfeederfailcause AS isfe27_35_83_,
outageeven84_.ishotline AS isho28_35_83_,
outageeven84_.rst AS rst29_35_83_,
outageeven84_.networkpressure AS netw30_35_83_,
outageeven84_.cutposts AS cutp31_35_83_,
outageeven84_.hotlinerecloserstate AS hotl32_35_83_,
outageeven84_.mamoor AS mamo33_35_83_,
outageeven84_.singleconsumer AS sing34_35_83_,
outageeven84_.eventdescp AS even35_35_83_,
outageeven84_.announcerule AS anno36_35_83_,
outageeven84_.eventaddr AS even37_35_83_,
outageeven84_.postfromname AS post38_35_83_,
outageeven84_.posttoname AS post39_35_83_,
outageeven84_.maineventid AS main40_35_83_,
outageeven84_.protectiondo AS prot41_35_83_,
outageeven84_.requestdate AS requ42_35_83_,
outageeven84_.requesttime AS requ43_35_83_,
outageeven84_.subbranch AS subb44_35_83_,
outageeven84_.delayreasonid AS dela45_35_83_,
outageeven84_.regionplace AS regi46_35_83_,
outageeven84_.regionid AS regi47_35_83_,
outageeven84_.soundfileid AS soun48_35_83_,
outageeven84_.predictiontime AS pred49_35_83_,
outageeven84_.predictiondate AS pred50_35_83_,
outageeven84_.noelem AS noel51_35_83_,
outageeven84_.isurgent AS isur52_35_83_,
outageeven84_.latlontype AS latl53_35_83_,
outageeven84_.registerdelay AS regi54_35_83_,
outageeven84_.contactdelay AS cont55_35_83_,
outageeven84_.isoutagetemporarilyon AS isou56_35_83_,
outageeven84_.eventdatetime AS even57_35_83_,
outageeven84_.joindatetime AS join58_35_83_,
outageeven84_.contactdatetime AS cont59_35_83_,
outageeven84_.viewdatetime AS view60_35_83_,
outageeven84_.eventdes AS even61_35_83_,
outageeven84_.takmoshtarak AS takm62_35_83_,
outageeven84_.eventstagecount AS even63_35_83_,
outageeven84_.workpermitnumber AS work64_35_83_,
outageeven84_.repetitiverequestcount AS repe65_35_83_,
outageeven84_.ohmid AS ohmi66_35_83_,
outageeven84_.externalfollowerid AS exte67_35_83_,
outageeven84_.changedversion AS chan68_35_83_,
outageeven84_.shouldbeinformedofnotdonebyteam AS shou69_35_83_,
outageeven84_.ccserverip AS ccse70_35_83_,
outageeven84_.isticket AS isti71_35_83_,
outageeven84_.relayfunctionphase AS rela72_35_83_,
outageeven84_.hotlinesubcontractor AS hotl73_35_83_,
outageeven84_.naturaldisastersid AS natu74_35_83_,
outageeven84_.feederrecloserdeactivedatetime AS feed75_35_83_,
outageeven84_.feederrecloseractivedatetime AS feed76_35_83_,
outageeven84_.linepathdeactivedatetime AS line77_35_83_,
outageeven84_.linepathactivedatetime AS line78_35_83_,
outageeven84_.hotlineeventaddr AS hotl79_35_83_,
outageeven84_.datetemporarilyon AS date80_35_83_,
outageeven84_.normalizationforecast AS norm81_35_83_,
outageeven84_.predectedduration AS pred82_35_83_,
outageeven84_.newpredectedduration AS newp83_35_83_,
outageeven84_.licenserequired AS lice84_35_83_,
outageeven84_.depth AS dept85_35_83_,
outageeven84_.sewagenetworktype AS sewa86_35_83_,
outageeven84_.omurid AS omur87_35_83_,
outageeven84_.recevieduserid AS rece88_35_83_,
outageeven84_.consumerinsid AS cons89_35_83_,
outageeven84_.userid AS user90_35_83_,
outageeven84_.delayuserid AS dela91_35_83_,
outageeven84_.defectcause1 AS defe92_35_83_,
outageeven84_.defectcause2 AS defe93_35_83_,
outageeven84_.eventreason AS even94_35_83_,
outageeven84_.notdonereasonid AS notd95_35_83_,
outageeven84_.eventstatusid AS even96_35_83_,
outageeven84_.eventflowstatusid AS even97_35_83_,
outageeven84_.hvpostid AS hvpo98_35_83_,
outageeven84_.feeder2id AS feed99_35_83_,
outageeven84_.feederid AS fee100_35_83_,
outageeven84_.postid AS pos101_35_83_,
outageeven84_.transid AS tra102_35_83_,
outageeven84_.omurzoneid AS omu103_35_83_,
outageeven84_.cutterelement AS cut104_35_83_,
outageeven84_.failureid AS fai105_35_83_,
outageeven84_.defectid AS def106_35_83_,
outageeven84_.cutterelementins AS cut107_35_83_,
outageeven84_.reporttype AS rep108_35_83_,
outageeven84_.parenteventid AS par109_35_83_,
outageeven84_.subcontractor AS sub110_35_83_,
outageeven84_.priority AS pri111_35_83_,
outageeven84_.protectionopr AS pro112_35_83_,
outageeven84_.scheventactivetypeid AS sch113_35_83_,
outageeven84_.eventdurationinminutes AS eve114_35_83_,
outageeven84_.registersource AS reg115_35_83_,
outageeven84_.diameteractionid AS dia116_35_83_,
outageeven84_.materialactionid AS mat117_35_83_,
outageeven84_.eventcausingfactoractionid AS eve118_35_83_,
outageeven84_.eventcausingreasonactionid AS eve119_35_83_,
outageeven84_.postfromid AS pos120_35_83_,
outageeven84_.posttoid AS pos121_35_83_,
outageeven84_.flowamountbeforinterruption AS flo122_35_83_,
outageeven84_.selectedplace AS sel123_35_83_,
outageeven84_.dispatchedeventtype AS dis124_35_83_,
outageeven84_.tavanirid AS tav125_35_83_,
outageeven84_.updated AS upd126_35_83_,
outageeven84_.numberoflamps AS num127_35_83_,
outageeven84_.policestationid AS pol128_35_83_,
outageeven84_.countofpostoff AS cou129_35_83_,
outageeven84_.prioritizeduserid AS pri130_35_83_,
outageeven84_.valuepriorityevent AS val131_35_83_,
outageeven84_.totalpriceelement AS tot132_35_83_,
outageeven84_.hasbeensenttosanam AS has133_35_83_,
mvpost85_.id AS id1_181_84_,
mvpost85_.postname AS post2_181_84_,
mvpost85_.mvposttype AS mvpo3_181_84_,
mvpost85_.postcode AS post4_181_84_,
mvpost85_.sortflag AS sort5_181_84_,
mvpost85_.delflg AS delf6_181_84_,
mvpost85_.globalid AS glob7_181_84_,
mvpost85_.gisobjectid AS giso8_181_84_,
mvpost85_.address AS addr9_181_84_,
mvpost85_.coveragearea AS cov10_181_84_,
mvpost85_.nominalpower AS nom11_181_84_,
mvpost85_.nominalamp AS nom12_181_84_,
mvpost85_.sensitiveplace AS sen13_181_84_,
mvpost85_.sensitivetype AS sen14_181_84_,
mvpost85_.latitude AS lat15_181_84_,
mvpost85_.longitude AS lon16_181_84_,
mvpost85_.omurid AS omu17_181_84_,
mvpost85_.giscode AS gis18_181_84_,
mvpost85_.tavanirid AS tav19_181_84_,
mvpost85_.updated AS upd20_181_84_,
subjectite86_.id AS id1_177_85_,
subjectite86_.subjid AS subj2_177_85_,
subjectite86_.itemnameen AS item3_177_85_,
subjectite86_.itemnamefa AS item4_177_85_,
subjectite86_.ismv AS ismv5_177_85_,
subjectite86_.mark AS mark6_177_85_,
subjectite86_.valuesubjid AS valu7_177_85_,
subjectite87_.id AS id1_177_86_,
subjectite87_.subjid AS subj2_177_86_,
subjectite87_.itemnameen AS item3_177_86_,
subjectite87_.itemnamefa AS item4_177_86_,
subjectite87_.ismv AS ismv5_177_86_,
subjectite87_.mark AS mark6_177_86_,
subjectite87_.valuesubjid AS valu7_177_86_,
subjectite88_.id AS id1_177_87_,
subjectite88_.subjid AS subj2_177_87_,
subjectite88_.itemnameen AS item3_177_87_,
subjectite88_.itemnamefa AS item4_177_87_,
subjectite88_.ismv AS ismv5_177_87_,
subjectite88_.mark AS mark6_177_87_,
subjectite88_.valuesubjid AS valu7_177_87_,
subjectite89_.id AS id1_177_88_,
subjectite89_.subjid AS subj2_177_88_,
subjectite89_.itemnameen AS item3_177_88_,
subjectite89_.itemnamefa AS item4_177_88_,
subjectite89_.ismv AS ismv5_177_88_,
subjectite89_.mark AS mark6_177_88_,
subjectite89_.valuesubjid AS valu7_177_88_,
subjectite90_.id AS id1_177_89_,
subjectite90_.subjid AS subj2_177_89_,
subjectite90_.itemnameen AS item3_177_89_,
subjectite90_.itemnamefa AS item4_177_89_,
subjectite90_.ismv AS ismv5_177_89_,
subjectite90_.mark AS mark6_177_89_,
subjectite90_.valuesubjid AS valu7_177_89_,
registerso91_.id AS id1_121_90_,
registerso91_.titlefa AS titl2_121_90_,
registerso91_.titleen AS titl3_121_90_,
actions92_.id AS id1_142_91_,
actions92_.subjectitems_id AS subj2_142_91_,
actions92_.actionname AS acti3_142_91_,
actions92_.actionnameen AS acti4_142_91_,
actions93_.id AS id1_142_92_,
actions93_.subjectitems_id AS subj2_142_92_,
actions93_.actionname AS acti3_142_92_,
actions93_.actionnameen AS acti4_142_92_,
actions94_.id AS id1_142_93_,
actions94_.subjectitems_id AS subj2_142_93_,
actions94_.actionname AS acti3_142_93_,
actions94_.actionnameen AS acti4_142_93_,
actions95_.id AS id1_142_94_,
actions95_.subjectitems_id AS subj2_142_94_,
actions95_.actionname AS acti3_142_94_,
actions95_.actionnameen AS acti4_142_94_,
eventdetai96_.id AS id1_97_95_,
eventdetai96_.excavationheight AS excav2_97_95_,
eventdetai96_.excavationwidth AS excav3_97_95_,
eventdetai96_.excavationlength AS excav4_97_95_,
eventdetai96_.diameter AS diame5_97_95_,
eventdetai96_.actiondone AS actio6_97_95_,
eventdetai96_.eventinsid AS event7_97_95_,
subjectite97_.id AS id1_177_96_,
subjectite97_.subjid AS subj2_177_96_,
subjectite97_.itemnameen AS item3_177_96_,
subjectite97_.itemnamefa AS item4_177_96_,
subjectite97_.ismv AS ismv5_177_96_,
subjectite97_.mark AS mark6_177_96_,
subjectite97_.valuesubjid AS valu7_177_96_
FROM tbleventins outageeven0_
LEFT OUTER JOIN tblsubjectitems subjectite1_
ON outageeven0_.reporttype=subjectite1_.id
LEFT OUTER JOIN tblsubject subject2_
ON subjectite1_.subjid=subject2_.id
LEFT OUTER JOIN tblsubjectitems subjectite3_
ON outageeven0_.priority=subjectite3_.id
LEFT OUTER JOIN tblsubjectitems subjectite4_
ON outageeven0_.scheventactivetypeid=subjectite4_.id
LEFT OUTER JOIN tblconsumerins consumerin5_
ON outageeven0_.consumerinsid=consumerin5_.id
LEFT OUTER JOIN tblsubjectitems subjectite6_
ON consumerin5_.ctype=subjectite6_.id
LEFT OUTER JOIN tblconsumertype consumerty7_
ON consumerin5_.consumertypeid=consumerty7_.id
LEFT OUTER JOIN tblomur omur8_
ON consumerin5_.omurid=omur8_.id
LEFT OUTER JOIN tblcontrollcenter controllce9_
ON omur8_.controllcenterid=controllce9_.id
LEFT OUTER JOIN tblsubjectitems subjectite10_
ON consumerin5_.ereaposttype=subjectite10_.id
LEFT OUTER JOIN tblsubjectitems subjectite11_
ON consumerin5_.consumerlevelid=subjectite11_.id
LEFT OUTER JOIN tblregion region12_
ON consumerin5_.regionid=region12_.id
LEFT OUTER JOIN tblomurzone omurzone13_
ON region12_.omurzoneid=omurzone13_.id
LEFT OUTER JOIN tblomur omur14_
ON omurzone13_.omurid=omur14_.id
LEFT OUTER JOIN tblpost post15_
ON consumerin5_.consumerpostid=post15_.id
LEFT OUTER JOIN tblsubjectitems subjectite16_
ON post15_.posttype=subjectite16_.id
LEFT OUTER JOIN tblsubjectitems subjectite17_
ON post15_.sensitivetype=subjectite17_.id
LEFT OUTER JOIN tblsubjectitems subjectite18_
ON post15_.voltagelevel1=subjectite18_.id
LEFT OUTER JOIN tblsubjectitems subjectite19_
ON post15_.voltagelevel2=subjectite19_.id
LEFT OUTER JOIN tblmvfeedername mvfeederna20_
ON post15_.mvfeederid=mvfeederna20_.id
LEFT OUTER JOIN tblmvtrans mvtrans21_
ON mvfeederna20_.mvtransid=mvtrans21_.id
LEFT OUTER JOIN tblmvpost mvpost22_
ON mvtrans21_.mvpostid=mvpost22_.id
LEFT OUTER JOIN tblomur omur23_
ON mvpost22_.omurid=omur23_.id
LEFT OUTER JOIN tblsubjectitems subjectite24_
ON mvpost22_.mvposttype=subjectite24_.id
LEFT OUTER JOIN tblsubjectitems subjectite25_
ON mvtrans21_.naminalcapacity=subjectite25_.id
LEFT OUTER JOIN tblsubjectitems subjectite26_
ON mvtrans21_.transtype=subjectite26_.id
LEFT OUTER JOIN tblsubjectitems subjectite27_
ON mvtrans21_.voltagelevel1=subjectite27_.id
LEFT OUTER JOIN tblsubjectitems subjectite28_
ON mvtrans21_.voltagelevel2=subjectite28_.id
LEFT OUTER JOIN tblomur omur29_
ON mvfeederna20_.mainomurid=omur29_.id
LEFT OUTER JOIN tblsubjectitems subjectite30_
ON mvfeederna20_.feedertype=subjectite30_.id
LEFT OUTER JOIN tblsubjectitems subjectite31_
ON mvfeederna20_.sensetivetype=subjectite31_.id
LEFT OUTER JOIN tblsubjectitems subjectite32_
ON mvfeederna20_.consumetype=subjectite32_.id
LEFT OUTER JOIN tblsubjectitems subjectite33_
ON post15_.postconsumertype=subjectite33_.id
LEFT OUTER JOIN tblsubjectitems subjectite34_
ON post15_.loadtype=subjectite34_.id
LEFT OUTER JOIN tblomur omur35_
ON post15_.omurid=omur35_.id
LEFT OUTER JOIN tblregion region36_
ON post15_.regionid=region36_.id
LEFT OUTER JOIN tblomurzone omurzone37_
ON post15_.omurzoneid=omurzone37_.id
LEFT OUTER JOIN tblomurzone omurzone38_
ON consumerin5_.omurzoneid=omurzone38_.id
LEFT OUTER JOIN tblomur omur39_
ON outageeven0_.omurid=omur39_.id
LEFT OUTER JOIN tblomurzone omurzone40_
ON outageeven0_.omurzoneid=omurzone40_.id
LEFT OUTER JOIN tbleventstatus eventstatu41_
ON outageeven0_.eventstatusid=eventstatu41_.id
LEFT OUTER JOIN tbleventflowstatus eventflows42_
ON outageeven0_.eventflowstatusid=eventflows42_.id
LEFT OUTER JOIN tblitemtree outagereas43_
ON outageeven0_.eventreason=outagereas43_.id
LEFT OUTER JOIN tblitemtree outagereas44_
ON outagereas43_.parentid=outagereas44_.id
LEFT OUTER JOIN tblitemtree outagereas45_
ON outagereas44_.firstparentid=outagereas45_.id
LEFT OUTER JOIN tblitemtree outagereas46_
ON outagereas45_.secondparentid=outagereas46_.id
LEFT OUTER JOIN tblsubjectitems subjectite47_
ON outagereas46_.consumeritemname_fa=subjectite47_.id
LEFT OUTER JOIN tbloutageclass tavanirout48_
ON outagereas46_.outageclassid=tavanirout48_.id
LEFT OUTER JOIN tbloutagegroup tavanirout49_
ON outagereas46_.outagegroupid=tavanirout49_.id
LEFT OUTER JOIN tbloutageclass tavanirout50_
ON tavanirout49_.outageclassid=tavanirout50_.id
LEFT OUTER JOIN tblfailure failure51_
ON outageeven0_.failureid=failure51_.id
LEFT OUTER JOIN tblitemtree outagereas52_
ON failure51_.parrentid=outagereas52_.id
LEFT OUTER JOIN tbloutageproblem tavanirout53_
ON failure51_.outageproblemid=tavanirout53_.id
LEFT OUTER JOIN tbloutagegroup tavanirout54_
ON tavanirout53_.outagegroupid=tavanirout54_.id
LEFT OUTER JOIN tbldefect defect55_
ON outageeven0_.defectid=defect55_.id
LEFT OUTER JOIN tblitemtree outagereas56_
ON defect55_.parentid=outagereas56_.id
LEFT OUTER JOIN tbloutagereason tavanirout57_
ON defect55_.outagereasonid=tavanirout57_.id
LEFT OUTER JOIN tbloutagegroup tavanirout58_
ON tavanirout57_.outagegroupid=tavanirout58_.id
LEFT OUTER JOIN tblsubjectitems subjectite59_
ON outageeven0_.cutterelement=subjectite59_.id
INNER JOIN tbluser user60_
ON outageeven0_.userid=user60_.id
LEFT OUTER JOIN tblomur omur61_
ON user60_.omurid=omur61_.id
LEFT OUTER JOIN tblcity city62_
ON user60_.profileid=city62_.id
LEFT OUTER JOIN tblomur omur63_
ON city62_.omurid=omur63_.id
LEFT OUTER JOIN tbldepartment department64_
ON user60_.depid=department64_.id
LEFT OUTER JOIN tbldepartment department65_
ON department64_.parentdepid=department65_.id
LEFT OUTER JOIN tbluser user66_
ON outageeven0_.delayuserid=user66_.id
LEFT OUTER JOIN tbluser user67_
ON outageeven0_.recevieduserid=user67_.id
LEFT OUTER JOIN tblsubjectitems subjectite68_
ON outageeven0_.postfromid=subjectite68_.id
LEFT OUTER JOIN tblsubjectitems subjectite69_
ON outageeven0_.posttoid=subjectite69_.id
LEFT OUTER JOIN tbldisconnector disconnect70_
ON outageeven0_.cutterelementins=disconnect70_.id
LEFT OUTER JOIN tblsubjectitems subjectite71_
ON disconnect70_.typeid=subjectite71_.id
LEFT OUTER JOIN tblomur omur72_
ON disconnect70_.omurid=omur72_.id
LEFT OUTER JOIN tblpost post73_
ON outageeven0_.postid=post73_.id
LEFT OUTER JOIN tblmvfeedername mvfeederna74_
ON outageeven0_.feederid=mvfeederna74_.id
LEFT OUTER JOIN tblfeedername lvfeeder75_
ON outageeven0_.feeder2id=lvfeeder75_.id
LEFT OUTER JOIN tblsubjectitems subjectite76_
ON lvfeeder75_.feedertype=subjectite76_.id
LEFT OUTER JOIN tblsubjectitems subjectite77_
ON lvfeeder75_.consumetype=subjectite77_.id
LEFT OUTER JOIN tbltrans trans78_
ON lvfeeder75_.transid=trans78_.id
LEFT OUTER JOIN tblsubjectitems subjectite79_
ON trans78_.transtype=subjectite79_.id
LEFT OUTER JOIN tblsubjectitems subjectite80_
ON trans78_.naminalcapacity=subjectite80_.id
LEFT OUTER JOIN tblsubjectitems subjectite81_
ON trans78_.transconsumertype=subjectite81_.id
LEFT OUTER JOIN tblpost post82_
ON trans78_.postid=post82_.id
LEFT OUTER JOIN tbltrans trans83_
ON outageeven0_.transid=trans83_.id
LEFT OUTER JOIN tbleventins outageeven84_
ON outageeven0_.parenteventid=outageeven84_.id
LEFT OUTER JOIN tblmvpost mvpost85_
ON outageeven84_.hvpostid=mvpost85_.id
LEFT OUTER JOIN tblsubjectitems subjectite86_
ON outageeven84_.defectcause1=subjectite86_.id
LEFT OUTER JOIN tblsubjectitems subjectite87_
ON outageeven84_.defectcause2=subjectite87_.id
LEFT OUTER JOIN tblsubjectitems subjectite88_
ON outageeven84_.subcontractor=subjectite88_.id
LEFT OUTER JOIN tblsubjectitems subjectite89_
ON outageeven84_.notdonereasonid=subjectite89_.id
LEFT OUTER JOIN tblsubjectitems subjectite90_
ON outageeven84_.protectionopr=subjectite90_.id
LEFT OUTER JOIN tblregistersource registerso91_
ON outageeven84_.registersource=registerso91_.id
LEFT OUTER JOIN tblactions actions92_
ON outageeven84_.diameteractionid=actions92_.id
LEFT OUTER JOIN tblactions actions93_
ON outageeven84_.materialactionid=actions93_.id
LEFT OUTER JOIN tblactions actions94_
ON outageeven84_.eventcausingfactoractionid=actions94_.id
LEFT OUTER JOIN tblactions actions95_
ON outageeven84_.eventcausingreasonactionid=actions95_.id
LEFT OUTER JOIN tbleventdetails eventdetai96_
ON outageeven84_.id=eventdetai96_.eventinsid
LEFT OUTER JOIN tblsubjectitems subjectite97_
ON eventdetai96_.actiondone=subjectite97_.id
WHERE outageeven0_.id=84007005Editor is loading...
Leave a Comment