select p.Id,p.owneruserid,p.ViewCount,p.AcceptedAnswerId,...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select p.Id,p.owneruserid,p.ViewCount,p.AcceptedAnswerId,p.CommentCount,
p.Score as 'postscore', p.tags,p.AnswerCount,u.Reputation,u.Upvotes,
u.DownVotes,u.Views
from posts p inner join users u on p.owneruserid=u.id 
where p.answercount<1 and p.id not in
(
13254,
132724,
197629,
219345,
228082,
252319,
269520,
271089,
281341,
284994,
286148,
293975,
307247,
314937,
320845,
324146,
325774,
335240,
336822,
349241,
375910,
382800,
388711,
392561,
406605,
427287,
431409,
431581,
441397,
443587,
454303,
454959,
463607,
472695,
494769,
498231,
511176,
512600,
513719,
516058,
519145,
525433,
542662,
543795,
545179,
551034,
566991,
570309,
604781,
682427,
682783,
704343,
704814,
705176,
718316,
723991,
725429,
730568,
735874,
736257,
741744,
744917,
751876,
755285,
768553,
771964,
784164,
789167,
804356,
807354,
812998,
813712,
814585,
818359,
818926,
823219,
825900,
829044,
832237,
835149,
837824,
839179,
840506,
841688,
854765,
855473,
859438,
860715,
862782,
870623,
872571,
876753,
878271,
879688,
883293,
883327,
884894,
886673,
887824,
889843,
899700,
901207,
901818,
902332,
911585,
914272,
915878,
919178,
922285,
924051,
924409,
925172,
925210,
927190,
927507,
931739,
933293,
941404,
947463,
949907,
954767,
955205,
960749,
970114,
972882,
974514,
974693,
976805,
979677,
981757,
982032,
982790,
987516,
988721,
989234,
989633,
990620,
991836,
994221,
1000429,
1000815,
1002009,
1003990,
1018558,
1020731,
1025646,
1027948,
1028138,
1029142,
1029294,
1029540,
1033142,
1035675,
1039258,
1042985,
1043511,
1054522,
1060489,
1061674,
1062194,
1062780,
1065253,
1070125,
1070847,
1084842,
1087201,
1087653,
1089882,
1092330,
1093701,
1094384,
1095686,
1096981,
1097415,
1100383,
1100685,
1101567,
1104934,
1109001,
1109410,
1110712,
1112485,
1112790,
1113541,
1116493,
1116515,
1116711,
1118700,
1121651,
1125218,
1126206,
1126575,
1128499,
1128727,
1129326,
1130909,
1137596,
1140801,
1142810,
1145298,
1152010,
1157902,
1158394,
1165606,
1166556,
1167377,
1171099,
1172768,
1172939,
1173712,
1174133,
1177224,
1180562,
1182677,
1187618,
1188543,
1188552,
1189201,
1189660,
1190200,
1191478,
1192765,
1201978,
1202942,
1206158,
1206777,
1211833,
1214044,
1214296,
1218247,
1219534,
1219652,
1220386,
1222411,
1222707,
1223212,
1223655,
1224528,
1226316,
1227162,
1229866,
1232861,
1234167,
1234594,
1235409,
1240031,
1240300,
1242123,
1246681,
1247264,
1251315,
1253370,
1253448,
1253451,
1256486,
1259181,
1259772,
1260324,
1260605,
1263087,
1263573,
1263658,
1264894,
1266796,
1266832,
1267508,
1269395,
1269422,
1271013,
1273969,
1275348,
1276299,
1276366,
1278347,
1279763,
1281012,
1282148,
1282949,
1285413,
1286802,
1289952,
1290633,
1291433,
1291743,
1292367,
1294197,
1294814,
1298166,
1299397,
1300473,
1301120,
1301486,
1303237,
1304837,
1305589,
1307170,
1309941,
1310117,
1310810,
1311445,
1312837,
1315065,
1316718,
1317164,
1317998,
1320010,
1323073,
1325642,
1329796,
1330446,
1330834,
1332964,
1334843,
1335260,
1336293,
1336521,
1339988,
1340065,
1340150,
1342648,
1342989,
1344095,
1344728,
1350362,
1354093,
1355922,
1356596,
1356710,
1357915,
1359432,
1360255,
1360298,
1360617,
1362029,
1364945,
1365410,
1366749,
1366976,
1367750,
1368345,
1369502,
1371097,
1372399,
1372536,
1372618,
1372763,
1372886,
1373426,
1377190,
1377546,
1386141,
1387172,
1397857,
1398109,
1402087,
1405845,
1407309,
1414092,
1415855,
1416344,
1417793,
1417819,
1423091,
1423483,
1424564,
1426582,
1427139,
1430034,
1430847,
1430979,
1436423,
1438051,
1439225,
1440262,
1444601,
1446340,
1447303,
1448774,
1452624,
1458097,
1459819,
1461994,
1463182,
1463583,
1465221,
1465863,
1467150,
1467785
)
order by p.id

Enter Parameters

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