SELECT `e`.*, `at_status`.`value` AS `status`, `at_blcg_attribute_field_2`.`value` AS `blcg_attribute_field_2`, `at_blcg_attribute_field_3`.`value` AS `blcg_attribute_field_3`, `at_blcg_attribute_field_1`.`value` AS `blcg_attribute_field_1`, `at_blcg_attribute_field_8`.`value` AS `blcg_attribute_field_8`, `at_blcg_attribute_field_4`.`value` AS `blcg_attribute_field_4`, `at_blcg_attribute_field_5`.`value` AS `blcg_attribute_field_5`, `at_blcg_attribute_field_6`.`value` AS `blcg_attribute_field_6` FROM `mc_catalog_product_entity` AS `e`
 INNER JOIN `mc_catalog_product_entity_int` 
 AS `at_status` 
 ON (`at_status`.`entity_id` = `e`.`entity_id`)
 AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_varchar`
 AS `at_blcg_attribute_field_2` 
 ON (`at_blcg_attribute_field_2`.`entity_id` = `e`.`entity_id`)
 AND (`at_blcg_attribute_field_2`.`attribute_id` = '86') AND (`at_blcg_attribute_field_2`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_varchar` 
 AS `at_blcg_attribute_field_3` 
 ON (`at_blcg_attribute_field_3`.`entity_id` = `e`.`entity_id`) 
 AND (`at_blcg_attribute_field_3`.`attribute_id` = '151') AND (`at_blcg_attribute_field_3`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_int` 
 AS `at_blcg_attribute_field_1` 
 ON (`at_blcg_attribute_field_1`.`entity_id` = `e`.`entity_id`)
 AND (`at_blcg_attribute_field_1`.`attribute_id` = '137') AND (`at_blcg_attribute_field_1`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_varchar` 
 AS `at_blcg_attribute_field_8` 
 ON (`at_blcg_attribute_field_8`.`entity_id` = `e`.`entity_id`) 
 AND (`at_blcg_attribute_field_8`.`attribute_id` = '139') AND (`at_blcg_attribute_field_8`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_varchar` 
 AS `at_blcg_attribute_field_4` 
 ON (`at_blcg_attribute_field_4`.`entity_id` = `e`.`entity_id`) 
 AND (`at_blcg_attribute_field_4`.`attribute_id` = '152') AND (`at_blcg_attribute_field_4`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_varchar` 
 AS `at_blcg_attribute_field_5` 
 ON (`at_blcg_attribute_field_5`.`entity_id` = `e`.`entity_id`) 
 AND (`at_blcg_attribute_field_5`.`attribute_id` = '138') AND (`at_blcg_attribute_field_5`.`store_id` = 0)
 LEFT JOIN `mc_catalog_product_entity_int` 
 AS `at_blcg_attribute_field_6` 
 ON (`at_blcg_attribute_field_6`.`entity_id` = `e`.`entity_id`) 
 AND (`at_blcg_attribute_field_6`.`attribute_id` = '137') 
 AND (`at_blcg_attribute_field_6`.`store_id` = 0) ORDER BY `e`.`entity_id` DESC LIMIT 20