<?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>DuplicatedEquipotentialInSameLocation_Imperial</FILENAME>
		<DESCRIPTION>
			<LANGUAGE xml:lang="en">Duplicated equipotentials in same location</LANGUAGE>
			<LANGUAGE xml:lang="fr">Equipotentielle en double au même endroit</LANGUAGE>
			<LANGUAGE xml:lang="cs">Duplicitní ekvipotenciály ve stejném umístění</LANGUAGE>
			<LANGUAGE xml:lang="de">Duplizierte Äquipotentiale in gleicher Position</LANGUAGE>
			<LANGUAGE xml:lang="it">Equipotenziali duplicati nella stessa ubicazione</LANGUAGE>
			<LANGUAGE xml:lang="ja">同じロケーションで重複した等電位</LANGUAGE>
			<LANGUAGE xml:lang="ko">동일 위치에 등전위 중복</LANGUAGE>
			<LANGUAGE xml:lang="pl">Potencjały zduplikowane w tym samym miejscu</LANGUAGE>
			<LANGUAGE xml:lang="zh">同一位置上重复的电位</LANGUAGE>
			<LANGUAGE xml:lang="pt">Equipotenciais duplicados na mesma localização</LANGUAGE>
			<LANGUAGE xml:lang="ru">Дублирующиеся эквипотенциальные уровни в одном местоположении</LANGUAGE>
			<LANGUAGE xml:lang="es">Equipotenciales duplicados en la misma situación</LANGUAGE>
			<LANGUAGE xml:lang="tr">Aynı konumdaki kopyası oluşturulmuş eşpotansiyeller</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
 Query2.equ_text AS equ_text
