SELECT ColourLinkingTable.id AS ColourLinkingTable_id, ColourLinkingTable.Product, ColourLinkingTable.Colour AS ColourLinkingTable_Colour, Products.id AS Products_id, Products.productCode, Products.Name, Products.Description AS Products_Description, Products.Keywords, Products.Price, Products.Category, Products.Range, Products.Brand, Products.Stock, Products.Image, Products.Thumb, Products.Top10Image, Products.added, Products.ordered, Products.Rank, Products.Show, Products.SRWName, colour.id AS colour_id, colour.colour AS colour_colour, colour.description AS colour_description FROM colour INNER JOIN (Products INNER JOIN ColourLinkingTable ON Products.id = ColourLinkingTable.Product) ON colour.id = ColourLinkingTable.Colour WHERE colour.colour='garnet'
garnet Gemstone Jewellery, Zoo Silver Jewellery
 |
garnet Jewellery, at Zoo Jewellery
|
|
 |
|
|
|
| |
|
 |
| Page: [1]
|
|
| Zoo
Jewellery - Specialists in Silver Jewellery established in 1992 |
 |
 |
|