SELECT * FROM eav_attribute WHERE attribute_code LIKE 'visibility' // get id the EAV attribute 102 select * from catalog_product_entity_int as cpei where attribute_id = 102 and entity_id in (select entity_id from `catalog_product_entity` where `type_id`= 'simple') and value >1 update...