MySQL Query:SELECT itemid,title,thumb,linkurl,style,catid,areaid,introduce,addtime,edittime,username,company,groupid,vip,qq,wx,ali,skype,validated,price,unit,minamount,amount,hits,comments,messages,orders FROM [pre]sell_5 AS s LEFT JOIN [pre]sell_5_lang as l ON s.itemid=l.itemid WHERE s.status=3 AND catid IN (50587,112023,112074,112075,112076,112077,112078,112079,112080,112081,112082,112083,112084,112085,112024,112086,112087,112088,112089,112090,112091,112092,112025,112093,112094,112095,112096,112097,112098,112099,112100,112101,112102,112103,112104,112105,112106,112107,112108,112109,112110,112111,112112,112113,112114,112115,112116,112117,112118,112119,112120,112121,112122,112123,112124,112125,112126,112127,112128,112129,112130,112131,112132,112133,112026,112134,112135,112136,112137,112138,112139,112140,112141,112142,112143,112144,112145,112146,112147,112148,112149,112150,112027,112151,112152,112153,112154,112155,112156,112157,112158,112159,112160,112161,112162,112163,112164,112165,112028,112166,112167,112168,112169,112170,112171,112172,112173,112174,112175,112176,112177,112178,112179,112180,112181,112182,112183,112184,112185,112186,112187,112188,112189,112190,112191,112192,112029,112193,112194,112195,112196,112197,112198,112199,112200,112201,112202,112203,112030,112204,112205,112206,112207,112208,112209,112210,112211,112212,112213,112214,112215,112216,112217,112218,112031,112219,112220,112221,112222,112032,112223,112224,112225,112226,112227,112228,112229,112230,112231,112232,112233,112234,112235,112236,112237,112238,112239,112240,112241,112242,112243,112244,112245,112246,112247,112248,112249,112250,112251,112252,112253,112254,112255,112256,112257,112033,112258,112259,112260,112261,112262,112263,112264,112265,112266,112267,112268,112269,112270,112271,112034,112272,112273,112274,112275,112276,112277,112278,112279,112280,112281,112035,112282,112283,112284,112285,112286,112287,112288,112289,112290,112036,112291,112292,112293,112294,112037,112295,112296,112297,112298,112299,112300,112301,112302,112303,112038,112304,112305,112306,112307,112308,112309,112310,112311,112039,112312,112313,112314,112315,112316,112317,112318,112319,112320,112040,112321,112322,112323,112324,112325,112326,112327,112328,112329,112330,112331,112332,112333,112334,112335,112336,112337,112338,112339,112340,112341,112342,112343,112344,112345,112346,112347,112348,112349,112350,112351,112352,112353,112354,112041,112355,112356,112357,112358,112359,112360,112361,112362,112042,112363,112364,112365,112366,112367,112368,112369,112370,112371,112043,112372,112373,112374,112375,112376,112377,112378,112379,112380,112381,112382,112383,112384,112385,112386,112387,112388,112389,112390,112044,112391,112392,112393,112394,112395,112396,112397,112398,112399,112400,112401,112402,112403,112404,112405,112406,112407,112408,112409,112410,112411,112412,112413,112414,112415,112416,112417,112418,112419,112420,112421,112422,112423,112424,112045,112425,112426,112427,112428,112429,112430,112431,112432,112433,112434,112435,112436,112437,112438,112439,112440,112441,112442,112443,112444,112445,112446,112046,112447,112448,112449,112450,112451,112452,112453,112454,112455,112456,112457,112047,112458,112459,112460,112461,112462,112463,112464,112465,112466,112467,112468,112469,112470,112471,112048,112472,112473,112474,112475,112476,112477,112478,112479,112480,112049,112481,112482,112483,112484,112485,112486,112487,112488,112050,112489,112490,112491,112492,112493,112494,112495,112496,112497,112498,112499,112500,112051,112501,112502,112503,112504,112505,112506,112507,112508,112509,112510,112511,112512,112513,112514,112515,112516,112517,112518,112519,112520,112521,112522,112523,112524,112525,112526,112052,112527,112528,112529,112530,112531,112532,112533,112534,112535,112536,112537,112538,112539,112540,112541,112542,112543,112544,112545,112546,112547,112548,112549,112550,112551,112552,112553,112554,112555,112556,112557,112558,112053,112559,112560,112561,112562,112563,112564,112565,112566,112567,112568,112569,112570,112571,112572,112573,112574,112575,112576,112577,112578,112579,112580,112581,112582,112583,112584,112054,112585,112586,112587,112588,112589,112590,112591,112592,112593,112594,112595,112596,112597,112598,112055,112599,112600,112601,112602,112603,112604,112605,112056,112606,112607,112608,112609,112610,112611,112612,112613,112614,112615,112616,112617,112618,112619,112620,112621,112622,112623,112624,112625,112626,112627,112628,112629,112630,112631,112632,112633,112634,112057,112635,112636,112637,112638,112639,112640,112641,112642,112643,112644,112645,112058,112646,112647,112648,112649,112650,112651,112652,112653,112654,112655,112656,112657,112658,112659,112660,112661,112662,112663,112664,112665,112059,112666,112667,112668,112669,112670,112671,112672,112673,112674,112675,112676,112677,112678,112679,112680,112681,112682,112683,112684,112685,112686,112687,112688,112689,112690,112691,112692,112693,112694,112695,112696,112697,112698,112699,112700,112701,112702,112703,112704,112060,112705,112706,112707,112708,112709,112710,112711,112712,112713,112714,112715,112716,112717,112718,112719,112720,112721,112722,112723,112724,112725,112726,112727,112728,112729,112730,112731,112732,112733,112734,112735,112736,112737,112738,112739,112740,112061,112741,112742,112743,112744,112745,112062,112746,112747,112748,112749,112750,112751,112752,112753,112754,112755,112756,112757,112063,112758,112759,112760,112761,112762,112763,112764,112765,112766,112767,112768,112769,112770,112771,112772,112773,112064,112774,112775,112776,112777,112778,112779,112780,112781,112782,112783,112784,112785,112786,112787,112788,112789,112790,112791,112792,112793,112794,112795,112796,112797,112798,112799,112800,112801,112802,112803,112804,112805,112806,112807,112808,112809,112810,112065,112811,112812,112813,112814,112815,112066,112816,112817,112818,112819,112820,112821,112822,112823,112824,112825,112826,112827,112828,112829,112830,112831,112832,112833,112834,112835,112836,112837,112838,112839,112840,112841,112842,112067,112843,112844,112845,112846,112847,112848,112849,112850,112068,112851,112852,112853,112854,112855,112856,112857,112858,112859,112860,112861,112069,112862,112863,112864,112865,112866,112867,112868,112869,112870,112871,112872,112873,112874,112875,112876,112877,112878,112879,112880,112881,112882,112883,112884,112885,112886,112887,112888,112889,112890,112891,112070,112892,112893,112894,112895,112896,112897,112898,112899,112900,112901,112902,112903,112904,112905,112906,112907,112908,112909,112071,112910,112911,112912,112913,112914,112915,112916,112917,112918,112919,112920,112921,112922,112923,112924,112925,112926,112927,112928,112929,112930,112072,112931,112932,112933,112934,112935,112936,112937,112938,112939,112940,112941,112942,112943,112944,112073,112945,112946,112947,112948,112949,112950,112951,112952) AND areaid=2 ORDER BY editdate desc,sort desc,vip desc,edittime desc LIMIT 0,20
MySQL Error:Column 'itemid' in field list is ambiguous MySQL Errno:0
Message:MySQL Query Error