sandro20 Posted July 16, 2008 Report Share Posted July 16, 2008 Abend zusammen. Wen ich die Suche benützen möchte kommt dieser fehler. 1054 - Unknown column 'p.products_id' in 'on clause' 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 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 '%glaskopf%' or p.products_model like '%glaskopf%' or p.products_ean like '%glaskopf%' or m.manufacturers_name like '%glaskopf%') ) [XT SQL Error] Wer kann mir da weiter helfen? Link to comment Share on other sites More sharing options...
sandro20 Posted July 17, 2008 Author Report Share Posted July 17, 2008 Kann mir den niemand Helfen? Link to comment Share on other sites More sharing options...
Hetfield Posted July 17, 2008 Report Share Posted July 17, 2008 Tausendfach gefragt und beantwortet im Forum ( z.B. hier: http://www.xt-commerce.com/forum/showthread.php?t=62334 ). Bitte auch mal die Suche verwenden. MfG Hetfield Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.