» Витрина

SELECT s.id, s.client_id, s.product, s.domain, s.msg_sent, TO_DAYS( DATE_ADD(activation_date, INTERVAL 1 YEAR ) ) - TO_DAYS( NOW( ) ) AS period, DATE_ADD(activation_date, INTERVAL 1 YEAR ) AS endLicense, m.memberName, m.emailAddress, g.groupName AS productName FROM crm_sales s INNER JOIN smf_members m ON s.client_id = m.ID_MEMBER INNER JOIN smf_membergroups g ON s.product = g.ID_GROUP HAVING period BETWEEN 0 AND 30

SELECT s.id, s.client_id, s.product, s.domain, s.msg_sent, DATE_ADD(activation_date, INTERVAL 1 YEAR ) AS endLicense, m.memberName, m.emailAddress, g.groupName AS productName FROM crm_sales s INNER JOIN smf_members m ON s.client_id = m.ID_MEMBER INNER JOIN smf_membergroups g ON s.product = g.ID_GROUP WHERE s.token IN ('new','active') AND s.msg_sent != 4 HAVING endLicense <= NOW()

SELECT client_id, product FROM crm_sales WHERE token IN ('expired') GROUP BY client_id

SELECT SQL_CACHE * FROM crm_sales WHERE client_id='144' AND token IN ('new','active') HAVING DATE_ADD(activation_date, INTERVAL 1 YEAR ) > NOW() LIMIT 0, 1

SELECT SQL_CACHE * FROM smf_members WHERE ID_MEMBER='144' LIMIT 0, 1

SELECT SQL_CACHE * FROM crm_sales WHERE client_id='266' AND token IN ('new','active') HAVING DATE_ADD(activation_date, INTERVAL 1 YEAR ) > NOW() LIMIT 0, 1

SELECT SQL_CACHE * FROM smf_members WHERE ID_MEMBER='266' LIMIT 0, 1

SELECT SQL_CACHE * FROM crm_sales WHERE client_id='285' AND token IN ('new','active') HAVING DATE_ADD(activation_date, INTERVAL 1 YEAR ) > NOW() LIMIT 0, 1

SELECT SQL_CACHE * FROM crm_sales WHERE client_id='448' AND token IN ('new','active') HAVING DATE_ADD(activation_date, INTERVAL 1 YEAR ) > NOW() LIMIT 0, 1

SELECT SQL_CACHE * FROM smf_members WHERE ID_MEMBER='448' LIMIT 0, 1

SELECT SQL_CACHE * FROM crm_sales WHERE client_id='519' AND token IN ('new','active') HAVING DATE_ADD(activation_date, INTERVAL 1 YEAR ) > NOW() LIMIT 0, 1

SELECT SQL_CACHE * FROM smf_members WHERE ID_MEMBER='519' LIMIT 0, 1

SELECT SQL_CACHE ID_GROUP,groupName FROM smf_membergroups WHERE ID_GROUP IN (9)

SELECT SQL_CACHE SQL_CALC_FOUND_ROWS * FROM crm_showcase WHERE token IN ('new', 'active') ORDER BY datetime DESC LIMIT 0,10

SELECT FOUND_ROWS()

SELECT SQL_CACHE * FROM crm_showcase WHERE token IN ('new', 'active') ORDER BY 1 LIMIT 0,3