Return to Previous Page
x

Socks & More

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, 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`, `stock_status_index`.`stock_status` AS `is_salable`, `at_bestsellers`.`qty_ordered` AS `bestsellers`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '5' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `amasty_sorting_bestsellers` AS `at_bestsellers` ON (at_bestsellers.`product_id`=e.entity_id) AND (at_bestsellers.store_id = '5') LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (79470, 60869, 60870, 60871, 64570, 64571, 64595, 66390, 66393, 79471, 79472, 79476, 79482, 79483, 79484, 82870, 82889, 82890, 77185, 77187, 77190, 77191, 77192, 79431, 79432, 66380, 77186)) ORDER BY FIELD(e.entity_id,79470,60869,60870,60871,64570,64571,64595,66390,66393,79471,79472,79476,79482,79483,79484,82870,82889,82890,77185,77187,77190,77191,77192,79431,79432,66380,77186)

27 Items

Set Ascending Direction
per page

27 Items

Set Ascending Direction
per page
Trending In This Category
Forage Black Socks
Forage Black Socks
Special Price $11.70 Regular Price $13.00
The Beatles Yellow Submarine Socks
The Beatles Yellow Submarine Socks
Special Price $16.20 Regular Price $18.00
Feline Pack of 2 Socks
Feline Pack of 2 Socks
Special Price $13.50 Regular Price $15.00
Out of stock
Moomin Bouquet Socks
Moomin Bouquet Socks
Special Price $11.70 Regular Price $13.00
Forage Sheer Socks
Forage Sheer Socks
Special Price $10.80 Regular Price $12.00
Moomin Fair Isle Little My Socks
Moomin Fair Isle Little My Socks
Special Price $13.50 Regular Price $15.00
Moomin ‘Love’ Fluffy Slipper Socks
Moomin ‘Love’ Fluffy Slipper Socks
Special Price $23.40 Regular Price $26.00
Moomin Floral Fluffy Slipper Socks
Moomin Floral Fluffy Slipper Socks
Special Price $23.40 Regular Price $26.00
The Beatles All You Need Is Love Socks
The Beatles All You Need Is Love Socks
Special Price $16.20 Regular Price $18.00
Moomin Lotus Socks
Moomin Lotus Socks
Special Price $11.70 Regular Price $13.00
Fast and secure payment with:
Secure Payment Options
© 2023 - 2025