SELECT SQL_CALC_FOUND_ROWS customers.CustID, customerjobinfo.WebLeadImageID, customerjobinfo.ForSalePrice,customerjobinfo.ShowForSalePrice,customerjobinfo.ShowPriceDateStart, customerjobinfo.ProjectedFinalDate, customerjobinfo.ForSaleStatus, customerjobinfo.Web360,customerjobinfo.WebDescriptionShort,jobspecs.PlanNameBuilt, jobspecs.Bedrooms, jobspecs.Bathrooms, customers.SubdivisionID, customers.JobSiteAddr, customers.JobSiteCity, jobspecs.FirstFlrSqFt + IFNULL(jobspecs.SecFlrSqFt,0) + IFNULL(jobspecs.BsmtSqFtFin,0) as sqft, subdivisionquickinfo.SubdivisionsID, subdivisionquickinfo.SubDivisionName, teamplans.HouseType FROM customers
LEFT JOIN jobspecs ON jobspecs.CustID = customers.CustID
LEFT JOIN customerjobinfo ON customerjobinfo.CustID = customers.CustID
LEFT JOIN teamplans ON teamplans.TeamPlansID = jobspecs.PlanID
LEFT JOIN subdivisionquickinfo ON subdivisionquickinfo.SubdivisionsID = customers.SubdivisionID
WHERE customers.JobTypeCategoryID = 6 and customers.CustID = 5841 LIMIT 100<BR><BR>Unknown column 'jobspecs.PlanNameBuilt' in 'field list'