asked on
SELECT
CURRENT_TIMESTAMP AS CURDATE,
ADDDATE(
CS.timestamp_SurveyDateCreated,
INTERVAL ST.tinyint_ResendInterval DAY
) AS OFFDATE,
C.*,
SL.*,
SP.*
FROM
21_consumersurveys CS
LEFT JOIN (
19_consumers C,
25_serviceleads SL,
10_serviceprospects SP,
20_surveytypes ST
) ON (
CS.bigint_ConsumerID = C.bigint_ConsumerID AND
CS.bigint_LeadID = SL.bigint_LeadID AND
CS.bigint_ReferenceID = SP.bigint_ProspectID AND
CS.bigint_SurveyType = ST.bigint_SurveyID
)
WHERE
OFFDATE <= CURDATE AND
CS.tinyint_SurveyStatus = 0;