Cronologia pagina

SELECT COALESCE(SUM(contact.shares), 0) AS azioni
FROM delegate JOIN participant ON delegate.receivergiver_id = participant.id
JOIN contact ON participant.contact_id = contact.id AND contact.deleted = 0
JOIN participant AS receiver ON delegate.receiver_id = receiver.id AND receiver.deleted = 0
WHERE delegate.event_id = {{EVENT_ID}} AND delegate.deleted = 0 AND participant.deleted = 0 AND participantreceiver.registration_time <= NOW()

SELECT COALESCE(SUM(contact.shares), 0) AS azioni FROM participant
JOIN contact ON participant.contact_id = contact.id AND contact.deleted = 0
WHERE participant.event_id = {{EVENT_ID}} AND participant.registration_time <= NOW() AND participant.deleted = 0

SELECT COUNT(*) AS COUNT FROM delegate
JOIN participant ON delegate.receiver_id = participant.id
WHERE participant.event_id = {{EVENT_ID}} AND delegate.deleted = 0 AND participant.deleted = 0 AND participant.registration_time <= NOW()

SELECT COUNT(*) AS COUNT FROM participant
JOIN contact ON participant.contact_id = contact.id AND contact.deleted = 0
WHERE participant.event_id = {{EVENT_ID}} AND contact.subscribe_date <= (NOW() - INTERVAL {{MIN_DELEGATE_DAYS}} DAY) AND participant.deleted = 0
ORDER BY contact.subscribe_date

SELECT COUNT(*) AS COUNT FROM participant
WHERE event_id = {{EVENT_ID}} AND registration_time <= NOW() AND deleted = 0

SELECT COALESCE(SUM(contact.shares), 0) AS azioni FROM participant
JOIN contact ON participant.contact_id = contact.id AND contact.deleted = 0
WHERE participant.event_id = {{EVENT_ID}} AND participant.deleted = 0