The last model of the C64 to be sold was the 64G. It had the original "breadbin" case, but the color was much lighter, pretty much the same as on the 64C model, to match the tastes of the moment.
The keyboard could either be the original black model with graphical symbols on the front side of the keys or the cream colored c-model type with the symbols on top of the keys. It seems that Commodore just tried to use up all the parts that they had in stock which resulted in all kinds of weird color combinations. The motherboard was a small and simplified one, very similar to the the one found in the Aldi version, though some C64G are reported with more older classic C64 motherboards in them...
The SID chip used here is a MOS 8580 version, resulting in sampled sound playing on very low volume. The reason comes from a bug in the older 6581 SID that was removed in the 8580. Eventually a solution was found by grounding one leg of the 8580 through a resistor.
Some of these machines were made from C=64GS game console parts when the console bombed. Most were sold with a game pack (some magazine adds show the same game module as with the GS) and was marketed almost as a pure game console which just happened to have a computer in the same package. The G-model kind of replaced the horrible GS.
Build quality is not very good, especially the case feels quite brittle. The model sticker says "Made in W. Germany", but the motherboards were probably made in Hong Kong in the same factory as the C-model machines and only final assembly was made in Germany. The machine was probably only aimed at the European market.
The G-model was clearly a final cheap gaming computer that Commodore made to get rid of the huge stocks of C=64 spares and GS-parts. It was sometimes also named c64-III or C64 BN/E.