ivanklykov

SELECT t2.product_id, t4.value AS `Season`, t5.value AS `ProductName`, t6.value AS `Brand`, t7.value AS `MDM`,t8.value AS `Status` FROM catalog_product_entity t1 
INNER JOIN cataloginventory_stock_status t2 ON t2.product_id = t1.entity_id
INNER JOIN catalog_product_entity_int t3 ON t3.entity_id = t1.entity_id AND t3.attribute_id = 179 
INNER JOIN eav_attribute_option_value t4 ON t4.option_id = t3.value AND t4.store_id = 1
INNER JOIN catalog_product_entity_varchar t5 ON t5.entity_id = t1.entity_id AND t5.attribute_id = 71 
INNER JOIN catalog_product_entity_varchar t6 ON t6.entity_id = t1.entity_id AND t6.attribute_id = 174 
INNER JOIN catalog_product_entity_varchar t7 ON t7.entity_id = t1.entity_id AND t7.attribute_id = 181 
INNER JOIN catalog_product_entity_int t8 ON t8.entity_id = t1.entity_id AND t8.attribute_id = 96 
WHERE t1.type_id = 'configurable' AND t2.stock_status = 1 AND t4.value LIKE 'FW 2017-2018' AND t8.value = 1