SELECT SQL_CALC_FOUND_ROWS customers.CustID, teamplans.PlanName FROM customers
LEFT JOIN jobspecs ON jobspecs.CustID = customers.CustID
LEFT JOIN teamplans ON teamplans.TeamPlansID = jobspecs.PlanID
WHERE customers.JobTypeCategoryID = 6 and customers.CustID = LIMIT 100
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 'LIMIT 100' at line 4