File manager - Edit - /home/autoph/public_html/connectv1/tmp/top nature of business data.sql
Back
SELECT c.id, IF(c.type = 1,CONCAT(c.last_name,', ',c.first_name,' ',c.middle_name),c.corporation_name) as customer, c.type as customer_type, cc.mobile_phone_1 as mobile, cc.email_1 as email, sc.code as company, sd.code as dealer, s.activity_date as date FROM customer c INNER JOIN customer_contact cc ON c.id = cc.customer_id INNER JOIN vehicle v ON c.id = v.customer_record_id INNER JOIN sales s ON v.id = s.vehicle_id LEFT OUTER JOIN source_nature_of_business snob ON c.nature_of_business_id = snob.id LEFT OUTER JOIN source_company_dealer scd ON v.company_dealer_id = scd.id LEFT OUTER JOIN source_company sc ON scd.company_id = sc.id LEFT OUTER JOIN source_dealer sd ON scd.dealer_id = sd.id WHERE 1 /*fix where statement*/ AND s.activity_date != '' AND snob.id in (9) GROUP BY c.id ORDER BY customer ASC
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings