Database System Tips: MySQL Query Error
Time: 2013-5-25 12:23am
Script:
SQL: SELECT DISTINCT t5.* FROM `***categories` AS t1 INNER JOIN `sub_subject` AS t2 ON t2.subject=t1.cateid INNER JOIN `sub_sub_subject` AS t3 ON t3.sub_subject=t2.id INNER JOIN `book2subjects` AS t4 ON t4.sub_sub_subject=t3.id INNER JOIN `***blogs` AS t5 ON t5.blogid=t4.book WHERE `blogid` IN (,169555,169593,301222,301508,301585,301678,301902,302282,302320,302359,302372,302380,302423,302435,302504,302579,302599,302604,302672,302705,302789,302806,302819,302840,302873,302888,302994,302998,303005,303012,303018,303046,303079,303139,303218,303473,304126,304128,304134,304159,304233,304301,305362,305677,305724,305730,305732,305740,305742,305753,305759,305791,305862,305908,305944,306010,306017,306050,306088,306109,306112,306128,306130,306134,306178,306211,306215,306221,306292,306325,306338,306402,306420,306421,306423,306471,306479,306495,306501,306578,306606,306610,306630,306683,306698,306708,306735,306739,306753,306851,306881,306929,306939,306941,306946,306980,306983,307050,307067,307092,307095,307111,307124,307140,307156,307209,307218,307221,307228,307233,307236,307242,307249,307250,307253,307254,307256,307261,307262,307361,307384,307410,307412,307450,307456,307459,307461,307465,307510,307516,307573,307611,307614,307642,307683,307686,307719,307770,307825,307845,307847,307848,307855,307900,307961,307981,307982,308118,308130,308162,308194,308204,308207,308213,308220,308241,308248,308255,308457,308467,308483,308489,308631,308638,308735,308970,308988,309034,309063,309068,309126,309155,309202,309203,309225,309252,309273,309274,309305,309320,309408,309487,309494,309515,309520,309566,309584,309595,309656,309657,309664,309688,309694,309747,309749,309756,309758,309783,309823,309837,309850,309851,309862,309863,309868,309924,309930,309936,309948,309950,310013,310020,310058,310059,310073,310103,310108,310115,310121,310234,310242,310258,310369,310405,310476,310488,310509,310543,310617,310709,310710,310715,310739,310753,310826,310837,310848,310939,310959,310963,311018,311024,311053,311082,311090,311106,311174,311266,311303,311353,311374,311392,311405,311467,311468,311490,311496,311513,311578,311597,311598,311624,311646,311650,311658,311685,311692,311696,311708,311721,311728,311735,311741,311758,311777,311792,311849,311871,311913,311921,311941,311963,312000,312035,312086,312127,312130,312153,312311,312347,312372,312392,312406,312413,312502,312506,312523,312529,312546,312571,312581,312585,312595,312681,312706,312710,312795,312847,312918,312943,312976,313024,313040,313053,313057,313069,313123,313126,313128,313133,313145,313148,313183,313194,313209,313213,313214,313223,313229,313230,313277,313281,313289,313426,313452,313456,313486,313492,313514,313515,313520,313537,313554,313571,313612,313663,313682,313703,313771,313779,313815,313839,313847,313848,313859,313869,313952,313982,313985,314000,314041,314094,314156,314216,314222,314235,314240,314301,314316,314338,2652463,2652464,2652474,2652536,358681,358703,358749,358768,358776,358782,358800,358807,358817,358837,358839,358842,358869,358872,358918) AND `property`<'2' ORDER BY `sticky` DESC, `pubtime` DESC LIMIT 0, 10
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '169555,169593,301222,301508,301585,301678,301902,302282,302320,302359,302372,302' at line 1
Errno.: 1064