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 t1
LEFT JOIN catalog_product_entity_int AS t2 ON t2.entity_id = t1.entity_id
LEFT JOIN (SELECT entity_id,value AS `name`FROM catalog_product_entity_varchar WHERE attribute_id=71) t5 ON t1.entity_id=t5.entity_id
WHERE t2.attribute_id=102 AND t2.value =4 
ORDER BY t1.entity_id DESC;