PostHistoryTypes comparisons

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

Q&A for scientists using computers to solve scientific problems

Select 'ServerFault' As [DatabaseName], Count(*) As [Count] From [ServerFault.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                                        Select 'ServerFault.Meta' As [DatabaseName], Count(*) As [Count] From [ServerFault.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                              Select 'StackApps' As [DatabaseName], Count(*) As [Count] From [StackApps.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                                            Select 'StackExchange.Android' As [DatabaseName], Count(*) As [Count] From [StackExchange.Android.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.Android.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Android.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL          Select 'StackExchange.Apple' As [DatabaseName], Count(*) As [Count] From [StackExchange.Apple.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                        Select 'StackExchange.Apple.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Apple.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL              Select 'StackExchange.Bicycles' As [DatabaseName], Count(*) As [Count] From [StackExchange.Bicycles.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Bicycles.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Bicycles.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL        Select 'StackExchange.Cooking' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cooking.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.Cooking.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cooking.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL          Select 'StackExchange.Cstheory' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cstheory.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Cstheory.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Cstheory.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL        Select 'StackExchange.Dba' As [DatabaseName], Count(*) As [Count] From [StackExchange.Dba.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                            Select 'StackExchange.Dba.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Dba.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Diy' As [DatabaseName], Count(*) As [Count] From [StackExchange.Diy.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                            Select 'StackExchange.Diy.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Diy.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Drupal' As [DatabaseName], Count(*) As [Count] From [StackExchange.Drupal.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                      Select 'StackExchange.Drupal.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Drupal.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL            Select 'StackExchange.Electronics' As [DatabaseName], Count(*) As [Count] From [StackExchange.Electronics.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL            Select 'StackExchange.Electronics.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Electronics.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL  Select 'StackExchange.English' As [DatabaseName], Count(*) As [Count] From [StackExchange.English.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.English.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.English.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL          Select 'StackExchange.GameDev' As [DatabaseName], Count(*) As [Count] From [StackExchange.GameDev.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.GameDev.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.GameDev.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL          Select 'StackExchange.Gaming' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gaming.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                      Select 'StackExchange.Gaming.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gaming.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL            Select 'StackExchange.Gis' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gis.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                            Select 'StackExchange.Gis.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Gis.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Math' As [DatabaseName], Count(*) As [Count] From [StackExchange.Math.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                          Select 'StackExchange.Math.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Math.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                Select 'StackExchange.Photography' As [DatabaseName], Count(*) As [Count] From [StackExchange.Photography.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL            Select 'StackExchange.Photography.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Photography.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL  Select 'StackExchange.Physics' As [DatabaseName], Count(*) As [Count] From [StackExchange.Physics.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.Physics.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Physics.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL          Select 'StackExchange.Programmers' As [DatabaseName], Count(*) As [Count] From [StackExchange.Programmers.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL            Select 'StackExchange.Programmers.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Programmers.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL  Select 'StackExchange.Scifi' As [DatabaseName], Count(*) As [Count] From [StackExchange.Scifi.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                        Select 'StackExchange.Scifi.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Scifi.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL              Select 'StackExchange.Security' As [DatabaseName], Count(*) As [Count] From [StackExchange.Security.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Security.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Security.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL        Select 'StackExchange.Sharepoint' As [DatabaseName], Count(*) As [Count] From [StackExchange.Sharepoint.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL              Select 'StackExchange.Sharepoint.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Sharepoint.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL    Select 'StackExchange.Stats' As [DatabaseName], Count(*) As [Count] From [StackExchange.Stats.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                        Select 'StackExchange.Stats.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Stats.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL              Select 'StackExchange.Tex' As [DatabaseName], Count(*) As [Count] From [StackExchange.Tex.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                            Select 'StackExchange.Tex.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Tex.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                  Select 'StackExchange.Ubuntu' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ubuntu.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                      Select 'StackExchange.Ubuntu.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ubuntu.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL            Select 'StackExchange.Ui' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ui.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                              Select 'StackExchange.Ui.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Ui.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.Unix' As [DatabaseName], Count(*) As [Count] From [StackExchange.Unix.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                          Select 'StackExchange.Unix.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Unix.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                Select 'StackExchange.WebApps' As [DatabaseName], Count(*) As [Count] From [StackExchange.WebApps.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                    Select 'StackExchange.WebApps.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.WebApps.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL          Select 'StackExchange.Webmasters' As [DatabaseName], Count(*) As [Count] From [StackExchange.Webmasters.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL              Select 'StackExchange.Webmasters.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Webmasters.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL    Select 'StackExchange.Wordpress' As [DatabaseName], Count(*) As [Count] From [StackExchange.Wordpress.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                Select 'StackExchange.Wordpress.Meta' As [DatabaseName], Count(*) As [Count] From [StackExchange.Wordpress.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL      Select 'StackOverflow' As [DatabaseName], Count(*) As [Count] From [StackOverflow.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                                    Select 'StackOverflow.Meta' As [DatabaseName], Count(*) As [Count] From [StackOverflow.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                          Select 'SuperUser' As [DatabaseName], Count(*) As [Count] From [SuperUser.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name UNION ALL                                            Select 'SuperUser.Meta' As [DatabaseName], Count(*) As [Count] From [SuperUser.Meta.Exported]..PostHistoryTypes fp Left Outer Join PostHistoryTypes p ON fp.Id=p.Id Where fp.Name Collate SQL_Latin1_General_CP1_CI_AS <> p.Name

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results