<?xml version="1.0"?>
<SECTIONS>
	<EW_HEADER>
		<VERSION Number="2020.0.0.0"/>
		<VERSIONS>
			<DataProjectVersion>268</DataProjectVersion>
			<AppVersion>2020.0.0.31</AppVersion>
		</VERSIONS>
		<FILENAME>EquipotentialSortedBySize_Imperial</FILENAME>
		<DESCRIPTION>
			<LANGUAGE xml:lang="en">Equipotentials sorted by size (number of drawings crossed)</LANGUAGE>
			<LANGUAGE xml:lang="fr">Equipotentielles triées par taille (nombre de folios traversés)</LANGUAGE>
			<LANGUAGE xml:lang="cs">Ekvipotenciály tříděny podle velikosti (počet výkresů překročen)</LANGUAGE>
			<LANGUAGE xml:lang="de">Äquipotentiale, sortiert nach Größe (Anzahl der Zeichnungen gekreuzt)</LANGUAGE>
			<LANGUAGE xml:lang="it">Equipotenziali ordinati per dimensione (numero di disegni incrociati)</LANGUAGE>
			<LANGUAGE xml:lang="ja">ｻｲｽﾞで並べ替えた等電位 (交差する図面の数)</LANGUAGE>
			<LANGUAGE xml:lang="ko">크기별로 정렬된 등전위(교차된 도면 수)</LANGUAGE>
			<LANGUAGE xml:lang="zh">按大小分类的电位（交叉图纸的数量）</LANGUAGE>
			<LANGUAGE xml:lang="pl">Potencjały posortowane według rozmiaru (liczba przeciętych rysunków)</LANGUAGE>
			<LANGUAGE xml:lang="pt">Equipotenciais classificados por tamanho (número de desenhos cruzados)</LANGUAGE>
			<LANGUAGE xml:lang="ru">Эквипотенциали, отсортированные по размеру (число пересекаемых чертежей)</LANGUAGE>
			<LANGUAGE xml:lang="es">Equipotenciales agrupados por tamaño (número de planos cruzados)</LANGUAGE>
			<LANGUAGE xml:lang="tr">Boyutuna göre sıralanmış eşpotansiyeller (çapraz teknik resimlerin sayısı)</LANGUAGE>
			<LANGUAGE xml:lang="zh-tw">等電位，依大小排序 (跨越的圖紙數)</LANGUAGE>
		</DESCRIPTION>
		<FILE_TYPE>10</FILE_TYPE>
		<OBJECT_TYPE>6</OBJECT_TYPE>
		<MEASURMENT>0</MEASURMENT>
		<Datatype>0</Datatype>
	</EW_HEADER>
	<QUERY>
		<FileData>
			<FileNameFormula/>
			<TZ_0>
				<LANGUAGE xml:lang="en">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="fr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="cs">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="de">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="it">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ja">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ko">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pl">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="pt">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="ru">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="es">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="tr">REP_DESC</LANGUAGE>
				<LANGUAGE xml:lang="zh-tw">REP_DESC</LANGUAGE>
			</TZ_0>
			<AutoFilterDesc>1</AutoFilterDesc>
		</FileData>
		<SQLQuery>SELECT 
	myQuery.count_files AS count_files
	,myQuery.count_wires AS count_wires
	,myQuery.count_lines AS count_lines
	,myQuery.equip_text AS equip_text
	,myQuery.equip_id AS equip_id
	,myQuery.equip_file_id AS equip_file_id
	,myQuery.file_mark AS file_mark
