View difference between Paste ID: iSFFF9sx and wHhuE6PX

     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;