array(1) { [0]=> array(3) { ["errno"]=> int(1054) ["sqlstate"]=> string(5) "42S22" ["error"]=> string(38) "Unknown column 'ode' in 'where clause'" } } string(1282) "SELECT g.ItemID, g.Nabor, FotoID, Back, g.brandID, g.colorID, price, detail_price, minprice, action_price, cnt, brand, color, colorUa, GoodNameTranslitUa, GoodName, GoodNameUa, g.Model, 0 AS ordered, size1, size2, IFNULL(MinPropValue, 0) AS MinPropValue, IFNULL(MinPropValue2, 0) AS MinPropValue2, avail, 1 AS discount, 1 AS discount2, 0 AS special_price, 0 AS special_price2 FROM `m_main_table` g LEFT OUTER JOIN ( /* MinPropValue и MinPropValue2 только для товаров с единственным размером для случая, когда не задано фильтров размеров */ SELECT ItemId, Nabor, IF(Nabor=1, (SELECT MinPropValue FROM `m_filters_sizes` WHERE ItemId=z.`ItemId` AND Nabor=1 AND `PartNum`=1 LIMIT 0, 1), (SELECT MinPropValue FROM `m_filters_sizes` WHERE ItemId=z.`ItemId` AND Nabor=0 AND `PartNum`=0 LIMIT 0, 1)) AS MinPropValue, IF(Nabor=1, (SELECT MinPropValue FROM `m_filters_sizes` WHERE ItemId=z.`ItemId` AND Nabor=1 AND `PartNum`=2 LIMIT 0, 1), 0) AS MinPropValue2 FROM `m_filters_sizes` z GROUP BY ItemId, Nabor ) s ON s.ItemId=g.ItemId AND s.Nabor=g.Nabor WHERE `GoodNameTranslitUa` LIKE 'forum' AND g.`itemID`=ode=editprofile AND g.`Nabor`=1"