SELECT DISTINCT `e`.*, `cat_index`.`position`, `_price_rule`.`rule_price` AS `_rule_price`, IFNULL(_table_status.value, _table_status_default.value) AS `status` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.category_id='7'
 LEFT JOIN `catalogindex_price` AS `_price_order_table` ON _price_order_table.entity_id = e.entity_id AND _price_order_table.website_id = '1' AND _price_order_table.customer_group_id = 0 AND _price_order_table.attribute_id = '60'
 LEFT JOIN `catalogrule_product_price` AS `_price_rule` ON _price_rule.product_id = e.entity_id AND _price_rule.rule_date = '2009-06-02' AND _price_rule.website_id = '1' AND _price_rule.customer_group_id = '0'
 INNER JOIN `catalog_product_entity_int` AS `_table_status_default` ON (_table_status_default.entity_id = e.entity_id) AND (_table_status_default.attribute_id='80') AND _table_status_default.store_id=0
 LEFT JOIN `catalog_product_entity_int` AS `_table_status` ON (_table_status.entity_id = e.entity_id) AND (_table_status.attribute_id='80') AND (_table_status.store_id='1') WHERE (cat_index.visibility IN (2, 4)) AND (IFNULL(_table_status.value, _table_status_default.value) = '1') ORDER BY `_price_order_table`.`value` asc LIMIT 9