当店のウェア検索は、お求めのウェアのサイズやブランドを選択すれば、条件にあったウェアを簡単にみつけられます！

ブランド（複数選択可）

SELECT DISTINCT products_description.`products_name`,products.`products_price`,products.`products_price_sorter`,products.`products_image`,manufacturers.`manufacturers_name`,products.`products_model`,products_rakuten_fields.`display_price`,products_rakuten_fields.`shipping_cost` FROM products JOIN products_description ON (products_description.`products_id` = products.`products_id`) JOIN rakuten_zaiko_relation ON (rakuten_zaiko_relation.`products_id` = products.`products_id`) JOIN jisha_wear_size_map ON (rakuten_zaiko_relation.`col_option_value` = jisha_wear_size_map.`col_option_value`) JOIN products_rakuten_fields ON (products_rakuten_fields.`products_id` = products.`products_id`) JOIN manufacturers ON (manufacturers.`manufacturers_id` = products.`manufacturers_id`) WHERE products.class_name like '%ウェア%' AND products.products_status= '1' AND products_rakuten_fields.stock_type >= '0' AND 1=1 ORDER BY products.products_id DESC