Issues trying to implement search wizard across set of multi-relational tables
I'm trying to implement a search that involves several relational tables. I have the joins set, but I'm having two issues:
1) The page is throwing the following error on searches:
SELECT tbl_images.id AS id, tbl_images.publish AS publish, tbl_images.dateinsert AS dateinsert, tbl_images.type AS type, tbl_images.category AS category, tbl_images.title AS title, tbl_images.`file` AS file, rel_tags.tag_id as rel_tag_id, rel_images.home_id as rel_images_home_id FROM tbl_images LEFT JOIN rel_tags ON rel_tags.image_id = tbl_images.id LEFT JOIN rel_images ON rel_images.image_id = tbl_images.id WHERE category = 10 AND publish = 1 AND ((`rel_images_home_id` = ?)) ORDER BY dateinsert ASC
Unknown column 'rel_images_home_id' in 'where clause'
This is odd because the rel_images_home_id is already defined in the query. I've also tried rel_images.home_id. The query works fine (screen shot attached), without that last AND statement.
2) I'm having trouble understanding how to structure the query to avoid duplicate returns while ensuring searches for all instances. This is a photo gallery and I only want 1 copy of each photo to show. If you look at the screen capture, I'm returning 3 version of image69.jpg, but I would need that to account for all three instances of rel_tag_id (12, 13, 14). So if rel_tag_id = 12 is searched for, I want the image69.jpg to show, but if the search is more general, I don't want it to return 3 duplicate image69.jpg. Hopefully I'm being clear here.