Invalid query: SELECT CatItems.__id, CatItems.Price, CatItems.OriginalPrice ,CatItems.Name, CatItems.Code, CatItems.SmallDesc, CatItems.smallImage, CatItems.Parameters, CatItems.ImageText, CatCategories.ParentActive, CatItems.isStock, CatCategories.ImageText AS CatImageText, CatItems2Cats.parent_id as Category, GROUP_CONCAT( Colors.__id, '||', Colors.Name, '||', Colors.smallImage, '||', Colors.bigImage ORDER BY Colors.CustomOrder SEPARATOR '::' ) AS ColorVals FROM CatItems INNER JOIN CatItems2Cats ON CatItems.__id=CatItems2Cats.child_id INNER JOIN CatCategories ON CatItems2Cats.parent_id = CatCategories.__id LEFT JOIN Color2Item ON CatItems.__id = Color2Item.ItemID LEFT JOIN Colors ON Colors.__id = Color2Item.ColorID WHERE CatItems2Cats.parent_id='1665' AND CatItems.Active='1' AND CatCategories.Active = 1 AND CatCategories.ParentActive = 1 GROUP BY CatItems.__id ORDER BY CatItems2Cats.CustomOrder LIMIT 0,99999999
Got error 28 from storage engine