FROM
(
	SELECT
		(SELECT COUNT(*) FROM tew_file WHERE EXISTS 
			(SELECT * FROM tew_line WHERE tew_file.fil_id = lin_fil_id AND tew_equipotential.equ_id = lin_equ_id)
		) AS count_files
	, 	(SELECT COUNT(*) FROM tew_wire WHERE EXISTS 
			(SELECT * FROM tew_line WHERE tew_wire.wir_mes_idmfi = lin_mes_id AND tew_equipotential.equ_id = lin_equ_id)
		) AS count_wires
	, 	(SELECT COUNT(*) FROM tew_line WHERE tew_equipotential.equ_id = lin_equ_id
		) AS count_lines
		, tew_equipotential.equ_text AS equip_text
		, tew_equipotential.equ_id AS equip_id	
		, tew_equipotential.equ_fil_id AS equip_file_id	
		, tew_file.fil_title AS file_mark
	FROM tew_equipotential
	LEFT JOIN tew_file ON tew_equipotential.equ_fil_id = tew_file.fil_id

) 
AS myQuery

    ORDER BY count_files,count_wires</SQLQuery>
		<BreakFormula/>
		<ORDERS>
			<ORDER>
				<No>0</No>
				<FieldName>count_files</FieldName>
				<IsBreak>0</IsBreak>
			</ORDER>
			<ORDER>
				<No>1</No>
				<FieldName>count_wires</FieldName>
				<IsBreak>0</IsBreak>
			</ORDER>
		</ORDERS>
		<ObjectType>1</ObjectType>
	</QUERY>
	<LAYOUT>
		<HeadingFormula>[AUTO]""</HeadingFormula>
		<IsHeadingVisible>1</IsHeadingVisible>
		<IsTitleVisible>1</IsTitleVisible>
		<IsHorzSeparationVisible>1</IsHorzSeparationVisible>
		<IsTotalVisible>0</IsTotalVisible>
		<COLUMNS>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">Equipotential ID</LANGUAGE>
					<LANGUAGE xml:lang="fr">ID d équipotentielle</LANGUAGE>
					<LANGUAGE xml:lang="cs">Ekvipotenciální ID</LANGUAGE>
					<LANGUAGE xml:lang="de">Äquipotential-ID</LANGUAGE>
					<LANGUAGE xml:lang="it">ID equipotenziale</LANGUAGE>
					<LANGUAGE xml:lang="ja">等電位 ID</LANGUAGE>
					<LANGUAGE xml:lang="ko">등전위ID</LANGUAGE>
					<LANGUAGE xml:lang="zh">电位 ID</LANGUAGE>
					<LANGUAGE xml:lang="pl">ID potencjału</LANGUAGE>
					<LANGUAGE xml:lang="pt">ID equipotencial</LANGUAGE>
					<LANGUAGE xml:lang="ru">ИД эквипотенциали</LANGUAGE>
					<LANGUAGE xml:lang="es">ID equipotencial</LANGUAGE>
					<LANGUAGE xml:lang="tr">Eşpotansiyel Kimliği</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">等電位 ID</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>0</columnIndex>
				<ContentFormula>equip_id</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>50.000000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">Equipotential mark</LANGUAGE>
					<LANGUAGE xml:lang="fr">Repère d'équipotentielle</LANGUAGE>
					<LANGUAGE xml:lang="zh">电位标注</LANGUAGE>
					<LANGUAGE xml:lang="cs">Značka ekvipotenciálu</LANGUAGE>
					<LANGUAGE xml:lang="de">Äquipotentialkennzeichen</LANGUAGE>
					<LANGUAGE xml:lang="it">Contrassegno equipotenziale</LANGUAGE>
					<LANGUAGE xml:lang="ja">等電位ﾏｰｸ</LANGUAGE>
					<LANGUAGE xml:lang="ko">등전위 기호</LANGUAGE>
					<LANGUAGE xml:lang="pl">Znacznik potencjału</LANGUAGE>
					<LANGUAGE xml:lang="pt">Marca do equipotencial</LANGUAGE>
					<LANGUAGE xml:lang="ru">Эквипотенциальная метка</LANGUAGE>
					<LANGUAGE xml:lang="es">Numeración equipotencial</LANGUAGE>
					<LANGUAGE xml:lang="tr">Eşpotansiyel işareti</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">等電位標注</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>1</columnIndex>
				<ContentFormula>equip_text</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">Number of drawings crossed</LANGUAGE>
					<LANGUAGE xml:lang="fr">Nombre de folios traversés</LANGUAGE>
					<LANGUAGE xml:lang="cs">Počet výkresů překročen</LANGUAGE>
					<LANGUAGE xml:lang="de">Anzahl der Zeichnungen gekreuzt</LANGUAGE>
					<LANGUAGE xml:lang="it">Numero di disegni incrociati</LANGUAGE>
					<LANGUAGE xml:lang="ja">交差する図面の数</LANGUAGE>
					<LANGUAGE xml:lang="ko">교차된 도면 수</LANGUAGE>
					<LANGUAGE xml:lang="zh">交叉图纸的数量</LANGUAGE>
					<LANGUAGE xml:lang="pl">Liczba przeciętych rysunków</LANGUAGE>
					<LANGUAGE xml:lang="pt">Número de desenhos cruzados</LANGUAGE>
					<LANGUAGE xml:lang="ru">Число пересекаемых чертежей</LANGUAGE>
					<LANGUAGE xml:lang="es">Número de planos cruzados</LANGUAGE>
					<LANGUAGE xml:lang="tr">Çapraz teknik resimlerin sayısı</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">跨越的圖紙數</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>2</columnIndex>
				<ContentFormula>count_files</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">Number of lines</LANGUAGE>
					<LANGUAGE xml:lang="fr">Nombre de lignes</LANGUAGE>
					<LANGUAGE xml:lang="cs">Počet čar</LANGUAGE>
					<LANGUAGE xml:lang="de">Anzahl der Leitungen</LANGUAGE>
					<LANGUAGE xml:lang="it">Numero di linee</LANGUAGE>
					<LANGUAGE xml:lang="ja">配線の数</LANGUAGE>
					<LANGUAGE xml:lang="ko">선의 개수</LANGUAGE>
					<LANGUAGE xml:lang="zh">连接线数目</LANGUAGE>
					<LANGUAGE xml:lang="pl">Liczba linii</LANGUAGE>
					<LANGUAGE xml:lang="pt">Número de linhas</LANGUAGE>
					<LANGUAGE xml:lang="ru">Число проводников</LANGUAGE>
					<LANGUAGE xml:lang="es">Número de líneas</LANGUAGE>
					<LANGUAGE xml:lang="tr">Çizgi sayısı</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">線路數</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>3</columnIndex>
				<ContentFormula>count_lines</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">Number of wires</LANGUAGE>
					<LANGUAGE xml:lang="fr">Nombre de fils</LANGUAGE>
					<LANGUAGE xml:lang="cs">Počet vodičů</LANGUAGE>
					<LANGUAGE xml:lang="de">Anzahl der Leiter</LANGUAGE>
					<LANGUAGE xml:lang="it">Numero di fili</LANGUAGE>
					<LANGUAGE xml:lang="ja">ﾜｲﾔの数</LANGUAGE>
					<LANGUAGE xml:lang="ko">와이어 개수</LANGUAGE>
					<LANGUAGE xml:lang="zh">线数目</LANGUAGE>
					<LANGUAGE xml:lang="pl">Liczba przewodów</LANGUAGE>
					<LANGUAGE xml:lang="pt">Número de fios</LANGUAGE>
					<LANGUAGE xml:lang="ru">Число проводов</LANGUAGE>
					<LANGUAGE xml:lang="es">Número de cables</LANGUAGE>
					<LANGUAGE xml:lang="tr">Tel sayısı</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">電線數</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>4</columnIndex>
				<ContentFormula>count_wires</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">Start drawing</LANGUAGE>
					<LANGUAGE xml:lang="fr">Folio de départ</LANGUAGE>
					<LANGUAGE xml:lang="cs">Začít kreslit</LANGUAGE>
					<LANGUAGE xml:lang="de">Mit Zeichnung beginnen</LANGUAGE>
					<LANGUAGE xml:lang="it">Inizia disegno</LANGUAGE>
					<LANGUAGE xml:lang="ja">開始図面</LANGUAGE>
					<LANGUAGE xml:lang="ko">그리기 시작</LANGUAGE>
					<LANGUAGE xml:lang="zh">开始绘图</LANGUAGE>
					<LANGUAGE xml:lang="pl">Rozpocznij rysowanie</LANGUAGE>
					<LANGUAGE xml:lang="pt">Iniciar desenho</LANGUAGE>
					<LANGUAGE xml:lang="ru">Начать чертеж</LANGUAGE>
					<LANGUAGE xml:lang="es">Iniciar plano</LANGUAGE>
					<LANGUAGE xml:lang="tr">Teknik resme başla</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">開始繪製</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>5</columnIndex>
				<ContentFormula>file_mark</ContentFormula>
				<GotoId>equip_file_id</GotoId>
				<GotoType>1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>1</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>1</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>0</HorzTitleAlignment>
				<HorzContentAlignment>0</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<BreakColumn>1</BreakColumn>
				<columnIndex>6</columnIndex>
				<ContentFormula>""</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter>,</EnumerationDelimiter>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>400.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>0</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
		</COLUMNS>
		<DefaultCodeLg>
		</DefaultCodeLg>
		<DefaultGoto>equip_file_id</DefaultGoto>
		<HorizontalCellMargin>-1</HorizontalCellMargin>
		<VerticalCellMargin>0</VerticalCellMargin>
	</LAYOUT>
	<VARIABLES/>
	<FONT>
		<HeadingFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>6.000000</RowHeight>
		</HeadingFont>
		<TitleFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
		</TitleFont>
		<ContentFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>7</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>6.000000</RowHeight>
		</ContentFont>
		<TotalFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>1</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>2.000000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>1</DwgColor>
			<DwgFontHeight>5.000000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>6.000000</RowHeight>
		</TotalFont>
	</FONT>
	<OPTIONS>
		<IsTxtOneArrayPerPage>1</IsTxtOneArrayPerPage>
		<DwgBOMHeight>245.000000</DwgBOMHeight>
		<DwgBOMWidth>380.000000</DwgBOMWidth>
		<IsReverseOrder>0</IsReverseOrder>
		<XDwgBOMOrigine>25.000000</XDwgBOMOrigine>
		<YDwgBOMOrigine>40.000000</YDwgBOMOrigine>
		<DwgHorzOffset>10.000000</DwgHorzOffset>
		<DwgVertOffset>10.000000</DwgVertOffset>
		<IsDwgOneArrayPerPage>0</IsDwgOneArrayPerPage>
		<IsDwgFollowingOnSameSheet>0</IsDwgFollowingOnSameSheet>
		<IsDwgOneArrayPerColumn>0</IsDwgOneArrayPerColumn>
		<TITLEBLOCK_NAME/>
		<OneArrayPerBundle>1</OneArrayPerBundle>
		<TakeIntoGeneratedFile>0</TakeIntoGeneratedFile>
		<MargeBetweenLabelAndTable>2.000000</MargeBetweenLabelAndTable>
		<UsePipeCharacter>1</UsePipeCharacter>
		<BreakTextIntoGeneratedFile>0</BreakTextIntoGeneratedFile>
	</OPTIONS>
	<FILTERS/>
</SECTIONS>
