Magento常用SQL：按产品Visibility过滤，查询所有产品

#catalog_product_entity_int表的attribute_id=102是产品的Visibility属性(1=>Not Visible Individually、2=>Catalog、3=>Search、4=>Catalog, Search)#catalog_product_entity_int表value字段的值为4(Visibility属性是：Catalog, Search)SELECT *FROM catalog_product_entity AS t1LEFT JOIN catalog_product_entity_int AS t2 ON t2.entity_id = t1.entity_idLEFT JOIN (SELECT entity_id,value AS `name`FROM catalog_product_entity_varchar WHERE attribute_id=71) t5 ON t1.entity_id=t5.entity_idWHERE t2.attribute_id=102 AND t2.value =4 ORDER BY t1.entity_id DESC;