SELECT p.*, a_visibility.VALUE visibility
FROM catalog_product_entity p
LEFT JOIN eav_attribute ea_visibility ON ea_visibility.entity_type_id=4 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;