Jump to content
xt:Commerce Community Forum

Problem beim finden von SQL Anweisung


Recommended Posts

Hallo zusammen,

Ich will euch nicht mit dem Problem erneut nerven wie ich es l?se wei? ich :-)

1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '2' ORDER BY pd.products_name ASC

Ich wei? aber leider nicht wo ich diese SQL Abfrage in meinen PHP dateien finde.

Bitte helft mir.

Danke schonmal.

Andi

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
  • Create New...