MySQL Query : SELECT COUNT(*) AS num FROM `010bjxzl`.`soupu_house` WHERE status=99 and cityid in () and id in(189,140,141,143,144,146,148,51,149,150,165,194,151,38,153,155,157,158,48,49,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,200,53,171,83,266,267,84,300,202,52,58,268,174,231,37,85,43,301,59,86,254,88,203,269,176,89,205,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,62,44,99,207,100,39,101,234,296,103,192,104,105,287,106,188,247,109,248,108,68,69,249,110,40,46,111,112,113,297,114,115,291,116,117,70,223,288,289,118,119,120,121,122,123,124,125,127,128,129,130,132,131,133,45,42,179,236,138,197,208,135,237,137,184,227,260,63,276,210,243,211,180,181,261,277,167,216,240,244,218,219,182,241,64,65,279,220,212,284,285,280,286,281,259,66,262,213,67,187,246,221,309,310,311,312,313,315,316,318,319,320,321,322,323,324,325,326,329,330,331,332,333,334,335,336,337,338,339,340,341,342,344,346,348,350,351,352,353,356,359,360,361,363,364,365,366,367,368,369,373,374,375,376,377,378,379,380,383,384,385,386,387,388,389,390,391,392,394,395,396,398,399,400,401,404,405,406,408,409,410,411,412,413,415,416,402,403,418,420,422,423,424,425,427,428,429,430,431,433,617,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,453,454,455,456,457,458,459,460,461,463,464,465,466,469,467,468,471,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,500,501,502,508,509,510,511,513,514,519,515,516,517,518,503,504,505,506,507,520,521,522,524,525,526,527,529,530,533,535,536,537,538,539,540,541,543,544,545,546,548,549,550,551,553,554,555,560,561,562,563,565,566,569,571,573,574,575,578,579,580,581,582,585,586,587,589,590,591,593,594,595,596,602,603,604,605,607,608,609,612,606,613,614,615,616,597,618,619,620,621,622,623,624,626,627,628,629,632,633,634,635,20,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(189,140,141,143,144,146,148,51,149,150,165,194,151,38,153,155,157,15' 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(189,140,141,143,144,146,148,51,149,150,165,194,151,38,153,155,157,15' at line 1
Need Help?