MySQL Query : SELECT COUNT(*) AS num FROM `010bjxzl`.`soupu_house` WHERE status=99 and cityid in () and id in(302,139,189,140,141,142,161,159,162,143,191,144,145,163,146,147,148,164,51,149,150,165,166,193,194,151,38,152,153,154,155,156,157,158,48,49,305,71,264,50,229,72,228,168,298,73,74,75,76,77,29,169,299,78,79,55,80,31,81,56,57,238,54,199,170,173,265,53,200,171,83,266,267,84,172,300,202,52,230,58,268,174,231,37,232,85,43,301,59,86,253,254,87,88,233,203,175,269,176,89,255,204,205,256,270,271,272,224,225,226,273,90,94,290,91,92,190,292,47,96,93,97,95,294,195,196,177,178,206,295,98,61,62,44,274,99,207,257,100,235,39,101,234,102,296,103,192,104,258,105,282,106,287,188,107,222,109,247,248,108,68,69,249,110,40,46,111,112,113,297,114,115,291,116,70,117,251,223,288,289,118,119,120,121,41,198,122,123,124,125,126,127,128,129,130,132,131,133,45,42,179,138,236,275,197,134,208,135,237,136,137,184,227,260,63,276,185,210,243,211,214,180,181,261,215,277,167,239,216,240,244,217,218,219,278,182,241,283,64,245,65,279,220,183,186,212,284,285,280,286,281,259,66,262,213,67,242,187,246,221,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,372,373,374,375,376,377,378,379,380,383,384,385,386,387,388,389,390,391,392,394,395,396,397,398,399,400,401,404,405,406,407,408,409,410,411,412,413,414,415,416,417,402,403,418,420,422,423,424,425,427,428,429,430,431,432,433,617,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,470,469,467,468,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,508,509,510,511,513,512,514,519,515,516,517,518,503,504,505,506,507,520,521,522,523,524,525,526,527,528,529,530,533,534,535,536,537,538,539,540,541,543,544,545,546,547,548,549,550,551,553,554,552,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,584,585,586,587,588,589,590,591,592,593,594,595,596,598,600,602,603,604,605,607,426,608,609,610,612,606,613,614,615,616,597,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,638,20,640,641) LIMIT 1
MySQL 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 ') and id in(302,139,189,140,141,142,161,159,162,143,191,144,145,163,146,147,148,' at line 1
MySQL Errno : 1064
Message : 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 ') and id in(302,139,189,140,141,142,161,159,162,143,191,144,145,163,146,147,148,' at line 1
Need Help?