MySQL Query : SELECT COUNT(*) AS num FROM `010bjxzl`.`soupu_house` WHERE status=99 and cityid in () and id in(302,189,139,142,161,162,143,191,163,149,166,193,194,151,153,155,158,48,49,71,264,50,229,72,228,168,298,73,74,75,76,77,29,169,299,78,79,80,81,57,199,173,170,265,164,200,266,83,267,84,172,300,230,174,232,43,59,253,254,87,88,233,203,175,269,176,255,204,205,256,270,224,225,226,273,89,90,94,91,190,292,96,93,95,196,177,178,206,295,98,62,274,99,235,100,234,101,102,103,287,106,188,222,247,109,248,108,68,69,249,110,40,46,111,112,113,114,115,291,116,70,251,223,117,289,118,119,120,41,122,123,124,125,126,129,130,132,133,127,179,138,195,236,275,197,134,208,135,237,136,238,137,184,227,260,63,276,185,210,211,243,180,214,181,261,215,277,167,239,240,244,217,218,278,182,283,245,279,220,183,186,212,284,285,281,286,66,262,213,242,246,221,307,308,309,310,312,313,314,315,317,318,321,322,324,325,326,330,332,335,336,337,339,341,342,344,345,347,348,352,353,354,355,356,357,358,359,361,363,364,365,368,369,375,378,379,380,383,384,386,387,390,394,395,396,398,401,405,406,407,408,409,410,412,413,415,416,418,420,422,424,425,429,430,431,433,435,436,437,438,440,442,443,444,445,446,447,449,451,453,454,455,456,458,459,460,461,463,466,469,473,474,476,477,479,482,483,484,486,487,488,491,492,493,494,495,496,500,502,510,512,518,504,505,507,522,523,525,526,527,530,534,536,457,538,540,543,545,546,551,558,560,562,563,564,568,570,571,572,573,575,577,578,579,589,594,604,426,608,610,613,622,625,627,628,629,635,640) 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,189,139,142,161,162,143,191,163,149,166,193,194,151,153,155,158,' 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,189,139,142,161,162,143,191,163,149,166,193,194,151,153,155,158,' at line 1
Need Help?