INNER JOIN `catalog_product_entity_int` AS `_table_ln_qty` ON (`_table_ln_qty`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_qty`.`attribute_id` = '211') AND (`_table_ln_qty`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_color` ON (`_table_ln_color`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_color`.`attribute_id` = '213') AND (`_table_ln_color`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_pages` ON (`_table_ln_pages`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_pages`.`attribute_id` = '210') AND (`_table_ln_pages`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_size` ON (`_table_ln_size`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_size`.`attribute_id` = '217') AND (`_table_ln_size`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_cover_paper` ON (`_table_ln_cover_paper`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_cover_paper`.`attribute_id` = '214') AND (`_table_ln_cover_paper`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_paper` ON (`_table_ln_paper`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_paper`.`attribute_id` = '220') AND (`_table_ln_paper`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_cmg` ON (`_table_ln_cmg`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_cmg`.`attribute_id` = '356') AND (`_table_ln_cmg`.`store_id` = 0) INNER JOIN `catalog_product_entity_int` AS `_table_ln_binding` ON (`_table_ln_binding`.`entity_id` = `e`.`entity_id`) AND (`_table_ln_binding`.`attribute_id` = '212') AND (`_table_ln_binding`.`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` = '84') AND (`_table_status`.`store_id` = '2') 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` = '84') AND `_table_status_default`.`store_id` = 0 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='2' AND cat_index.visibility IN(2, 4) AND cat_index.category_id='39' +++++ SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, IF(_table_status.value_id > 0, _table_status.value, _table_status_default.value) AS `status`, `_table_ln_binding`.`value` AS `ln_binding`, `_table_ln_cmg`.`value` AS `ln_cmg`, `_table_ln_paper`.`value` AS `ln_paper`, `_table_ln_cover_paper`.`value` AS `ln_cover_paper`, `_table_ln_size`.`value` AS `ln_size`, `_table_ln_pages`.`value` AS `ln_pages`, `_table_ln_color`.`value` AS `ln_color`, `_table_ln_qty`.`value` AS `ln_qty`, `_table_ln_turnaround`.`value` AS `ln_turnaround` FROM `catalog_product_entity` AS `e`
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |