SELECT SQL_CALC_FOUND_ROWS customers.CustID, jobspecs.PlanNameBuilt, customers.JobSiteCity, subdivisionquickinfo.SubDivisionName FROM customers
LEFT JOIN jobspecs ON jobspecs.CustID = customers.CustID
LEFT JOIN customerjobinfo ON customerjobinfo.CustID = customers.CustID
LEFT JOIN subdivisionquickinfo ON subdivisionquickinfo.SubdivisionsID = customers.SubdivisionID
WHERE customers.JobTypeCategoryID = 6 and customerjobinfo.ShowModelHomeWeb=-1 LIMIT 100
Unknown column 'jobspecs.PlanNameBuilt' in 'field list'