gistfile1.sql

SET timestamp=1372286975;
SELECT `e`.*, IF(at_status.value_id > 0, at_status.value, at_status_default.value) AS `status`, IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) AS `visibility`, `at_price`.`value` AS `price`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name`, `stock`.`qty`, `stock`.`is_in_stock`, `stock`.`manage_stock`, `stock`.`use_config_manage_stock`, `url`.`request_path`, `categories`.*, GROUP_CONCAT(categories_index.category_id) AS `categories_ids`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `price_index`.`final_price` FROM `catalog_product_entity` AS `e`
 INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1'
 INNER JOIN `catalog_product_entity_int` AS `at_status_default` ON (`at_status_default`.`entity_id` = `e`.`entity_id`) AND (`at_status_default`.`attribute_id` = '273') AND `at_status_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '273') AND (`at_status`.`store_id` = 1)
 INNER JOIN `catalog_product_entity_int` AS `at_visibility_default` ON (`at_visibility_default`.`entity_id` = `e`.`entity_id`) AND (`at_visibility_default`.`attribute_id` = '526') AND `at_visibility_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_int` AS `at_visibility` ON (`at_visibility`.`entity_id` = `e`.`entity_id`) AND (`at_visibility`.`attribute_id` = '526') AND (`at_visibility`.`store_id` = 1)
 INNER JOIN `catalog_product_entity_decimal` AS `at_price` ON (`at_price`.`entity_id` = `e`.`entity_id`) AND (`at_price`.`attribute_id` = '99') AND (`at_price`.`store_id` = 0)
 INNER JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '96') AND `at_name_default`.`store_id` = 0
 LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '96') AND (`at_name`.`store_id` = 1)
 LEFT JOIN `cataloginventory_stock_item` AS `stock` ON stock.product_id=e.entity_id
 LEFT JOIN `core_url_rewrite` AS `url` ON url.product_id=e.entity_id AND url.category_id IS NULL AND is_system=1 AND ISNULL(options) AND url.store_id=1
 LEFT JOIN `catalog_category_product` AS `categories` ON categories.product_id=e.entity_id
 LEFT JOIN `catalog_category_product_index` AS `categories_index` ON categories_index.category_id=categories.category_id AND categories_index.product_id=categories.product_id AND categories_index.store_id=1
 LEFT JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id=e.entity_id AND customer_group_id=0 AND price_index.website_id=1 WHERE (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') AND (`e`.`type_id` IN('simple', 'configurable', 'bundle', 'virtual', 'downloadable')) AND (IF(at_visibility.value_id > 0, at_visibility.value, at_visibility_default.value) IN('2', '3', '4')) AND (at_price.value > '0') AND (`e`.`sku` IS NOT NULL) AND (IF(at_name.value_id > 0, at_name.value, at_name_default.value) IS NOT NULL) AND (IF(at_status.value_id > 0, at_status.value, at_status_default.value) = '1') GROUP BY `e`.`entity_id` LIMIT 1500 OFFSET 57000;