select ce.sku,ci.`attribute_id`,ci.value ,ci.store_id from catalog_product_entity as ce
inner join catalog_product_entity_int as ci on ce.row_id=ci.row_id
where ce.sku in (
‘050-3923-MASTER’,
‘050-3880-MASTER’,
‘050-3899-MASTER’,
‘050-3853-MASTER’,
‘050-3914-MASTER’,
‘056-4128-MASTER’,
‘056-4173-MASTER’,
‘056-4182-MASTER’,
‘056-4207-MASTER’,
‘056-4191-MASTER’,
‘060-9069-MASTER’,
‘060-9078-MASTER’,
‘060-9087-MASTER’,
‘060-9096-MASTER’,
‘060-9041-MASTER’) and ci.attribute_id=97
UNION all
select ce.sku,ci.`attribute_id`,ci.value ,ci.store_id from catalog_product_super_link as cpl
inner join catalog_product_entity as ce on ce.row_id =cpl.product_id
inner join catalog_product_entity_int as ci on ce.row_id= ci.row_id
where cpl.parent_id in (
select row_id from catalog_product_entity as ce
where ce.sku in (
‘050-3923-MASTER’,
‘050-3880-MASTER’,
‘050-3899-MASTER’,
‘050-3853-MASTER’,
‘050-3914-MASTER’,
‘056-4128-MASTER’,
‘056-4173-MASTER’,
‘056-4182-MASTER’,
‘056-4207-MASTER’,
‘056-4191-MASTER’,
‘060-9069-MASTER’,
‘060-9078-MASTER’,
‘060-9087-MASTER’,
‘060-9096-MASTER’,
‘060-9041-MASTER’) and ci.attribute_id=97
)
select ce.sku,ci.`attribute_id`,ci.value ,ci.store_id from catalog_product_entity as ce
inner join catalog_product_entity_int as ci on ce.row_id=ci.row_id
where ce.sku in (
‘056-4191’
) and ci.attribute_id=97