SELECT `p`.*, `c1`.`lngCategorieID` AS `parent`, `c2`.`lngCategorieID` AS `parent2` FROM `tblProducten` `p`, `tblMerken` `m` INNER JOIN `tblCategorieen` `c1` ON (`c1`.`lngCategorieID` = `p`.`lngP_Categorie`) INNER JOIN `tblCategorieen` `c2` ON (`c2`.`lngCategorieID` = `c1`.`lngC_Parent`) WHERE `m`.`lngMerkID` = `p`.`lngP_Merk` AND `p`.`blnP_Prullenbak` = 0 AND `p`.`lngProductID` = 216

elapsed time

-1,337,763,387,577.287 

used memory

179680 

# affected rows

 

# num rows

 

MySQL errno

1054 

MySQL error

Unknown column 'p.lngP_Categorie' in 'on clause'