想问下terms和range以及or的并列使用,例如:
SELECT idarchive, value, name, date1 as startDate FROM archive_numeric_2019_03
WHERE idsite = ?
AND date1 = ?
AND date2 = ?
AND period = ?
AND ( (((name IN ('done','done.VisitsSummary')) AND (value IN (1,3))))
OR name = 'nb_visits'
OR name = 'nb_visits_converted')
AND ts_archived >= ?
AND ts_archived <= ?
SELECT idarchive, value, name, date1 as startDate FROM archive_numeric_2019_03
WHERE idsite = ?
AND date1 = ?
AND date2 = ?
AND period = ?
AND ( (((name IN ('done','done.VisitsSummary')) AND (value IN (1,3))))
OR name = 'nb_visits'
OR name = 'nb_visits_converted')
AND ts_archived >= ?
AND ts_archived <= ?
0 个回复