|
|
Query 'SELECT SQL_CACHE count(DISTINCT(hspln.HsPlnId)) as Total FROM hspln LEFT JOIN ( hsplnstyles ) ON (hsplnstyles.HsPlnId = hspln.HsPlnId ) LEFT JOIN ( users ) ON (users.usrId = hspln.HsCustomer ) LEFT JOIN ( hsplntobuilders ) ON (hsplntobuilders.HsPlnId = hspln.HsPlnId ) LEFT JOIN ( tblbuilder ) ON (tblbuilder.BuilderID = hspln.HsPlnBldrKey ) LEFT JOIN ( tblbuilder as PlanBuilder ) ON (PlanBuilder.BuilderID = hspln.HsBuilderID )
LEFT JOIN ( tblbuilder as PlanDesigner ) ON (PlanDesigner.BuilderID = hspln.HsDesigner ) LEFT JOIN ( hsplntypes ) ON (hsplntypes.HsPlnTypeId = hspln.HsPlnTypeKey ) WHERE HsVisible = 1 AND ( HsShowOnMainSite = 1 OR ( tblbuilder.BldrType = 2 AND HsIsSellPlan =1 ) ) AND HsPlnTypeKey = 1 ' failed with error message: "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'count(DISTINCT(hspln.HsPlnId)) as Total FROM hspln LEFT JOIN ( hsplnstyles ) ON' at line 1" | | |