| RESULT | | Struct | | CACHED | | | COLUMNLIST | | string | SECONDPUBLICID,GROUPROWCOUNT,PROPERTYTYPE,MLSID |
| | EXECUTIONTIME | | | KEY | | string | D22D50DF22A5297A329F6444BF254CE4 |
| | SQL | | string | SELECT tblResidential_mls_southbend.SecondPublicID,COUNT( tblResidential_mls_southbend.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_southbend' AS MLSIDFROM [data-3_mls_southbend].[mls_southbend].[dbo].[Residential] AS tblResidential_mls_southbendWHERE tblResidential_mls_southbend.SecondPublicID <> ''AND tblResidential_mls_southbend.DeleteFlag = 'N'GROUP BY tblResidential_mls_southbend.SecondPublicIDUNIONSELECT tblResidential_mls_neindiana.SecondPublicID,COUNT( tblResidential_mls_neindiana.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_neindiana' AS MLSIDFROM [data-3_mls_neindiana].[mls_neindiana].[dbo].[Residential] AS tblResidential_mls_neindianaWHERE tblResidential_mls_neindiana.SecondPublicID <> ''AND tblResidential_mls_neindiana.DeleteFlag = 'N'GROUP BY tblResidential_mls_neindiana.SecondPublicIDUNIONSELECT tblResidential_mls_kosciusko.SecondPublicID,COUNT( tblResidential_mls_kosciusko.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_kosciusko' AS MLSIDFROM [data-3_mls_kosciusko].[mls_kosciusko].[dbo].[Residential] AS tblResidential_mls_kosciuskoWHERE tblResidential_mls_kosciusko.SecondPublicID <> ''AND tblResidential_mls_kosciusko.DeleteFlag = 'N'GROUP BY tblResidential_mls_kosciusko.SecondPublicIDUNIONSELECT tblResidential_mls_ncindiana.SecondPublicID,COUNT( tblResidential_mls_ncindiana.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_ncindiana' AS MLSIDFROM [data-3_mls_ncindiana].[mls_ncindiana].[dbo].[Residential] AS tblResidential_mls_ncindianaWHERE tblResidential_mls_ncindiana.SecondPublicID <> ''AND tblResidential_mls_ncindiana.DeleteFlag = 'N'GROUP BY tblResidential_mls_ncindiana.SecondPublicIDUNIONSELECT tblResidential_mls_ftwayne.SecondPublicID,COUNT( tblResidential_mls_ftwayne.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_ftwayne' AS MLSIDFROM [data-3_mls_ftwayne].[mls_ftwayne].[dbo].[Residential] AS tblResidential_mls_ftwayneWHERE tblResidential_mls_ftwayne.SecondPublicID <> ''AND tblResidential_mls_ftwayne.DeleteFlag = 'N'GROUP BY tblResidential_mls_ftwayne.SecondPublicIDUNIONSELECT tblResidential_mls_elkhartcounty.SecondPublicID,COUNT( tblResidential_mls_elkhartcounty.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_elkhartcounty' AS MLSIDFROM [data-3_mls_elkhartcounty].[mls_elkhartcounty].[dbo].[Residential] AS tblResidential_mls_elkhartcountyWHERE tblResidential_mls_elkhartcounty.SecondPublicID <> ''AND tblResidential_mls_elkhartcounty.DeleteFlag = 'N'GROUP BY tblResidential_mls_elkhartcounty.SecondPublicIDUNIONSELECT tblResidential_mls_swmichigan.SecondPublicID,COUNT( tblResidential_mls_swmichigan.SecondPublicID ) AS GroupRowCount,'Residential' AS PropertyType,'mls_swmichigan' AS MLSIDFROM [data-3_mls_swmichigan].[mls_swmichigan].[dbo].[Residential] AS tblResidential_mls_swmichiganWHERE tblResidential_mls_swmichigan.SecondPublicID <> ''AND tblResidential_mls_swmichigan.DeleteFlag = 'N'GROUP BY tblResidential_mls_swmichigan.SecondPublicIDUNIONSELECT tblCommercial_mls_southbend.SecondPublicID,COUNT( tblCommercial_mls_southbend.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_southbend' AS MLSIDFROM [data-3_mls_southbend].[mls_southbend].[dbo].[Commercial] AS tblCommercial_mls_southbendWHERE tblCommercial_mls_southbend.SecondPublicID <> ''AND tblCommercial_mls_southbend.DeleteFlag = 'N'GROUP BY tblCommercial_mls_southbend.SecondPublicIDUNIONSELECT tblCommercial_mls_neindiana.SecondPublicID,COUNT( tblCommercial_mls_neindiana.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_neindiana' AS MLSIDFROM [data-3_mls_neindiana].[mls_neindiana].[dbo].[Commercial] AS tblCommercial_mls_neindianaWHERE tblCommercial_mls_neindiana.SecondPublicID <> ''AND tblCommercial_mls_neindiana.DeleteFlag = 'N'GROUP BY tblCommercial_mls_neindiana.SecondPublicIDUNIONSELECT tblCommercial_mls_kosciusko.SecondPublicID,COUNT( tblCommercial_mls_kosciusko.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_kosciusko' AS MLSIDFROM [data-3_mls_kosciusko].[mls_kosciusko].[dbo].[Commercial] AS tblCommercial_mls_kosciuskoWHERE tblCommercial_mls_kosciusko.SecondPublicID <> ''AND tblCommercial_mls_kosciusko.DeleteFlag = 'N'GROUP BY tblCommercial_mls_kosciusko.SecondPublicIDUNIONSELECT tblCommercial_mls_ncindiana.SecondPublicID,COUNT( tblCommercial_mls_ncindiana.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_ncindiana' AS MLSIDFROM [data-3_mls_ncindiana].[mls_ncindiana].[dbo].[Commercial] AS tblCommercial_mls_ncindianaWHERE tblCommercial_mls_ncindiana.SecondPublicID <> ''AND tblCommercial_mls_ncindiana.DeleteFlag = 'N'GROUP BY tblCommercial_mls_ncindiana.SecondPublicIDUNIONSELECT tblCommercial_mls_ftwayne.SecondPublicID,COUNT( tblCommercial_mls_ftwayne.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_ftwayne' AS MLSIDFROM [data-3_mls_ftwayne].[mls_ftwayne].[dbo].[Commercial] AS tblCommercial_mls_ftwayneWHERE tblCommercial_mls_ftwayne.SecondPublicID <> ''AND tblCommercial_mls_ftwayne.DeleteFlag = 'N'GROUP BY tblCommercial_mls_ftwayne.SecondPublicIDUNIONSELECT tblCommercial_mls_elkhartcounty.SecondPublicID,COUNT( tblCommercial_mls_elkhartcounty.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_elkhartcounty' AS MLSIDFROM [data-3_mls_elkhartcounty].[mls_elkhartcounty].[dbo].[Commercial] AS tblCommercial_mls_elkhartcountyWHERE tblCommercial_mls_elkhartcounty.SecondPublicID <> ''AND tblCommercial_mls_elkhartcounty.DeleteFlag = 'N'GROUP BY tblCommercial_mls_elkhartcounty.SecondPublicIDUNIONSELECT tblCommercial_mls_swmichigan.SecondPublicID,COUNT( tblCommercial_mls_swmichigan.SecondPublicID ) AS GroupRowCount,'Commercial' AS PropertyType,'mls_swmichigan' AS MLSIDFROM [data-3_mls_swmichigan].[mls_swmichigan].[dbo].[Commercial] AS tblCommercial_mls_swmichiganWHERE tblCommercial_mls_swmichigan.SecondPublicID <> ''AND tblCommercial_mls_swmichigan.DeleteFlag = 'N'GROUP BY tblCommercial_mls_swmichigan.SecondPublicIDUNIONSELECT tblLand_mls_southbend.SecondPublicID,COUNT( tblLand_mls_southbend.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_southbend' AS MLSIDFROM [data-3_mls_southbend].[mls_southbend].[dbo].[Land] AS tblLand_mls_southbendWHERE tblLand_mls_southbend.SecondPublicID <> ''AND tblLand_mls_southbend.DeleteFlag = 'N'GROUP BY tblLand_mls_southbend.SecondPublicIDUNIONSELECT tblLand_mls_neindiana.SecondPublicID,COUNT( tblLand_mls_neindiana.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_neindiana' AS MLSIDFROM [data-3_mls_neindiana].[mls_neindiana].[dbo].[Land] AS tblLand_mls_neindianaWHERE tblLand_mls_neindiana.SecondPublicID <> ''AND tblLand_mls_neindiana.DeleteFlag = 'N'GROUP BY tblLand_mls_neindiana.SecondPublicIDUNIONSELECT tblLand_mls_kosciusko.SecondPublicID,COUNT( tblLand_mls_kosciusko.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_kosciusko' AS MLSIDFROM [data-3_mls_kosciusko].[mls_kosciusko].[dbo].[Land] AS tblLand_mls_kosciuskoWHERE tblLand_mls_kosciusko.SecondPublicID <> ''AND tblLand_mls_kosciusko.DeleteFlag = 'N'GROUP BY tblLand_mls_kosciusko.SecondPublicIDUNIONSELECT tblLand_mls_ncindiana.SecondPublicID,COUNT( tblLand_mls_ncindiana.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_ncindiana' AS MLSIDFROM [data-3_mls_ncindiana].[mls_ncindiana].[dbo].[Land] AS tblLand_mls_ncindianaWHERE tblLand_mls_ncindiana.SecondPublicID <> ''AND tblLand_mls_ncindiana.DeleteFlag = 'N'GROUP BY tblLand_mls_ncindiana.SecondPublicIDUNIONSELECT tblLand_mls_ftwayne.SecondPublicID,COUNT( tblLand_mls_ftwayne.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_ftwayne' AS MLSIDFROM [data-3_mls_ftwayne].[mls_ftwayne].[dbo].[Land] AS tblLand_mls_ftwayneWHERE tblLand_mls_ftwayne.SecondPublicID <> ''AND tblLand_mls_ftwayne.DeleteFlag = 'N'GROUP BY tblLand_mls_ftwayne.SecondPublicIDUNIONSELECT tblLand_mls_elkhartcounty.SecondPublicID,COUNT( tblLand_mls_elkhartcounty.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_elkhartcounty' AS MLSIDFROM [data-3_mls_elkhartcounty].[mls_elkhartcounty].[dbo].[Land] AS tblLand_mls_elkhartcountyWHERE tblLand_mls_elkhartcounty.SecondPublicID <> ''AND tblLand_mls_elkhartcounty.DeleteFlag = 'N'GROUP BY tblLand_mls_elkhartcounty.SecondPublicIDUNIONSELECT tblLand_mls_swmichigan.SecondPublicID,COUNT( tblLand_mls_swmichigan.SecondPublicID ) AS GroupRowCount,'Land' AS PropertyType,'mls_swmichigan' AS MLSIDFROM [data-3_mls_swmichigan].[mls_swmichigan].[dbo].[Land] AS tblLand_mls_swmichiganWHERE tblLand_mls_swmichigan.SecondPublicID <> ''AND tblLand_mls_swmichigan.DeleteFlag = 'N'GROUP BY tblLand_mls_swmichigan.SecondPublicIDUNIONSELECT tblMultiFamily_mls_southbend.SecondPublicID,COUNT( tblMultiFamily_mls_southbend.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_southbend' AS MLSIDFROM [data-3_mls_southbend].[mls_southbend].[dbo].[MultiFamily] AS tblMultiFamily_mls_southbendWHERE tblMultiFamily_mls_southbend.SecondPublicID <> ''AND tblMultiFamily_mls_southbend.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_southbend.SecondPublicIDUNIONSELECT tblMultiFamily_mls_neindiana.SecondPublicID,COUNT( tblMultiFamily_mls_neindiana.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_neindiana' AS MLSIDFROM [data-3_mls_neindiana].[mls_neindiana].[dbo].[MultiFamily] AS tblMultiFamily_mls_neindianaWHERE tblMultiFamily_mls_neindiana.SecondPublicID <> ''AND tblMultiFamily_mls_neindiana.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_neindiana.SecondPublicIDUNIONSELECT tblMultiFamily_mls_kosciusko.SecondPublicID,COUNT( tblMultiFamily_mls_kosciusko.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_kosciusko' AS MLSIDFROM [data-3_mls_kosciusko].[mls_kosciusko].[dbo].[MultiFamily] AS tblMultiFamily_mls_kosciuskoWHERE tblMultiFamily_mls_kosciusko.SecondPublicID <> ''AND tblMultiFamily_mls_kosciusko.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_kosciusko.SecondPublicIDUNIONSELECT tblMultiFamily_mls_ncindiana.SecondPublicID,COUNT( tblMultiFamily_mls_ncindiana.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_ncindiana' AS MLSIDFROM [data-3_mls_ncindiana].[mls_ncindiana].[dbo].[MultiFamily] AS tblMultiFamily_mls_ncindianaWHERE tblMultiFamily_mls_ncindiana.SecondPublicID <> ''AND tblMultiFamily_mls_ncindiana.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_ncindiana.SecondPublicIDUNIONSELECT tblMultiFamily_mls_ftwayne.SecondPublicID,COUNT( tblMultiFamily_mls_ftwayne.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_ftwayne' AS MLSIDFROM [data-3_mls_ftwayne].[mls_ftwayne].[dbo].[MultiFamily] AS tblMultiFamily_mls_ftwayneWHERE tblMultiFamily_mls_ftwayne.SecondPublicID <> ''AND tblMultiFamily_mls_ftwayne.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_ftwayne.SecondPublicIDUNIONSELECT tblMultiFamily_mls_elkhartcounty.SecondPublicID,COUNT( tblMultiFamily_mls_elkhartcounty.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_elkhartcounty' AS MLSIDFROM [data-3_mls_elkhartcounty].[mls_elkhartcounty].[dbo].[MultiFamily] AS tblMultiFamily_mls_elkhartcountyWHERE tblMultiFamily_mls_elkhartcounty.SecondPublicID <> ''AND tblMultiFamily_mls_elkhartcounty.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_elkhartcounty.SecondPublicIDUNIONSELECT tblMultiFamily_mls_swmichigan.SecondPublicID,COUNT( tblMultiFamily_mls_swmichigan.SecondPublicID ) AS GroupRowCount,'MultiFamily' AS PropertyType,'mls_swmichigan' AS MLSIDFROM [data-3_mls_swmichigan].[mls_swmichigan].[dbo].[MultiFamily] AS tblMultiFamily_mls_swmichiganWHERE tblMultiFamily_mls_swmichigan.SecondPublicID <> ''AND tblMultiFamily_mls_swmichigan.DeleteFlag = 'N'GROUP BY tblMultiFamily_mls_swmichigan.SecondPublicIDORDER BY PropertyType ASC, MLSID ASC, SecondPublicID ASC |
|
|
List Price
