SELECT SQL_CALC_FOUND_ROWS customers.CustID, customerjobinfo.ForSaleStatus, customerjobinfo.WebLeadImageID, jobspecs.PlanNameBuilt, jobspecs.Bedrooms, jobspecs.Bathrooms,
customers.SubdivisionID, customers.JobSiteCity, jobspecs.FirstFlrSqFt + IFNULL(jobspecs.SecFlrSqFt,0) + IFNULL(jobspecs.BsmtSqFtFin,0) as sqft, subdivisionquickinfo.SubDivisionName FROM customers
LEFT JOIN jobspecs ON customers.CustID = jobspecs.CustID
LEFT JOIN customerjobinfo ON customers.CustID = customerjobinfo.CustID
LEFT JOIN subdivisionquickinfo ON customers.SubdivisionID = subdivisionquickinfo.SubdivisionsID
WHERE customers.JobTypeCategoryID = 6 AND customerjobinfo.ShowModelHomeWeb=-1 LIMIT 100
Unknown column 'jobspecs.PlanNameBuilt' in 'field list'