SELECT h.PostHistoryTypeId, h.CreationDate as modCreation...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Academia

Q&A for academics and those enrolled in higher education

SELECT h.PostHistoryTypeId, h.CreationDate as modCreation, p.CreationDate as postCreation, 'crossvalidated' as Site FROM Posts as p
left join PostHistory AS h ON p.Id=h.PostId
WHERE h.PostHistoryTypeId IN (6, 9, 22, 36, 38)
AND h.UserId!=p.OwnerUserId
AND p.PostTypeId = 1
AND p.Id in (12111,12114,12115,12119,12120,12121,12123,12124,12125,12127,12129,12134,12139,12147,12148,12149,12154,12155,12156,12164,12167,12168,12171,12172,12174,12176,12179,12185,12186,12187,12188,12190,12194,12199,12202,12206,12207,12210,12214,12220,12222,12225,12226,12230,12234,12235,12237,12246,12248,12250,12258,12259,12263,12265,12279,12281,12289,12296,12297,12298,12299,12304,12306,12310,12314,12319,12320,12325,12327,12330,12335,12337,12340,12344,12347,12348,12352,12354,12355,12365,12368,12370,12384,12386,12388,12396,12402,12403,12409,12413,12418,12422,12423,12432,12437,12438,12441,12444,12445,12448,12449,12456,12457,12459,12463,12466,12469,12475,12492,12496,12498,12500,12501,12504,12508,12513,12514,12518,12519,12528,12530,12534,12535,12536,12538,12539,12541,12549,12564)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results