Tweet Share Pin it

• Email

  Send to a friend

  Use the form below to send your friend(s) a personal message and link to this item
  * *REQUIRED FIELDS

  SELECT m.*, p.`id_product`, p.`id_manufacturer` FROM `ps_manufacturer` AS m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) INNER JOIN `ps_product` AS p ON ( m.`id_manufacturer`= p.`id_manufacturer`) WHERE p.`id_product` = 2275 ORDER BY m.`name`
  BOXER

  

  Your name ^*

  Your email ^*

  Your friends' email ^*

  subject

  Your Message

  Send