• Goshen, Indiana based Team Construction logo
  • 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'