• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Saia couro rhone
  Mixed
  3865

  R$1.395,00

  em até 6x sem juros de R$ 232,50
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Regata nuit
  Mixed
  3400

  R$665,00

  em até 6x sem juros de R$ 110,83
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Regata under lace poá
  Mixed
  2988

  R$189,00

  em até 6x sem juros de R$ 31,50
  

• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Camisa mint
  Mixed
  3858

  R$638,00

  em até 6x sem juros de R$ 106,33
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Tricot pull dentelle
  Mixed
  2991

  R$593,00

  em até 6x sem juros de R$ 98,83
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Camisa mint
  Mixed
  3861

  R$638,00

  em até 6x sem juros de R$ 106,33
  

• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Regata olivia
  Mixed
  3398

  R$577,00

  em até 6x sem juros de R$ 96,17
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Camiseta poá
  Mixed
  2984

  R$187,00

  em até 6x sem juros de R$ 31,17
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Vestido couro margaux
  Mixed
  3856

  R$2.480,00

  em até 6x sem juros de R$ 413,33
  

• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Cinto snake
  Mixed
  3336

  R$326,00

  em até 6x sem juros de R$ 54,33
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Bota over knee
  Mixed
  3452

  R$980,00

  em até 6x sem juros de R$ 163,33
  
• string(1736) "SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, LEAST(`price_index`.`min_price`, `price_index`.`tier_price`), `price_index`.`min_price`) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `cat_index`.`position` AS `cat_index_position`, `_inventory_table`.`stock_status`, IF(_table_product_order.value_id>0, _table_product_order.value, _table_product_order_default.value) AS `product_order` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_eav` AS `designer_idx` ON `designer_idx`.`entity_id` = `e`.`entity_id` AND `designer_idx`.`attribute_id`='140' AND `designer_idx`.`store_id`='1' AND `designer_idx`.`value`='122' INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='2' LEFT JOIN `cataloginventory_stock_status` AS `_inventory_table` ON _inventory_table.product_id = e.entity_id LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order_default` ON (_table_product_order_default.entity_id = e.entity_id) AND (_table_product_order_default.attribute_id='142') AND _table_product_order_default.store_id=0 LEFT JOIN `catalog_product_entity_varchar` AS `_table_product_order` ON (_table_product_order.entity_id = e.entity_id) AND (_table_product_order.attribute_id='142') AND (_table_product_order.store_id='1') ORDER BY `stock_status` DESC, `product_order` asc LIMIT 12"

  Camiseta mojilo
  Mixed
  3263

  R$315,00

  em até 6x sem juros de R$ 52,50