select users.*, posts.id as 'postId' from users join post...

1

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 users.*, posts.id as 'postId' from users join posts on users.id = posts.OwnerUserId where posts.id in (
28734594,
29848140,
31188849,
30444150,
32021193,
32051973,
32258675,
34638651,
37206416,
39044494,
39022845,
40849143,
41032145,
26479618,
26310908,
28004653,
28003186,
28116521,
28355353,
27139281,
28685027,
28966466,
28954421,
29190072,
29724923,
29744045,
29861580,
30047918,
30106336,
30195940,
30582324,
30838231,
30163964,
30952459,
31064433,
31120662,
31323889,
31371440,
31345049,
31290783,
31506508,
31579686,
31751885,
31797821,
31786559,
31884355,
31984622,
31756883,
32108318,
32153945,
32142463,
32295158,
32310523,
32603382,
31987928,
33149700,
33220233,
33039188,
33379534,
33391042,
33371331,
33617074,
33654287,
33851794,
33907279,
33763874,
34017544,
34169251,
34170159,
34476043,
34545676,
34627394,
34387574,
35105545,
35211950,
32990275,
35354363,
35287835,
35489632,
35048208,
35604954,
34298780,
35634085,
35664198,
35711493,
35709241,
35757052,
35793657,
35636078,
33472447,
35968315,
36034766,
34832098,
36204550,
36180407,
36368371,
36472561,
36004651,
36530342,
35133519,
35620400,
37124544,
37144657,
37300874,
37441252,
37816319,
38403559,
38601271,
38274943,
39034348,
38832797,
39327480,
39281557,
39464909,
39954501,
40419605,
40832882,
41096332,
41251543,
41363429,
40766673,
41393423,
41500348,
41646040,
41652621,
41732005,
41705194,
41790052,
36055167,
41892544,
41982214,
42009948,
39407587,
42068877,
37462464,
42119670,
42054221,
42112519,
42258489,
42366276,
42358194,
42403890,
42420540,
42820003,
42583759,
39454127,
42901334,
43052236,
43134675,
43098757,
43362896,
43371389,
41627671,
43258773,
43632752,
43765499,
43774620,
38034005,
44208122,
44447767,
44487347,
44560981,
44753069,
44749473,
44863661,
44910631,
44948245,
45051996,
45139577,
45201324,
45208116,
45217815,
45358247,
45407964,
45586828,
45630453,
45531230,
45783523,
37483049,
46111860,
45982524,
41615189,
46278357,
46367880,
46435424,
45099484,
47002893,
47078005,
47148619,
47323883,
37747466,
45203918,
47451783,
47868684,
47866673,
47727211,
48094952,
48039177,
48127910,
48172376,
48172364,
47051069,
46984467,
48406497,
48645234,
48781673,
48774255,
48914977,
49029004,
49212540,
49213525,
49232559,
49417910,
49488903,
49590960,
49588393,
49688616,
49762991,
46689217,
49833533,
50053555,
50362528,
50423546,
50869969,
50709880,
51216376,
29472129,
51523053,
51757164,
51781176,
51884303,
51892478,
51988532,
51309576,
52140059,
52173040,
52235986,
52381029,
52367169,
52441736,
50615225,
52576072,
49832787,
52788958,
52873173,
52873328,
44497929,
52972693,
53051745,
53129932,
53193247,
53372539,
53638074,
53573731,
53931191,
54016644,
46646744,
54448798,
54489418,
54508117,
54847411,
54878343,
54728368,
54967251,
54529117,
55038077,
55237055,
26241916,
26689630,
27311251,
27529852,
27738431,
27876937,
28257607,
29029594,
29071154,
29253846,
29431021,
29501618,
29540171,
29542859,
29556406,
29578606,
29822760,
30172529,
30334319,
30350739,
30622664,
31154802,
31229953,
31232008,
31450919,
31640783,
31734248,
32063524,
32105132,
32105785,
32134299,
32193244,
32362072,
32525489,
32715573,
32736708,
32961771,
32970996,
32988308,
33115337,
33127258,
33151244,
33686656,
33876196,
34070557,
34609427,
34881551,
35054405,
35056994,
35127970,
35244472,
35381104,
35629725,
35660883,
35699359,
35811411,
35877936,
36051791,
36170914,
36174807,
36265659,
36440019,
36481333,
36530511,
36580297,
36669064,
36713033,
36715739,
36739298,
36755427,
36964572,
37014990,
37075088,
37327891,
37371844,
37539614,
37547385,
37559401,
37597252,
37623264,
37642551,
37764937,
37908660,
37936693,
38296278,
38305431,
38493000,
38535355,
38809845,
38814600,
38869938,
38901921,
39019899,
39075163,
39131973,
39253010,
39363500,
39443657,
39470098,
39481821,
39585232,
39658993,
39797164,
39982859,
40144970,
40331561,
40533276,
40548551,
41221284,
41284827,
41296030,
41518374,
41623247,
41680922,
41713056,
41766196,
41773621,
41828237,
41834529,
41926591,
41985926,
42107466,
42216472,
42268602,
42345734,
42418470,
42548247,
42581120,
42623014,
43159280,
43251528,
43300273,
43319318,
43382586,
43440909,
43460985,
43515031,
43532713,
43549220,
43632379,
43821919,
44022751,
44181562,
44231334,
44249483,
44467885,
44527420,
44905858,
44911596,
45005130,
45104944,
45461226,
45593065,
45630903,
45692889,
46119375,
46134466,
46268768,
46273499,
46275819,
46294833,
46317509,
46465056,
46533989,
46543877,
46567945,
46601474,
46666474,
46696170,
46774604,
46831355,
47158230,
47236796,
47248029,
47459523,
47469398,
47479274,
47528461,
47529737,
47533726,
47544132,
47551921,
47621046,
47839974,
47860064,
47874391,
47880718,
48005850,
48020271,
48095462,
48105925,
48169430,
48189415,
48198374,
48241802,
48382642,
48524083,
48604251,
48608334,
48675221,
48887518,
48972343,
49024906,
49167514,
49236067,
49520242,
49696008,
49834875,
49940190,
50031467,
50121501,
50173009,
50177783,
50456919,
50735291,
50747713,
50758822,
50770478,
50782496,
50797934,
50970915,
51067310,
51192192,
51203665,
51252795,
51365460,
51387282,
51393867,
51496306,
51498296,
51801851,
51854567,
51879224,
51892029,
51988969,
52269697,
52374888,
52454186,
52477887,
52480833,
53141233,
53445426,
53494927,
53507668,
53635269,
53865978,
54073476,
54091648,
54319444,
54402542,
54493736,
54539912,
54608165,
54640389,
54879581,
55083734,
55196032,
55301892,
55520315,
55764251,
38698426,
49942640,
18888714,
19482372,
20101448,
20168563,
21305874,
22600920,
22935840,
23366226,
24025004,
24539899,
25571843,
27105619,
27171629,
28702698,
29299181,
29831953,
29831374,
31730050,
34525587,
34512248,
34606760,
35076591,
35584271,
35195982,
35709341,
36433556,
36581834,
36655518,
36683434,
36899386,
37970709,
34751700,
39233986,
40357318,
40585031,
40802405,
40775533,
41092751,
41429778,
41578040,
42102689,
42420125,
42721597,
43150564,
36730903,
43374658,
45136514,
27987068,
45993586,
46162061,
46174992,
46732371,
43458500,
48772458,
51738718,
51736997,
37042106,
54750194,
23511605,
27643278,
29282870,
34821978,
36100395,
36705874,
37061697,
37598036,
37780976,
38800564,
38910280,
39082691,
39645590,
40355743,
40623809,
41738864,
41850162,
42867921,
43082213,
43431802,
47202657,
47239476,
49939639,
50141309,
51348352,
53816713,
55564608
)

Enter Parameters

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