mardi 20 mars 2018

Covert MySql query to Laravel

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