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='1530' 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