This is the current error:
SELECT SQL_CALC_FOUND_ROWS tbl_homes.id AS id, tbl_homes.title AS title, `sl_types`.`title` AS sl_types_title, `sl_categories`.`title` AS sl_categories_title, tbl_homes.sqft AS sqft, tbl_homes.beds AS beds, tbl_homes.baths AS baths, tbl_homes.featured AS featured, tbl_homes.dateupdate AS dateupdate, `sl_publish`.`title` AS sl_publish_title FROM tbl_homes LEFT JOIN sl_types ON sl_types.id = tbl_homes.type LEFT JOIN sl_categories ON sl_categories.id = tbl_homes.category LEFT JOIN sl_publish ON sl_publish.id = tbl_homes.publish WHERE ((`id` = 1) and (`type` = 4) and (`category` = 7) and (`subcategory` = 1) and (`community` = 1) and (`beds` = 1) and (`baths` = 1) and (`garagemin` = 0) and (`garagemax` = 0) and (`publish` = 1)) LIMIT 1000
Column 'id' in where clause is ambiguous
I should note, I've already modified the following query trying to fix the original error, which was a similar ambiguous error. I got the the point where the error is in the 'where' clause, and I don't quite understand how the search query builds that portion. The original before my changes is attached with the "_original" at the end of the name.