, Query2.fil_id AS fil_id
	, Query2.fil_title AS fil_title
	, Query2.loc_text AS loc_text
	, COUNT(*) AS Count_duplicated
 FROM
 (
	SELECT DISTINCT
	Query1.equ_text AS equ_text
	, Query1.fil_title AS fil_title
	, Query1.loc_text AS loc_text
	, Query1.equ_id AS equ_id
	 , Query1.fil_id AS fil_id

	FROM
	(
		SELECT DISTINCT
			  tew_equipotential.equ_text AS equ_text
			, tew_equipotential.equ_id AS equ_id
			, tew_file.fil_title AS fil_title
			, tew_file.fil_id AS fil_id
			, tew_location.loc_tagpath AS loc_text
			, tew_mesh.mes_id AS mesh_ID
		FROM 
			tew_mesh
			INNER JOIN tew_wire ON tew_wire.wir_mes_idmfi = tew_mesh.mes_id
			LEFT JOIN tew_equipotential ON tew_equipotential.equ_id = tew_mesh.mes_equ_id
			LEFT JOIN tew_line ON tew_line.lin_equ_id = tew_equipotential.equ_id
			LEFT JOIN tew_file ON tew_file.fil_id = tew_line.lin_fil_id
			LEFT JOIN tew_location ON tew_location.loc_id = tew_file.fil_loc_id
		WHERE (NOT(wir_tag = ]][[ ) OR NOT(equ_text = ]][[ )) 
		UNION
		SELECT DISTINCT 
			tew_wire.wir_tag AS equ_text
			, tew_equipotential.equ_id AS equ_id
			, tew_file.fil_title AS fil_title
			, tew_file.fil_id AS fil_id
			, tew_location.loc_tagpath AS loc_text
			, tew_mesh.mes_id AS mesh_ID
		FROM 
			tew_mesh 
			INNER JOIN tew_wire ON tew_wire.wir_mes_idmfi = tew_mesh.mes_id
			LEFT JOIN tew_equipotential ON tew_equipotential.equ_id = tew_mesh.mes_equ_id
			LEFT JOIN tew_line ON tew_line.lin_equ_id = tew_equipotential.equ_id
			LEFT JOIN tew_file ON tew_file.fil_id = tew_line.lin_fil_id
			LEFT JOIN tew_location ON tew_location.loc_id = tew_file.fil_loc_id		
		WHERE  NOT(equ_text = ]][[) 
	) AS Query1
)AS Query2
GROUP BY loc_text, equ_text, fil_id, fil_title
HAVING COUNT(*) &gt; 1 
    ORDER BY loc_text,equ_text</SQLQuery>
		<BreakFormula/>
		<ORDERS>
			<ORDER>
				<No>-1</No>
				<FieldName>loc_text</FieldName>
				<IsBreak>1</IsBreak>
			</ORDER>
			<ORDER>
				<No>0</No>
				<FieldName>loc_text</FieldName>
				<IsBreak>1</IsBreak>
			</ORDER>
			<ORDER>
				<No>1</No>
				<FieldName>equ_text</FieldName>
				<IsBreak>0</IsBreak>
			</ORDER>
		</ORDERS>
		<ObjectType>1</ObjectType>
	</QUERY>
	<LAYOUT>
		<HeadingFormula>[AUTO]loc_text</HeadingFormula>
		<IsHeadingVisible>1</IsHeadingVisible>
		<IsTitleVisible>1</IsTitleVisible>
		<IsHorzSeparationVisible>1</IsHorzSeparationVisible>
		<IsTotalVisible>0</IsTotalVisible>
		<COLUMNS>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Umístění/lokace</LANGUAGE>
					<LANGUAGE xml:lang="de">Montageort</LANGUAGE>
					<LANGUAGE xml:lang="en">Location</LANGUAGE>
					<LANGUAGE xml:lang="es">Situación</LANGUAGE>
					<LANGUAGE xml:lang="fr">Localisation</LANGUAGE>
					<LANGUAGE xml:lang="it">Ubicazione</LANGUAGE>
					<LANGUAGE xml:lang="ja">ロケーション</LANGUAGE>
					<LANGUAGE xml:lang="ko">위치</LANGUAGE>
					<LANGUAGE xml:lang="pl">Lokalizacja</LANGUAGE>
					<LANGUAGE xml:lang="pt">Localização</LANGUAGE>
					<LANGUAGE xml:lang="ru">Местоположение</LANGUAGE>
					<LANGUAGE xml:lang="tr">Konum</LANGUAGE>
					<LANGUAGE xml:lang="zh">位置</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">位置</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>0</columnIndex>
				<ContentFormula>loc_text</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>1.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Značka</LANGUAGE>
					<LANGUAGE xml:lang="de">Beschriftung</LANGUAGE>
					<LANGUAGE xml:lang="en">Mark</LANGUAGE>
					<LANGUAGE xml:lang="es">Etiqueta</LANGUAGE>
					<LANGUAGE xml:lang="fr">Repère</LANGUAGE>
					<LANGUAGE xml:lang="it">Contrassegno</LANGUAGE>
					<LANGUAGE xml:lang="ja">マーク</LANGUAGE>
					<LANGUAGE xml:lang="ko">표시</LANGUAGE>
					<LANGUAGE xml:lang="pl">Znacznik</LANGUAGE>
					<LANGUAGE xml:lang="pt">Tag</LANGUAGE>
					<LANGUAGE xml:lang="ru">Метка</LANGUAGE>
					<LANGUAGE xml:lang="tr">İşaret</LANGUAGE>
					<LANGUAGE xml:lang="zh">标注</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">標注</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>1</columnIndex>
				<ContentFormula>equ_text</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>2.500000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="cs">Počet duplicit</LANGUAGE>
					<LANGUAGE xml:lang="de">Anzahl duplizieren</LANGUAGE>
					<LANGUAGE xml:lang="en">Duplicated elements</LANGUAGE>
					<LANGUAGE xml:lang="es">Recuento duplicado</LANGUAGE>
					<LANGUAGE xml:lang="fr">Nombre en double</LANGUAGE>
					<LANGUAGE xml:lang="it">Conteggio duplicato</LANGUAGE>
					<LANGUAGE xml:lang="ja">重複ｶｳﾝﾄ</LANGUAGE>
					<LANGUAGE xml:lang="ko">복제 개수</LANGUAGE>
					<LANGUAGE xml:lang="pl">Licznik duplikatów</LANGUAGE>
					<LANGUAGE xml:lang="pt">Total duplicada</LANGUAGE>
					<LANGUAGE xml:lang="ru">Дублирующееся количество</LANGUAGE>
					<LANGUAGE xml:lang="tr">Kopyası oluşturulmuş sayı</LANGUAGE>
					<LANGUAGE xml:lang="zh">重复的计数</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">重複計數</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>2</columnIndex>
				<ContentFormula>Count_duplicated</ContentFormula>
				<GotoId/>
				<GotoType>-1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>1.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<Title>
					<LANGUAGE xml:lang="en">File</LANGUAGE>
					<LANGUAGE xml:lang="fr">Fichier</LANGUAGE>
					<LANGUAGE xml:lang="cs">Soubor</LANGUAGE>
					<LANGUAGE xml:lang="de">Datei</LANGUAGE>
					<LANGUAGE xml:lang="it">File</LANGUAGE>
					<LANGUAGE xml:lang="ja">ﾌｧｲﾙ</LANGUAGE>
					<LANGUAGE xml:lang="ko">파일</LANGUAGE>
					<LANGUAGE xml:lang="zh">文件</LANGUAGE>
					<LANGUAGE xml:lang="pl">Plik</LANGUAGE>
					<LANGUAGE xml:lang="pt">Arquivo</LANGUAGE>
					<LANGUAGE xml:lang="ru">Файл</LANGUAGE>
					<LANGUAGE xml:lang="es">Archivo</LANGUAGE>
					<LANGUAGE xml:lang="tr">Dosya</LANGUAGE>
					<LANGUAGE xml:lang="zh-tw">檔案</LANGUAGE>
				</Title>
				<BreakColumn>0</BreakColumn>
				<columnIndex>3</columnIndex>
				<ContentFormula>fil_title</ContentFormula>
				<GotoId>fil_id</GotoId>
				<GotoType>1</GotoType>
				<EnumerationDelimiter/>
				<HasTotal>0</HasTotal>
				<IsMultiline>0</IsMultiline>
				<IsNumerical>0</IsNumerical>
				<EnumerationType>0</EnumerationType>
				<IsVertSeparationVisible>0</IsVertSeparationVisible>
				<Width>2.000000</Width>
				<HorzTitleAlignment>1</HorzTitleAlignment>
				<HorzContentAlignment>1</HorzContentAlignment>
				<IsVisible>1</IsVisible>
				<NumericalColumnInDatabase>0</NumericalColumnInDatabase>
				<UserDataDescriptionNo>-1</UserDataDescriptionNo>
				<IsTranslatedUserData>0</IsTranslatedUserData>
				<UserDataFormulaFile/>
			</COLUMN>
			<COLUMN>
				<BreakColumn>1</BreakColumn>
				<columnIndex>4</columnIndex>
				<ContentFormula>loc_text</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/>
		<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>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</HeadingFont>
		<TitleFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>150</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
		</TitleFont>
		<ContentFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>0</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>7</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</ContentFont>
		<TotalFont>
			<TxtHeight>2.000000</TxtHeight>
			<TxtFontName>Tahoma</TxtFontName>
			<TxtSize>10</TxtSize>
			<IsTxtBold>1</IsTxtBold>
			<IsTxtItalic>0</IsTxtItalic>
			<IsTxtUnderline>0</IsTxtUnderline>
			<DwgHeight>0.100000</DwgHeight>
			<DwgFontName>Tahoma</DwgFontName>
			<DwgColor>1</DwgColor>
			<DwgFontHeight>0.250000</DwgFontHeight>
			<RowStyle>0</RowStyle>
			<RowHeight>0.300000</RowHeight>
		</TotalFont>
	</FONT>
	<OPTIONS>
		<IsTxtOneArrayPerPage>1</IsTxtOneArrayPerPage>
		<DwgBOMHeight>9.500000</DwgBOMHeight>
		<DwgBOMWidth>16.000000</DwgBOMWidth>
		<IsReverseOrder>0</IsReverseOrder>
		<XDwgBOMOrigine>0.750000</XDwgBOMOrigine>
		<YDwgBOMOrigine>1.400000</YDwgBOMOrigine>
		<DwgHorzOffset>0.500000</DwgHorzOffset>
		<DwgVertOffset>0.500000</DwgVertOffset>
		<IsDwgOneArrayPerPage>0</IsDwgOneArrayPerPage>
		<IsDwgFollowingOnSameSheet>0</IsDwgFollowingOnSameSheet>
		<IsDwgOneArrayPerColumn>0</IsDwgOneArrayPerColumn>
		<TITLEBLOCK_NAME/>
		<OneArrayPerBundle>0</OneArrayPerBundle>
		<TakeIntoGeneratedFile>0</TakeIntoGeneratedFile>
		<MargeBetweenLabelAndTable>0.100000</MargeBetweenLabelAndTable>
		<UsePipeCharacter>1</UsePipeCharacter>
		<BreakTextIntoGeneratedFile>0</BreakTextIntoGeneratedFile>
	</OPTIONS>
	<FILTERS/>
	<FILTERS/>
</SECTIONS>
