tlalochj Posted March 15, 2007 Posted March 15, 2007 I install the Product Extra field contribution and I need a lot of but I have too many problem's another problem that results whe I make a serch or an advanced serch it's that this message appears 1066 - Not unique table/alias: 'pd' select count(distinct p.products_id) as total from (products p left join products_to_products_extra_fields p2pef on p.products_id=p2pef.products_id) left join manufacturers m on m.manufacturers_id=p.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c, products_extra_fields pef, 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 = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and pef.products_extra_fields_id=p2pef.products_extra_fields_id and ((pd.products_name like '%harry%' or p.products_model like '%harry%' or m.manufacturers_name like '%harry%' or pef.products_extra_fields_name like '%harry%' or p2pef.products_extra_fields_value like '%harry%') ) I install the advanced search results and the advnced search that comes in the contribution and nothing happend Somebody please can help me Quote
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.