ust-tuning Posted October 31, 2006 Posted October 31, 2006 If I search for something in my Shop I get the following text: 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 = '2' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%fiat%' or p.products_model like '%fiat%' or m.manufacturers_name like '%fiat%') and (pd.products_name like '%bravo%' or p.products_model like '%bravo%' or m.manufacturers_name like '%bravo%') ) [TEP STOP] In this case I searched for "Fiat Bravo" please tell me what this means.. regards christian Quote Contribs I postet something in *g*
ust-tuning Posted November 10, 2006 Author Posted November 10, 2006 please help me Quote Contribs I postet something in *g*
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.