B - Production Support » KFH Support

Update by Hafiz, Oct 23, 2015 03:48 PM:-

Hi Puan Rozita

We found sql at debug mode. Maybe this can help to solve the problem

Schema : joomla

SELECT DISTINCT `sales_referral`.`fabrik_internal_id` AS `sales_referral___fabrik_internal_id`, `sales_referral`.`fabrik_internal_id` AS `sales_referral___fabrik_internal_id_raw`, `sales_referral`.`time_date` AS `sales_referral___time_date`, `sales_referral`.`time_date` AS `sales_referral___time_date_raw`, `sales_referral`.`products` AS `sales_referral___products_raw`, `sales_referral_products`.`products` AS `sales_referral___products`, `sales_referral`.`Reference` AS `sales_referral___Reference_raw`, `sales_referral_products_reference`.`name` AS `sales_referral___Reference`, `sales_referral`.`reference_name` AS `sales_referral___reference_name`, `sales_referral`.`reference_name` AS `sales_referral___reference_name_raw`, `sales_referral`.`reference_email` AS `sales_referral___reference_email`, `sales_referral`.`reference_email` AS `sales_referral___reference_email_raw`, `sales_referral`.`reference_email2` AS `sales_referral___reference_email2`, `sales_referral`.`reference_email2` AS `sales_referral___reference_email2_raw`, `sales_referral`.`StaffName` AS `sales_referral___StaffName_raw`, `jos_contact_details`.`name` AS `sales_referral___StaffName`, `sales_referral`.`StaffEmail` AS `sales_referral___StaffEmail`, `sales_referral`.`StaffEmail` AS `sales_referral___StaffEmail_raw`, `sales_referral`.`StaffDepartment` AS `sales_referral___StaffDepartment`, `sales_referral`.`StaffDepartment` AS `sales_referral___StaffDepartment_raw`, `sales_referral`.`StaffId` AS `sales_referral___StaffId`, `sales_referral`.`StaffId` AS `sales_referral___StaffId_raw`, `sales_referral`.`CustomerName` AS `sales_referral___CustomerName`, `sales_referral`.`CustomerName` AS `sales_referral___CustomerName_raw`, `sales_referral`.`CustomerMobilePhone` AS `sales_referral___CustomerMobilePhone`, `sales_referral`.`CustomerMobilePhone` AS `sales_referral___CustomerMobilePhone_raw`, `sales_referral`.`CustomerIc` AS `sales_referral___CustomerIc`, `sales_referral`.`CustomerIc` AS `sales_referral___CustomerIc_raw`, `sales_referral`.`CustomerFixedLine` AS `sales_referral___CustomerFixedLine`, `sales_referral`.`CustomerFixedLine` AS `sales_referral___CustomerFixedLine_raw`, `sales_referral`.`CustomerEmail` AS `sales_referral___CustomerEmail`, `sales_referral`.`CustomerEmail` AS `sales_referral___CustomerEmail_raw`, `sales_referral`.`Comments` AS `sales_referral___Comments`, `sales_referral`.`Comments` AS `sales_referral___Comments_raw`, `sales_referral`.`text` AS `sales_referral___text`, `sales_referral`.`text` AS `sales_referral___text_raw`, `sales_referral`.`fabrik_internal_id` AS slug , `sales_referral`.`fabrik_internal_id` AS `__pk_val` FROM `sales_referral` LEFT JOIN `jos_contact_details` AS `jos_contact_details` ON `jos_contact_details`.`id` = `sales_referral`.`StaffName` LEFT JOIN `sales_referral_products` AS `sales_referral_products` ON `sales_referral_products`.`fabrik_internal_id` = `sales_referral`.`products` LEFT JOIN `sales_referral_products_reference` AS `sales_referral_products_reference` ON `sales_referral_products_reference`.`reference` = `sales_referral`.`Reference`

Update by Rozita in SCP, Oct 29, 2015 10:13 AM:-

Penril, 
Yes using the sql script extracted by Hafiz we managed to resolve the issue for users. 
You may close this case.

Issue closed in SCP.