dmatwood Posted October 12, 2008 Share Posted October 12, 2008 I was informed by a customer that my search wasn't working right, When I do a search I get this message. I think it has something to do with the sql but I'm not sure. If anyone can help I would appreciate it very much. Thank you David 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%predator%' or p.products_model like '%predator%' or m.manufacturers_name like '%predator%') ) Link to comment Share on other sites More sharing options...
joep147 Posted October 12, 2008 Share Posted October 12, 2008 maybe this topic might be of help? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.