Can you please help me out to write the Laravel Raw Query for below Mysql query.
SELECT
SUM(IF(d.business_email_template_10_open = "Yes", 1,0)) AS `business_email_template_10_open`,
SUM(IF(d.business_email_template_11_open = "Yes", 1,0)) AS `business_email_template_11_open`
FROM dummy_email_track d
join recommend_email_send_by_cron r on d.user_id = r.user_id
join user_form_submission u on r.user_id = u.id'
where d.business_id = $businessId
from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2HKKIth
via IFTTT
Aucun commentaire:
Enregistrer un commentaire