Witam mam takie zapytanie SQL:

[SQL] pobierz, plaintext 
SELECT * FROM brand WHERE brand.id IN (SELECT DISTINCT(product.brandid) FROM product, productpackage 
LEFT JOIN category AS subcategory ON product.categoryid = subcategory.id 
LEFT JOIN category AS category ON subcategory.parent = category.id AND category.parent IS NOT NULL 
LEFT JOIN category AS department ON category.parent = department.id AND department.parent IS NULL 
WHERE productpackage.productid = product.id AND category.id = 28)
[SQL] pobierz, plaintext 

Na jednym serwerze dziala, na drugim wywala blad. Bazy sa IDENTYCZNE, collation, charset, zawartosc itd...

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'product.categoryid' in 'on clause'

Wie ktos moze w czym moze byc problem ?

MySQL wersja 5.0.37

Pozdrawiam

A pokaż strukturę tabeli product.

Witaj,
dziekuje za zainteresowanie sie tamatem.

mysql> describe product;
+------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------+------+-----+---------+----------------+
| id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| name | varchar(100) | YES | MUL | NULL | |
| brandid | int(10) unsigned | YES | MUL | NULL | |
| modelid | int(10) unsigned | YES | | NULL | |
| weight | float unsigned | YES | | NULL | |
| weightcategoryid | int(11) | YES | | NULL | |
| shortdescription | text | YES | | NULL | |
| purposeid | int(10) unsigned | YES | | NULL | |
| marketprice | decimal(5,2) | YES | | NULL | |
| shopprice | decimal(5,2) | YES | | NULL | |
| categoryid | int(10) unsigned | YES | MUL | NULL | |
| longdescription | text | YES | | NULL | |
| catalogid | varchar(50) | YES | MUL | NULL | |
+------------------+------------------+------+-----+---------+----------------+

Pozdrawiam