愛鄰出品
1064 - 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 n.id = p.id AND p.id = pd.id AND pd.langStatus = 1 AND '2021-02-26' BETWEE' at line 1

SELECT COUNT(*) AS total FROM cm_node AS n, cm_node_to_node AS ntn ,cm_product AS p ,cm_product_desc AS pd WHERE pd.langId = 4 AND n.id = ntn.nodeId AND n.status = 1 AND n.type = 2 AND ntn.nodeFolderId IN() AND n.id = p.id AND p.id = pd.id AND pd.langStatus = 1 AND '2021-02-26' BETWEEN p.startDate AND p.endDate ORDER BY n.sort ASC, p.startDate DESC, n.id DESC

[TEP STOP]