select *, group_concat(DISTINCT Secondary_Attributes.Description,"|",Secondary_Attributes.Details SEPARATOR ";") as deets
FROM Attributes
INNER JOIN Secondary_Attributes ON Attributes.ASIN = Secondary_Attributes.secondary_attribute_ASIN
and Attributes.slug = 'The-Rough-Guide-to-Portugal'
LEFT JOIN EditorialReviews as ER ON ER.editorialReviewsASIN = Attributes.ASIN
INNER JOIN Small_Image ON Small_Image.Small_ImageASIN = Attributes.ASIN
INNER JOIN Medium_Image ON Medium_Image.Medium_ImageASIN = Attributes.ASIN
INNER JOIN Large_Image ON Large_Image.Large_ImageASIN = Attributes.ASIN
/*LEFT JOIN Rank ON Rank.rankASIN = Attributes.ASIN*/
LEFT JOIN CustomerReviews ON CustomerReviews.CustomerReviewsASIN = Attributes.ASIN
LEFT JOIN Offers ON Offers.priceASIN = Attributes.ASIN
/*order by Rank.id desc*/
limit 1 ;
