MySQL Query : SELECT COUNT(*) AS num FROM `dgmpscn`.`v9_zb` WHERE `status` = '99' AND `mianji` = '9' AND `xmlx` = '29018' AND `yusuan` = '1' AND `zb` = '2' AND `addrid` IN (1_40,37,567,575,574,573,572,571,570,569,568,576,53,848,859,860,861,862,863,864,865,866,858,857,849,850,851,852,853,854,855,856,867,52,830,831,832,833,834,835,836,837,838,839,840,841,842,843,844,845,846,847,51,814,815,816,817,818,819,820,821,822,823,824,825,826,827,828,829,50,797,798,799,800,801,802,803,804,805,806,807,808,809,810,811,812,813,49,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,48,758,759,760,761,762,763,764,765,766,767,768,769,770,771,772,773,774,775,776,777,778,779,47,743,744,745,746,747,748,749,750,751,752,753,754,755,756,757,46,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,742,45,702,703,704,705,706,707,708,709,710,711,712,713,714,44,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,691,692,693,694,695,696,697,698,699,700,701,43,663,664,665,666,667,668,669,670,671,672,42,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,41,599,600,601,602,603,604,605,606,607,608,609,610,611,612,613,614,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,40,591,592,593,594,595,596,597,598,39,584,585,586,587,588,589,590,38,577,578,579,580,581,582,583,54,868,869,870,871,872,873,874,875,876,877,878,879,880,881,882) and `catid`='97' AND `cityid` IN (0,289) LIMIT 1
MySQL Error : Unknown column '1_40' in 'where clause'
MySQL Errno : 1054
Message : Unknown column '1_40' in 'where clause'
Need Help?