You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's_21.09.2017yh' AND DEALS.DealStatus = 'Active' GROUP BY(DEALS.DealNumericID)' at line 47<br/><br/>SELECT DEALS.pkDealID,DEALS.DealName,DEALS.fkCenterID,DEALS.DealNumericID,DEALS.fkPracticeAreaID,DEALS.fkIndustryID,GROUP_CONCAT(DEALS.fkIndustryID) AS INDUSTRIES,DEALS.fkValueID,DEALS.fkAdviseID,GROUP_CONCAT(DEALS.fkAdviseID) AS ADVISES,DEALS.DealDescription,DEALS.DealRemarks,DEALS.fkJurisdictionID1,DEALS.DealLogo,DEALS.fkJurisdictionID2,DEALS.DealDate,DEALS.DealIsTombstone,DEALS.fkClassificationSubLevel,DEALS.fkLawFirmID,DealCreatedBy,DealDateAdded,DealDate,DealDateModified,LAW.LawFirmName,FINANCIAL.pkCenterID,FINANCIAL.CenterName,FINANCIAL.fkCurrencyID,DEALS.fkLawyerId,LAWYER.pkLawyerId,LAWYER.LawyerName,LAW.packageID,LAW.packageEndDate1,LAW.packageEndDate2,LAW.packageEndDate3,LAW.packageEndDate4,LAW.packageEndDate5,CLASSIFICATION.pkClassificationID,GROUP_CONCAT(CLASSIFICATION.pkClassificationID) AS CLASSIFICATIONS,CLASSIFICATION.fkPracticeAreaID,CLASSIFICATION.ClassificationName,ADVISE.AdviseName,PRACTICE.pkPracticeAreaID,PRACTICE.PracticeAreaName,VALUE.fkPracticeAreaID,VALUE.ValueStartRange,VALUE.ValueEndRange,INDUSTRY.IndustryName,(SELECT JurisdictionName1 FROM jurisdictions WHERE fkClassificationID = CLASSIFICATION.pkClassificationID limit 0,1) AS J1 ,(SELECT JurisdictionName2 FROM jurisdictions WHERE fkClassificationID = CLASSIFICATION.pkClassificationID limit 0,1) AS J2  FROM deals AS DEALS 
				 LEFT JOIN practice_area AS PRACTICE 
				 ON 
				 DEALS.fkPracticeAreaID = PRACTICE.pkPracticeAreaID 
				 AND 
				 DEALS.DealStatus = 'Active' 
				 AND
				 PRACTICE.PracticeAreaStatus = 'ACTIVE' 
				 LEFT JOIN 
				 lawyers AS LAWYER 
                                ON 
                                DEALS.fkLawyerID  = LAWYER.pkLawyerId  
                                AND LAWYER.LawyerStatus='Active' 
                                LEFT JOIN
                                law_firms AS LAW 
				 ON 
				 DEALS.fkLawFirmID = LAW.pkLawFirmID 
				 AND LAW.LawFirmStatus='Active' 
				 LEFT JOIN 
				 centers AS FINANCIAL 
				 ON
				 FINANCIAL.pkCenterID = DEALS.fkCenterID 
				 AND 
				 FINANCIAL.CenterStatus = 'Active' 
				 LEFT JOIN 
				classifications AS CLASSIFICATION 
				 ON
				 CLASSIFICATION.pkClassificationID = DEALS.fkClassificationID 
				 AND
				 CLASSIFICATION.ClassificationStatus = 'Active' 
				 LEFT JOIN
				advises AS ADVISE 
				 ON
				 ADVISE.pkAdviseID = DEALS.fkAdviseID 
				 LEFT JOIN 
				 value AS VALUE 
				 ON
				 VALUE.pkValueID = DEALS.fkValueID 
				 AND
				 VALUE.ValueStatus = 'Active' 
				 LEFT JOIN 
				 industries AS INDUSTRY
				 ON  
				 INDUSTRY.pkIndustryID = DEALS.fkIndustryID 
				 AND 
				 INDUSTRY.IndustryStatus = 'Active'
				  WHERE  1 AND LAW.packageID!=''  AND DEALS.DealNumericID = 'Macfarlane's_21.09.2017yh' AND DEALS.DealStatus = 'Active' GROUP BY(DEALS.DealNumericID)