1. 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`
2.  INNER JOIN `mc_catalog_product_entity_int`
3.  AS `at_status`
4.  ON (`at_status`.`entity_id` = `e`.`entity_id`)
5.  AND (`at_status`.`attribute_id` = '97') AND (`at_status`.`store_id` = 0)
6.  LEFT JOIN `mc_catalog_product_entity_varchar`
7.  AS `at_blcg_attribute_field_2`
8.  ON (`at_blcg_attribute_field_2`.`entity_id` = `e`.`entity_id`)
9.  AND (`at_blcg_attribute_field_2`.`attribute_id` = '86') AND (`at_blcg_attribute_field_2`.`store_id` = 0)
10.  LEFT JOIN `mc_catalog_product_entity_varchar`
11.  AS `at_blcg_attribute_field_3`
12.  ON (`at_blcg_attribute_field_3`.`entity_id` = `e`.`entity_id`)
13.  AND (`at_blcg_attribute_field_3`.`attribute_id` = '151') AND (`at_blcg_attribute_field_3`.`store_id` = 0)
14.  LEFT JOIN `mc_catalog_product_entity_int`
15.  AS `at_blcg_attribute_field_1`
16.  ON (`at_blcg_attribute_field_1`.`entity_id` = `e`.`entity_id`)
17.  AND (`at_blcg_attribute_field_1`.`attribute_id` = '137') AND (`at_blcg_attribute_field_1`.`store_id` = 0)
18.  LEFT JOIN `mc_catalog_product_entity_varchar`
19.  AS `at_blcg_attribute_field_8`
20.  ON (`at_blcg_attribute_field_8`.`entity_id` = `e`.`entity_id`)
21.  AND (`at_blcg_attribute_field_8`.`attribute_id` = '139') AND (`at_blcg_attribute_field_8`.`store_id` = 0)
22.  LEFT JOIN `mc_catalog_product_entity_varchar`
23.  AS `at_blcg_attribute_field_4`
24.  ON (`at_blcg_attribute_field_4`.`entity_id` = `e`.`entity_id`)
25.  AND (`at_blcg_attribute_field_4`.`attribute_id` = '152') AND (`at_blcg_attribute_field_4`.`store_id` = 0)
26.  LEFT JOIN `mc_catalog_product_entity_varchar`
27.  AS `at_blcg_attribute_field_5`
28.  ON (`at_blcg_attribute_field_5`.`entity_id` = `e`.`entity_id`)
29.  AND (`at_blcg_attribute_field_5`.`attribute_id` = '138') AND (`at_blcg_attribute_field_5`.`store_id` = 0)
30.  LEFT JOIN `mc_catalog_product_entity_int`
31.  AS `at_blcg_attribute_field_6`
32.  ON (`at_blcg_attribute_field_6`.`entity_id` = `e`.`entity_id`)
33.  AND (`at_blcg_attribute_field_6`.`attribute_id` = '137')
34.  AND (`at_blcg_attribute_field_6`.`store_id` = 0) ORDER BY `e`.`entity_id` DESC LIMIT 20