[EMAIL PROTECTED] wrote:
Hi,I resolve my problem...select count(p.products_id) as total from products_description pd, products p left join manufacturers m using (manufacturers_id), products_to_categories p2c left join specials s using (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 = '4' and p2c.categories_id = '16'
Read: http://dev.mysql.com/doc/refman/5.0/en/join.htmlespecially the part starting with: "Before MySQL 5.0.12, the comma operator (,) and JOIN both had the same precedence (...)".
It may be wiser to replace the comma-operator by an explicit JOIN to prevent any problems with precedence, using aliases before they are declared, etc. This part of the manual explains the changes made in MySQL regarding the handling of joins in MySQL 5.
Regards, Jigal.
smime.p7s
Description: S/MIME Cryptographic Signature
