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 = 'Leviton-10097-8-Pull-Chain-Switch-Single-Pole-On-Off-1A-125V-T-3A-125V-1A-250V-With-Two-6-Inch-Black-Leads-18-Awg-Awm-Tew-105C-600V-Stripped-12-Inch' 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 ;


New: $5.52

Price as of 08/16/17

  • ASIN:
  • :