SELECT p.*, a_visibility.VALUE visibility
    FROM catalog_product_entity p
LEFT JOIN eav_entity_type et ON et.entity_type_code='catalog_product'
    LEFT JOIN eav_attribute ea_visibility ON ea_visibility.entity_type_id=et.entity_type_id AND ea_visibility.attribute_code='visibility'
    LEFT JOIN catalog_product_entity_int a_visibility ON a_visibility.store_id = 0 AND a_visibility.entity_id = p.entity_id AND a_visibility.attribute_id = ea_visibility.attribute_id
    WHERE a_visibility.VALUE = 4;