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` = 480 AND `g`.`daddress_id` IN (94,97,99,100,101,102,103,107,108,112,113,114,115,116,117,119,121,122,129,140,141,143,155,157,162,176,187,200,225,226,233,241,251,257,267,278,280,281,283,285,286,287,288,289,290,297,304,308,310,314,318,320,325,327,328,329,330,336,340,347,355,356,359,360,362,363,364,365,366,367,380,381,382,383,384,385,396,397,402,406,407,410,411,412,413,416,418,419,420,421,423,424,426,429,433,437,438,439,440,442,445,448,450,456,458,459,460,461,462,464,465,471,474,475,476,478,479,481,484,485,489,490,491,493,495,499,500,503,504,505,507,508,509,510,511,512,514,518,522,524,528,529,534,535,539,540,541,542,543,553,555,556,557,559,561,562,563,564,566,567,571,572,576,587,588,593,596,597,600,604,605,608,609,610,611,623,624,625,626,635,639,641,647,650,651,653,656,660,662,669,670,671,672,673,674,675,679,680,683,688,690,691,693,706,708,713,716,718,722,723,724,725,727,728,733,738,748,750,752,754,756,757,760,763,764,766,767,768,769,775,776,777,778,779,780,781,793,794,804,808,810,831,836,850,851,857,859,860,861,865,867,871,879,880,881,884,886,887,889,891,894,895,918,924,925,926,927,944,945,952,953,954,961,969,970,973,974,1029,1030,1031,1032,1033,1034,1035,1036,1037,1038,1042,1043,1044,1045,1046,1047,1058,1062,1064,1074,1075,1076,1077,1078,1082,1083,1084,1085,1087,1088,1089,1094,1095,1097,1098,1099,1100,1101,1102,1103,1106,1113,1115,1119,1120,1122,1130,1131,1132,1134,1135,1138,1142,1144,1148,1149,1150,1152,1153,1158,1159,1160,1161,1163,1164,1165,1166,1167,1168,1178,1179,1180,1186,1187,1188,1197,1200,1202,1208,1210,1213,1218,1219,1224,1225,1228,1229,1231,1236,1237,1238,1240,1251,1252,1253,1254,1255,1257,1259,1264,1265,1266,1267,1268,1270,1271,1272,1275,1281,1282,1284,1286,1287,1290,1291,1293,1294,1297,1298,1299,1300,1301,1302,1303,1306,1309,1317,1319,1324,1328,1339,1340,1349,1350) AND `g`.`deleted` = 0 GROUP BY `g`.`goods_id` ) `_group_count_` LIMIT 1 |