Database System Tips: MySQL Query Error

Time: 2013-5-24 4:18pm
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 (61,146,162,175,12701413,12701414,12701417,12701418,12701420,12701421,12701425,12701427,12701428,12701430,12701431,12701432,12701433,12701435,12701441,12701442,12701448,12701449,,,,169546,169553,169616,169658,169719,169727,169752,169753,169770,169777,169782,169783,169788,169792,169802,169803,169804,169808,169822,169823,169825,301213,301219,301223,301226,301227,301231,301274,301277,301283,301291,301294,301297,301300,301309,301321,301336,301343,301353,301356,301373,301377,301396,301402,301417,301423,301427,301432,301447,301458,301459,301463,301465,301468,301471,301473,301482,301484,301488,301493,301494,301497,301516,301517,301521,301531,301533,301543,301545,301552,301565,301572,301574,301581,301583,301589,301596,301607,301609,301612,301639,301643,301648,301660,301665,301688,301691,301703,301710,301717,301721,301732,301760,301770,301785,301794,301799,301804,301808,301819,301821,301824,301852,301853,301868,301869,301874,301889,301891,301909,301912,301935,301942,301947,302197,302206,302208,302215,302232,302234,302235,302237,302242,302255,302260,302269,302288,302295,302298,302302,302309,302315,302321,302329,302335,302348,302362,302369,302371,302385,302392,302393,302397,302399,302417,302420,302447,302449,302455,302471,302481,302492,302501,302504,302507,302515,302523,302544,302548,302560,302573,302582,302584,302594,302602,302629,302643,302644,302645,302648,302650,302652,302662,302664,302666,302668,302673,302686,302689,302690,302692,302699,302702,302705,302711,302716,302718,302723,302724,302728,302733,302738,302740,302743,302747,302770,302773,302777,302785,302792,302808,302814,302828,302841,302847,302857,302863,302867,302868,302878,302897,302898,302903,302907,302909,302915,302917,302919,302922,302924,302926,302928,302929,302931,302933,302934,302952,302953,302957,302962,302966,302968,302972,302973,302980,302986,302992,302995,302997,302999,303009,303018,303022,303028,303036,303037,303039,303040,303041,303042,303045,303048,303050,303053,303054,303056,303057,303059,303060,303061,303062,303064,303065,303068,303069,303070,303072,303073,303074,303078,303083,303085,303086,303089,303097,303102,303111,303113,303114,303123,303124,303128,303140,303141,303146,303148,303150,303153,303157,303158,303161,303167,303176,303193,303197,303200,303203,303204,303205,303206,303207,303208,303212,303226,303230,303234,303283,303290,303374,303394,303411,303465,303473,303489,303494,303526,303538,303736,303738,303740,303742,303744,303745,303750,303751,303755,303756,303759,303760,303763,303768,303773,303780,303790,303799,303804,303807,303809,303813,303815,303816,303821,303823,303824,303826,303828,303829,303837,303845,303849,303850,303851,303852,303853,303858,303867,303877,303885,303890,303891,303908,303945,303959,304001,304034,304054,304055,304061,304104,304122,304127,304130,304132,304135,304156,304169,304174,304185,304193,304197,304198,304214,304231,304327,304330,304341,304345,304353,304364,304366,304368,304376,304380,304471,304476,304481,304506,304514,304516,304524,304526,304538,304541,304614,304626,304636,304637,304660,304663,304664,304667,304719,304750,304776,304785,304796,304800,304818,304823,304825,304834,304914,304959,304975,304981,305009,305019,305020,305073,305098,305159,305191,305198,305280,305290,305294,305300,305308,305312,305362,305368,305389,305402,305403,305409,305410,305411,305413,305414,305423,305659,305667,305677,305681,305688,305724,305730,305732,305740,305742,305753,305759,305783,305789,305791,305794,305796,305797,305798,305800,305801,305805,305807,305808,305809,305810,305811,305814,305819,305821,305824,305825,305826,305827,305829,305832,305837,305839,305840,305842,305845,305850,305854,305856,305858,305862,305863,305880,305883,305884,305885,305889,305890,305894,305896,305903,305904,305905,305906,305907,305909,305911,305922,305951,305953,305956,305958,305961,305977,305985,305986,306006,306015,306021,306027,306029,306032,306034,306038,306041,306042,306043,306047,306048,306049,306050,306052,306054,306058,306059,306060,306061,306062,306063,306075,306076,306077,306092,306093,306094,306101,306102,306105,306120,306122,306131,306132,306134,306139,306154,306155,306165,306171,306172,306180,306185,306194,306200,306206,306221,306234,306238,306243,306264,306296,306316,306322,306326,306363,306373,306393,306419,306431,306439,306440,306441,306447,306449,306453,306460,306461,306464,306466,306472,306473,306474,306475,306477,306481,306484,306489,306491,306492,306493,306495,306498,306499,306500,306503,306508,306512,306520,306525,306526,306527,306535,306536,306537,306539,306561,306604,306608,306637,306640,306650,306661,306662,306663,306664,306665,306666,306667,306668,306672,306673,306674,306675,306677,306680,306684,306686,306687,306688,306689,306690,306691,306700,306705,306706,306709,306713,306715,306725,306729,306730,306734,306735,306736,306739,306752,306753,306757,306761,306779,306780,306789,306792,306795,306797,306806,306809,306811,306813,306828,306830,306851,306853,306857,306858,306874,306875,306879,306899,306902,306915,306917,306920,306922,306924,306926,306929,306932,306933,306934,306941,306946,306960,306963,306964,306969,306973,306977,306978,306980,306981,306983,306986,306987,307010,307012,307013,307025,307047,307050,307054,307055,307057,307059,307060,307063,307066,307071,307072,307074,307076,307078,307081,307083,307084,307085,307086,307092,307093,307094,307097,307098,307100,307101,307107,307113,307115,307123,307127,307140,307141,307142,307144,307145,307146,307150,307155,307161,307162,307164,307165,307168,307170,307176,307177,307178,307182,307197,307199,307206,307207,307209,307210,307215,307217,307218,307219,307221,307222,307224,307227,307234,307236,307237,307241,307242,307247,307255,307256,307260,307261,307262,307263,307265,307267,307268,307270,307276,307280,307282,307283,307291,307292,307313,307332,307334,307336,307346,307362,307366,307369,307371,307377,307378,307382,307386,307388,307390,307392,307395,307403,307404,307410,307411,307412,307414,307420,307421,307423,307425,307427,307428,307430,307431,307435,307447,307450,307453,307458,307461,307462,307463,307466,307467,307468,307469,307470,307471,307472,307473,307476,307478,307480,307482,307483,307486,307490,307495,307500,307501,307503,307505,307506,307511,307512,307514,307523,307525,307526,307528,307529,307530,307538,307558,307560,307571,307597,307598,307602,307603,307608,307609,307612,307615,307616,307619,307620,307621,307624,307626,307627,307628,307641,307642,307649,307660,307664,307667,307670,307679,307680,307682,307689,307693,307694,307699,307700,307706,307707,307709,307722,307728,307733,307745,307747,307761,307766,307770,307772,307773,307774,307776,307777,307778,307779,307784,307785,307788,307789,307790,307792,307794,307801,307802,307803,307806,307808,307809,307810,307814,307815,307818,307819,307821,307824,307826,307828,307829,307830,307831,307833,307834,307835,307838,307840,307842,307844,307848,307849,307850,307851,307852,307855,307856,307860,307861,307865,307868,307869,307870,307873,307875,307877,307879,307888,307889,307892,307895,307896,307900,307912,307913,307914,307915,307916,307917,307918,307919,307920,307922,307923,307924,307925,307928,307931,307936,307947,307948,307950,307955,307956,307959,307961,307962,307965,307969,307973,307985,307992,307995,308000,308001,308004,308005,308007,308008,308009,308015,308021,308022,308024,308028,308030,308031,308036,308038,308049,308054,308060,308064,308067,308073,308077,308083,308085,308090,308091,308093,308095,308099,308101,308102,308105,308106,308108,308109,308110,308111,308112,308113,308114,308116,308117,308131,308132,308135,308138,308142,308144,308154,308158,308160,308161,308162,308164,308170,308176,308178,308181,308185,308187,308200,308202,308205,308220,308224,308241,308243,308252,308256,308258,308259,308261,308264,308265,308268,308269,308273,308274,308281,308303,308305,308312,308313,308314,308316,308318,308320,308322,308323,308324,308325,308327,308329,308330,308333,308335,308341,308346,308347,308350,308352,308362,308369,308372,308373,308378,308385,308386,308389,308396,308397,308407,308418,308422,308427,308431,308432,308450,308484,308492,308500,308520,308526,308531,308534,308559,308562,308563,308564,308566,308567,308572,308573,308576,308579,308582,308583,308614,308622,308634,308689,308693,308711,308712,308715,308716,308717,308719,308720,308724,308741,308745,308748,308778,308781,308784,308801,308808,308814,308816,308818,308825,308826,308831,308835,308836,308843,308846,308853,308858,308862,308864,308865,308867,308868,308869,308870,308872,308875,308886,308899,308917,308919,308934,308939,308941,308943,308945,308949,308950,308952,308965,308973,308977,309002,309006,309013,309014,309015,309055,309060,309065,309067,309070,309125,309131,309133,309134,309146,309159,309184,309206,309213,309234,309236,309238,309239,309240,309241,309242,309245,309246,309247,309249,309256,309261,309265,309266,309269,309274,309275,309300,309302,309308,309309,309311,309313,309315,309318,309328,309331,309334,309335,309336,309347,309351,309358,309364,309369,309373,309382,309387,309394,309399,309418,309420,309428,309429,309432,309434,309457,309458,309471,309472,309493,309497,309501,309503,309509,309512,309521,309524,309531,309533,309535,309536,309563,309566,309568,309575,309579,309580,309583,309590,309592,309593,309599,309600,309604,309605,309610,309611,309615,309620,309625,309637,309642,309644,309646,309647,309660,309663,309664,309666,309668,309683,309689,309696,309700,309702,309708,309713,309714,309720,309724,309750,309764,309773,309790,309799,309801,309817,309821,309822,309833,309837,309839,309842,309867,309872,309904,309905,309907,309914,309916,309918,309931,309938,309940,309942,309948,309974,309977,309978,309979,309985,309989,309991,310007,310013,310024,310033,310052,310065,310069,310080,310081,310085,310090,310102,310106,310126,310132,310135,310141,310146,310147,310153,310159,310168,310174,310179,310186,310192,310210,310238,310239,310250,310255,310262,310263,310267,310268,310277,310285,310288,310294,310298,310312,310323,310355,310356,310359,310365,310371,310381,310401,310406,310420,310434,310445,310450,310456,310484,310488,310492,310495,310496,310503,310508,310532,310537,310555,310579,310600,310601,310610,310631,310638,310641,310644,310647,310650,310667,310700,310712,310715,310717,310728,310737,310754,310761,310767,310778,310782,310783,310797,310800,310802,310803,310805,310812,310825,310846,310850,310851,310861,310871,310876,310877,310889,310891,310925,310927,310929,310930,310936,310940,310956,310972,310988,310990,311004,311005,311019,311029,311047,311093,311095,311118,311125,311152,311167,311176,311178,311180,311189,311196,311197,311209,311220,311224,311225,311235,311254,311255,311256,311258,311261,311270,311274,311281,311283,311287,311315,311318,311334,311339,311340,311351,311365,311370,311377,311404,311424,311429,311436,311448,311456,311460,311461,311465,311471,311488,311492,311493,311503,311504,311516,311517,311522,311527,311537,311539,311541,311570,311572,311577,311583,311587,311589,311596,311597,311598,311604,311605,311618,311619,311638,311648,311654,311656,311660,311662,311665,311666,311667,311668,311672,311673,311677,311678,311680,311682,311683,311684,311685,311687,311689,311690,311693,311694,311696,311699,311702,311709,311720,311723,311735,311738,311739,311740,311748,311750,311757,311759,311763,311766,311769,311772,311785,311787,311788,311790,311794,311805,311806,311807,311817,311821,311822,311824,311827,311843,311845,311855,311858,311860,311867,311879,311884,311888,311890,311901,311906,311910,311917,311924,311931,311937,311938,311944,311948,311949,311952,311953,311959,311960,311966,311967,311969,311976,311983,311984,311991,311992,311994,311995,311999,312001,312007,312011,312012,312016,312017,312020,312024,312026,312028,312034,312036,312041,312042,312043,312052,312063,312064,312078,312085,312086,312093,312094,312095,312101,312114,312135,312146,312150,312156,312158,312163,312164,312169,312180,312182,312185,312199,312205,312213,312221,312236,312239,312243,312250,312253,312257,312263,312266,312268,312278,312280,312297,312302,312313,312319,312323,312324,312325,312326,312328,312329,312330,312333,312337,312339,312347,312348,312355,312360,312361,312363,312364,312366,312369,312370,312375,312380,312381,312401,312414,312420,312422,312424,312430,312437,312440,312451,312455,312456,312460,312465,312470,312472,312483,312485,312487,312499,312500,312505,312518,312521,312522,312523,312529,312532,312547,312556,312557,312567,312568,312573,312575,312581,312586,312587,312589,312592,312599,312600,312626,312627,312633,312646,312652,312654,312655,312658,312659,312662,312663,312666,312668,312675,312678,312682,312683,312694,312696,312699,312701,312707,312708,312711,312713,312723,312724,312728,312732,312734,312743,312745,312753,312757,312767,312779,312790,312797,312814,312830,312831,312832,312840,312844,312847,312848,312854,312861,312865,312881,312903,312914,312917,312936,312939,312942,312945,312946,312953,312954,312959,312960,312961,312970,312975,312980,312987,312989,312990,312998,312999,313006,313008,313009,313012,313028,313032,313035,313037,313045,313046,313047,313050,313054,313055,313073,313080,313082,313084,313086,313094,313098,313103,313108,313114,313116,313117,313122,313129,313131,313134,313138,313142,313155,313163,313165,313170,313190,313196,313204,313205,313207,313216,313217,313219,313225,313227,313238,313242,313252,313256,313266,313270,313272,313273,313278,313297,313303,313306,313308,313312,313329,313343,313345,313355,313359,313360,313364,313368,313371,313372,313374,313376,313377,313380,313386,313389,313390,313393,313398,313412,313419,313423,313424,313433,313436,313446,313447,313450,313456,313459,313462,313465,313470,313471,313472,313476,313479,313486,313489,313491,313493,313495,313496,313498,313502,313507,313510,313515,313520,313522,313540,313547,313552,313556,313561,313563,313564,313572,313576,313583,313590,313591,313593,313596,313597,313599,313613,313619,313625,313626,313630,313639,313646,313649,313657,313661,313662,313668,313670,313675,313688,313689,313691,313698,313704,313706,313710,313713,313715,313717,313719,313720,313725,313728,313732,313745,313754,313759,313762,313763,313765,313777,313778,313781,313788,313798,313800,313802,313803,313812,313819,313821,313824,313826,313832,313836,313841,313843,313845,313853,313858,313860,313861,313863,313874,313877,313887,313898,313900,313903,313909,313912,313915,313917,313927,313944,313952,313955,313965,313966,313976,313980,313986,313993,313996,314005,314012,314013,314038,314060,314064,314065,314072,314075,314078,314089,314091,314099,314110,314111,314112,314114,314117,314134,314141,314144,314151,314156,314163,314165,314169,314182,314184,314186,314187,314194,314198,314202,314206,314216,314224,314227,314236,314242,314248,314258,314259,314266,314276,314280,314290,314291,314299,314301,314308,314316,314317,314322,314323,314330,314332,314340,314343,2652473,2652486,2652492,2652515,2652524,2652527,2652532,2652534,2652538,358679,358686,358694,358698,358699,358702,358706,358707,358708,358713,358725,358726,358731,358740,358748,358750,358752,358755,358757,358761,358763,358773,358780,358788,358790,358791,358795,358798,358800,358807,358810,358811,358813,358822,358823,358830,358840,358843,358869,358871,358873,358886,358887,358892,358893,358897,358900,358903,358907,358911,358917) 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 ',,169546,169553,169616,169658,169719,169727,169752,169753,169770,169777,169782,1' at line 1
Errno.: 1064