Error SQL |
SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) FROM `ds_goods` `g` LEFT JOIN `ds_goodscommon` `mon` ON `mon`.`goods_commonid`=`g`.`goods_commonid` WHERE `g`.`goods_state` = 1 AND `g`.`no_external_display` = 0 AND `g`.`gc_id_9` = 366 AND `g`.`daddress_id` IN (90,91,93,95,96,123,124,125,127,128,142,147,154,156,161,164,165,169,170,171,172,175,179,192,199,201,202,203,205,208,210,211,212,218,220,221,223,227,228,229,230,234,235,236,239,242,247,249,250,253,256,258,259,260,261,262,263,264,265,266,271,274,275,284,291,292,293,294,295,296,300,301,303,306,309,311,312,315,316,317,319,321,326,332,333,335,337,338,342,343,348,350,352,353,354,357,361,368,369,370,371,372,373,374,375,376,377,378,379,392,393,394,404,417,427,428,431,432,436,441,443,444,446,454,466,467,468,472,515,519,532,536,538,544,545,548,549,550,551,552,554,565,570,575,582,583,584,586,589,598,599,602,603,606,613,614,618,619,627,628,630,632,633,634,636,640,642,643,646,649,654,659,663,664,665,668,676,678,684,685,686,689,692,694,697,698,699,700,701,705,709,711,712,715,717,721,729,731,734,735,736,737,741,742,743,745,747,749,753,755,758,761,762,770,771,772,773,774,782,783,787,788,789,790,791,792,795,796,797,798,802,803,805,806,807,811,812,814,816,817,818,819,820,821,822,823,826,827,828,829,830,833,838,841,842,843,844,845,847,855,856,858,863,866,872,873,874,888,893,896,899,900,904,907,911,912,913,914,915,916,917,920,928,929,933,935,936,937,938,939,940,941,943,948,949,950,951,957,958,963,964,965,971,972,975,976,977,981,982,983,984,985,986,987,988,989,990,997,998,999,1000,1001,1002,1003,1004,1009,1010,1011,1012,1013,1014,1015,1016,1017,1020,1021,1027,1040,1041,1048,1049,1050,1052,1053,1056,1057,1059,1060,1065,1066,1069,1070,1071,1072,1073,1104,1105,1110,1112,1116,1118,1123,1124,1125,1126,1129,1139,1145,1147,1185,1198,1203,1209,1214,1215,1217,1220,1221,1226,1230,1235,1242,1243,1244,1245,1250,1260,1269,1274,1276,1278,1279,1280,1288,1292,1311,1312,1316,1318,1320,1321,1325,1327,1335,1344) AND `g`.`deleted` = 0 GROUP BY `g`.`goods_id` ) `_group_count_` LIMIT 1 |