File manager - Edit - /home/autoph/public_html/tasks/top nature of business.sql.tar
Back
home/autoph/public_html/connectv1/tmp/top nature of business.sql 0000644 00000001563 15025042327 0021006 0 ustar 00 SELECT snob.id,snob.name,COUNT(1) as count,snob.category_id,snob.is_parent FROM ( SELECT snob.id, IF(snob.category_id = 0,snob.id,snob.category_id) AS category_id, snob.name, snob.is_parent FROM customer c 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.category_id != 0 OR snob.is_parent = 1) GROUP BY c.id ORDER BY s.activity_date DESC ) t1 INNER JOIN source_nature_of_business snob ON t1.category_id = snob.id WHERE 1 AND snob.is_parent = 1 GROUP BY snob.id ORDER BY count DESC
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings